New Discussion
ethar ethar
4
Eloquent

Multi Parameter in Search 'GET'

i try to make multi search parameter, i check if request->any have value or not, if have value shot match that value , if not should not append it in search...
ethar replied
Solved
Eloquent
4
31
princeoo7 princeoo7
7
Eloquent

how to search result in data appended in model ?

I have 2 tabled, First is category and second is categoryTrasnlation. As the name suggest. 1st table save based data for a category a...
princeoo7 replied
Eloquent
7
111
ChrisF79 ChrisF79
5
Eloquent

How to save to a database with multiple tables?

I have a Users table and an Address (mailing address) table and I have the relationships set up as such: User Model class User extend...
chr15k replied
Solved
Eloquent
5
105
Formatink Formatink
5
Eloquent

Nested comments with eager loading

Hello, I am currently doing a nested comments system. In my model, I use this method to retrieve children of the comment pu...
ziayamin replied
Solved
Eloquent
5
525
mallaury mallaury
6
Eloquent

Get withCount() of nested relationship

Hello, Here is my problem: In my database I have departments that have lessons. Lesson belongs to many departments. So there is a pivot table named department_lesson...
MichalOravec replied
Solved
Eloquent
6
93
tduffy tduffy
5
Eloquent

Trying to do a SQLSRV Query using cte_sum in Eloquent

I have a Laravel 6 app that uses a MySQL connection for authentication and storing user settings, but it also uses a SQL Server connection to read data for dashboarding. I...
staudenmeir replied
Solved
Eloquent
5
696
datarecall datarecall
4
Eloquent

Pagination

I have a method on my Supplier model that looks like: public function getAllDiariesAttribute() { $products = $this->products(); $weeks...
MichalOravec replied
Eloquent
4
55
t0berius t0berius
2
Eloquent

laravel load() with paginate()

Using the following query: $product->load(['stockItems' => function ($query) { $query->available()->oldest()->paginate(2); }])...
t0berius replied
Solved
Eloquent
2
34
Mikegk Mikegk
8
Eloquent

Relationship Problem

Hi guys, I just faced a relationship problem. I have got a "Category" Model that has many CategoryData (entries). One CategoryData belongs to the Ca...
Sinnbeck replied
Eloquent
8
74
joseff joseff
1
Eloquent

Please help me with the table structure.

WHAT AM I TRYING TO DO application manager, calendar, custom content template application, facebook application (bring the last post) etc. briefly application manage...
automica replied
Eloquent
1
44
mrcorex mrcorex
5
Eloquent

illuminate/database (+ migrations) outside Laravel

Hey guys. I am trying to find a good solution to use illuminate/database (+ migrations) outside Laravel. I have the need of several packages (non-public) that are ta...
juanatwondersauce replied
Eloquent
5
891
ChrisF79 ChrisF79
2
Eloquent

Unknown Column when inserting into a polymorphic schema

I created a "telephonenumbers" table that will store many numbers for each "customer". However, when I try to insert I get an error that the column &quo...
ChrisF79 replied
Eloquent
2
71
Dhruva Dhruva
3
Eloquent

How to use Scope for Intermediatble Table in Many to Many Relationships

Hi All I am trying to use scope for retrieving column field name from many to many relationship's intermediate table. Pivot Table fields are quiz...
bobbybouwmann replied
Eloquent
3
67
scottsuhy scottsuhy
3
Eloquent

Eloquent relationships that deal with 3 tables

I have made all the one to many relationships in 3 models ‘user’, ‘auctionschedule’ and ‘auctionregistrations’ for “hasMany” and “belongsTo”. Here is...
scottsuhy replied
Solved
Eloquent
3
68
Mick79 Mick79
15
Eloquent

Group by month and order by something else?

I'm stuck... I have a series of posts that can be upvoted by my users. I require these posts to be grouped by month (as this is how I display them on the site) but w...
rodrigo.pedra replied
Solved
Eloquent
15
273
eeight eeight
8
Eloquent

One To One (Polymorphic) - nullable?

Is it possible to have a One To One Polymorphic relationship nullable? I want to extend the users table (adding userable_type and userable_id) and 2 morping tables (mentors...
bugsysha replied
Eloquent
8
165
jesse_orange_newable jesse_orange_newable
2
Eloquent

Working with date and time

I have a query scope called inDate that is meant to check the given start_datetime and check whether its newer than today i.e Carbon::today(...
jesse_orange_newable replied
Eloquent
2
53
graemenewable graemenewable
4
Eloquent

How to prevent the rounding of decimals when inserting into mysql database

I have a strange issue whereby each time I insert or update decimals into my database, the decimal values get rounded. For example if I insert 51.4988814, it g...
Geoff38 replied
Eloquent
4
942
timtom timtom
11
Eloquent

Update return false

Hello, I try to do an update request but the request return false. Do you know if something exist to see the error in details (and not just get false in return ...)...
Talinon replied
Solved
Eloquent
11
162
ethar ethar
6
Eloquent

hasOneThrough RelationShip

i have City Model (id,name), and Address Model (id,cities_id,users_id) and Orders Model (id,products_id,addresses_id). in Orders Model i...
ethar replied
Eloquent
6
92
TristanKobalt TristanKobalt
10
Eloquent

Using model variables in a relationship function

I am trying to constrain a relationship based on another relationship from that same model. class CinemaRoom extends Model { public function cinema() { r...
TristanKobalt replied
Eloquent
10
279
krie9er krie9er
10
Eloquent

how does laravel know?!

Heylo, i've made some startexercieses and they were pretty cool. But i still have one question: how does laravel match a model to the equivalent of the...
martinbean replied
Solved
Eloquent
10
320
ajfick ajfick
2
Eloquent

Splitting model data between tables based on type

Hello! I'm working on a listing site which will have a few major categories of listings available to users. These categories will each have some "listing type&q...
martinbean replied
Eloquent
2
63
TomNeal TomNeal
7
Eloquent

Quickly counting records with Eloquent

Hi, I display in my application a count of the records that exist within a table. When the user changes an input i.e. selects a different start date, it sends an aja...
TomNeal replied
Solved
Eloquent
7
125
finlamit finlamit
1
Eloquent

Eloquent, group by relationship.

Hi My data. Projects -> (has many) Tasks -> (has many) SubTasks I am looking to display all of the SubTasks in order of the Su...
_Marco_ replied
Eloquent
1
80
KevDev KevDev
4
Eloquent

Whats the best way to remove item on a hasMany relation

Hi. So I have a posts that has a hasMany relation with photos and then I remove 1 of the photos but the relation only no...
Snapey replied
Eloquent
4
87
FrankClark FrankClark
2
Eloquent

Eloquent : Scope whereIn matches all (relation)

Hello There, I have a table rooms And a table room_availabilities A room has many room room_availabilities...
FrankClark replied
Solved
Eloquent
2
65
ethar ethar
3
Eloquent

send static data with eloquent result

from cookies, I get (item_id, item_qty), depend on item_id I make a select statement to return data, I want to send item_qty with this statement to the blade...
GeordieJackson replied
Solved
Eloquent
3
110
Drummerkolle Drummerkolle
3
Eloquent

Eloquent Has many over different models with index sort

Hi everybody, I'm kind of stuck what to do for my use case, or better which relation to choose for it... I want to have a table for multiple webpages (landing...
martinbean replied
Eloquent
3
95
ethar ethar
3
Eloquent

query inside foreach

i try to get all product where id in array if(isset($_COOKIE["shopping_cart_panorama"])){ $cookie_data = stripslashes($_COOKIE["shopping_c...
Thibaultvanc replied
Eloquent
3
78
Mrs_Beginner Mrs_Beginner
5
Eloquent

some thing like Soft delete in model for returning only active models

i Have product model (Belongs to products table), and i want to tell model when i select any product you have to return the models that their Active column is True,...
bugsysha replied
Solved
Eloquent
5
110
derekdunes derekdunes
1
Eloquent

Laravel 7 sync issue using eloquent models

Please how do you perform this code $user->roles()->sync([1 => ['years' => true,'levels' => true], 2, 3]); using a for loop or for each...
guybrush_threepwood replied
Solved
Eloquent
1
68
yaeykay yaeykay
1
Eloquent

Laravel whereDoesntHave union whereHas

I'm trying to query my models that don't have relation and union it with the ones that have relations but I get an error with memory being exhausted. Post::w...
bugsysha replied
Eloquent
1
57
schroedingerswg schroedingerswg
2
Eloquent

Getting error on one-to-many relation

Hey, I receive this error, when trying to get the relation: https://flareapp.io/share...
colbyalbo replied
Eloquent
2
75
oroalej oroalej
4
Eloquent

When to use Model Observers and Mutators

Hi All, When do I need to use Observer and Mutators? For example I have 6 Setters and Getters, is it better to just place it in Observer's creating...
martinbean replied
Eloquent
4
145
Create a New Discussion Button

Want us to email you occasionally with Laracasts news?