I have the following models/tables: branch: id - integer department: id - integer teacher: id - integer branch_department_id - integer branch_department: id - integer branch_id - integer department_id - integer each branch has many departments through the pivot table branch_department…
in my Laravel project i have two tables. One for products and another one for translations of products. 1 - products 2 - product_translations So i want to write my controller for adding a product and it translations. How can…
I am quite new to laravel. Using Laravel 8. When saving data I have seen below method in many examples. In the controller $emp = new Employee(); $emp->emp_name = $request->emp_name; $emp->emp_no = $request->emp_no; $emp->email = $request->email; $emp->save(); My doubt is…
I am facing this error 'Attempt to read property "nom" on null' in Laravel 10. though the User eloquent model work fine beside for Plaques; Here is my Code: Plaques Model: class Plaques extends Model { use HasFactory; protected $table…
Given a Dues and Payment Laravel Eloquent models with the following defined relationships: /** * Get the payment(s) for this set of dues */ public function payments() { return $this->hasMany(Payment::class); } /** * Get the Dues to which this payment…
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…