I have ProductCollection Model and AttributeValue Model which have a common table product_collection_attributes that has 2 columns: product_collection_id and attribute_value_id that are a foreign key to their respective tables and are both a primary key. In ProductCollection Model relation is:…
I have a table User, which has an id. In another table (AdminUser), I want to reference it, but with camelCase convention. However, Laravel doesn't convert that and/or recognize the user table, so it returns always null when asking for…
To show application_status in result, I'm using DB::raw statement in my query. DB::raw(' CASE WHEN status = 0 THEN "Pending" WHEN status = 1 THEN "Approved" WHEN status = 2 THEN "Declined" END AS application_status' ) How can I convert…
I am having an issue filtering a Mariadb query through HAVING on a computed column based on a Mariadb variable. I am having an issue in Laravel Elquent where a query I am running is producing no results. I have…
I am a bit confused about laravel database connection. If I execute a laravel code that select from database three queries as example. If laravel establish database connection and login into database then logout for each executing query or laravel…
I'm working on an ecommerce project in Laravel 10.48.8, my PHP version is 8.2.12. I have used one to many relation to link the parent table categories to one of the child table products using foreign key in delete cascade.…
I'm trying to build a wizard form in Filament. It has 2 steps: First, an user need to specify some product number. After that script gets some info including image url from other site by api. I want a respective…
My implementation is laravel, but this could generally apply to php/mysql. I have a large file, generally about 500MB that I want to store in the database. If it helps, the file itself is a zip of pdfs. The code…
Good morning Currently I have an application running within AWS through the ElasticBeanstalk infrastructure, this application is made with the Laravel 10 tool and has nginx as a server. My mission is to transform this EB application into a docker…
After run composer create-project laravel/laravel:^11.0 project-name then going to my project folder cd project-name after that i should run php artisan serve but i got an error at this step that seems vendor folder not found in my project Please…