For this issue, I have reduced the complexity of the database. I have a table with Orders id name And a table with Suborders id order_id user_id One order may contain numerous suborders. A suborder is only connected to one…
I'm a beginner with Laravel and inertia. I use Laravel 10 with Inertia and react. When I go to the index page, the field "$this->typeEducation->title" is filled, but when I click edit, the field is empty. I then get the…
problem with this is withCount() not changing after when() is applied for example without when() transaction_count is 5000 and after when is applied it still remains 5000 ? it should change according to filter apply in when() public function allUsers(Request…
I want to ask for your help. I'm studying laravel, i am using laravel 10, and I need to retrieve related data, the application and data that I'm working on are related to students in a school. I want to…
I was trying to add a new column as a foriegn key in existing table in laravel 9. But, it continuously giving SQL error. I want to create a simple category_id as a foreign_key in brand table. The below code…
In below query the awarded, banned, featured and published parts are being ignored, why? Query: Show me a list of all featured published books with an author that has been awarded and has not been banned. $books = myBooks::with('authors') ->whereHas('authors',…