I got this error while running php artisan migrate:fresh --seed this command will create table in MySQL database and fill the database details DB_DATABASE in .env file. parent::boot(); static::creating(function($model) { $user = Auth::user(); model->created_by = $user->id ? $user->id : 1…
I'm migrating my Laravel app to Vite, and one of the things I wanted to do is copy over my images assets to the public folder. Following the Laravel doc https://laravel.com/docs/9.x/vite#blade-processing-static-assets I added import.meta.glob('../images/**'); to my app.js file, and ran…
I recently started going through inertia.js docs, and tried to replicate pages with a default layout: https://inertiajs.com/pages My app.js (followed by the docs) looks like: import "./bootstrap"; import "../css/app.css"; import React from "react"; import { render } from "react-dom"; import…
Hi I have a situation where I want $first_name = $request->first_name; $last_name = $request->last_name; $customers = Customer::where('first_name','=',$first_name) ->where('last_name','=',$last_name **OR $last_name <> NULL**) ->get(); I want where clause to be implemented only if the input $last_name is not blank. How can…
I want it to reduce the number of products in the cart from stock after the order is placed. sample: The product stock with 5 IDs is 50 pieces, if 5 orders are received from this product,I want it updated…
I have a model called Presence that stores user's presences as recurring events, where each row has a start and end date, a frequency, and an interval. In that way, I can use RRule to create events from a single…
The following example will give me all users that are older than $age and have the gender $gender: public function get_users_older_than(int $age = null, string $gender = null) { $users = User::query() ->where('age', '>', $age) ->where('gender', $gender) ->get(); return $users;…
i have problem with my code. I use Ajax in Laravel. I have a database with 2 tables: jobs and timers. In timers, I store the users' working time. The structure of the database is as follows: job_id, user_id, status,…
I have a categories table with parent_id column, referring to parent category's ID. I need to retrieve all of the ID's that are under a certain category (all of its children & grandchildren) I wrote this recursive function but for…
First things first, I upload an image to a Storage:: in the controller like this: $ranker = Ranker::create([ ... ]); if ($request->file('file')) { $filename = Storage::put('ranker', $request->file('file'); $ranker->image_url = $filename; $ranker->save(); } So this is working, in the database I…