How do i calculate the totals of all values of a column amount after fetching it in laravel controller. table collections has only amount and id column and i want to determine the totals.
I'm trying to create foreign keys in Laravel however when I migrate my table using artisan i am thrown the following error: SQLSTATE[HY000]: General error: 1005 Can't create table `bright`.`carts` (errno: 150 "Foreign key constraint is incorrectly formed") (SQL: alter…
Her is my DB Structure I want to get 2 things. Allocated Departments to a user Departments not allocated to the user I have achived first one through hasMany() relationship in AllocatedDepartment Model public function departments(){ return $this->hasMany(Department::class, 'id', 'department_id');…
I have create a category Table i want to feed some fake date using Faker and Factory after doingusing php artisan db:seed i get error of InvalidArgumentException Unknown format "Str" i have try each format as per itellisense suggest as…
I'm writing an app that allows to rank (vote) among several options. If an user from the Internet (not signed into the app) votes, I just store it with a user_id = NULL, but if some authenticated user votes, I…
I have a table called services with multiple columns and one column named staff_assigned with this content: [{"user_id":"15549","price":"100"},{"user_id":"15548","price":"300"},{"user_id":"15552","price":"95"},{"user_id":"15553","price":"600"}] How can I find all services where user_id is 15548 with Laravel eloquent? Note that Service::where('staff_assign->user_id', "15548")->get(); doesn't work because column contains…
It looks small problem but I can't find the best solution. In Laravel validation, I need to check if the user enters the company email and I'm using ends_with check. But it is case sensitive $request->validate([ 'username' => [...], 'email'…
Am displaying user profile data from the database to an input field and at at the same time, the user should be able to update the input field Controller.php // shows details in input Public function details() { $id =…
I have two Models: Users and Appointments class Appointments extends Model { use HasFactory; protected $fillable = [ 'business_id', 'user_id', 'subject', 'description', 'status', 'phone_number', 'start_appointment', 'end_appointment', ]; class User extends Authenticatable { protected $fillable = [ 'name', 'email', 'password', 'card_id',…
I am trying to get the new validated request after merging the request with new variable. It can be found in $request->all() but not in $request->validated(). I understand that the new variable doesnt not being validated with the request but…