I want to fetch data from the database using laravel by using multiple conditions. The query must look for the different conditions in same columns and grab the result. Table looks like this Item Position Gender A All All B…
On laravel 10 site I have 3 related tables : Schema::create('users', function (Blueprint $table) { $table->id(); $table->string('name'); ... $table->timestamp('created_at')->useCurrent(); }); Schema::create('tasks', function (Blueprint $table) { $table->id(); $table->foreignId('creator_id')->references('id')->on('users')->onUpdate('RESTRICT')->onDelete('CASCADE'); $table->boolean('completed')->default(false); ... $table->timestamp('created_at')->useCurrent(); $table->timestamp('updated_at')->nullable(); }); Schema::create('task_user', function (Blueprint $table) { $table->id(); $table->unsignedBigInteger('user_id')->unsigned()->index(); $table->foreign('user_id')->references('id')->on('users')->onDelete('cascade');…
I have two tables that are connected with a pivot table. shows: +----+--------+ | id | show | +----+--------+ | 1 | show1 | | 2 | show2 | | 3 | show3 | +----+--------+ draft_types: +----+--------+ | id |…
I need help with my laravel 11 project. I have a table which acts as a morph table which would work with morphedByMany. But for this particular model I only need to retrieve one entry. My tables are: Site, Domain…
I'm encountering an issue with whereFullText in Laravel. Here's my code: $search_key = $args['q'] ?? $args['search_key'] ?? NULL; $builder->when($search_key, function (Builder $builder, $search_key) { $builder->whereFullText(self::fullTextColumns(), $search_key . self::WILDCARD, [ 'mode' => 'boolean', // [ natural, natural language, query expansion, boolean…
I'm currently building an API assigned for an ecommerce project using Laravel framework. While getting help to build data migrations and Models, I got confused on how the product_categories, the intermediate table, can link a product and category as in…
I'm encountering an issue with Laravel Eloquent while trying to order query results by a column from a related table. Specifically, I have a recipes table and a related nutrients table, and I want to order recipes by the kcal…
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:…
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…