Support the ongoing development of Laravel.io →

3,600 Threads

"Prefix" all queries with a where clause

I'm buidling a SaaS and have added a client_id column to each of my tables. Now in my repositories,...

0 Likes
3 Replies

Eloquent: join on confition

Hi, I need to join one table into a query only if another condition is true. I try, using the exanpl...

0 Likes
4 Replies

Ho boy - I have a very large query with > 10 joins - is there a way I can do it with Eloquent?

I've been searching and hacking away for the past few hours now. I have a bunch of models. They're...

0 Likes
0 Replies

Eloquent nested eager loading : bug or fail syntax ?

Hi all :), First of all : I opened a help paste here describing the core of the problem. I did many...

0 Likes
0 Replies

Best practices or better way to achieve these relationships

I'm developing an application system. Breakdown is there are Events and Districts - the Application...

0 Likes
0 Replies

select user followed person's post

users id follows id user_id follow_id posts id user_id let say i am user A and i followed user B. I...

0 Likes
0 Replies

How to properly design interchangeable user repository implementation?

I want the repository to be interchangeable, so I'm not dependant on Eloquent. I therefore have an i...

0 Likes
0 Replies

Any easier way to do this? Can you extend a model that's a conditional of the parent model?

Check out my code here: http://laravel.io/bin/9n9 I have a working solution now as shown, but I'd li...

0 Likes
0 Replies

Advanced leftJoin with date functions

Hi, I have https://gist.github.com/RokSiEu/8793452 But I need to get https://gist.github.com/RokSiEu...

0 Likes
1 Replies

Derived table from Pivot table

Hi folks, i have an issue about a derived table from a pivot table. Here is my schema: locale id nam...

0 Likes
4 Replies
posted 10 years ago

How can I add where clause on DB::raw equation result?

I have a query with a select that has a DB:raw equation to get an invoice balance. I'm not sure how...

0 Likes
0 Replies

Disable build-in commands

Is it possible to disable the build in commands like migrate. To be certain I can't run them by acci...

0 Likes
5 Replies
posted 10 years ago

Convince me of the advantages of L4 migrations

I've never been a fan of L4's migration approach. Maybe it's just the way I develop that is the rea...

0 Likes
13 Replies

Chaining first()

I just started using laravel, and I am trying some code. $candidate1 = ot_Candidate::where('id', '='...

0 Likes
1 Replies

Solution for form labes / column headers

I'm building an applicaiton where I have a lot of forms and CRUD stuff. What I'm trying to achieve i...

0 Likes
2 Replies

Failed PDOException

Can someone tell me how this code fails even though I am catching the PDOException? https://gist.git...

0 Likes
1 Replies

Help with proper query

I am looking for help in grabbing data the proper Laravel way. An existing site is being converted t...

0 Likes
1 Replies

Relationship questions

Hey guys, having troubles with second level relationship I got it figuring out how one to many works...

0 Likes
2 Replies

Sorting by a column of a child table in eager load and paginate

I need to display informations in a table that can be sort by columns. I'm using a eager load query...

0 Likes
0 Replies

Transform raw query with query builder or eloquent...

Hey, i got a rather complex query, and i would like to transform it with eloquent/query builder. I w...

0 Likes
1 Replies

Thanks to our community

Solutions given in the past year. Excluding solutions from thread authors.

Moderators

We'd like to thank these amazing companies for supporting us

Your logo here?

Laravel.io

The Laravel portal for problem solving, knowledge sharing and community building.

© 2024 Laravel.io - All rights reserved.