Sources Contact Advanced Search Tutorials

An Interest In:

Web News this Week

Search Archive

Some of Our Sources

View All Sources

Help Webnuz

Referal links:

April 19, 2022 05:01 am GMT

How to Retrieve Records in Laravel Model?

Originally posted @ https://codeanddeploy.com visit and download the sample code: https://codeanddeploy.com/blog/laravel/how-to-retrieve-records-in-laravel-model

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:

<?phpuse 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.

<?phpnamespace 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.

I hope this tutorial can help you. Kindly visit here https://codeanddeploy.com/blog/laravel/how-to-retrieve-records-in-laravel-model if you want to download this code.

Happy coding :)

Original Link: https://dev.to/codeanddeploy/how-to-retrieve-records-in-laravel-model-33kp

Share this article:

View Full Article

Dev To

An online community for sharing and discovering great ideas, having debates, and making friends

More About this Source Visit Dev To