I have a small query to run in my controller, it works fine in MySQL Workbench SELECT subprocess_id, MAX(CASE WHEN step_no = '1' THEN s_name END) AS first_step, MAX(CASE WHEN step_no = '2' THEN s_name END) AS second_step, MAX(CASE WHEN…
I have a database with users and a database with posts. A user has many posts. When a user deletes their account, I don't want to have their posts deleted. This results in a problem: when I try to access…
I have two laravel 10 projects in the same domain cms and website i access the images and files from cms side that url show domain.com/cms/public/storage/pages/press/root_1683963515doc.pdf here i remove the public from url and the cms domain like domain.com/cms/public/login without…
I'm working on a livewire component that acts as a file browser. Initially a list of files and folders is passed to the components blade, if the item is a directory an anchor is returned which changes the current path…
I have a minor issue where there is a text "Laravel" appearing on my header. Laravel Version is 10.13.5
I want a different Model the be able to login too. The name of the Model is Client. So this is added this to auth.php config: 'guards' => [ 'web' => [ 'driver' => 'session', 'provider' => 'users', ], 'client'…
I need to get an accurate timestamp of the request in order to then calculate the session end time I need the timestamp in the layout to be available globally for some JS script, so right now I store it…
Here is my validation code in the controller $eldate = Carbon::now()->addDay(4)->format('Y-m-d'); $validatedData = $this->validate($request, [ 'ldate' => 'required|date|unique:leaves,ldate,NULL,employee,employee,'.auth()->id(), 'ldate2' => 'nullable|date|after_or_equal:ldate', 'type' => 'required' ]); In this validation code I have to add one more condition for date1 If type…
I'm working with Laravel v10 and I have a users table and each user has also another record at the members table. So in order to set up the One To One Relationship between these two Models: User Model: public…
I'm building this multi-platform front-end using flutter for my webpage and I get an error when connecting to my Laravel back-end. I'm tracing the issue to the request on flutter, which I'm using Dio ^5.1, since I can log in…