How To CRUD (Create, Read, Update, and Delete) With Laravel

Creating a Laravel project from scratch and implementing CRUD operations involves several steps. Below is a comprehensive guide to help you set up a new Laravel project, configure CRUD functionality, and manage data using MySQL as the database

Step-by-Step Guide to Create a Laravel Project and Implement CRUD Operations

1. Install Laravel

First, make sure you have Composer installed. Then, use Composer to create a new Laravel project:

 

composer create-project --prefer-dist laravel/laravel crud-app
 

Replace crud-app with your preferred project name.

2. Configure Environment

Navigate to your project directory and configure your environment variables in .env file. Set up your database connection (DB_DATABASE, DB_USERNAME, DB_PASSWORD).

3. Set Up Database

Create a MySQL database for your project. Update .env with your database details.

4. Generate Model and Migration

Generate a model and migration for your Post entity:

 

php artisan make:model Post -m
 

This command creates a Post model and its migration file in database/migrations.

5. Define Schema in Migration

In the generated migration file (database/migrations/create_posts_table.php), define your posts table schema in the up method:

 

public function up()
{
   Schema::create('posts', function (Blueprint $table) {
       $table->id();
       $table->string('title');
       $table->text('body');
       $table->timestamps();
   });
}
 

Run the migration to create the posts table in your database:

 

php artisan migrate
 

6. Create Routes

Define routes in routes/web.php for CRUD operations:

 

use App\Http\Controllers\PostController;

Route::resource('posts', PostController::class);
 

7. Generate Controller

Generate a controller to handle CRUD operations for Post model:

 

php artisan make:controller PostController --resource
 

8. Implement CRUD Operations in Controller

In app/Http/Controllers/PostController.php, implement methods for CRUD operations:

 

namespace App\Http\Controllers;

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

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

   public function create()
   {
       return view('posts.create');
   }

   public function store(Request $request)
   {
       $request->validate([
           'title' => 'required',
           'body' => 'required',
       ]);

       Post::create($request->all());

       return redirect()->route('posts.index')
           ->with('success', 'Post created successfully.');
   }

   public function show(Post $post)
   {
       return view('posts.show', compact('post'));
   }

   public function edit(Post $post)
   {
       return view('posts.edit', compact('post'));
   }

   public function update(Request $request, Post $post)
   {
       $request->validate([
           'title' => 'required',
           'body' => 'required',
       ]);

       $post->update($request->all());

       return redirect()->route('posts.index')
           ->with('success', 'Post updated successfully');
   }

   public function destroy(Post $post)
   {
       $post->delete();

       return redirect()->route('posts.index')
           ->with('success', 'Post deleted successfully');
   }
}
 

9. Create Views

Create views in resources/views/posts directory (index.blade.php, create.blade.php, edit.blade.php, show.blade.php) to display and manage posts.

10. Link Routes in Views

Add links to navigate between CRUD operations in your views:

 

Create New Post

11. Create Form Views

Use Laravel Blade templates to create forms for creating and editing posts:

 

 

   @csrf
   
   
   Create Post

 

 

12. Run Your Application

Finally, run your Laravel application:

 

php artisan serve
 

Visit http://localhost:8000/posts in your browser to see your CRUD application in action.

Summary

Building a CRUD application in Laravel involves setting up routes, creating a controller, defining model relationships, and creating views to interact with data. Laravel's Eloquent ORM, Blade templating engine, and routing make it straightforward to implement CRUD functionality efficiently. Customize the example code above based on your specific application requirements and design preferences.

 

Increase The Profitability, Availability Of Your Business

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim.