I'm just learning laravel. I want update key / value in database with laravel api but not work. My products model is one to many with ProductMeta and many to many with contents model. My Models class Product extends Model…
A Teacher has many Students. When I am showing the Teachers list I also want to show the counts of Student for each Teachers. How can I do this by using Eloquent? I can find the Teachers from this, $teacher=…
Help me please. I'm trying to write a function where I get all the categories of my forum with the 3 most recently updated Topics in the given categories. But according to the result, take(3) filters by id (where the…
I have a strange Laravel 9 setup due to being constrained to a very ancient database. I'm trying to come up with a clean way to create a hasMany relationship to multiple models located in a folder. I believe it…
i am trying to retrieve questions based on the category witch they belong with this function inside my questions controller: public function getByCategoryName($categoryName) { $category = Category::where('name', $categoryName)->first(); return response($category->questions); } the problem is that, even if $category its being…
I have a reports table which looks like something as follows: Reports is monthly reports of users putting their efforts. It's many to many relationship table. id user_id project_id total_effort created_at 1 5 232 40 2023-01-23 I want to get…
I am struggling with a mysql problem. I have two exact same queries, just the item_id at the end is different, but they return different execution plans when I execute them with analyze/explain. This results in a huge difference of…
I have a simple list of tasks that need to be completed today, at various times. Each task has a reminder/notification that needs to be sent x amount of minutes before it is planned. Simplified migration is as follows: Schema::create('user_tasks',…
How do I generate pagination links? My code looks like this: // In Model public function comments() { return $this->hasMany(Comment::class); } // In Controller public function show(User $user) { $user = User::query() ->with(['comments' => fn ($query) => $query->paginate(20)->withQueryString()]) ->find($user->id); return…
I want to use a record fields in laravel eloquent subquery I tried this $clients = Client::with(['records' => function (Builder $query) { // how can i take a record fields there? $record = $query->first(); $query->where('time', Carbon::now()->subMinutes(10 + $record->duration); }])->where('profile_id', $profile->id)->get();…