Everything you need as a full stack developer
Fullstackist » Laravel

Laravel

Laravel is a powerful, open-source PHP web framework for building modern, scalable web applications. It uses the Model-View-Controller (MVC) architectural pattern to ensure code is clean and well-organized. Laravel provides an elegant syntax and a robust set of tools, including the Eloquent ORM for database interactions, the Blade templating engine, and the Artisan command-line interface, which dramatically speed up development.

Its massive ecosystem, featuring official tools like Forge for server management and Vapor for serverless deployment, alongside a vast package library and active community, makes it a top choice for developers. With continuous innovation, such as built-in WebSocket support via Reverb and a focus on security and performance, Laravel remains a leading and highly relevant framework in 2025 for projects ranging from small sites to large enterprise systems.

Eloquent Has One Through through intermediate model

- Posted in Laravel by

TL;DR Laravel provides HasOneThrough relationships to navigate complex data structures through intermediate models. This feature allows you to establish a connection between two models and traverse relationships in an intuitive manner. Unlocking Laravel's Eloquent Relationships: A Deep Dive into Has One Through As a Laravel developer, you're likely no stranger to Eloquent relationships. These powerful tools allow us to model complex data structures with ease, enabling seamless interactions between related models in our applications. Today, we're going to explore one of the most versatile and oft-misunderstood relationship types: HasOneThrough.

Eloquent With Sum with sum of related models

- Posted in Laravel by

Laravel developers can efficiently fetch data from their database using Eloquent's `with` and `sum` functions to retrieve related models and perform aggregate operations, simplifying complex queries and improving performance.

Eloquent With Avg with average of related models

- Posted in Laravel by

Calculating the average rating for each category in a Laravel application can be done using Eloquent's `avg` method on a relation. This can be achieved by retrieving all categories and their associated products, then calculating the average rating for each category. For example: `$category = Category::with('products')->get(); $averageRating = $category->products()->avg('rating');`. To calculate averages across multiple related models, use the `withAverage` method provided by Laravel.

Eloquent With Min with min of related models

- Posted in Laravel by

In Laravel, Eloquent's `min` method can be used with related models to retrieve products with the lowest price in each category by combining the power of `with` and `pluck`. The technique uses joins, groupBy, min, with, and pluck methods to fetch the desired data. Example use cases include fetching products with minimum prices in each category and retrieving users with lowest balances in each group.

Eloquent With Max with max of related models

- Posted in Laravel by

Laravel developers can use the `max()` function to retrieve related models by chaining it to Eloquent model's relationship retrieval methods. This technique is particularly useful for `BelongsTo` or `HasOne` relationships and can simplify complex database queries.

Eloquent With Count with counting related models

- Posted in Laravel by

Laravel's `withCount` method allows you to efficiently count related models while still using eager loading, reducing database queries and improving performance. This technique simplifies complex querying tasks and enhances application efficiency.

Eloquent Where DoesntHave with absence of relationship

- Posted in Laravel by

When using Eloquent's `WhereDoesntHave` method without a relationship, utilize raw queries or database agnostic syntax to filter out records based on their absence of relationships. This technique is particularly useful in scenarios where traditional methods like `whereHas` won't yield the desired results due to absent relationships between models.

Eloquent Where Has with constraining by relationship

- Posted in Laravel by

Laravel developers can use Eloquent's `whereHas` functionality to constrain queries based on relationships between models, such as fetching products by category and supplier assignment for efficient data retrieval in e-commerce applications.

Eloquent Or Where with orWhere conditions

- Posted in Laravel by

Laravel's Eloquent ORM has a powerful feature for performing complex queries called `orWhere` conditions, allowing you to filter data using multiple criteria with an OR operator. It's ideal for scenarios where you want to combine multiple conditions in a logical OR way.

Eloquent Where Column with whereColumn method

- Posted in Laravel by

Laravel's Eloquent ORM has a method called `whereColumn()` that allows you to add conditions based on specific column values being equal or not equal within the same row. It can simplify complex queries and is useful for tasks like retrieving customers with certain payment methods where they have made a purchase.

Eloquent Where Time with whereTime method

- Posted in Laravel by

Eloquent's `whereTime` method simplifies filtering database results based on a specific time range, making it easy to work with temporal data. It can be applied to any Eloquent model and is used by specifying the column name, expression, start time, and end time. For example, `$posts = Post::whereTime('created_at', '>=', now()->subDay())->get();` retrieves all posts created within the last 24 hours.

Eloquent Where Date with whereDate method

- Posted in Laravel by

The `whereDate` method in Eloquent allows for date-based filtering and is useful for querying data based on specific dates or date ranges. It can be used to retrieve data published on a certain date, within a specified date range, or between two dates. The method takes two arguments: the column name to filter on and the date value to match against.

Eloquent Where Null with whereNull method

- Posted in Laravel by

Eloquent's `whereNull` method allows filtering records based on null values in specific columns, improving readability and efficiency by optimizing database queries. It enables specifying one or more columns expected to be null and returns all records with no value (i.e., are null).

Eloquent Where In with whereIn method

- Posted in Laravel by

Laravel's `whereIn` method simplifies conditional querying by allowing you to specify an array of values for a given column, reducing cumbersome and inefficient simple queries. This technique is especially useful when fetching data based on multiple conditions and can be used in conjunction with eager loading for optimal performance.

Eloquent Where Between with whereBetween method

- Posted in Laravel by

Eloquent's `whereBetween` method filters model collections based on a specific range of values, making it ideal for date-based or numerical fields. It allows you to retrieve all orders placed within a specified time frame or fetch users whose age falls between two certain thresholds.

Eloquent Advanced Where with nested where clauses

- Posted in Laravel by

Laravel's Eloquent ORM allows complex queries with advanced where clauses, including nested conditions. Chained `where` methods or anonymous functions can define multiple conditions, combined using `$query->where()` and `$query->orWhere()` methods.

Eloquent Cross Join with cross join clause

- Posted in Laravel by

Laravel's Eloquent ORM introduces the `crossJoin` clause, allowing developers to perform complex database operations by combining rows from multiple tables without relying on common columns. This enables powerful tools for generating reports, aggregating data, and simulating scenarios.

Eloquent Left Join with left join clause

- Posted in Laravel by

A left join is a SQL query that returns all records from the left table and matched records from the right table, useful for fetching related data from databases. It's like combining two datasets with the primary dataset always being returned. Eloquent in Laravel uses the `leftjoin` method to implement this, handling null values can be done using functions like `IFNULL`.

Eloquent Join with join clause for related tables

- Posted in Laravel by

Laravel's Eloquent ORM simplifies joining related tables with its `join` clause, allowing you to retrieve data without complex SQL queries. Join types include Inner Join, Left Join, and Right Join. The anatomy of an Eloquent join is demonstrated through a simple example, showcasing how to use the `join` method on the `Post` model to fetch posts along with their corresponding comments.

Eloquent Raw Expressions with DB::raw method

- Posted in Laravel by

Eloquent's DB::raw allows injecting raw SQL expressions into Eloquent code, providing more control over generated SQL. It can be used to execute complex database queries, but requires proper formatting and escaping to prevent security vulnerabilities.

Eloquent DD with dumping query and dying

- Posted in Laravel by

When debugging Eloquent queries in Laravel, use `toSql()` to inspect the raw SQL query string or `dump()` for a more detailed view of the query, including parameters. To halt execution and display variables, use `die()` (or `dd()`) on any variable or expression.

Eloquent ToSql with getting raw SQL query

- Posted in Laravel by

Laravel's Eloquent ORM provides a convenient way to interact with databases, but sometimes it's necessary to get the underlying raw SQL query being executed. This can be useful for debugging performance issues, auditing changes, or generating custom queries. The `toSql` method on a Query Builder instance returns the SQL query as a string.

Eloquent Refresh with reloading fresh from database

- Posted in Laravel by

Eloquent's `refresh()` method reloads a model's attributes from the database, ensuring fresh and accurate data, especially when dealing with relationships or eager loading. This powerful method helps ensure that models are always up-to-date in applications where data needs to be updated in real-time.

Eloquent Replicate with cloning model instances

- Posted in Laravel by

TL;DR Eloquent Replicate is a powerful tool in Laravel that allows developers to create identical copies of existing model instances, saving time and effort compared to manual duplication methods. It preserves relationships and supports mass assignment, making it ideal for cloning model instances in various scenarios. Eloquent Replicate: A Powerful Tool for Cloning Model Instances in Laravel As a Fullstack Developer, you're likely no stranger to the concept of data replication. Whether it's duplicating user accounts, creating temporary test environments, or populating staging databases with production-like data, there are countless scenarios where cloning model instances can save time and effort.

Eloquent GetOriginal with retrieving original values

- Posted in Laravel by

When working with Eloquent models, retrieving original values after updating or inserting data into database tables is a crucial feature. `getOriginal()` allows access to these original attributes, ensuring accurate and up-to-date records while fulfilling business requirements. It's particularly useful for auditing features, validation logic, and rollbacks.
Fullstackist aims to provide immersive and explanatory content for full stack developers Fullstackist aims to provide immersive and explanatory content for full stack developers
Backend Developer 103 Being a Fullstack Developer 107 CSS 109 Devops and Cloud 70 Flask 108 Frontend Developer 357 Fullstack Testing 99 HTML 171 Intermediate Developer 105 JavaScript 206 Junior Developer 124 Laravel 221 React 110 Senior Lead Developer 124 VCS Version Control Systems 99 Vue.js 108

Recent Posts

Web development learning resources and communities for beginners...

TL;DR As a beginner in web development, navigating the vast expanse of online resources can be daunting but with the right resources and communities by your side, you'll be well-equipped to tackle any challenge that comes your way. Unlocking the World of Web Development: Essential Learning Resources and Communities for Beginners As a beginner in web development, navigating the vast expanse of online resources can be daunting. With so many tutorials, courses, and communities vying for attention, it's easy to get lost in the sea of information. But fear not! In this article, we'll guide you through the most valuable learning resources and communities that will help you kickstart your web development journey.

Read more

Understanding component-based architecture for UI development...

Component-based architecture breaks down complex user interfaces into smaller, reusable components, improving modularity, reusability, maintenance, and collaboration in UI development. It allows developers to build, maintain, and update large-scale applications more efficiently by creating independent units that can be used across multiple pages or even applications.

Read more

What is a Single Page Application (SPA) vs a multi-page site?...

Single Page Applications (SPAs) load a single HTML file initially, handling navigation and interactions dynamically with JavaScript, while Multi-Page Sites (MPS) load multiple pages in sequence from the server. SPAs are often preferred for complex applications requiring dynamic updates and real-time data exchange, but MPS may be suitable for simple websites with minimal user interactions.

Read more