Eloquent hasMany with multiple foreign keys and where
Hi! I have two tables, tasks id startTarget endTarget status targets id title I need get all tar...
filter data in hasMany using where and parent field value
Hi, Is it possible to filter the data returned by relationship using values in the parent class Prog...
DB query builder with LEFT JOIN using a RAW expression
I would like to left join data from a many-to-many relationship. In my first attempt to solve the pr...
Handling unchecked checkbox by updating
When a checkbox is not checked, it gives no value back. How to handle this in your model when updati...
remove null from laravel collection ,php array
Hello I need to remove null coming from database , after using this code $school_dropdowns = DB::tab...
Searching for newest data and oldest data from the DB.
How do i use Eloquent to search for newest and oldest records from the database.
How do I integrate a custom sql into a model
Hi, I am using Eloquent with Codeigniter, and I have a model that has multiple one to many and many...
DB::select with raw where
Hey, I'm having a hard time compiling the DB:: or preferably Eloquent code for a query that involves...
403 error on from submit
Hi. I faced with some problems on my Laravel project. Script works correctly on WAMP but when I uplo...
Eloquent get count relation
My Eloquent model Module has many Sections. I can query thus: Module::with('sections')->get();...
Upgraded from Laravel 5.4 to Laravel 5.5 getting error.
Just updated a Laravel project from Laravel version 5.4 to 5.5. Just after that getting the followin...
updateOrCreate large number of records
I have a relatively large number of records that will need to be updated once a minute (anywhere fro...
Can I add a where condition on the belongsToMany join?
Hi, having this relation public function programs() { return $this->belongsToMany...
How to get Image from MS SQL Server Database
How to get Image from MS SQL Server Database. Column DataType: Image ?
Best option , Laravel Many to Many or Not
Hello guys , does some one could help me ? I am developing a real estate website , something like th...
Laravel way to generate Affiliate Referral Tree
can anyone help me in getting this done correctly ? I have asked question on Stack over flow and tri...
Use Eloquent to Query only master table
I use PostgreSQL with partitioning by one table. Here's my quesrtion. Is there any way to query ONLY...
MAX/GROUP BY Query
How would I do the following query using query builder? Preferably without using any raw sql :-) SEL...
Sorting by related field
How do I orderBy a field that's in a related table as in: DB::with('relatedTable')->orderBy('rela...
Order and paginate a collection by a releted field using Eloquent
I have these models: Post, Category and User. My goal is to show a paginated and sortable table disp...
Thanks to our community
-
muhalifanhar 1 Solution1
-
ajooda 1 Solution2
-
miladghorbani1999 1 Solution3
-
fredikaputra 1 Solution
4 -
ali_rasouli 1 Solution5
Solutions given in the past year. Excluding solutions from thread authors.
Moderators
-
driesvints Joined 16 Dec 2013
-
joedixon Joined 23 Jun 2014
-
tvbeek Joined 8 Jan 2018
Filter tag
Select a tag below to filter the results
