How do I return the following response format using the code below: {"data":[],"meta":{"paging":{"links":[],"total":0},"time":0.079}} The controller code: public function someMethod() { $var=SomeModel::with(['status' => function ($query) { $query->where('name', 'like', '%Pending Payment%'); }])->get(); return [ 'data' => $var, ]; } Response am getting…
SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'category_slug' cannot be null (SQL: update products set category_slug = ?, products.updated_at = 2022-12-23 12:06:26 where id = 1) How I get product category_slug colmun from category slug table. Categories Table: |id|name|slug | |4…
I have a User model which has a hasMany relationship to a Brands model and I am having issues updating the Brands for a user properly. I have a form which allows a user to enter / delete / update…
I have a toggle button to set status from pending to approved, it works fine but I cannot sort the values based on pending or approved. Every row value is displayed as PendingApprovedPendingApproved (in console.log). (In database its correctly saved…
I'm creating 192 html pages using this function in the web.php file, but when it creates the fifth page gives me the error. function() { $homepage = Page::find(1); $articles_show = Article::where(function ($query) { $query->where(function ($query2) { $query2->where('draft', 0)->whereNull('publication_date'); })->orWhere(function ($query2)…
Am just learning Laravel and I have this logic were in I want to display array of total items based from user, to explain this further here is my database user table items table this is my current code public…
I have a table that shows a list of students, I want to be able to attach the images to each child in the table and then upload them at once to cloudinary. The PHP code that I have is…
I am trying to work through the below code and it is giving me the error as above in postman. I thought that by storing AttendanceRecord in a variable should've sufficed. I wonder what did I do wrong ? Below…
Laravel site root is https://example.com/path_to_root/ To get to what would be URL path / in a normal site, you actually go to https://example.com/path_to_root/ So, the Laravel site is under /path_to_root/ and there is other non-Laravel content in for, example, https://example.com/other…
I am learning laravel. Right now working on a project with inertia. Have created a model, controller and view in default settings. I am able to create user with the built-in user manager. But getting 403 error while creating records…