Table of contents

retrieve records in laravel

In this post, I will share an example of how to retrieve records in the Laravel model. After saving records we need to retrieve the records and show them to the HTML table. Now let's do it.

 

I assumed that you have already installed Laravel 8 application.

 

Step 1: Create Model, Migration, and Controller

Let's create first our migration. See our previous post about creating a model with additional options.

 

Run the following command:

php artisan make:model Post --migration --controller

 

Once generate our Model, migration, and controller. Navigate your migration with this path: project_folder/database/migrations/{datetime}_create_posts_table.php

 

See below the sample code of our migration:

<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreatePostsTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('posts', function (Blueprint $table) {
            $table->id();
            $table->string('title');
            $table->string('description')->nullable();
            $table->text('body');
            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('posts');
    }
}

 

Then run migrate command:

php artisan migrate

 

Once done with the migration create your posts seeder. See this post on how to do it.

 

Step 2: Create Route

Now let's create our posts routes. Navigate project_folder/routes/web.php

 

Route::get('/posts', 'PostController@index')->name('post.index');

 

Step 3: Setup Controller

Next, we will set up our controller for retrieving data.

<?php

namespace App\Http\Controllers;

use App\Models\Post;
use Illuminate\Http\Request;

class PostController extends Controller
{
    public function index() 
    {   
        $posts = Post::all();
        
        return view('posts.index', compact('posts'));
    }
}

 

Step 4: Setup Views

Then we will add our views. Create posts folder inside project_folder/resources/views. Then add index.blade.php see below code:

<!DOCTYPE html>
<html>
<head>
	<meta charset="utf-8">
	<title>Posts</title>
</head>
<body>
	<table>
		<tr>
			<td>Id</td>
			<td>Title</td>
			<td>Description</td>
			<td>Body</td>
		</tr>
		@foreach($posts as $post)
			<tr>
				<td>{{ $post->id }}</td>
				<td>{{ $post->title }}</td>
				<td>{{ $post->description }}</td>
				<td>{{ $post->body }}</td>
			</tr>
		@endforeach
	</table>
</body>
</html>

 

Now we already retrieve our records from our Laravel model. See below results.

 

retrieve records in laravel

 

That's it. I hope it helps.