Subquery error - SQLSTATE[42000]
I'm using the Laravel query builder to write a join statement and I find that I'm encountering a str...
Where Between in Query Builder
I'm using query builder in Laravel 5.2 to make some similar to "SELECT value FROM table1 WHERE...
Unknown column 'photo' in 'field list' error in database
when i create a "photo" in the "flyer_photos" table with Tinker like below. >...
How to convert this SQL command into laravel 5.2 ?
if($type == 'fetch') { $events = array(); $query = mysqli_query($con, "SELECT * FROM calendar&q...
whereBetween
whereBetween() takes a field and an array. Is there a way to do a between on 2 fields with an input?...
Retrieving database data from the Controller
how can i retrieve data from the database using a controller
Undefined property: Illuminate\Database\Eloquent\Relations\HasMany::$due_date
I'm trying to create a collection of items that are over due. Here's my code Transaction.php /**...
Eager load a polymorphic relation with a constraint
Hello all! I am not a professional programmer but I am trying to develop an application for my perso...
Best Practice, many tables and many models?
Hi, So my app will have around 30 - 40 tables and therefore similar amount of models. It seems weird...
Artisan Tinker exception
Hi all... Sorry if is a noob question, i'm new to Laravel. When i do a simple command like this one:...
Laravel database failover?
Hey does anyone know if there is a relatively simple way to manage the database connection for failo...
Override Password encryption method for User model
Hi All I am using Laravel on top on an existing database. Another application is still also using th...
Query Builder - "orderBy()" when fetching data with "with()"
Hi all! I've got an Order model that hasOne('customer') bind to itself. I want to query something li...
Is there a way to sort whole collection based on related model.
Hi, all. I have a query builder question. I want the result to be sorted by a field in a related mod...
MySQL partitions and Schema Builder
Hi, I will start working in a new project that requires a massive database (tens of million rows) in...
Table reverting to old name, hidden variables?
I started playing around / learning laravel. Got everything set up and made a few models: artists s...
eager load with sum() on relations
Hi Artisans, I am trying to figure out how to reduce number of queries when I am doing this kind of...
Eager loading, collection of relations
Hi guys, How to get results of secondary query? Ofc I could merge all related collections: $paramet...
DB::raw as a parameter in another select statement.
Is it possible to make the customized column in database inside a new select clause using DB::raw()?...
Turn off eloquent events?
Is it possible to turn off eloquent events? Just temporarily, to stop myself getting into an event l...
Thanks to our community
-
tvbeek 1 Solution
1 -
mahbuburriad 1 Solution
2 -
devriazul 1 Solution
3
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
Laravel
Laravel News
Laracasts
Laravel Podcast