I have theses tables : chevals : id name courses : id name horses_races : id cheval_id course_id For no french speakers, cheval = horse, and course = race. I want to make a relation ship between horses and races.…
So i have codes that can search data based on relation columns, there are 2 search input, 1 of them work really well but the other one doesn't work. my Model Category id name Task id title category_id company_id Company…
I have a classroom model with a hasMany students relationship. I want to check if every classroom has students in one query with eloquent builder. I dont want to retireve the student count either. The has function filters the classrooms…
I have a weird value for the parameter inside the closure when I pass this variable to when() method of Laravel Eloquent. Inside the closure, for $user_id I get true instead of 2. What might be the reason for that?…
Not equal to function is not working in below code when I am running it through Postman, but the same query is giving output in MySQL. Laravel Eloquent Code - Invoice::where('invoices.centre_code', $userInfo->centre_code) ->where("invoices.itemTotalPrice","<>", "invoices.paymentCollected") // this line is not working…
I have class People extends Model { public function invoices() { return $this->hasMany(Invoice::class)->orderBy('date', 'desc'); } } ... class Invoice extends Model { public function person() { return $this->belongsTo(People::class, 'people_id'); } public function latestInvoice(){ return $this->hasOne(Invoice::class)->latestOfMany(); } } ... class Clerk…
I have a post table that has a many to many relationship with a category table, and of course a pivot table between both. I'm trying to get all posts that match exactly with an array of categories, example: category_array…
We have three tables. Get the Last Attendance Date from the attendance table of every user using eloquent relation users and user_attandance table users id - integer name - string attendance id - integer date - date user_attandance id -…
I need to find all results that include this substring (note the leading zero): $code = '02549'; Nomenclature::where('code', 'like', '%' . $code . '%')->get(); With such a builder, I get the correct request: select * from `nomenclatures` where `code` like…
I want to search if a user submitted comment contains comma separated bad words in the database. Table bad_word: id words 1 foo bar, fooBar 2 aaa bbb, ccc ddd I'm using the following code but it only work for…