Laravel Query Builder: Insert and Get ID of Last Inserted Row
Updated: Jan 16, 2024
Introduction Laravel, a popular PHP framework, facilitates database operations with Eloquent ORM and Query Builder, streamlining the database handling process remarkably. This guide offers a comprehensive look at using Laravel’s......
Bulk Insert/Update in Laravel Query Builder: Tutorial & Examples
Updated: Jan 16, 2024
Overview Working with database operations is an integral part of developing applications in Laravel. In scenarios where you have to insert or update large datasets in a database, utilizing bulk operations can be a crucial performance......
How to insert new record with Laravel Query Builder
Updated: Jan 16, 2024
Introduction Laravel is a powerful PHP framework designed for web developers who need a simple and elegant toolkit to create full-featured web applications. One of its core features is the Fluent Query Builder which makes database......
Upsert in Laravel Query Builder: Tutorial & Examples
Updated: Jan 16, 2024
Overview When building web applications with Laravel, developers often come across scenarios where they need to update an existing record or, if it doesn’t already exist, create a new one. This is a common task known as......
Using ‘GROUP BY’ and ‘HAVING’ in Laravel Query Builder
Updated: Jan 16, 2024
Overview Laravel’s Query Builder provides a convenient, fluent interface to creating and running database queries. It can be used to perform most database operations in your application and works on all supported database......
Laravel Query Builder: Select N Random Rows the Right Way
Updated: Jan 16, 2024
Introduction If you’ve been using Laravel for web development, you’re likely familiar with Eloquent ORM, a powerful and fluent Object-Relational Mapper. But there are times when the Query Builder, which offers a less......
Using Multiple ‘WHERE’ Conditions in Laravel Query Builder
Updated: Jan 16, 2024
Introduction Laravel, as a PHP framework, facilitates elegant syntax and robust features for interacting with databases. Laravel’s Query Builder provides a convenient wrapper around SQL queries, making it simple to perform......
Laravel Query Builder: Find rows where column is null/not null
Updated: Jan 16, 2024
Introduction Dealing with databases is an integral part of most web applications and Laravel, as a modern PHP framework, offers a powerful abstraction layer for database interactions: the Query Builder. This tool allows developers to......
Laravel Query Builder: Select rows in last day/week/month/year
Updated: Jan 16, 2024
Introduction Laravel’s eloquent ORM is a powerful and fluid database query builder that makes working with PHP’s database interactions a breeze. Periodic queries based on timeframes like the last day, week, month, or year......
Laravel Query Builder: Selecting Rows Between Two Dates
Updated: Jan 16, 2024
Introduction Laravel is a popular PHP framework known for its expressive and elegant syntax. Developers often need to fetch data within a specific date range from databases, which can be a common requirement for applications involving......
Laravel Query Builder: Search Results with ‘LIKE’ Operator
Updated: Jan 16, 2024
Introduction Laravel, the popular PHP framework for web artisans, simplifies database operations by providing an elegant, fluent interface for creating and running database queries. One commonly used database operation is searching,......
Laravel Query Builder: Find Results Between a Range of Numbers
Updated: Jan 16, 2024
Introducing Laravel’s Query Builder Laravel’s Query Builder provides a convenient, fluent interface for creating and running database queries. It can be used to perform most database operations in your application and works......