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…
I have multiple many-to-many relationships and i want to filter through them. The models are: State District I attached an screenshot: (https://i.stack.imgur.com/TJPwp.png) States are Alabama and Arizona, Districts are Autaga, Baldwin and Apache When i check Alabama and Arizona the…
I want to remove old images in my public folder when he want to change him profile photo. ProfileController: if($request->hasFile('image')){ $request->validate([ 'image' => 'image|mimes:jpeg,png,jpg,svg|max:2048' ]); $imageName = $request->user()->id.'-'.time().'.'.$request->image->extension(); $request->image->move(public_path('users'), $imageName); $path = "users/".$imageName; $request->user()->image = $path; $request->user()->save(); } i tried…