Laravel Query Builder Usage With Example Code

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-studio

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 https://youtu.be/qoMg86QA5P4
Measure PHP Code Quality With Static Analysis Using PHPStan https://youtu.be/OiS2xGVWEa0
Define Technical Debt and Contributing Factors for Software Errors https://youtu.be/ZJ5a4mxBbWw
Getting Started using Laravel Sail for Docker on WSL 2 https://youtu.be/Zxi157MpoRE
Developing on Windows with WSL2 (Subsystem for Linux) and PHP https://youtu.be/_H1iKXksjF0
WSL 2 With Docker Getting Started and Docker Desktop Installation https://youtu.be/h0Lwtcje-Jo
Getting Started with WSL 2 and Ubuntu on Windows 10 https://youtu.be/X3bPWl9Z2D0
Secrets To Get A Developer Job And Searching For Programming Jobs https://youtu.be/zls-4vbjFxk
Store sensitive data in environment variables using phpdotenv https://youtu.be/oTrJfgUF1SI
How to understand code written by someone else https://youtu.be/lj6GH6yWSlk
Ways to advance your programming skills and improve as a developer https://youtu.be/X6abVw8SlZc
Make your local DEV environment available on the internet https://youtu.be/xs2o7B_Ex9E
AWS Elastic Load Balancer (ELB) Tutorial How-To https://youtu.be/Sr2Mq9Gegew
Laravel Model Factory Tutorial using Artisan make:model https://youtu.be/hM135dPJ1dM
Authentication in Laravel Tutorial https://youtu.be/2qJkzWJNpjQ
Top 5 skills to be a better software developer https://youtu.be/kbX8iATLqxs
Install Laravel in Docker container on Ubuntu for beginners https://youtu.be/0HTruhilvcU
Getters and Setters accessors in object-oriented programming https://youtu.be/cozignPaoLg
Critical programming issues preventing a PHP 7 upgrade https://youtu.be/z13glyDnm6s
Behat for beginners functional REST API testing tutorial https://youtu.be/nFNGDhyFrm4
PHP Mess Detector static analysis to find PHP code smells https://youtu.be/8fEfHESrK5E
How to get lines of code in PHP https://youtu.be/HpC-Cvxj6oY
Use UUID with Doctrine ORM for DB keys https://youtu.be/SYuLwMwSIpg
Learn about Hypermedia and how to create it https://youtu.be/aV6ro_JXL_A
Configure PhpStorm for PHP development with Docker https://youtu.be/FQWL-JTZvf4
Create PHP development environment with docker https://youtu.be/2ESAi2vq-80

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