8

Laravel 8.0 CRUD Tutorial Using Mysql Database

 3 years ago
source link: https://dev.to/jewelcse/laravel-8-0-crud-tutorial-using-mysql-database-4ecf
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
neoserver,ios ssh client
Cover image for Laravel 8.0 CRUD Tutorial Using Mysql Database

Laravel 8.0 CRUD Tutorial Using Mysql Database

Jul 20

・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 modeExit 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 modeExit 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 modeExit fullscreen mode

To see out all route, run this command

php artisan route:list

Output

FULL CRUD GET HERE: Link


report

Recommend

About Joyk


Aggregate valuable and interesting links.
Joyk means Joy of geeK