While Laravel may help you out through its Query Builder, sometimes you just need to add raw queries or raw where sentences. It's not the best scenario, but sometimes pragmatism overrides a good practice. Learn how you can add raw sentences to your queries and still work in the same manner as a built query.
- [Instructor] While Laravel query builder…makes our life easier by creating queries for us,…sometimes we just need a good old-fashioned raw query.…Fortunately, Laravel gives us the flexibility…to be able to feed eloquent raw queries.…Raw queries should be used to execute…complex SQL statements,…because trying to get the eloquent query builder…to do it for us may become cumbersome.…Having said that, let's still check out an example…of raw queries for the complicated situation…where we want to get available rooms within a date range.…
So we first SELECT by a date range…and rooms that have been booked within those dates.…To get the available rooms…we need to get the rooms that are not in the first query.…And finally, we need to ORDER BY id.…This last one is optional.…So now let's do the same query, but on Laravel.…So let's open our Room model.…We'll type ctrl + p or cmd + p…and type Room.…
Let's first import the database facade.…Let's copy line five and paste it…and remove the Database Eloquent Model…and replace it with Support\Facades\DB.…
Author
Released
8/24/2017- Laravel file and folder structure
- Dependency injection
- Routing requests to controllers
- Loading a view
- Creating a basic Blade template
- Sending data to a view
- Creating and validating forms
- Integrating a database
- Modifying data with Eloquent
- Returning data to a Laravel view
- Adding relational data and concurrent connections
Skill Level Intermediate
Duration
Views
Related Courses
-
PHP: Creating Secure Websites
with Kevin Skoglund4h 15m Intermediate -
Ajax with PHP: Add Dynamic Content to Websites
with Kevin Skoglund3h 37m Intermediate -
MVC Frameworks for Building PHP Web Applications
with Drew Falkman2h 57m Intermediate -
Learning Symfony 3
with Bernardo Pineda1h 46m Intermediate
-
Introduction
-
Welcome49s
-
What you should know1m 8s
-
Using the exercise files1m 57s
-
-
1. Getting Started with Laravel
-
What is Laravel?2m 17s
-
Get a copy of Laravel2m 54s
-
Artisan for developers4m 33s
-
Dependency injection6m 15s
-
Service providers2m 50s
-
Facades and their utility4m 34s
-
-
2. Controlling an Application
-
Routing to controllers5m 16s
-
Loading a view5m 12s
-
3. Views and Blade
-
Send data to a view5m 57s
-
Create forms4m 23s
-
Process form data5m 13s
-
Form validation: Back end2m 36s
-
Form validation: Front end4m 47s
-
4. Introducing Eloquent
-
Introduction to Eloquent2m 48s
-
Set up a database3m 37s
-
Database migrations8m 12s
-
Models in Laravel4m 7s
-
Select data with Eloquent5m 21s
-
Modify data with Eloquent2m 51s
-
Relations in Eloquent5m 49s
-
Select data with raw queries7m 39s
-
Return data to the view7m 4s
-
Add relational data7m 20s
-
Concurrent connections6m 39s
-
-
Conclusion
-
Next steps43s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Select data with raw queries