I am trying to retrieve data using a belongsToMany relationship in Laravel. So I have Student and Course model and they have a many to many relationship, but there are few courses that are compulsory so we don't want to…
I have this model: AppControllersImageController.php ..... $image = new Image; $image->id = "pre_" . (string) Str::ulid()->toBase58(); $image->filename = $filename $image->post_id= $post_id; $image->save(); return $image->load("post:id,status,subject,body"); it is working fine, it returns the following: { "id": "pre_1BzVrTK8dviqA9FGxSoSnU", "type": "document", "filename": "v1BzVc3jJPp64e7bQo1drmL.jpeg", "post_id":…
I'm working with Laravel 8... So I have the following eloquent query, I've eager loaded a bunch of models but I want to do 2 things to the way the models are loaded: Only select certain fields from the cooking_methods…
I want to apply some conditions on my models (after retrieving from the database), I found this approach but it has a problem that is for before getting relations and the model has no relations but I want them. public…
I have a table in my db that looks like this: Col 1 Col 2 John 230601 Frank 230601 Tom 230604 Bill 230604 Tina 230604 Leroy 230602 Ernie 230601 Sue 230601 I want to get all rows with the max…
I have the following three table in laravel app purchases table id, name, price Products table id, purchase_id, price sales table id, product_id, quantity, total-price The sales table belongs to products table refers product id while products table belong to…
I have a car model and an order model, i need a query that will filter the list of cars that are not rented between two dates, i'm lacking the logic to get the answer right what i came up…
Undefined property: IlluminateDatabaseQueryBuilder::$title public function show(string $id) { $books = DB::table("book_tbls") ->where("author_tbls.id", "=", $id) ->where("author_tbls.id", "=", "book_tbls . author_id") ->where("categories.id", "=", $id) ->where("categories.id", "=", "book_tbls . category_id"); // $books = book_tbl::find($id); return view('books.show', compact('books')); } I am learning laravel for…
I want to ask for your help. I'm studying laravel, i am using laravel 10, and I need to retrieve related data, the application and data that I'm working on are related to students in a school. I want to…
how to type this sql in laravel eloquent 10 $data = array:2 [ 0 => "3" 1 => "5" 2 => "1" ] relations public function followActionFollowStudent() { return $this->hasMany(FollowActionFollowStudent::class, 'follow_student_id', id'); } i need sql as this below select…