Laravel 8 CRUD Tutorial by Example
In this post we will give you information about Laravel 8 CRUD Tutorial by Example. Hear we will give you detail about Laravel 8 CRUD Tutorial by ExampleAnd how to use it also give you demo for it if it is necessary.
Laravel is one of the most popular PHP-based framework for creating database-driven apps.
Laravel is described by its creators as the framework for web artisans. It’s based on the MVC (Model-View-Controller) pattern and can be used for easily creating apps for making CRUD (Create, Retrieve, Update, Delete) operations against a database.
Laravel has a large community of worlwide developers around it that creates packages for common web development problems so other developers don’t need to re-invent the wheel.
The Laravel team releases a new version each six months. At the time of writing this tutorial, the latest version is Laravel 8 which was released on the 8th Sept 2020.
Throughout this tutorial, we’ll be learning how to create a CRUD app with Laravel 8 to create, insert, update and delete products from a MySQL database.
Read how to add authentication to your Laravel 8 app.
Laravel 8 Prerequisites
In order to follow this tutorial, you’ll need to have the following prerequisites:
- PHP and MySQL installed on your development machine,
- Composer
Step 1 — Installing Laravel 8
Let’s get started by installing Laravel 8 using Composer.
Open a new command-line interface and run the following command:
$ composer create-project laravel/laravel=8.0 laravel8app --prefer-distLaravel 8 has a few new features, for example we don’t need to copy and rename the env.example file, Laravel 8 takes care of that. You also don’t need to generate APP_KEY, it will be automatically generated.
Wait for composer to install the dependencies and set you your project and let’s proceed to the next step.
Step 2 — Setting up a MySQL Database
Let’s now create a MySQL database that we’ll use to persist data in our Laravel application. In your terminal, run the following command to run the mysql client:
$ mysql -u root -pWhen prompted, enter the password for your MySQL server when you’ve installed it.
Next, run the following SQL statement to create a db database:
mysql>createdatabasedb;Open the .env file and update the credentials to access your MySQL database:
DB_CONNECTION=mysqlDB_HOST=127.0.0.1DB_PORT=3306DB_DATABASE=dbDB_USERNAME=rootDB_PASSWORD=******You need to provide the database name, the username and password.
At this point, you can run the migrate command to create your database and a bunch of SQL tables needed by Laravel:
$ php artisan migrateNote: You can run the
migratecommand at any other points of your development to add other SQL tables in your database or to later your database if you need to add any changes later.
Step 3 — Creating a Database Migration
We’ll be creating a CRUD application with Laravel 8 for a products app so we’ll need to create the corresponding SQL table in the database using a migration.
Head back to your terminal and run the following commands:
$ cd laravel8app$ php artisan make:migration create_products_table --create=productsA migration file will be created inside the database/migrations folder of your product, next we need to add the fields to our database table. A product will have a name, description, price, date created, and date updated.
Open the 2020_09_12_222716_create_products_table.php file that contains the migration class and update it as follows:
<?phpuseIlluminateDatabaseMigrationsMigration;useIlluminateDatabaseSchemaBlueprint;useIlluminateSupportFacadesSchema;classCreateProductsTableextendsMigration{/** * Run the migrations. * * @return void */publicfunctionup(){Schema::create('products',function(Blueprint$table){$table->id();$table->string('name',255)->nullable();$table->string('description',500)->nullable();$table->decimal('price',22)->nullable()->default(0.00);$table->timestamp('created_at')->useCurrent();$table->timestamp('updated_at')->nullable();});}/** * Reverse the migrations. * * @return void */publicfunctiondown(){Schema::dropIfExists('products');}}To avoid running into errors, you need to specify the default string length before running your migration.
Open the app/Providers/AppServiceProvider.php file and add Schema::defaultstringLength(191) as follows:
<?phpnamespaceAppProviders;useIlluminateSupportServiceProvider;useIlluminateSupportFacadesSchema;classAppServiceProviderextendsServiceProvider{/** * Register any application services. * * @return void */publicfunctionregister(){//}/** * Bootstrap any application services. * * @return void */publicfunctionboot(){Schema::defaultStringLength(191);}}Next, head back to your terminal and run the following command:
$ php artisan migrateThis will add the fields to our database table.
Step 4 — Adding a Resource Route
After creating our database table using a Laravel 8 migration. We’ll next need to add routes for our CRUD operations.
Open the routesweb.php file and add our resource route as follows:
<?phpuseIlluminateSupportFacadesRoute;useAppHttpControllersProductController;Route::get('/',function(){returnview('welcome');});Route::resource('products',ProductController::class);Step 5 — Adding a Laravel 8 Controller and Model
Next, we need to create a Laravel controller and model by running the following command:
$ php artisan make:controller ProductController --resource --model=ProductYou’ll be prompted if you want to create the Product model because it does not exist. Type yes and it will create the model and controller.
Open the app/Http/Controllers/ProductController.php file and update it as follows:
<?phpnamespaceAppHttpControllers;useAppModelsProduct;useIlluminateHttpRequest;classProductControllerextendsController{/** * Display a listing of the resource. * * @return IlluminateHttpResponse */publicfunctionindex(){$products=Product::latest()->paginate(5);returnview('products.index',compact('products'))->with('i',(request()->input('page',1)-1)*5);}/** * Show the form for creating a new resource. * * @return IlluminateHttpResponse */publicfunctioncreate(){returnview('products.create');}/** * Store a newly created resource in storage. * * @param IlluminateHttpRequest $request * @return IlluminateHttpResponse */publicfunctionstore(Request$request){$request->validate(['name'=>'required','description'=>'required','price'=>'required']);Product::create($request->all());returnredirect()->route('products.index')->with('success','Product created successfully.');}/** * Display the specified resource. * * @param AppModelsProduct $product * @return IlluminateHttpResponse */publicfunctionshow(Product$product){returnview('products.show',compact('product'));}/** * Show the form for editing the specified resource. * * @param AppModelsProduct $product * @return IlluminateHttpResponse */publicfunctionedit(Product$product){returnview('products.edit',compact('product'));}/** * Update the specified resource in storage. * * @param IlluminateHttpRequest $request * @param AppModelsproduct $product * @return IlluminateHttpResponse */publicfunctionupdate(Request$request,Product$product){$request->validate(['name'=>'required','description'=>'required','price'=>'required']);$product->update($request->all());returnredirect()->route('products.index')->with('success','Product updated successfully');}/** * Remove the specified resource from storage. * * @param AppModelsProduct $product * @return IlluminateHttpResponse */publicfunctiondestroy(Product$product){$product->delete();returnredirect()->route('products.index')->with('success','Product deleted successfully');}}Laravel 8 makes use of a Models folder for storing model files.
Open the app/Models/Product.php, add the following functions and the fillable, the fillable are the fields in the database that a user can fill:
<?phpnamespaceAppModels;useIlluminateDatabaseEloquentFactoriesHasFactory;useIlluminateDatabaseEloquentModel;classProductextendsModel{useHasFactory;protected$table='products';public$timestamps=true;protected$casts=['price'=>'float'];protected$fillable=['name','description','price','created_at'];}Step 6 — Adding your Larevl 8 Blade Views
Laravel makes use of the blade templating system for views.
Inside the resources/views folder, create two Layouts and Products folders.
Update yhe Layouts/App.blade.php file with the following content:
<html><head><title>App Name - @yield('title')</title><!-- Bootstrap --><linkhref="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/4.0.0-alpha/css/bootstrap.css"rel="stylesheet"><!-- Font Awesome JS --><script defersrc="https://use.fontawesome.com/releases/v5.0.13/js/solid.js"integrity="sha384-tzzSw1/Vo+0N5UhStP3bvwWPq+uvzCMfrN1fEFe+xBmv1C/AtVX5K0uZtmcHitFZ"crossorigin="anonymous"></script><script defersrc="https://use.fontawesome.com/releases/v5.0.13/js/fontawesome.js"integrity="sha384-6OIrr52G08NpOFSZdxxz1xdNSndlD4vdcf/q2myIUVO0VsqaGHJsB0RaBE01VTOY"crossorigin="anonymous"></script><style>.footer{position:fixed;left:;bottom:;width:100%;background-color:#9C27B0;color:white;text-align:center;}</style></head><body> @section('sidebar') @show <divclass="container"> @yield('content') </div></body></html>Open the Index.blade.php and update it as follows:
@extends('layouts.app')@section('content') <divclass="row"><divclass="col-lg-12 margin-tb"><divclass="pull-left"><h2>Laravel 8 CRUD Example </h2></div><divclass="pull-right"><aclass="btn btn-success"href=""title="Create a product"><iclass="fas fa-plus-circle"></i></a></div></div></div> @if ($message = Session::get('success')) <divclass="alert alert-success"></p></div> @endif <tableclass="table table-bordered table-responsive-lg"><tr><th>No</th><th>Name</th><th>description</th><th>Price</th><th>Date Created</th><th>Actions</th></tr> @foreach ($products as $product) <tr><td></td><td></td><td></td><td></td><td></td><td><formaction=""method="POST"><ahref=""title="show"><iclass="fas fa-eye text-success fa-lg"></i></a><ahref=""><iclass="fas fa-edit fa-lg"></i></a> @csrf @method('DELETE') <buttontype="submit"title="delete"style="border: none; background-color:transparent;"><iclass="fas fa-trash fa-lg text-danger"></i></button></form></td></tr> @endforeach </table> {!! $products->links() !!}@endsectionOpen the create.blade.php file and update it as follows:
@extends('layouts.app')@section('content') <divclass="row"><divclass="col-lg-12 margin-tb"><divclass="pull-left"><h2>Add New Product</h2></div><divclass="pull-right"><aclass="btn btn-primary"href=""title="Go back"><iclass="fas fa-backward "></i></a></div></div></div> @if ($errors->any()) <divclass="alert alert-danger"><strong>Error!</strong><ul> @foreach ($errors->all() as $error) <li></li> @endforeach </ul></div> @endif <formaction=""method="POST"> @csrf <divclass="row"><divclass="col-xs-12 col-sm-12 col-md-12"><divclass="form-group"><strong>Name:</strong><inputtype="text"name="name"class="form-control"placeholder="Name"></div></div><divclass="col-xs-12 col-sm-12 col-md-12"><divclass="form-group"><strong>Description:</strong><preclass="form-control"style="height:50px"name="introduction"placeholder="description"></pre></div></div><divclass="col-xs-12 col-sm-12 col-md-12"><divclass="form-group"><strong>Price:</strong><inputtype="number"name="price"class="form-control"placeholder="Put the price"></div></div><divclass="col-xs-12 col-sm-12 col-md-12 text-center"><buttontype="submit"class="btn btn-primary">Submit</button></div></div></form>@endsectionOpen the edit.blade.php file and update it as follows:
@extends('layouts.app')@section('content') <divclass="row"><divclass="col-lg-12 margin-tb"><divclass="pull-left"><h2>Edit Product</h2></div><divclass="pull-right"><aclass="btn btn-primary"href=""title="Go back"><iclass="fas fa-backward "></i></a></div></div></div> @if ($errors->any()) <divclass="alert alert-danger"><strong>Error!</strong><ul> @foreach ($errors->all() as $error) <li></li> @endforeach </ul></div> @endif <formaction=""method="POST"> @csrf @method('PUT') <divclass="row"><divclass="col-xs-12 col-sm-12 col-md-12"><divclass="form-group"><strong>Name:</strong><inputtype="text"name="name"value=""class="form-control"placeholder="Name"></div></div><divclass="col-xs-12 col-sm-12 col-md-12"><divclass="form-group"><strong>Description</strong><preclass="form-control"style="height:50px"name="description"placeholder="description"></pre></div></div><divclass="col-xs-12 col-sm-12 col-md-12"><divclass="form-group"><strong>Price</strong><inputtype="number"name="price"class="form-control"placeholder=""value=""></div></div><divclass="col-xs-12 col-sm-12 col-md-12 text-center"><buttontype="submit"class="btn btn-primary">Submit</button></div></div></form>@endsectionOpen the show.blade.php file and update it as follows:
@extends('layouts.app')@section('content') <divclass="row"><divclass="col-lg-12 margin-tb"><divclass="pull-left"><h2></h2></div><divclass="pull-right"><aclass="btn btn-primary"href=""title="Go back"><iclass="fas fa-backward "></i></a></div></div></div><divclass="row"><divclass="col-xs-12 col-sm-12 col-md-12"><divclass="form-group"><strong>Name:</strong></div></div><divclass="col-xs-12 col-sm-12 col-md-12"><divclass="form-group"><strong>Description</strong></div></div><divclass="col-xs-12 col-sm-12 col-md-12"><divclass="form-group"><strong>Price</strong></div></div><divclass="col-xs-12 col-sm-12 col-md-12"><divclass="form-group"><strong>Date Created</strong></div></div></div>@endsectionThat’s it, we have finished implementing our Laravel 8 CRUD application.
You can serve your Laravel 8 application using the following command:
$ php artisan serveYou can access your app from http://127.0.0.1:8000.
Hope this code and post will helped you for implement Laravel 8 CRUD Tutorial by Example. if you need any help or any feedback give it in comment section or you have good idea about this post you can give it comment section. Your comment will help us for help you more and improve us. we will give you this type of more interesting post in featured also so, For more interesting post and code Keep reading our blogs