Laravel 8.0 CRUD Tutorial Using Mysql Database

Hello Artisan,

Today we will create a CRUD application in Laravel using Mysql Database. CRUD extends Create, Read, Update, Delete. We performing This operation in our new fresh laravel project. So, let’s start.

Create a Laravel Project first, run this command

composer create-project --prefer-dist laravel/laravel blog

After completion the creation of laravel project, lets go…

*Make databse Connection *
create a databse in the mysql database after that go to the .env file

and add the code

DB_CONNECTION=mysql DB_HOST=127.0.0.1 DB_PORT=3306 DB_DATABASE=laravel_crud DB_USERNAME=root DB_PASSWORD= 

Set your Databasae name,username and password.

Now, run this command to migrate

php artisan migrate

Create Product model

php artisan make:model Product

Create migration for products table, run this command

php artisan make:migration create_products_table --create=products

let’s add products table column propertise to the migration file.

Schema::create('products', function (Blueprint $table) { $table->id(); $table->string('title'); $table->text('details'); $table->timestamps(); }); 

Create Controller, run this command

php artisan make:controller ProductController --resource

In web.php add our route,

web.php

<?php use Illuminate\Support\Facades\Route; use App\Http\Controllers\ProductController; use App\Http\Controllers\UserController; /* |-------------------------------------------------------------------------- | Web Routes |-------------------------------------------------------------------------- | | Here is where you can register web routes for your application. These | routes are loaded by the RouteServiceProvider within a group which | contains the "web" middleware group. Now create something great! | */ Route::get('/', function () { return view('index'); }); Route::resource('product',ProductController::class); 

To see out all route, run this command

php artisan route:list

Output

FULL CRUD GET HERE: Link