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…
Below is my controller code $category_ids = array(); foreach($categories as $category){ $category_ids[] = $category->id; } $paginated_products = Product::where('status',1)->whereIn('category_id',$category_ids)->latest()->paginate(30); Below is my blade view code $first_ten_products = array_slice($paginated_products,0,9); But am getting the error below how can i fix it. Thanks array_slice():…
i have a problem that when i get data from other api and want if same title wont save to api. Each time getting data from the api is 20 and want to save it to the database without duplicate.…
I have two relationship table. I used with using where to filter records as well as i used wherehas using where to filter records. But can't find the differences between both
I have the following Laravel query, it does not appear to be returning the $abort and $pend variables as strings: $abort = "Aborted"; $pend = "Pending"; $transactions = DB::table('callpay_transactions') ->select(DB::raw('SUBSTR(created,1,7) as YrMth') ,DB::raw('SUM(amount) as total_sales' )) ->where('status', '!=', $abort) ->where('status',…
How can I write query for below table in Laravel. Like In my app logged user id is 109 So I need whose user match with logged user in BlindDate and PaidDate table to user id. This is User table…