I'm using ORM Eloquent and I need to filter all models using a date interval and an own property of the model. The raw SQL would be: SELECT * FROM model WHERE s
In laravel Many to Many relationship like the one in the Laravel Documentation example. https://laravel.com/docs/9.x/eloquent-relationships#many-to-many users
I have a form that is supposed to submit order details to the orders table through a custom select element (headlessUI Combobox). The element works fine but I c
I use multiple database connections in my app, one SQLServ, and another MySQL. I want to debug every query from both servers sequentially. therefore rather usin
I have the User model which define the following attribute: public function getAvatarUrlAttribute() { return 'https://i.pravatar.cc/300?u=' . $this->
I've posted about this three times and hopefully someone will help me with a solution. I have a lot of data in my database that the user has created. Suppose I
I'm trying to sort a post table by a foreign key, and can't figure out how to do it. Hopefully someone can lend me a hand. I can sort by the fields already pres
Is there any way we can use operator or regex as we normally do with the whereIn() clause. I want to use something like this $query->whereIN(name,'like','%te
I get the error Doctrine\DBAL\Schema\SchemaException : There is no column with name 'price' on table 'class_rooms'. while running migration to rename the price
I have category and product table as follows: Categories: id | name | slug | parent_id Products : id | brand_id | name | slug | price | desc P
I started to develop a little Content Management System for two languages (de, en) that starts to grow bigger. In that context, I have Posts and Pages (a bit li
How to delete the aircon in database when there is no any data. Order and Aircon are many to many relationship. $orders = Order::with('aircons', 'user')
I have a Laravel 5.8 app. It works with a Postgres Database encoded with UTF8. I have a query for my users table, so i made my query as: $users = User::where
I just upgraded laravel 7 to laravel 8.30.1 and I am trying to add the default value of pivot column object_model of term_relationships table using the newly in
I am new to laravel, I need to create a query for the db, $query = Deal::query(); I want to use the wherehas operator. this is my code that is worked. else if
Hello and thank you beforehand for your help. I've been hitting my head against a wall with this problem for a few days now so decided to ask here. I have two q
Laravel 8. I have two tables(models) 'employees' and 'positions'. In a model 'employees' I have a casts: protected $casts = [ 'academic_post' => 'array'
Laravel 5.7 Hello I have been looking through stack overflow and have tried many possible answers and have come to no conclusions. I am updating a simple inte
My query from Laravel Builder toSql() function. select `dispatcher_leads`.*, (select CASE WHEN lead_positions.order_type = 'shift' THEN DATE_ADD(lead_positions
In Laravel I have got this error, while inserting a record in my MongoDB database. Call to a member function prepare() on null namespace App\Http\Controllers;