In this video, Justin teaches you how to find records using the simple ActiveRecords system in Laravel Eloquent to find and return records from the database.
- [Narrator] So we've seen the ability to paginate … over a set of records. … We've seen the ability to get all records, … and we've seen the ability to build in a where clause. … But let's do this with a more standard SQL operation … to be able to find just the records that we want. … We'll open up the Show Room controller at App, … Http, Controllers, ShowRoomsController.php. … We'll replace some of this logic with a more … straightforward approach given some of the tools … Eloquent provides us. … Let's start by erasing the lines from 19 through 22. … Now starting from zero how might we ask the question … if we want to find the rooms, … and possibly limit by room type? … First, we'll begin like we always should in Laravel … by looking at the route. … We'll find the route in Routes, web.php. … Here on line 24, we can add in the ability … to pass in a route type paramater to our rooms URL. … We'll do this by adding in to the string for the rooms URL: … forward slash, and in curly braces, room type question mark. …
Author
Updated
10/4/2019Released
7/8/2019- Exploring Laravel
- Setting up simple authentication
- Controllers and routes
- Create and index view
- Show, edit, and destroy views
- Models
- Writing scopes in Laravel Eloquent
- Creating one-to-one relationships
Skill Level Beginner
Duration
Views
Related Courses
-
MVC Frameworks for Building PHP Web Applications
with Drew Falkman2h 57m Intermediate -
PHP: Creating Secure Websites
with Kevin Skoglund4h 15m Intermediate -
Ajax with PHP: Add Dynamic Content to Websites
with Kevin Skoglund3h 37m Intermediate -
Learning Symfony 3
with Bernardo Pineda1h 46m Intermediate
-
Introduction
-
What you should know1m 52s
-
1. Installation
-
Install Homestead8m 7s
-
Explore Laravel4m 43s
-
Configuration4m 47s
-
The first page5m 21s
-
-
2. Starting Your Project
-
Simple authentication2m 38s
-
The first migration7m 49s
-
Seeding3m 40s
-
The first route3m 15s
-
The first controller3m 17s
-
The first action5m 1s
-
The first view6m 7s
-
-
3. The Create and Index Views
-
Resource controller routes7m 56s
-
Index action6m 17s
-
Index view6m 6s
-
Create an action4m 55s
-
Create a view3m 49s
-
Store an action5m 22s
-
-
4. The Show, Edit, and Destroy Views
-
Show action and view5m 3s
-
Edit an action5m 47s
-
Edit a view8m 45s
-
Update an action2m 30s
-
Destroy an action5m 15s
-
-
5. Models
-
The first model4m 9s
-
Pagination3m 43s
-
Finding4m 41s
-
Saving4m 37s
-
Editing1m 50s
-
Soft-deleting2m 52s
-
-
6. Eloquent
-
Scopes4m 42s
-
One-to-one relationships4m 32s
-
One-to-many relationships3m 29s
-
Many-to-many relationships4m 44s
-
Lazy-loading relationships3m 16s
-
Eager loading relationships2m 18s
-
Saving relationships3m 54s
-
-
Conclusion
-
Next steps1m
-
- 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: Finding