how i can do this Ex : select 5 random rows from the 20 most recent row I need do this with eloqunet and get data with query from db not with mapping data I found this query but i cant convert this to laravel eloqunet … Query : select tbl1.* from (select *from DemoTable ..
Category : eloquent
my first database host in aws and secound database host in diedem server. and I want to reference one column from laravel_1.uesrs table to multiple other database server in employees table . Host: 192.168.0.100 Database:[laravel_1.uesrs]: https://i.stack.imgur.com/Tq5Mm.png CreateUsersTable Schema::create(‘users’, function (Blueprint $table) { $table->bigIncrements(‘id’); $table->string(‘name’); $table->string(’email’); } Host: 10.0.0.12 (different server) Database: [laravel_2.employees]: https://i.stack.imgur.com/QcLY5.png CreateEmployeesTable Schema::create(’employees’, ..
I’ve encountered a problem with Eloquent model. My database column is defined as date_to date null It is also defined as nullable() in migration. When I select a database record (either with query builder or directly via find($id)), value for $model->date_to is always returned by Eloquent as 0000-00-00 (In MySQL, this column is properly set ..
im stuck in few days for fixing this problem. in my case, there is student received a scholar. But student’s table and scholar member’s table are different. there is deactivated student status date. the student get $70 every month with condition the student still active OR if stundent status deativated (drop out/mutation to other school) ..
I will ask you. in sql i have a code like this ? SELECT keterangan_warga, COUNT(keterangan_warga) as cnt FROM ( SELECT distinct nokk_warga, keterangan_warga FROM `warga` ) as t GROUP by keterangan_warga; then , i will perform this to Laravels. How can I do? Thanks, I try to 2 select but it error. i will ..
I have a model called CustomerInfo and i am trying to update it. update returns true but the changes are not reflecting on my db. $customerInfo = CustomerInfo::where(‘machine_name’,$username)->firstOrFail(); $result = $customerInfo->update($data); $data varaible is a array having key value pair. Also tried the following $customerInfo = CustomerInfo::where(‘machine_name’,$username)->update($data); Sourc..
i want to show about daily, weekly and monthly avg of signup from my users table i have created_at column mean signup at column in my users table so how i can do it in Laravel 8.0 using DB queries or better from Eloquent. Sourc..
My Laravel Project have a resource controller named Blogpost, where in destroy method, the $blogpost->delete() approach doesn’t work. But if I use DB Query, it works just fine. See code below. This doesn’t work: public function destroy(Blogpost $blogpost) { $blogpost->delete(); return redirect()->route(‘blog.index’); } This works perfectly: public function destroy($id) { $post = Blogpost::find($id); $post->delete(); return ..
I want to create query for promotion. my question is how this query to change from SQL to eloquent? SELECT * from Insurance_promotion where Active = 1 AND VehicleNo NOT IN ( SELECT RegistrationNo from insurance_motor where Insurance_promotion.VehicleNo = insurance_motor.RegistrationNo AND InsuranceID In ( SELECT InsuranceID from insurance_holder where insurance_motor.InsuranceID = insurance_holder.InsuranceID and NRIC = ..
When i send this with postman to test for my local server, i got the error message: The POST method is not supported for this route. Supported methods: GET, HEAD . php artisan route:list shows this route correctly with the method name – POST. All other routes in the api.php are working. i’ve also tried ..
Has MySQL view ‘histstat’. In MySQL select * from histstat works fine. Laravel model is very simple: class HistStat extends Model { use HasFactory; protected $table = ‘histstat’; protected $fillable = [‘day’, ‘total’, ‘paid’]; } Then I want to get first 14 records of hisstat: $dynamic = HistStat::all()->slice(14); … and execution ends with error SQLSTATE[42000]: ..
I am trying to create an email blaster for more than 100k emails at once using the Laravel framework. My command: public function handle() { $blastId = $this->argument(‘blast’); $blast = Blast::find($blastId); activity()->performedOn($blast)->log(‘Blast is sending’); foreach ($blast->unsentLogs as $log) { try { Mail::queue((new BlastEmail($log))->onQueue(’emails’)); } catch (Exception $e) { activity(‘send_failed’)->performedOn($log->contact)->causedBy($log)->log(‘Email send failed: ‘.$e->getMessage()); } } $blast->status ..
I need the column date and digits to concatenate. The date should be YY-mm format and the digits should have a leading zero. Example output 21-09-0001 How to do it in WHERE FUNCTION laravel eloquent? like this. I found this on the internet example: public function scopeFindDVNumber($query,$name) { $query->where(DB::raw( "REPLACE( COALESCE(name_first,”),’ ‘, COALESCE(name_middle,”),’ ‘, COALESCE(name_last,”) ..
I try to make an instagram clone with PHP laravel. I want to show posts in home page. This is the pagesController.php: class PagesController extends Controller { public function home() { $posts = Post::all(); return view(‘pages.home’, [‘posts’ => $posts]); } } And this is the home page view: @foreach($posts as $post) { <div>{{ $post->id }}</div> ..
I have a model Survey which is related to hasOne another model Installation which is related to hasMany another model Assignment. So i defined a hasManyThrough relationship like this public function assignments() { return $this->hasManyThrough(Assignment::class,Installation::class); } I want to write a query to fetch any Survey where the Assignments associated with the survey does not ..
i have 5 filter , kampus,fakulti,program ,semester and status so each filter is always been filter with status it means the status filter will be the selection of switch case and the other filter will be condition in the switch case example : if($student){ $today = date("Y-m-d"); switch($request->stat){ case ‘Y’: if($request->kampus != "-" && $request->fakulti ..
I’m trying to get today’s orders by a restaurant. Here is my table structure restaurants id – integer name – string categories id – integer restaurant_id- foreign name – string items id – integer category_id – foreign name – string orders id – integer amonut- double order_items (pivot table) id – integer order_id – foreign ..
In a Laravel context, I’ve got this messages page, with all the messages belonging to a specific user. Initially all messages are not readed, so I put a button to change the boolean in DB (from 0 to 1) and finally show the message. I’m doing this: The view @if ($message->readed != 0) <p class="card-text ..
I have SaleInvoice model, Sale invoice belongs to User model and User model belongs to another model called Client. On the User model I am using eager loading to load the Client class User extends Authenticatable { /** * The relations to eager load on every query. * * @var array */ protected $with = ..
// how should i join these 4 tables users, pages, category, products using relationships intead in controller. //I also prefer calling these functions from corresponding models using respective function names but not database column names in view. Thanks in advance. These are my models //models class User extends Authenticatable{ use HasFactory, Notifiable; protected $fillable = ..
I am working on a medical system and as I have a patient profile that will get all these data from different 4 tables on the page as you can see on the pic. so, how to select and update Database Design Sourc..
I have 3 models (Products, Invoices, Invoice Items) and I am trying to achieve the following flow: When viewing an invoice detail, allow user to add an invoice item. (done) When adding a new invoice item, autocomplete user input in "title" column of Invoice Items with Products (help). When a product is auto completed, autofill ..
I have three tables as shown in the picture. I would like to run a query that returns: Total_Parcel_Value, Total_Parcel_Delivery of parcels from all orders where customer = A. Sourc..
How to write the Laravel eloquent query to select the max value without using DB::raw and writing in pure eloquent so that it doesn’t have to put MySQL strict mode to false. Means any alternative to write, DB::raw(‘max(price) as price’) without making MySQL strict mode false. Item::join(‘product’, ‘item.id’, ‘=’, ‘product.item_id’) ->select([‘item_id’, ‘item.title’,DB::raw(‘max(price) as price’)]) ->where(‘product.user_id’, ..
I’ve this query to list all the users with their corresponding relationships. user has many tasks each tasks has many worktimes and these worktimes can have different users ie, each task can be shared by different users, hence they have individual worktime for each task. i’ve tried the below code $users = User::select(‘users.id’, ‘users.first_name’, ‘users.last_name’, ..
Web Development Company
Free Hosting Company
