I am using Laravel 11 and the following structure: users - id artworks - id collections - id collection_user - id - collection_id - user_id artwork_collection - id - artwork_id - collection_id So a User can have multiple Collections, a…
I am currently using Laravel Scout to search through my models with the database driver My search controller looks like this Post::search($request->filter)->get(); Lets say I have a posts with a Text that say "Hello this is a Post" When I…
I have three models: Group, Activity, User. With the following relationships in the models. Activities belongTo a Group (with the group_id being a field in the activity) Users belongTo a Group (with the group_id being a field in the user)…
I have a table transaction_details cta scta sscta charge 102 1 1 80.00 102 1 1 5.00 102 1 2 20.00 102 1 2 2.00 105 1 0 30.00 105 2 0 50.00 107 1 0 45.00 107 1 0…
Imagine we have a Facture and Item model in a one-to-many relationship. I'm using $facture->items() or $facture->load('items') and it works perfectly. However, when I need to use a condition on items like where('items.price', 30), I have no idea how to…
I'm not sure how I should have titled this question. I have a table called products. A simplified schema is: +--------+-----------+----------+ | id | name | priority | +--------+-----------+----------+ | 1 | Product 1 | null | | 2 |…
My question is quite similar to this unanswered question. I'm making a 2v2 ladder system in Laravel 11. I have 2 models: Users Games There's a pivot table between them with an added team_user column, defining which team the user…
Background In my Laravel application, I have models Organization, Region, and Location, which all have a polymorphic relationship to the User model via an Assignment model. (An Assignment is a three-way relationship between User, Role, and one of the other…
$dbConnection = DB::connection('test_connection'); $dbConnection->beginTransaction(); try{ $dbConnection->getSchemaBuilder()->create('Alpha_1', function ($table) use ($validatedData) { $table->string('name')->nullable(); }); $dbConnection->commit(); } catch (Exception $e) { // Rollback the transaction in case of error $dbConnection->rollBack(); // Get the exact database error $errorMessage = $e->getMessage(); dd($errorMessage); } I…
I am using the Cknow/Money package to handle money values in models. I have this model event that validates a value before saving to prevent wrong data from being entered due to a common scenario: I have this laravel 10…