Buka Corner

Sign in Subscribe

Laravel

Speed Up Your Laravel Queries with whereIntegerInRaw()

Speed Up Your Laravel Queries with whereIntegerInRaw()

If you've been using Laravel for a while, you're likely familiar with the whereIn() method for filtering records by a list of values. It's clean, expressive, and gets the job done. But did you know that when working with large arrays of integers, there&

Avoiding the N+1 Query Trap in Laravel with withCount()

Avoiding the N+1 Query Trap in Laravel with withCount()

When working with Laravel Eloquent, one of the most common performance pitfalls is the N+1 query problem—and it often happens without developers realizing it. Imagine you're displaying a list of blog posts along with the number of comments each one has. You might think this is

Laravel Tip: firstWhere() vs where()->first() – Which One Should You Use?

Laravel Tip: firstWhere() vs where()->first() – Which One Should You Use?

When working with Eloquent in Laravel, you’ve likely come across two ways to fetch the first matching model from the database: Currency::where('code', 'CAD')->first(); or Currency::firstWhere('code', 'CAD'); At first glance, they seem interchangeable—and for

Stop Using Try-Catch in Laravel Controllers: Here's the Better Way

Stop Using Try-Catch in Laravel Controllers: Here's the Better Way

If you’re sprinkling try-catch blocks inside your Laravel controllers, it’s time to stop and take a step back. This pattern might feel safe, like you’re protecting your application from breaking. But in reality, it’s often a code smell — and there’s a cleaner, more scalable approach

Why I Will Always Love Model::query() in Laravel — And You Should Too

Why I Will Always Love Model::query() in Laravel — And You Should Too

There’s a special place in my heart for one of Laravel’s most elegant and powerful features: Model::query(). As a PHP developer, especially one who works a lot with Eloquent ORM, I’ve come to appreciate how much control, flexibility, and readability this one little method offers. The

Using Virtual Columns in Laravel Queries and Filtering with HAVING

Using Virtual Columns in Laravel Queries and Filtering with HAVING

When working with Laravel’s Eloquent ORM, you may sometimes need to add virtual columns to your query results—columns that don’t exist in your database table but are generated dynamically. A common use case is adding a constant value, a computed field, or even an aggregated result. One

How to Store and Retrieve Clean Phone Numbers in Laravel Eloquent

How to Store and Retrieve Clean Phone Numbers in Laravel Eloquent

When working with phone numbers in a Laravel application, it's essential to ensure they are stored in a clean and consistent format in the database. However, when retrieving the data, we often need to format it correctly for display. In this article, we'll explore how to