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…
I want to display only 3 news in each category to display the last 3 news that were added. Class category: class category extends Model { use HasFactory; public function articles(){ return $this->hasMany(Article::class)->limit(3)->orderBy('created_at', 'desc'); } } Class Article: class Article…
I'm trying to migrate a Laravel 5 API with MySQL 5.7 to a Laravel 9 API with MySQL 8. Almost everything is working well, except on a few queries that tries to load data with their parent, recursively. On Laravel…
I'm trying to call 2 columns from 2 different tables. applicants.ic_no and agents.ic_no. It have different values. Using the following codes only displayed only ic_no from agents.ic_no $claimLists = ClaimDetail::join('applicants', 'applicants.ic_no', '=', 'claim_details.ic_no') ->join('agents', 'agents.id', '=', 'claim_details.agent_id') ->where('claim_date', $cutt_off) ->groupBy('agents.id',…
I have a laravel model that has a JSON column type named "properties". This column is a array of objects like below [ { "quantity":4210, "price":"21247.10", "childs":[ { "quantity":0.19814469, "price":"22329.70" } ] }, { "quantity":1234, "price":"21247.10", "childs":[ { "quantity":0.19814469, "price":"22329.70"…
I have a polymorphic relationship between an Article model and 3 models (Company, Group & User) that sometimes returns null. 90% of the time, the articleable relation is perfectly OK and looks like this: #relations: array:1 [▼ "articleable" => AppModelsUser…