I am using spatie/laravel-data to work with some data that eventually gets inserted into the database. One of the things I need to do is sum up and average some things while I'm doing calculations, and I have (maybe unwisely)…
Hello I have a project table which has a field name in my db which is multi lang so I stored it as json so I can store each lang value the problem is that the arabic lang is being…
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…