I get a Laravel collection from a Eloquent query and I converted into an array using toArray() method. The sample output is mentioned below. Array ( [0] => Array ( [id] => 1 [details] => routes [level] => beginner [created_at]…
How to automatically update UI with the new tasks? For example, while I'm on the tasks page, I load them once. In the meantime, let's say new task are created and stored from my web application to mysql db. I…
I have Raw query running as select meeting.id, GROUP_CONCAT(users.name separator " | ") AS present_user_id from `meeting` left join `users` on JSON_CONTAINS(meeting.present_user_id, JSON_ARRAY(users.id), '$') group by `meeting`.`id` Which provide proper result, I tried to convert same in Laravel 8 like…
I am attempting to use the FPDF (http://www.fpdf.org/) PHP addon for my website that uses Laravel. I want to be able to dynamically create a PDF. I have stored the libraries' files in the folder: '/public/vendor'. This is what I…
My tables users id name Cell 1 Cell 2 Cell 3 Cell 4 group id name Cell 1 Cell 2 Cell 3 Cell 4 group_users id user_id group_id Cell 1 Cell 2 Cell 4 Cell 3 Cell 4 Cell 6…
I'm doing a dental function, I'm looking to sync data in a many-to-many relationship. I have the following: tooth - id - name cost - id - name cost_tooth - id - tooth_id - cost_id - row_number This is the…
how can I increase the laravel 8 dd() limitations? I have lots of nested relationship and I cant view most of them due to many data. For example this #relations: array:4 [▼ "activecourses" => IlluminateDatabaseEloquentCollection {#1346 ▼ #items: array:3 [▼…
I'm using Laravel 9 for making a forum project. Now for this project, I need to upload some images. So at the Controller, I added this: if($request->has('filep')){ $files = $request->file('filep'); foreach ($files as $file) { $this->uploadImage($file, $questionCreated->id, 'question_image'); } }…
I'm truing to get the employees that have birthday within next 3 days. I tried to do that by using the following query. public function upcomingBirthdays() { $from = now()->format('m-d'); $to = now()->addDays(3)->format('m-d'); $employees = Employees::whereRaw("DATE_FORMAT(dob, '%m-%d') BETWEEN '{$from}' AND…
Here is a Rest Api method that sets the user rating. The database table contains the composite primary key: user_id + rate_id. When user tries to set the same rating the framework throws an exception. I catch it and return…