Getting Started with Laravel :Database Querying: Selecting and Retrieving Data from Your Database

Screenshot from the tutorial

Getting Started with Laravel: Database Querying

Laravel is one of the most popular PHP frameworks, known for its elegant syntax and powerful features. In this tutorial, we'll dive into the basics of database querying in Laravel, focusing on how to select and retrieve data from your database. Whether you're a beginner or someone looking to refresh your skills, this guide will help you understand how to work with databases in Laravel efficiently.

Prerequisites

Before we get started, make sure you have the following:

• PHP installed on your machine (version 7.4 or higher).
• Composer for managing your PHP dependencies.
• A Laravel application set up. You can create a new Laravel project using the command:

composer create-project --prefer-dist laravel/laravel your-project-name

• A database set up (MySQL, PostgreSQL, SQLite, etc.) along with the required credentials.

Configuring Your Database

To connect your Laravel application to a database, you need to configure the database settings in the .env file located in the root of your Laravel project. Here’s an example configuration for a MySQL database:

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=your_database_name
DB_USERNAME=your_username
DB_PASSWORD=your_password

Make sure to replace the placeholders with your actual database details.

Setting Up Models

In Laravel, models are used to interact with database tables. To create a model, you can use the Artisan command:

php artisan make:model Post

This command will create a new file in the app/Models directory named Post.php. Laravel assumes that your model corresponds to a database table named posts, following the convention of pluralizing the model name.

Basic Querying with Eloquent ORM

Laravel uses Eloquent ORM (Object-Relational Mapping) for database interactions, allowing you to work with your database using PHP syntax rather than SQL. Here are some examples of how to retrieve data using Eloquent:

Retrieving All Records

To retrieve all records from the posts table, you can use the all() method:

use App\Models\Post;

$posts = Post::all();

This will return a collection of all Post records.

Retrieving a Single Record

To retrieve a single record by its primary key, you can use the find() method:

$post = Post::find(1); // Retrieves the post with an ID of 1

If the record does not exist, it will return null.

Retrieving Records with Conditions

If you want to retrieve records based on specific conditions, you can use the where() method:

$publishedPosts = Post::where('status', 'published')->get();

This retrieves all posts where the status column equals 'published'.

Ordering Records

To order the retrieved records, you can chain the orderBy() method:

$orderedPosts = Post::orderBy('created_at', 'desc')->get();

This will return posts ordered by the created_at timestamp in descending order.

Querying with Query Builder

In addition to Eloquent, Laravel provides a query builder for more complex queries. Here’s how to use it:

Using the DB Facade

You can use the DB facade for raw SQL queries. Here’s an example of retrieving posts directly from the database:

use Illuminate\Support\Facades\DB;

$posts = DB::table('posts')->get();

This retrieves all records from the posts table.

Adding Conditions

Just like Eloquent, you can add conditions using the query builder:

$draftPosts = DB::table('posts')->where('status', 'draft')->get();

You can also chain methods for ordering and limiting results:

$latestPosts = DB::table('posts')
    ->orderBy('created_at', 'desc')
    ->limit(5)
    ->get();

Conclusion

In this tutorial, we covered the basics of database querying in Laravel using both Eloquent ORM and the query builder. You learned how to configure your database, set up models, and retrieve data using various methods.

As you continue your journey with Laravel, remember that the framework offers powerful tools and features that can significantly enhance your PHP development experience. For more advanced queries and database operations, explore the Laravel documentation.

Happy coding!

Another view from the tutorial

---

Connect with SkillBakery Studios

Explore more tutorials, tools, and resources:

• skillbakery.com
• Facebook
• X (Twitter)
• YouTube Channel

Posted by SkillBakery Studios