A project I've taken over creates relationships in a rather odd way that I've never seen done before. consider one such example: public function invites(): BelongsToMany { return $this->belongsToMany( Invite::class, 'user_invites', 'id', 'user_id' )->where('is_active', 1); } I have concerns for…
I’m experiencing an issue in Laravel where certain keywords (e.g., "AND" in a movie title slug) are being interpreted as SQL syntax within a where clause. This causes the query to break when I try to retrieve a record by…
Why is this laravel eloquent query running so SLOWLY? I have a query running in a Laravel job that executes very slowly and inconsistently. Sometimes it takes 1-2 minutes to fetch the result, while at other times it completes in…
I'm working on a Laravel application and I need help with filtering titles based on their relationships with practices, quizzes, and contests. Specifically, I want to retrieve titles that have associated practices but do not have any associated quizzes or…
In my Laravel app, I have User, List and ListItem models, with a one-to-many relationship between User and List and many-to-many relationships between User and ListItem and between List and ListItem. Each User should be able to tag the ListItems…
I'm developing a Laravel 11 application that asks users to submit data, which is then saved to a database. My migrations have successfully created the necessary tables, but I'm having an issue. I can't seem to save data to the…
i am casting an array [1,2] and in my model I have this setup protected $casts = [ 'skills' => 'array' ]; and I have my relationship setup like this public function skills(){ return $this->hasMany(Skill::class,'id'); } now my problem is…
I want a single row of player through his playerNo field which is later added and updated. I am doing this. $player = Account::where('playerNo', 99)->get(); Result I am getting is many objects of players that only has player object with…
I'm having performance issues with MySQL, despite having indexes when using both join and order by . The query is currently taking 77 seconds to complete. The purpose of the query is to order the table alphabetically. Background I have…
I'm using latest version of Laravel. I'm trying to setup a model method relationship that passes through other intermediary tables. Understanding the table structure below, my goal is retrieve a collection of Students (only) which are enrolled in a course…