I am having a little trouble with the logic of this sql, I don't know why it's given me an error but the error is at line 4 "the start of the first AND". What I am trying to do…
I have no idea what all of the terminology means in the Laravel/Eloquent docs for relationships like hasOne or belongsTo. The hasOne class has the properties $parent, $related, $foreignKey, and $localKey among others. The belongsTo class has the properties $parent,…
I installed Laravel UI using this tutorial https://www.itsolutionstuff.com/post/laravel-9-authentication-using-breeze-tutorialexample.html The login and register forms are there http://localhost:8000/login but after login if I go to my route (http://localhost:8000/api/categories) inside the middleware I am redirected to the home page. If I have the…
I have a categories table. every category has some posts. I want to get categories with their last 10 posts. So I tried this: Category::query()->with(['posts' => function($q) { $q->take(10); }])->get(); The problem is instead of putting 10 posts in each…
I have two data tables vehicles and trips, which have a one to many relationship and allow for multiple trips per vehicle. route is a column in the trips table. I want to see the vehicle list for a specific…
I have a laravel blade view/page that I'd like to update without refreshing the page. The blade.php code is working fine and retrieving data from a MySQL database - but the ajax/javascript isn't. Apparently my AJAX calls are not even…
My Laravel links keep breaking each time I restart my local server So, I am using Laravel 9 and my links keep breaking each time I reload the page or when I restart the server For example 127.0.0.1:8000/cars/1/edit will become…
This one's been giving me problems for a week, cross my fingers one of you can help me here... This application was built on Laravel and the front scaffolded using Vue. Thing is I have an array of objects that…
I have a table called addresses, it has a column name user_ids which is an array of the users who have that same address. When I request to /api/addresses what it returns is {id:1,name:"lorem", user_ids:[1,2]}. I want it to return…
I'm using a container in Docker to host my Laravel app and this container is connected to another container using Nginx to host it. I'm trying to import a SQL file into my Laravel app with a seeder that's like…