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…
I have a column called Class ID and I am trying to sort this column. It seems to ignore the numbers. I assume because they are strings. Currently, it looks like this: NewSyn - 1 OBSSt NewSyn - 1 OBSSt…
I have a table called sales with the following columns. transaction_id transaction_refund_id price id transaction_id transaction_refund_id price 1 tr_001 0 5 2 tr_002 tr_001 5 3 tr_003 tr_003 5 I want to query the sales table and join the records…
i was try to get environment variabel, to get APP_URL from .env, but always return null, but when use random string it show, so this because .env value can't retrieve class Attachment extends Model { public function getUrlAttribute() { return…