I have a problem with the methods in the controller getting very large and hard to read. In the code below that I will place is a method for ecommerce categories that stores data in the database. At the beginning,…
I'm using Laravel 10 and I have made a table named pages which stores the all static pages field data of website. Here is the table: Now in order to retrieve this data, at the Controller I added this: use…
I'm designing the database for a food delivery app. There are special kind of products: Product examples: Kebab (price is fixed) Pizza Margherita - (price is dynamic) Pizza Half-Half - (price is dynamic - there are two products combined into…
Im trying to return results for 2 models into one resource and finding it a bit difficult to understand. I have a 'project', this project can have multiple 'members' and it can also have people that have been 'invited' ...…
I have the following queries in my controller to show some statistics about orders paid, and unpaid and the respective amounts (totals), by year. Yet, I feel that the queries I'm using may be optimized but I can't figure out…
I am using spatie/laravel-data to work with some data that eventually gets inserted into the database. One of the things I need to do is sum up and average some things while I'm doing calculations, and I have (maybe unwisely)…
Hello I have a project table which has a field name in my db which is multi lang so I stored it as json so I can store each lang value the problem is that the arabic lang is being…
I am trying to retrieve data using a belongsToMany relationship in Laravel. So I have Student and Course model and they have a many to many relationship, but there are few courses that are compulsory so we don't want to…
I have this model: AppControllersImageController.php ..... $image = new Image; $image->id = "pre_" . (string) Str::ulid()->toBase58(); $image->filename = $filename $image->post_id= $post_id; $image->save(); return $image->load("post:id,status,subject,body"); it is working fine, it returns the following: { "id": "pre_1BzVrTK8dviqA9FGxSoSnU", "type": "document", "filename": "v1BzVc3jJPp64e7bQo1drmL.jpeg", "post_id":…
I'm working with Laravel 8... So I have the following eloquent query, I've eager loaded a bunch of models but I want to do 2 things to the way the models are loaded: Only select certain fields from the cooking_methods…