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();
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…