Laravel Query With sqlsrv
i have a query to fetch all data and these data are support tickets, each support ticket has many comments, i want to order these data by last comment if exists else order by ticket created date any idea what…
Laravel – Multitenant route api with react component
i am building a multitenant saas system, with laravel for backend and for my frontend i chose to use react js. But it is my first time i do this type of system (Tenant). So i have a question, how…
Php versions – Having trouble deploying Laravel site to Bluehost subdomain
[Update: At this point, I have been able to resolve all my deployment problems but one. The most recent one is that I had an Access denied for user 'bob'@'localhost' (using password: YES) error whenever I attempted to access a…
Plesk – exclude a directory from Laravel mechanism and access the directory directly
I have a website built on Laravel 9. Now for some reason, I need to add a folder/directory in the root (httpdocs) named "news". When I go to my website e.g. mywebsite.com, Laravel website works fines as expected but when…
Php versions – `console.log` and `alert` not working in Vite Laravel 10 app
I'm currently working on a Vite Laravel 10 app and I'm facing an issue where both console.log and alert statements are not working. I have the following code in my `resources/js/app.js alert("hi"); console.log("hi"); import "./bootstrap"; I expect to see the…
Populate dropdown select button with database array values Laravel
I'm trying to populate a HTML select dropdown with values of a particular column in the database which is an array in this format ["Red","Yellow","Blue"]. I know how to pull the entire product instance for a particular row from DB…
Laravel – Get a data from user table for line chart (chart.js)
Below is the image is what i am trying to achieve:- I am on Laravel and I want to get the last 30 days from the current date data from the user table based on how many new users enter…
Laravel – Need help to decipher how the app connects to the database
I'm a Php newbee and I recently received some work for an app (php/laravel) which is running on the server (AWS) using MySQL with RDS with nginx hosting the app/php contents this is the file that defines paths for nginx…
Laravel Sanctum CSRF Protection
So I am trying to configure Sanctum so that I would have CSRF protection for my API routes so that only my SPA's frontend would be able to make requests to it. After following the documentation and doing the instructions…
Laravel – groupby sum and count tickets
I am learning to use groupBy. In my exercise, I must count the number of tickets that were sold and add the total money collected. $tickets = Ingresostaquilla::groupBy('tipo') ->selectRaw('count(*) as quantity, tipo') ->get(); I did the count by type of…