I have made my own Access Control List with Laravel 9 and basically, I made also a Many To Many relationships between User & Role: User Model: public function roles() { return $this->belongsToMany(Role::class); } Role Model: public function users() {…
My view displays collections from four different tables. $redtable is my longest collection. @for ($i = 0; $counter < $redtable->count(); $i++) <div> {{ $red->slice($i, 1)->first()?->content }} {{ $green->slice($i, 1)->first()?->content }} {{ $blue->slice($i, 1)->first()?->content }} {{ $gray->slice($i, 1)->first()?->content }} <div> @endfor…
I have two related models in a job listing application, Company and Listing. The relationship between them is that company may have listing and a listing must have exactly one company. class Company extends Model { use HasFactory; /** *…
I want to make a chat app. So I can get a list of patient but the top last message doesn't have the patient. How to solve my problem. PHP : $appointment = Appointment::with([ 'upcoming.consultant' => function($query) use ($user) {…
I have two models, User and Post, where a User can have multiple Post models. In my application, I only want to retrieve the title column from the related Post model when querying for a User. Here is my current…
I have a Laravel application. I am performing the user information update function, but I can't bypass the validation check for the admin_email and admin_title fields in the tbl_admin database. I am using the following FormRequest: <?php namespace AppHttpRequests; use…
I have a small Laravel app that is basically a few tables as follows and I'm having a problem with Laravel Eloquent generating more SQL queries than it needs. I am basically trying to display all 'grades' for a student…
I am trying to figure out how to form my database query to build up a collection of projects, each of which has a set of personnel with their assigned working periods and the daily shift hours that they submit.…
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();