DEV Community

loading...
Cover image for Laravel 8.0 CRUD Tutorial Using Mysql Database

Laravel 8.0 CRUD Tutorial Using Mysql Database

devcse
JAVA DEVELOPER
Updated on ・1 min read

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=
Enter fullscreen mode Exit fullscreen mode

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();
});
Enter fullscreen mode Exit fullscreen mode

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

Enter fullscreen mode Exit fullscreen mode

To see out all route, run this command

php artisan route:list

Output

FULL CRUD GET HERE: Link

Discussion (0)