Laravel Query Builder Usage With Example Code

Published: 18 January 2022
on channel: Beachcasts Programming Videos
2,251
49

Laravel Query Builder Usage With Example Code. Adam Culp of Beachcasts shares the basics of how to use Laravel Illuminate Database Query Builder from documentation, and methods available for advanced querying in this Laravel tutorial.

Please * LIKE, COMMENT, AND SUBSCRIBE * - and share with others!

Key Topics:
How to use the Laravel Illuminate Database Query Builder
Detailed SELECT methods available for Laravel Query Builder
Detailed WHERE clause methods in Laravel
Using DATE and Time functions in Laravel queries
Including JSON comparisons in queries

For a nice list of equipment I use in my studio, and to support the channel if you make any purchases (doesn't cost you a thing), visit my kit at kit.co: https://kit.co/beachcasts/beachcasts-...

Errata:
Let me know if you notice anything that should be errata

Support the channel with this Cloudways affiliate link: https://www.cloudways.com/en/?id=1013434 and use the discount code BEACHCASTS to get a free month of hosting.

Associated Links:
https://laravel.com/docs/8.x/database
https://laravel.com/docs/8.x/queries
https://beachcasts.com

Timeline:
00:00 Video Start
01:10 How to import the Laravel DB facade and available methods
02:06 Intro to our sponsor
02:31 Example usage of basic Laravel DB facade methods
05:39 Retrieving data using Laravel Illuminate DB Query Builder
08:56 More advanced querying methods of Laravel Illuminate DB Query Builder
09:52 Detailed SELECT method examples of Laravel Illuminate DB Query Builder
11:08 Passing RAW strings to queries with Laravel Illuminate DB Query Builder (DANGER!)
13:17 Detailed WHERE clause method examples of Laravel Illuminate DB Query Builder
14:47 Using DATETIME comparisons with Laravel Illuminate DB Query Builder
15:46 JSON data types in queries using Laravel Illuminate DB Query Builder
17:42 JOINs available in Laravel Illuminate DB Query Builder

Other Beachcasts videos you might find interesting:
How To Create And Use Github Packages For Docker Containers    • How To Create And Use Github Packages For ...  
Measure PHP Code Quality With Static Analysis Using PHPStan    • Measure PHP Code Quality With Static Analy...  
Define Technical Debt and Contributing Factors for Software Errors    • Define Technical Debt and Contributing Fac...  
Getting Started using Laravel Sail for Docker on WSL 2    • Getting Started using Laravel Sail for Doc...  
Developing on Windows with WSL2 (Subsystem for Linux) and PHP    • Developing on Windows with WSL2 (Subsystem...  
WSL 2 With Docker Getting Started and Docker Desktop Installation    • WSL 2 With Docker Getting Started and Dock...  
Getting Started with WSL 2 and Ubuntu on Windows 10    • Getting Started with WSL 2 and Ubuntu on W...  
Secrets To Get A Developer Job And Searching For Programming Jobs    • Secrets To Get A Software Engineering Job ...  
Store sensitive data in environment variables using phpdotenv    • Store sensitive data in environment variab...  
How to understand code written by someone else    • Secrets of how to understand code written ...  
Ways to advance your programming skills and improve as a developer    • Ways to advance your programming skills an...  
Make your local DEV environment available on the internet    • Make your local DEV environment available ...  
AWS Elastic Load Balancer (ELB) Tutorial How-To    • AWS Elastic Load Balancer (ELB) Tutorial H...  
Laravel Model Factory Tutorial using Artisan make:model    • Laravel Model Factory Tutorial using Artis...  
Authentication in Laravel Tutorial    • Authentication in Laravel Tutorial for PHP...  
Top 5 skills to be a better software developer    • Top 5 skills to be a better software devel...  
Install Laravel in Docker container on Ubuntu for beginners    • Install Laravel in Docker container on Ubu...  
Getters and Setters accessors in object-oriented programming    • Getters and Setters accessors in object or...  
Critical programming issues preventing a PHP 7 upgrade    • Critical programming issues preventing a P...  
Behat for beginners functional REST API testing tutorial    • Behat for beginners functional REST API te...  
PHP Mess Detector static analysis to find PHP code smells    • PHP Mess Detector static analysis to find ...  
How to get lines of code in PHP    • PHPLoc Lines of code static analysis to fi...  
Use UUID with Doctrine ORM for DB keys    • UUID with Doctrine ORM in Zend Expressive ...  
Learn about Hypermedia and how to create it    • Creating Hypermedia (HAL) in PHP REST API ...  
Configure PhpStorm for PHP development with Docker    • PhpStorm setup for PHP web development wit...  
Create PHP development environment with docker    • PHP web development environment with Docke...  

Help through referrals:
I use TubeBuddy to help me manage my YouTube channel. If you're interested, click the following link to check it out. https://www.tubebuddy.com/beachcasts

#php #laravel #beachcasts


On this page of the site you can watch the video online Laravel Query Builder Usage With Example Code with a duration of hours minute second in good quality, which was uploaded by the user Beachcasts Programming Videos 18 January 2022, share the link with friends and acquaintances, this video has already been watched 2,251 times on youtube and it was liked by 49 viewers. Enjoy your viewing!