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…
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;…
Here is the query I tried to write and gives an error $users =User::has('subscriptions', function (Builder $q) { $q->whereNotNull('ends_at'); })->get(); Getting this error SQLSTATE[42601]: Syntax error: 7 ERROR: SELECT * with no tables specified is not valid LINE 1: ...sers"."id"…
This is my original code where i display all data for team users. $data = Teamuser::join('teams', 'teams.id', '=', 'team_user.team_id') ->join('users', 'users.id', '=', 'team_user.user_id') ->get(['users.name as username','teams.name','users.email','team_user.role','team_user.id','team_user.user_id','team_user.team_id']); However, since im developing a search function for the table. I try adding orwhere…
I'm trying to delete a record with two primary keys, using Eloquent - Laravel. This is my model class Like extends Model { //protected $primaryKey = ['crdid', 'usrid']; public $timestamps = false; use HasFactory; } Controller try{ $dellike = Like::where('crdid',…
First please excuse my English, I'm french... Also, I must admit that I'm not a pro developer. The reason why I'm here. I'm trying to build a Laravel app based on an existing database. The original app was built with…