I have a problem with retrieving the data from Users table: User: -id int -name string -compartment_id int This is related with compartments table: Compartment: -id int -name string -country_id int Which is related to countries table: Country: -id int…
I have three tables categories, film_categories and films and three models respectively Category, FilmCategory and Film. I have seen many tutorials where they don't create a pivot table model like i have created FilmCategory Model . They just create a…
I have no idea how to solve my problem. I have Model1 with relation: class Model1 extends BaseModel { public function details(): BelongsToMany { return $this->belongsToMany( Detail::class, 'model1_details', 'model1_id', 'detail_id', ); } } model1_details is my pivot table. Also I…
maybe someone know how to insert pivot table in Laravel 8 automatically every i insert counselings table? I have Model Counseling n to n Problem, Input form counselings table problems table Counselings Model Problem Model Controller public function create() {…
I want to have the same mechanism like this https://www.w3schools.com/html/default.asp but in laravel application This is my code on routes/web.php Route::get('tutorial', function(){ $tutorial = Tutorial::get(); return view('tutorial.index')->with('tutorial', $tutorial); })->name('index-tutorial'); // Show one Tutorial by Id Route::get('tutorial/{id}', function($id){ $tutorial = Tutorial::findOrFail($id);…
In my case, I have three tables: type id type reason_id reason id reason permission id type_id reason_id (not sure has or not) I expect that: { "message": "Get all permissions with type and reason", "data": [ { "id": "1",…
Hello I am working with Laravel, I have to create two simple models, let's say Stores and Books. Stores can have one or multiple Books and Books can belong to many Stores. Of course I will use a many to…
I'm just learning laravel. I want update key / value in database with laravel api but not work. My products model is one to many with ProductMeta and many to many with contents model. My Models class Product extends Model…
A Teacher has many Students. When I am showing the Teachers list I also want to show the counts of Student for each Teachers. How can I do this by using Eloquent? I can find the Teachers from this, $teacher=…
Help me please. I'm trying to write a function where I get all the categories of my forum with the 3 most recently updated Topics in the given categories. But according to the result, take(3) filters by id (where the…