I need to make an advanced query in Laravel hopefully using Eloquent to make that a collection but a query builder or raw normal SQL query is acceptable. I have users table with User model having relation: public function roles()…
I'm using Laravel Fortify in my site. It has 2 different authentication screens for Admin and User. For example: Admin login route: /admin/login Admin forgot password route: /admin/forgot-password User login route: /login User forgot password route: /forgot-password and so on...…
I am developing a Laravel 9 application, which is using Blade for UIs. The application uses some pictures which are stored in resources/images folder. In my Blade views I include the images like this: <img src="{{ Vite::asset('resources/images/logo.png') }}"/> Everything works…
i'm facing an error Call to a member function subjects() on null . My project is by php and laravel. My project is on live server. Its works fine normally but when i click to edit something or click update…
I have a dev server that is used by me and a fellow dev, I have set up similar scenarios on live development servers before. The following Apache set up has worked on other Laravel projects, though lower versions. The…
I have made a blogging application in Laravel 8. I am working on the functionality of adding comment replies. In the controller, I add comments like this: $comment = [ 'user_id' => Auth::user()->id, 'article_id' => $request->get( 'article_id' ), 'parent_id' =>…
I have a hasOne relationship. The image shows the records of the relationship which have the same "contract_id" Following result is required: I want to only select the last record with the highest "version" => 5, but only if the…
I am trying to improve at laravel, the story here is that I have customers, customers can have appointments and users create appointments for the customers. Visit model: class Visit extends Model { use HasFactory; protected $fillable = [ 'user_id',…
I am trying to filter data with search terms. But its not populate data. Any one can help me with this? Here is my code: $query = Lesson::select('lesson.*') ->join('lesson_language', 'lesson_language.lesson_id', 'lesson.id') ->leftJoin('content', 'content.lesson_id', 'lesson.id') ->leftJoin('lesson_role', 'lesson_role.lesson_id', 'lesson.id') ->leftJoin('lesson_brand', 'lesson_brand.lesson_id', 'lesson.id')…
Controller $userAlbums =album::select('album_id')->where('created_by','=',Auth::id())->count(); $userData = user::where('id','=',Auth::id())->first(); return view('welcome', compact('userData','userAlbums')); Blade @if($userData->email_varified_at == null) @include('include.email-verification') @endif if i try to display $userData->email_varified_at variable it works ,but the IF condition also run every time even if email_varified_at field is not null. is…