For an API using Laravel and MySQL we are trying to setup an audit mechanism using MySQL triggers.
We’ve extended IlluminateDatabaseDatabaseManager with something like

I have two tables and I want to do left Join but to retrieve only one record from right table even if there is more than one record matching and count them.

I have this Laravel query which searches two fields in the table (name, introduction) for matching entries:

after migration from host to other host i get this problem with database :

How can I find duplicate phones from json column with whereIn in Laravel. Below is my code?

I have troubles trying to sort comments and replies (unlimited nesting levels) in my laravel project.

I have a Laravel application where I’m retrieving data from two tables: LoginData and LocationStatus. The LoginData table contains records with a single IMEI, while the LocationStatus table contains multiple records for each IMEI, with a serverDatetime timestamp indicating when the record was created.

I have table LocationStatus with 4 millions records as now, when i use this query LocationStatus::where('imei',$mhe->imei)->orderByDesc('serverDatetime')->first();

i want to make a one two many relationship between two tables medicines and suppliers, so i made a foreign id of the table suppliers in medicines table.

When i upload my project then after it gives error but i cannot find error what is this and how i can resolve this does anyone have idea i can show my error below