hello I just moved from php native and want to try relationships in laravel, so I want to display a post and each comment and the name of user who comments so that when looped the post has a comment…
I want to get records that are joined between this date period (2022-02-15, 2022-08-20) $users = User::whereDate('start_at', '>=', $startDate) ->whereDate('end_at', '<=', $endDate) ->get();
I am trying to use eloquent's with query within a join query to attach the relationships of the table I am joining with however I am faced with the error "Call to undefined method IlluminateDatabaseQueryJoinClause::with()" Hence, how can I use…
I am trying to autoload models in laravel 9, I want to use models in my blade files, but when i use a model i have to import it writing "use AppModelsUser", and after i can write "{{ User::all() }}",…
I have a table without primary key that looks like this: user_id config_key config_value 2296 config_key_1 config_value_1 2296 config_key_2 config_value_2 2296 config_key_3 config_value_3 2296 config_key_4 config_value_4 And every time I try to update one value from that table, for some…
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);…