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…
Here I'm trying to keep track of my Employees Skills like when they are added, when removed and then new skills are added. So, I'm getting storing them in the database as follows: Then Retrieving the data as follows: $skillHistories…