I have no idea what all of the terminology means in the Laravel/Eloquent docs for relationships like hasOne or belongsTo. The hasOne class has the properties $parent, $related, $foreignKey, and $localKey among others. The belongsTo class has the properties $parent,…
I have a categories table. every category has some posts. I want to get categories with their last 10 posts. So I tried this: Category::query()->with(['posts' => function($q) { $q->take(10); }])->get(); The problem is instead of putting 10 posts in each…
My Laravel links keep breaking each time I restart my local server So, I am using Laravel 9 and my links keep breaking each time I reload the page or when I restart the server For example 127.0.0.1:8000/cars/1/edit will become…
"message": "Call to a member function find() on array", "exception": "Symfony\Component\Debug\Exception\FatalThrowableError", How do I get the id parameter from the array below: When i pass the parameter 1 i want to fetch only first element when id is 2 I…
A table called api_call_data is being used in a seperate database (done by the original code author, not me) which is located in another server in our Laravel project (I can't move the table). Due to that, the original query…
Hi I want to know how can i do this query in Laravel 8 , I tried adding the join clause but not work as expected, i need join clause? Or maybe there is another form to do it. I…
I'm trying to create shopping cart page. From controller I'm getting an array of order items. Order item has foreign key "meal_id" - relationship with table meals. I need to access to connected meal object, to display information. How should…
I need to apply the same join i do in this code, but in another code i build it with EloquentBuilder $query The join I want is this: $afiliates = DB::table('ad_afiliado as af') ->join('af_promocion as promo', 'af.Clave', '=', 'promo.id_afiliado') ->select('af.logo_url',…
I want to show pagination on my page based on the data from the resource collection. I have done this code for get data in collection and paginate. return auth()->user()->hasRole('admin') ? ArticleResource::collection(Article::latest()->paginate(5)) : ArticleResource::collection(auth()->user()->articles()->latest()->paginate(5));
I have a function in a controller like this: DB::transaction(function () use ($request) { for ($parts=0; $parts < count($request->name) ; $parts++) { $parts_info = new PartsInfo; $parts_info -> part_id = $request -> id; $parts_info -> name = $request -> name[$parts];…