Eloquent is Laravel's own object-relational mapper. It is named "Eloquent" because it allows you to work with your database objects and relationships using an eloquent and expressive syntax.
2
votes
1answer
17 views
Database query with Eloquent
I have got two tables articles and tags in the database. My goal was to retrieve all fields from articles table and one category field from tags table with Eloquent. I couldn't do this so instead I ...
3
votes
1answer
96 views
Eloquent methods to calculate the average rent of apartments
I am working on a Laravel 5.1 website where I am counting the average rent of apartments in a specific area. Besides of that I want to get the average rent by amount of rooms in the apartment. The ...
1
vote
0answers
44 views
Proper PHP array walkthrough
I am working on a ticket reserving system right now. The users can reserve seats in a cinema for every movie. Whilst my code works, it is not the fastest. When a customer buys ticket (seat(s)) I check ...
1
vote
1answer
64 views
Method on Laravel model to find courses related to a course
I have a Laravel project that has courses. I want to take the related courses from one.
Should I create the method in the model (the php class) or in the controller?
Currently I have this code in ...
0
votes
1answer
44 views
Compare 2 Different database Table
I have php function that compares two different database table. Any suggestion on improving it.
...
4
votes
1answer
169 views
4 database queries, multiple loops in loops, slow processing time
The octoberCMS(based on laravel) controller below is what I use to select the lowest price in 4 pricelists in the given daterange.
Prices can vary and it's not guaranteed that the more expensive ...
1
vote
0answers
106 views
Extended Laravel Eloquent models to add filters to model setters
One of the tasks I find myself doing repeatedly is to filter the incoming inputs that will be stored in models. Examples of this include trimming, removing repeated or unnecessary pre/suffixes, commas ...
1
vote
0answers
33 views
Eloquent Scope and Normal Way
I read the documentation part of Eloquent, especially scopes:
Scopes allow you to easily re-use query logic in your models. To define a scope, simply prefix a model method with scope:
And so, ...
3
votes
2answers
603 views
Effective usage of multiple joins in Eloquent dependent on variable
I have an Eloquent model that has multiple types of joins that is used to filter out different request to grab the data of movies e.g.: Actors, ...
0
votes
1answer
11k views
Optimizing Laravel Eloquent multiple joins
The following is working and readable SQL for Eloquent that I have created. The downside is that it looks more like a 1:1 with SQL and I don't think I'm using the full potential of Eloquent. I thought ...
