Laravel’s Eloquent ORM is well-known for providing an elegant and straightforward way to interact with databases. However, it also hides many powerful methods that can make developer’s life easier while building Laravel applications. In this blog post, we will explore few of these hidden or lesser-known Eloquent features. Each method is explained simply and demonstrated
Using best practices in Laravel means using tried-and-true ways to write code that is clean, easy to understand, and simple to fix when something goes wrong. Best practices are helpful tips and rules that many Laravel developers follow to make websites and apps that work smoothly, stay secure, and can be improved easily over time.
Laravel provides a built-in feature to flag database rows as deleted without deleting them from the database. In this article, we will see how soft delete and restore works in Laravel. Why Use Soft Delete? Sometimes we need to delete some data from the database but we will need those data again when required or
What is Database Seeding? Database seeding is the process of seeding a database with actual or dummy data, according to Wikipedia. Seeding a database is the process of providing an initial collection of data to a database after setup. It’s especially beneficial when we need to populate the database with data that we’ll need later.
In this Blog, we’ll understand mutators and accessors of the Eloquent ORM in the Laravel framework by examples. Laravel, Accessors, and Mutators allow us to alter data while saving and fetching. As per the name, the Accessor alters data while accessing and Mutators modify data while saving. The major difference between an accessor and a
In database design, relationships are important to perform normalization. With a relationship, we can easily store, retrieve, and validate data. In the Laravel framework, Eloquent provides an easy way to work with database relationships. In this example, we create two different tables and define the relationship between them. A one-to-one relationship is a very simple
In this example, we will check the database connection in Laravel. Before starting to create a new Laravel application start your database services like XAMPP or WAMPP and change database credentials in the .env file. Here, we will check database is connected and get an active database name using DB helper. To check database exists
Sometimes we face issues in getting data or getting the wrong data. We can resolve this type of issue using row SQL queries but for that, we need to convert the eloquent queries into row queries. Laravel provides two ways to get row queries. Using Laravel Eloquent methods This method to get the query of
Working with dates, we need to display formatted dates to users and store dates in the database in a specific format. Laravel provides a few ways to implement this functionality like an accessor by defining a custom function or by converting the date every time. For this example, we will define the accessor function into
Sometimes we need to delete all the data from a table. Some tables are just to store temporary data. So we need to delete or empty the table using a specific time or event. Laravel or Eloquent has many methods from query to static from removing all records from the table like DB class with
