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:


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) {

     * Reverse the migrations.
     * @return void
    public function down()


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.


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>
	<meta charset="utf-8">
		@foreach($posts as $post)
				<td>{{ $post->id }}</td>
				<td>{{ $post->title }}</td>
				<td>{{ $post->description }}</td>
				<td>{{ $post->body }}</td>


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


retrieve records in laravel


That's it. I hope it helps.