Laravel 9 Ajax CRUD using Datatable Example

Laravel 9

Nicesnippets

16-05-2022


Laravel 9 Ajax CRUD using Datatable Example

Hi Guys,

Here, I will guide you step-by-step ajax crud operations in laravel 9 with modal & pagination. we will create jquery ajax crud with modals using datatables js in laravel 9. we will simply write jquery ajax request for crud with yajra datatable laravel 9.

We will use the bootstrap modal for create new records and update new records. we will use resource routes to create a crud (create read update delete) application in laravel 9. We will use yajra datatable to list a record with pagination, sorting, and filter.

I will provide you step by step guide to create ajax crud example with 9. you just need to follow a few steps to get crud with modals and ajax. you can easily use with your laravel 9 project and easy to customize it.

Step 1: Download Laravel


Let us begin the tutorial by installing a new laravel application. if you have already created the project, then skip the following step.

composer create-project laravel/laravel example-app

Step 2: Database Configuration

In second step, we will make database configuration for example database name, username, password etc for our crud application of laravel 9. So let's open .env file and fill all details like as bellow:

.env

DB_CONNECTION=mysql

DB_HOST=127.0.0.1

DB_PORT=3306

DB_DATABASE=here your database name(blog)

DB_USERNAME=here database username(root)

DB_PASSWORD=here database password(root)

Step 3: Install Yajra Datatable

We need to install yajra datatable composer package for datatable, so you can install using following command:

composer require yajra/laravel-datatables-oracle

After that, you need to set providers and alias.

config/app.php

.....

'providers' => [

....

Yajra\DataTables\DataTablesServiceProvider::class,

]

'aliases' => [

....

'DataTables' => Yajra\DataTables\Facades\DataTables::class,

]

.....

Step 4: Add Migration Table

we are going to create ajax crud application for product. so we have to create migration for "products" table using Laravel 9 php artisan command, so first fire bellow command:

php artisan make:migration create_products_table --create=products

After this command you will find one file in the following path "database/migrations" and you have to put the below code in your migration file to create a products table.

database/migrations/2020_01_10_102325_create_products_table.php

<?php

use Illuminate\Support\Facades\Schema;

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Database\Migrations\Migration;

class CreateProductsTable extends Migration

{

/**

* Run the migrations.

*

* @return void

*/

public function up()

{

Schema::create('products', function (Blueprint $table) {

$table->bigIncrements('id');

$table->string('name');

$table->text('detail');

$table->timestamps();

});

}

/**

* Reverse the migrations.

*

* @return void

*/

public function down()

{

Schema::dropIfExists('products');

}

}

Now you have to run this migration by following command:

php artisan migrate

Step 5: Add Route

Here, we need to add a resource route for the product ajax crud application. so open your "routes/web.php" file and add the following route.

routes/web.php

<?php

use App\Http\Controllers\ProductAjaxController;

/*

|--------------------------------------------------------------------------

| 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::resource('ajaxproducts',ProductAjaxController::class);

Step 6: Add Controller

In this step, now we should create new controller as ProductAjaxController. So run bellow command and create new controller.

php artisan make:controller ProductAjaxController --resource

So, let's copy the below code and put it on the ProductAjaxController.php file.

app/Http/Controllers/ProductAjaxController.php

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use App\Models\Product;

use DataTables;

class ProductAjaxController extends Controller

{

/**

* Display a listing of the resource.

*

* @return \Illuminate\Http\Response

*/

public function index(Request $request)

{

if ($request->ajax()) {

$data = Product::latest()->get();

return Datatables::of($data)

->addIndexColumn()

->addColumn('action', function($row){

$btn = '<a href="javascript:void(0)" data-toggle="tooltip" data-id="'.$row->id.'" data-original-title="Edit" class="edit btn btn-primary btn-sm editProduct">Edit</a>';

$btn = $btn.' <a href="javascript:void(0)" data-toggle="tooltip" data-id="'.$row->id.'" data-original-title="Delete" class="btn btn-danger btn-sm deleteProduct">Delete</a>';

return $btn;

})

->rawColumns(['action'])

->make(true);

}

return view('productAjax');

}

/**

* Store a newly created resource in storage.

*

* @param \Illuminate\Http\Request $request

* @return \Illuminate\Http\Response

*/

public function store(Request $request)

{

Product::updateOrCreate(['id' => $request->product_id],

['name' => $request->name, 'detail' => $request->detail]);

return response()->json(['success'=>'Product saved successfully.']);

}

/**

* Show the form for editing the specified resource.

*

* @param \App\Product $product

* @return \Illuminate\Http\Response

*/

public function edit($id)

{

$product = Product::find($id);

return response()->json($product);

}

/**

* Remove the specified resource from storage.

*

* @param \App\Product $product

* @return \Illuminate\Http\Response

*/

public function destroy($id)

{

Product::find($id)->delete();

return response()->json(['success'=>'Product deleted successfully.']);

}

}

Step 7: Add Model

php artisan make:model Product

Ok, so after run bellow command you will find "app/Product.php" and put bellow content in Product.php file:

app/Models/Product.php

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;

use Illuminate\Database\Eloquent\Model;

class Product extends Model

{

/**

* The attributes that are mass assignable.

*

* @var array

*/

protected $fillable = [

'name', 'detail'

];

}

Step 8: Add Blade Files

In the last step. In this step we have to create just a blade file. so we need to create only one blade file as the productAjax.blade.php file.

So let's just create following file and put bellow code.

resources/views/productAjax.blade.php

<!DOCTYPE html>

<html>

<head>

<title>Laravel 9 Ajax CRUD Tutorial Using Datatable - Nicesnippets.com</title>

<meta name="csrf-token" content="{{ csrf_token() }}">

<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/4.1.3/css/bootstrap.min.css" />

<link href="https://cdn.datatables.net/1.10.16/css/jquery.dataTables.min.css" rel="stylesheet">

<link href="https://cdn.datatables.net/1.10.19/css/dataTables.bootstrap4.min.css" rel="stylesheet">

<script src="https://ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.js"></script>

<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery-validate/1.19.0/jquery.validate.js"></script>

<script src="https://cdn.datatables.net/1.10.16/js/jquery.dataTables.min.js"></script>

<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.1.3/js/bootstrap.min.js"></script>

<script src="https://cdn.datatables.net/1.10.19/js/dataTables.bootstrap4.min.js"></script>

<script src="https://cdnjs.cloudflare.com/ajax/libs/bootbox.js/4.4.0/bootbox.min.js"></script>

</head>

<style type="text/css">

.container{

margin-top:150px;

}

h4{

margin-bottom:30px;

}

</style>

<body>

<div class="container">

<div class="row">

<div class="col-md-8 offset-md-2">

<div class="row">

<div class="col-md-12 text-center">

<h4>Laravel 9 Ajax CRUD Tutorial Using Datatable - Nicesnippets.com</h4>

</div>

<div class="col-md-12 text-right mb-5">

<a class="btn btn-success" href="javascript:void(0)" id="createNewProduct"> Create New Product</a>

</div>

<div class="col-md-12">

<table class="table table-bordered data-table">

<thead>

<tr>

<th>No</th>

<th>Name</th>

<th>Details</th>

<th width="280px">Action</th>

</tr>

</thead>

<tbody>

</tbody>

</table>

</div>

</div>

</div>

</div>

</div>

<div class="modal fade" id="ajaxModel" aria-hidden="true">

<div class="modal-dialog">

<div class="modal-content">

<div class="modal-header">

<h4 class="modal-title" id="modelHeading"></h4>

</div>

<div class="modal-body">

<form id="productForm" name="productForm" class="form-horizontal">

<input type="hidden" name="product_id" id="product_id">

<div class="form-group">

<label for="name" class="col-sm-2 control-label">Name</label>

<div class="col-sm-12">

<input type="text" class="form-control" id="name" name="name" placeholder="Enter Name" value="" maxlength="50" required="">

</div>

</div>

<div class="form-group">

<label class="col-sm-2 control-label">Details</label>

<div class="col-sm-12">

<textarea id="detail" name="detail" required="" placeholder="Enter Details" class="form-control"></textarea>

</div>

</div>

<div class="col-sm-offset-2 col-sm-10">

<button type="submit" class="btn btn-primary" id="saveBtn" value="create">Save changes</button>

</div>

</form>

</div>

</div>

</div>

</div>

</body>

<script type="text/javascript">

$(function () {

$.ajaxSetup({

headers: {

'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')

}

});

var table = $('.data-table').DataTable({

processing: true,

serverSide: true,

ajax: "{{ route('ajaxproducts.index') }}",

columns: [

{data: 'DT_RowIndex', name: 'DT_RowIndex'},

{data: 'name', name: 'name'},

{data: 'detail', name: 'detail'},

{data: 'action', name: 'action', orderable: false, searchable: false},

]

});

$('#createNewProduct').click(function () {

$('#saveBtn').val("create-product");

$('#product_id').val('');

$('#productForm').trigger("reset");

$('#modelHeading').html("Create New Product");

$('#ajaxModel').modal('show');

});

$('body').on('click', '.editProduct', function () {

var product_id = $(this).data('id');

$.get("{{ route('ajaxproducts.index') }}" +'/' + product_id +'/edit', function (data) {

$('#modelHeading').html("Edit Product");

$('#saveBtn').val("edit-user");

$('#ajaxModel').modal('show');

$('#product_id').val(data.id);

$('#name').val(data.name);

$('#detail').val(data.detail);

})

});

$('#saveBtn').click(function (e) {

e.preventDefault();

$(this).html('Sending..');

$.ajax({

data: $('#productForm').serialize(),

url: "{{ route('ajaxproducts.store') }}",

type: "POST",

dataType: 'json',

success: function (data) {

$('#productForm').trigger("reset");

$('#ajaxModel').modal('hide');

table.draw();

},

error: function (data) {

console.log('Error:', data);

$('#saveBtn').html('Save Changes');

}

});

});

$('body').on('click', '.deleteProduct', function (){

var product_id = $(this).data("id");

var result = confirm("Are You sure want to delete !");

if(result){

$.ajax({

type: "DELETE",

url: "{{ route('ajaxproducts.store') }}"+'/'+product_id,

success: function (data) {

table.draw();

},

error: function (data) {

console.log('Error:', data);

}

});

}else{

return false;

}

});

});

</script>

</html>

Run Laravel App:

All steps have been done, now you have to type the given command and hit enter to run the laravel app:

php artisan serve

Now, you have to open web browser, type the given URL and view the app output:

http://localhost:8000/ajaxproducts

It will help you...