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…
this code is working but is there a better way for it to make it shorter if ($request->has('images')) { $images = []; foreach ($data['images'] as $image) { $images[] = UploadImage::uploadImageToStorage($image, 'Feeds/store/' . $data['store_id']); } $data['images'] = $images; }
I have three Collections with the same keys and different numeric values, and I'd like to sum them together. e.g. $broadInventory = {'horse': 300, 'cow': 400, 'entropy': 400}; $ericaInventory = {'horse': 10, 'cow': 20, 'entropy': 30}; $johnsonInventory = {'horse': 5,…
I want to fetch only one columns which has name image_url from relationship table. relationship on table is belongsTO. i am confused how to fetch only single column value with belongsTo relation. below is my model. <?php namespace AppModels; use…
I have a field called language in my table submission. Here the different user has submitted their problem with different language such as java(56) 5 times, CPP(45) 7 times, and python(71) 10 times. I want to have a query in…