Before I state the issue I'll mention I'm using PHP and laravel 9, and my database is mysql with the following charset and collation: 'charset' => 'utf8mb4', 'collation' => 'utf8mb4_unicode_ci', I am working with ADIDs and a table called devices…
I'm trying to filter account in laravel.1 user can have many accounts with different format. It doesnt seem to work.The query: $accounts = $user->account()->where('account_no','like', ['34%','35%','3303%','3304%'])->get(); i'm wondering if this can be done or not?
I have two controllers (FirstController, SecondController) that use the same functions, to avoid rewriting them I thought of creating another controller (ThirdController) and subsequently calling the functions through it. the problem is that if in ThirdController there are relationship query…
I'm having trouble with the Laravel BelongsTo relation. I want to loop through a collection of cooks and get meals from them. I create the cooks collection like this: $cooks = Cook::has('meals')->get(); Then I want to get the meals like…
How do i calculate the totals of all values of a column amount after fetching it in laravel controller. table collections has only amount and id column and i want to determine the totals.
I'm trying to create foreign keys in Laravel however when I migrate my table using artisan i am thrown the following error: SQLSTATE[HY000]: General error: 1005 Can't create table `bright`.`carts` (errno: 150 "Foreign key constraint is incorrectly formed") (SQL: alter…
Her is my DB Structure I want to get 2 things. Allocated Departments to a user Departments not allocated to the user I have achived first one through hasMany() relationship in AllocatedDepartment Model public function departments(){ return $this->hasMany(Department::class, 'id', 'department_id');…
I have create a category Table i want to feed some fake date using Faker and Factory after doingusing php artisan db:seed i get error of InvalidArgumentException Unknown format "Str" i have try each format as per itellisense suggest as…
I'm writing an app that allows to rank (vote) among several options. If an user from the Internet (not signed into the app) votes, I just store it with a user_id = NULL, but if some authenticated user votes, I…
I have a table called services with multiple columns and one column named staff_assigned with this content: [{"user_id":"15549","price":"100"},{"user_id":"15548","price":"300"},{"user_id":"15552","price":"95"},{"user_id":"15553","price":"600"}] How can I find all services where user_id is 15548 with Laravel eloquent? Note that Service::where('staff_assign->user_id', "15548")->get(); doesn't work because column contains…