Category Archives: Laravel

Laravel Tutorials

Laravel 9 Daily Monthly Weekly Automatic Database Backup

In this Laravel 9 Automatic Daily Database Backup Example tutorial, I’ll show you how to take daily, monthly, weekly automatic backup of database in laravel. In this tutorial you will learn to take daily, monthly, weekly Automatic Database Backup in laravel 9. In this article I will guide you through process how to take daily, monthly, weekly automatic database backup of your laravel application.

Laravel 9 daily, monthly, weekly Automatic Database Backup Example

In this step by step tutorial I’ll guide you through the process to take daily automatic database backup in laravel. Pleasae Follow the instruction given below and take daily automatic database backup in laravel using scheduler cron job:

Create Command
Register Command In Kernel.php
Edit the DbBackup.php
Backup Files

Create Command

In this step we will switch to project directory as following:

cd /project directory

1	cd /project directory

Then use the below command to create command:

php artisan make:command DbBackup

1	php artisan make:command DbBackup

This command creates one file named DbBackup.php.

Register Command In Kernel.php

Now go to app/console and open kernal.php file. And then update the following code into your file:

<?php
namespace App\Console;
use Illuminate\Console\Scheduling\Schedule;
use Illuminate\Foundation\Console\Kernel as ConsoleKernel;
class Kernel extends ConsoleKernel
{
    /**
     * The Artisan commands provided by your application.
     *
     * @var array
     */
   protected $commands = [
        'App\Console\Commands\DbBackup'
    ];
    /**
     * Define the application's command schedule.
     *
     * @param  \Illuminate\Console\Scheduling\Schedule  $schedule
     * @return void
     */
    protected function schedule(Schedule $schedule)
    {
        $schedule->command('db:backup')->daily();
    }
    /**
     * Register the commands for the application.
     *
     * @return void
     */
    protected function commands()
    {
        $this->load(__DIR__.'/Commands');
        require base_path('routes/console.php');
    }
}

<?php

namespace App\Console;

use Illuminate\Console\Scheduling\Schedule;

use Illuminate\Foundation\Console\Kernel as ConsoleKernel;

class Kernel extends ConsoleKernel

{

/**

* The Artisan commands provided by your application.

* @var array

protected $commands = [

'App\Console\Commands\DbBackup'

];

/**

* Define the application's command schedule.

* @param \Illuminate\Console\Scheduling\Schedule $schedule

* @return void

protected function schedule(Schedule $schedule)

{

$schedule->command('db:backup')->daily();

}

/**

* Register the commands for the application.

* @return void

protected function commands()

{

$this->load(__DIR__.'/Commands');

require base_path('routes/console.php');

}

Edit the DbBackup.php

Now, go to app/Console/Commands/ folder and open DbBackup.php. And then update the following code into your

<?php
namespace App\Console\Commands;
use Illuminate\Console\Command;
use Carbon\Carbon;
class DbBackup extends Command
{
    /**
     * The name and signature of the console command.
     *
     * @var string
     */
    protected $signature = 'db:backup';
/**
     * The console command description.
     *
     * @var string
     */
    protected $description = 'Create Database Backup';
/**
     * Create a new command instance.
     *
     * @return void
     */
    public function __construct()
    {
        parent::__construct();
    }
    /**
     * Execute the console command.
     *
     * @return mixed
     */
    public function handle()
    {
        $filename = "backup-" . Carbon::now()->format('Y-m-d') . ".gz";
        $command = "mysqldump --user=" . env('DB_USERNAME') ." --password=" . env('DB_PASSWORD') . " --host=" . env('DB_HOST') . " " . env('DB_DATABASE') . "  | gzip > " . storage_path() . "/app/backup/" . $filename;
        $returnVar = NULL;
        $output  = NULL;
        exec($command, $output, $returnVar);
    }
}

<?php

namespace App\Console\Commands;

use Illuminate\Console\Command;

use Carbon\Carbon;

class DbBackup extends Command

{

/**

* The name and signature of the console command.

* @var string

protected $signature = 'db:backup';

/**

* The console command description.

* @var string

protected $description = 'Create Database Backup';

/**

* Create a new command instance.

* @return void

public function __construct()

{

parent::__construct();

}

/**

* Execute the console command.

* @return mixed

public function handle()

{

$filename = "backup-" . Carbon::now()->format('Y-m-d') . ".gz";

$command = "mysqldump --user=" . env('DB_USERNAME') ." --password=" . env('DB_PASSWORD') . " --host=" . env('DB_HOST') . " " . env('DB_DATABASE') . " | gzip > " . storage_path() . "/app/backup/" . $filename;

$returnVar = NULL;

$output = NULL;

exec($command, $output, $returnVar);

}

Backup Files

Finally the above Laravel scheduler command will take backup of database in zipped format and place file at “storage/app/backup”. So you can go to storage/app/backup folder and find daily database backup files here.

Laravel 9 Find Nearest Location By Latitude and Longitude

In this Laravel 9 Find Nearest Location By Latitude and Longitude tutorial I will show you How to find nearest location using latitude and longitude in laravel 9 application. In this tutorial you will learn How to find nearest location using latitude and longitude in laravel 9. In this article I will share example to find nearest location using latitude and longitude in laravel 9 application. When developing any web application we come to situations where we need to find the nearest location using latitude and longitude in laravel. In this tutorial I will help you find nearest location using your current latitude and longitude in laravel 9. In this example we will find neareby place using latitude and longitude query in laravel eloquent. You can get nearest geolocation by mysql radius query laravel 9.

Laravel 9 Find Nearest Location By Latitude and Longitude

In this step by step tutorial I will demonstrate you How to find nearest location using latitude and longitude in laravel 9. Please follow the instruction given below:

Install Laravel 9
Connecting App to Database
Add Route
Generate Controller by Command
Run Development Server
Test This App

Install Laravel 9

First of all we need to create a fresh laravel project, download and install Laravel 9 using the below command

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

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

Connecting App to Database

Now, lets create a MySQL database and connect it with laravel application. After creating database we need to set database credential in application’s .env file.

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=Enter_Your_Database_Name
DB_USERNAME=Enter_Your_Database_Username
DB_PASSWORD=Enter_Your_Database_Password

DB_CONNECTION=mysql

DB_HOST=127.0.0.1

DB_PORT=3306

DB_DATABASE=Enter_Your_Database_Name

DB_USERNAME=Enter_Your_Database_Username

DB_PASSWORD=Enter_Your_Database_Password

Add Route

After this, we need to define routes in “routes/web.php” file. Lets open “routes/web.php” file and add the following routes in it.

routes/web.php

use App\Http\Controllers\LocationController;
Route::get('near-places', [LocationController::class, 'index']);

1 2	use App\Http\Controllers\LocationController; Route::get('near-places', [LocationController::class, 'index']);

Generate Controller by Command

Now, lets create a controller named LocationController using command given below –

php artisan make:controller LocationController

1	php artisan make:controller LocationController

After successfully create controller go to app/controllers/LocationController.php and update the following code :

<?php
 
namespace App\Http\Controllers;
 
use Illuminate\Http\Request;
 
use DB;
 
class LocationController extends Controller
{
    // ---------------- [ Load View ] ----------------
    public function index(Request $request) {
 
                $lat = YOUR_CURRENT_LATTITUDE;
        $lon = YOUR_CURRENT_LONGITUDE;
            
        $data = DB::table("users")
            ->select("users.id"
                ,DB::raw("6371 * acos(cos(radians(" . $lat . ")) 
                * cos(radians(users.lat)) 
                * cos(radians(users.lon) - radians(" . $lon . ")) 
                + sin(radians(" .$lat. ")) 
                * sin(radians(users.lat))) AS distance"))
                ->groupBy("users.id")
                ->get();
 
      dd($data);
    }
}

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use DB;

class LocationController extends Controller

{

// ---------------- [ Load View ] ----------------

public function index(Request $request) {

$lat = YOUR_CURRENT_LATTITUDE;

$lon = YOUR_CURRENT_LONGITUDE;

$data = DB::table("users")

->select("users.id"

,DB::raw("6371 * acos(cos(radians(" . $lat . "))

* cos(radians(users.lat))

* cos(radians(users.lon) - radians(" . $lon . "))

+ sin(radians(" .$lat. "))

* sin(radians(users.lat))) AS distance"))

->groupBy("users.id")

->get();

dd($data);

}

Run Development Server

Now we are ready to run our example so lets start the development server using following artisan command –

php artisan serve

1	php artisan serve

Now, open the following URL in browser to see the output –

 http://localhost:8000/near-places

1	http://localhost:8000/near-places

Laravel 9 Get Country City Name & Address From IP Address Example

In this Laravel 9 get country name, country code, city name, and address from user IP address example tutorial I will show you how to get country name, country code, city name, and address from user IP address in laravel 9. In this tutorial you will learn to get country name, country code, city name, and address from user IP address in laravel 9. When you working on web development project you come to situation where you may want to fetch user information such as country Name, country Code, region Code, region Name, city Name, zip Code, iso Code, postal Code, latitude, longitude, metro Code, metro Code from ip address in laravel 9. In this example I will help you to fetch user info from IP their ip address. We will be using stevebauman/location package in this example to fetch country name, country code, city name, and address from IP address.

Laravel 9 Get Country, City Name & Address From IP Address Example

In this step by step tutorial I will demonstrate you with example to fetch country name, country code, city name, and address from IP address. Please follow the instruction given below:

Install Laravel 9
Connecting App to Database
Install “stevebauman/location”
Add Routes
Create Controller By Command
Start Development Server

Install Laravel 9

First of all we need to create a fresh laravel project, download and install Laravel 9 using the below command

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

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

Connecting App to Database

Now, lets create a MySQL database and connect it with laravel application. After creating database we need to set database credential in application’s .env file.

 DB_CONNECTION=mysql 
 DB_HOST=127.0.0.1 
 DB_PORT=3306 
 DB_DATABASE=here your database name here
 DB_USERNAME=here database username here
 DB_PASSWORD=here database password here

DB_CONNECTION=mysql

DB_HOST=127.0.0.1

DB_PORT=3306

DB_DATABASE=here your database name here

DB_USERNAME=here database username here

DB_PASSWORD=here database password here

Install “stevebauman/location”

In this step, we will install stevebauman/location Package via the composer dependency manager. Use the following command to install stevebauman/location Package.

composer require stevebauman/location

1	composer require stevebauman/location

Then, Go to config directory and open app.php file. And register this package into laravel 9 app by adding the following code into your app.php file:

'providers' => [
 
    ....
 
    Stevebauman\Location\LocationServiceProvider::class,
 
],
 
'aliases' => [
 
    ....
 
    'Location' => 'Stevebauman\Location\Facades\Location',
 
]

'providers' => [

....

Stevebauman\Location\LocationServiceProvider::class,

'aliases' => [

....

'Location' => 'Stevebauman\Location\Facades\Location',

]

Now you need to run the following command on terminal to publish config/location.php file:

php artisan vendor:publish

1	php artisan vendor:publish

Add Routes

After this, we need to define routes in “routes/web.php” file. Lets open “routes/web.php” file and add the following routes in it.

routes/web.php

use App\Http\Controllers\GeoLocationController;
 
Route::get('get-address-from-ip', [GeoLocationController::class, 'index']);

use App\Http\Controllers\GeoLocationController;

Route::get('get-address-from-ip', [GeoLocationController::class, 'index']);

Create Controller By Command

Now, lets create a controller named GeoLocationController using command given below –

php artisan make:controller GeoLocationController

1	php artisan make:controller GeoLocationController

Now, go to app\Http\Controllers and open GeoLocationController.php file. Then put the following code into your GeoLocationController.php file:

<?php
 
namespace App\Http\Controllers;
 
use Illuminate\Http\Request;
 
class GeoLocationController extends Controller
{
    
    public function index(Request $request)
    {
            $ip = $request->ip();
            $data = \Location::get($ip);
            dd($data);
    }
}

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

class GeoLocationController extends Controller

{

public function index(Request $request)

{

$ip = $request->ip();

$data = \Location::get($ip);

dd($data);

}

Start Development Server

Now we are ready to run our example so lets start the development server using following artisan command –

php artisan serve

1	php artisan serve

Now, open the following URL in browser to see the output –

http://localhost:8000/get-address-from-ip

1	http://localhost:8000/get-address-from-ip

Laravel 9 Multiple Image Upload with Preview

In this Laravel 9 Multiple Image Upload with Preview, I’ll show you how to upload image along with preview before upload in laravel 9. In this laravel 9 multiple image upload example, I’ll show you how to validate upload image into folder and then save it into database. In this tutorial before saving image into database we will show preview of the images and then save it into directory. Before uploading the image we will display preview of the image. After successfully image upload into the database and folder we will display success message on the screen.

Laravel 9 Multiple Image Upload with Preview

In this step by step Laravel 9 Multiple Image Upload with Preview tutorial I’ll demonstrate how to upload multiple image in laravel 9 with preview. I’ll also show you how to upload multiple image in laravel 9 with preview. Please follow the steps given below:

Install Laravel 9
Database Configuration
Build Photo Model & Migration
Create Routes
Generate Controller using Artisan Command
Create Blade View
Start Development Server
Start App on Browser

Install Laravel 9

First of all we need to create a fresh laravel project, download and install Laravel 9 using the below command

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

1	composer create-project --prefer-dist laravel/laravel lara9blog

Configure Database

Now, lets create a MySQL database and connect it with laravel application. After creating database we need to set database credential in application’s .env file.

.env

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

DB_CONNECTION=mysql

DB_HOST=127.0.0.1

DB_PORT=3306

DB_DATABASE=lara9blog

DB_USERNAME=root

DB_PASSWORD=

Create Model & Migration

Now, we have to define table schema for photos table. Open terminal and let’s run the following command to generate a migration along with model file to create photos table in our database.

php artisan make:model Photo -m

1	php artisan make:model Photo -m

Once this command is executed you will find a migration file created under “database/migrations”. lets open migration file and put following code in it –

public function up()
{
    Schema::create('photos', function (Blueprint $table) {
        $table->id();
        $table->string('title');
        $table->string('path');
        $table->timestamps();
    });
}

public function up()

{

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

$table->id();

$table->string('title');

$table->string('path');

$table->timestamps();

});

}

Now, run following command to migrate database schema.

php artisan migrate

1	php artisan migrate

After, the migration executed successfully the photos table will be created in database.

Create Routes

After this, we need to add following routes in “routes/web.php” file along with a resource route. Lets open “routes/web.php” file and add following route.

routes/web.php

use App\Http\Controllers\UploadMultipleImageController;
 
Route::get('upload-multiple-image-preview', [UploadImagesController::class, 'index']);
 
Route::post('upload-multiple-image-preview', [UploadImagesController::class, 'store']);

use App\Http\Controllers\UploadMultipleImageController;

Route::get('upload-multiple-image-preview', [UploadImagesController::class, 'index']);

Route::post('upload-multiple-image-preview', [UploadImagesController::class, 'store']);

Create Controller By Artisan Command

Now, lets create a controller for simple image uploading. Create a controller named UploadMultipleImageController using command given below –

php artisan make:controller UploadMultipleImageController

1	php artisan make:controller UploadMultipleImageController

Once the above command executed, it will create a controller file UploadMultipleImageController.php in app/Http/Controllers/ directory. Open the UploadMultipleImageController.php file and put the following code in it.

app/Http/Controllers/UploadMultipleImageController.php

<?php
namespace App\Http\Controllers;
use Illuminate\Http\Request;
use App\Models\Photo;
class UploadImagesController extends Controller
{
   public function index()
    {
        return view('images-upload-form');
    }
    public function store(Request $request)
    {
         
        $validateImageData = $request->validate([
        'images' => 'required',
            'images.*' => 'mimes:jpg,png,jpeg,gif,svg'
        ]);
        if($request->hasfile('images'))
         {
            foreach($request->file('images') as $key => $file)
            {
                $path = $file->store('public/images');
                $name = $file->getClientOriginalName();
                $insert[$key]['title'] = $name;
                $insert[$key]['path'] = $path;
            }
         }
        Photo::insert($insert);
 
        return redirect('upload-multiple-image-preview')->with('status', 'All Images has been uploaded successfully');
    }
}

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use App\Models\Photo;

class UploadImagesController extends Controller

{

public function index()

{

return view('images-upload-form');

}

public function store(Request $request)

{

$validateImageData = $request->validate([

'images' => 'required',

'images.*' => 'mimes:jpg,png,jpeg,gif,svg'

]);

if($request->hasfile('images'))

{

foreach($request->file('images') as $key => $file)

{

$path = $file->store('public/images');

$name = $file->getClientOriginalName();

$insert[$key]['title'] = $name;

$insert[$key]['path'] = $path;

}

Photo::insert($insert);

return redirect('upload-multiple-image-preview')->with('status', 'All Images has been uploaded successfully');

}

Create Blade View

In this step, we will create view/blade file to generate and display multiple Image Upload Form. Lets create a blade file “images-upload-form.blade.php” in “resources/views/” directory and put the following code in it respectively.

resources/views/images-upload-form.blade.php

<!DOCTYPE html>
<html>
<head>
<title>Laravel 9 Upload Multiple Image With Preview using jQuery</title>
<meta name="csrf-token" content="{{ csrf_token() }}">
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css">
</head>
<body>
<div class="container mt-5">
@if(session('status'))
<div class="alert alert-success">
{{ session('status') }}
</div>
@endif
<style>
.images-preview-div img
{
padding: 10px;
max-width: 100px;
}
</style>
<div class="card">
<div class="card-header text-center font-weight-bold">
<h2>Laravel 9 Upload Multiple Image With Preview</h2>
</div>
<div class="card-body">
<form name="images-upload-form" method="POST"  action="{{ url('upload-multiple-image-preview') }}" accept-charset="utf-8" enctype="multipart/form-data">
@csrf
<div class="row">
<div class="col-md-12">
<div class="form-group">
<input type="file" name="images[]" id="images" placeholder="Choose images" multiple >
</div>
@error('images')
<div class="alert alert-danger mt-1 mb-1">{{ $message }}</div>
@enderror
</div>
<div class="col-md-12">
<div class="mt-1 text-center">
<div class="images-preview-div"> </div>
</div>  
</div>
<div class="col-md-12">
<button type="submit" class="btn btn-primary" id="submit">Submit</button>
</div>
</div>     
</form>
</div>
</div>
<script src="https://code.jquery.com/jquery-3.5.1.min.js"></script>
<script >
$(function() {
// Multiple images preview with JavaScript
var previewImages = function(input, imgPreviewPlaceholder) {
if (input.files) {
var filesAmount = input.files.length;
for (i = 0; i < filesAmount; i++) {
var reader = new FileReader();
reader.onload = function(event) {
$($.parseHTML('<img>')).attr('src', event.target.result).appendTo(imgPreviewPlaceholder);
}
reader.readAsDataURL(input.files[i]);
}
}
};
$('#images').on('change', function() {
previewImages(this, 'div.images-preview-div');
});
});
</script>
</div>  
</body>
</html>

<!DOCTYPE html>

<html>

<head>

<title>Laravel 9 Upload Multiple Image With Preview using jQuery</title>

</head>

<body>

@if(session('status'))

</div>

@endif

<style>

.images-preview-div img

{

padding: 10px;

max-width: 100px;

}

</style>

<h2>Laravel 9 Upload Multiple Image With Preview</h2>

</div>

@csrf

</div>

@error('images')

<div class="alert alert-danger mt-1 mb-1">{{ $message }}</div>

@enderror

</div>

</div>

<button type="submit" class="btn btn-primary" id="submit">Submit</button>

</div>

</form>

</div>

$(function() {

// Multiple images preview with JavaScript

var previewImages = function(input, imgPreviewPlaceholder) {

if (input.files) {

var filesAmount = input.files.length;

for (i = 0; i < filesAmount; i++) {

var reader = new FileReader();

reader.onload = function(event) {

$($.parseHTML('<img>')).attr('src', event.target.result).appendTo(imgPreviewPlaceholder);

}

reader.readAsDataURL(input.files[i]);

}

};

$('#images').on('change', function() {

previewImages(this, 'div.images-preview-div');

});

</script>

</div>

</body>

</html>

Run Development Server

Now we are ready to run our example so lets start the development server using following artisan command –

php artisan serve

1	php artisan serve

Now, open the following URL in browser to see the output –

http://localhost:8000/upload-multiple-image-preview

1	http://localhost:8000/upload-multiple-image-preview

Laravel 9 Upload Multiple Files Tutorial

In this Laravel 9 Multiple File Upload Example, I’ll show you how to upload multiple image along with validation in laravel 9. In this laravel 9 multiple image upload example, I’ll show you how to validate and upload multiple image into folder and then save it into database. In this tutorial before saving multiple image into database we will validate image and then save it into directory. Before uploading the image we will validate the image. After successfully uploading multiple images into the folder and saving it in database we will display success message on the screen.

Laravel 9 Multiple File Upload Example

In this step by step tutorial I’ll demonstrate how to upload multiple files in laravel 9 with validation. I’ll also show you how to upload multiple pdf, txt, csv, excel, doc files in laravel 9 application. Please follow the steps to upload multiple files in laravel 9 given below:

Install Laravel 9
Database Configuration
Build Model & Migration
Create Routes
Build Multi Upload Controller By Artisan Command
Create Multiple File Upload Form
Create Directory inside Storage/app/public
Run Development Server

Install Laravel 9

First of all we need to create a fresh laravel project, download and install Laravel 9 using the below command

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

1	composer create-project --prefer-dist laravel/laravel lara9blog

Configure Database

Now, lets create a MySQL database and connect it with laravel application. After creating database we need to set database credential in application’s .env file.

.env

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

DB_CONNECTION=mysql

DB_HOST=127.0.0.1

DB_PORT=3306

DB_DATABASE=lara9blog

DB_USERNAME=root

DB_PASSWORD=

Create Model & Migration

Now, we have to define table schema for files table. Open terminal and let’s run the following command to generate a migration along with model file to create files table in our database.

php artisan make:model File -m

1	php artisan make:model File -m

Once this command is executed you will find a migration file created under “database/migrations”. lets open migration file and put following code in it –

public function up()
{
    Schema::create('files', function (Blueprint $table) {
        $table->id();
        $table->string('name');
        $table->string('path');
        $table->timestamps();
    });
}

public function up()

{

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

$table->id();

$table->string('name');

$table->string('path');

$table->timestamps();

});

}

Now, run following command to migrate database schema.

php artisan migrate

1	php artisan migrate

After, the migration executed successfully the files table will be created in database.

Create Routes

After this, we need to add following routes in “routes/web.php” file along with a resource route. Lets open “routes/web.php” file and add following route.

routes/web.php

use App\Http\Controllers\MultiFileUploadController;
 
Route::get('files-upload', [MultiFileUploadController::class, 'index']);
Route::post('save-multiple-files', [MultiFileUploadController::class, 'store']);

use App\Http\Controllers\MultiFileUploadController;

Route::get('files-upload', [MultiFileUploadController::class, 'index']);

Route::post('save-multiple-files', [MultiFileUploadController::class, 'store']);

Create Controller By Artisan Command

Now, lets create a controller for simple file uploading. Create a controller named MultiFileUploadController using command given below –

php artisan make:controller MultiFileUploadController

1	php artisan make:controller MultiFileUploadController

Once the above command executed, it will create a controller file MultiFileUploadController.php in app/Http/Controllers/ directory. Open the MultiFileUploadController.php file and put the following code in it.

app/Http/Controllers/MultiFileUploadController.php

<?php
 
namespace App\Http\Controllers;
 
use Illuminate\Http\Request;
 
use App\Models\File;
 
 
class MultiFileUploadController extends Controller
{
    public function index()
    {
        return view('multiple-files-upload');
    }
 
    public function store(Request $request)
    {
         
        $validatedData = $request->validate([
        'files' => 'required',
        'files.*' => 'mimes:csv,txt,xlx,xls,pdf'
        ]);
 
 
        if($request->hasfile('files'))
         {
            foreach($request->file('files') as $key => $file)
            {
                $path = $file->store('public/files');
                $name = $file->getClientOriginalName();
 
                $insert[$key]['name'] = $name;
                $insert[$key]['path'] = $path;
 
            }
         }
 
        File::insert($insert);
 
        return redirect('files-upload')->with('status', 'Multiple File has been uploaded Successfully');
 
    }
}

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use App\Models\File;

class MultiFileUploadController extends Controller

{

public function index()

{

return view('multiple-files-upload');

}

public function store(Request $request)

{

$validatedData = $request->validate([

'files' => 'required',

'files.*' => 'mimes:csv,txt,xlx,xls,pdf'

]);

if($request->hasfile('files'))

{

foreach($request->file('files') as $key => $file)

{

$path = $file->store('public/files');

$name = $file->getClientOriginalName();

$insert[$key]['name'] = $name;

$insert[$key]['path'] = $path;

}

File::insert($insert);

return redirect('files-upload')->with('status', 'Multiple File has been uploaded Successfully');

}

Note:- Before uploading any file make sure you have created following directory in the storage/app/public folder called files.

Create Multiple File Upload Form

In this step, we will create view/blade file to generate and display multiple file Upload Form. Lets create a blade file “multiple-files-upload.blade.php” in “resources/views/” directory and put the following code in it respectively.

resources/views/multiple-files-upload.blade.php

<!DOCTYPE html>
<html>
<head>
  <title>Multiple File Upload in Laravel 9</title>
 
  <meta name="csrf-token" content="{{ csrf_token() }}">
 
  <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css">
 
</head>
<body>
 
<div class="container mt-5">
 
  @if(session('status'))
    <div class="alert alert-success">
        {{ session('status') }}
    </div>
  @endif
 
 
      <h2 class="text-center">Laravel 9 Multiple File Upload With Validation</h2>
 
 
    <div class="text-center">
 
        <form name="save-multiple-files" method="POST"  action="{{ url('save-multiple-files') }}" accept-charset="utf-8" enctype="multipart/form-data">
 
          @csrf
                   
            <div class="row">
 
                <div class="col-md-12">
                    <div class="form-group">
                        <input type="file" name="files[]" placeholder="Choose files" multiple >
                    </div>
                    @error('files')
                        <div class="alert alert-danger mt-1 mb-1">{{ $message }}</div>
                    @enderror
                </div>
                   
                <div class="col-md-12">
                    <button type="submit" class="btn btn-primary" id="submit">Submit</button>
                </div>
            </div>     
        </form>
 
    </div>
 
 
</div>  
</body>
</html>

<!DOCTYPE html>

<html>

<head>

<title>Multiple File Upload in Laravel 9</title>

</head>

<body>

@if(session('status'))

</div>

@endif

<h2 class="text-center">Laravel 9 Multiple File Upload With Validation</h2>

@csrf

</div>

@error('files')

<div class="alert alert-danger mt-1 mb-1">{{ $message }}</div>

@enderror

</div>

<button type="submit" class="btn btn-primary" id="submit">Submit</button>

</div>

</form>

</div>

</body>

</html>

Create Directory inside Storage/app/public

Before uploading any file make sure you have created following directory in the storage/app/public folder called files.

$path = $request-&gt;file('file')-&gt;store('public/files');

1	$path = $request->file('file')->store('public/files');

Run Development Server

Now we are ready to run our example so lets start the development server using following artisan command –

php artisan serve

1	php artisan serve

Now, open the following URL in browser to see the output –

http://localhost:8000/files-upload

1	http://localhost:8000/files-upload

Laravel 9 Send Email with PDF Attachment Tutorial

In this Laravel 9 Send Email with PDF Attachment Tutorial I will show you how to send email with pdf attachment in laravel 9 application. In this tutorial you will learn to send email with pdf attachment in laravel 9. In this example we will be using niklasravnsborg/laravel-pdf package to generate pdf file to send as email attachment in laravel 9. We will also learn to generate pdf file using generate pdf library in laravel 9. In laravel mail class is used to send email. So, we would like to show you send an email in laravel 9. As well as we will also learn to send email in laravel 9 application using a mailable.

Laravel 9 Send Email with PDF Attachment Tutorial

In this step by step tutorial I will demonstrate you with example to send email with pdf attachment in laravel. Please follow the instruction given below:

Install Laravel 9
Configuration SMTP in .env
Install PDF Library
Add Email Send Route
Create Directory And Blade View
Create Email Controller
Run Development Server

Install Laravel 9

First of all we need to create a fresh laravel project, download and install Laravel 9 using the below command

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

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

Configuration SMTP in .env

In this step we will be setting smtp detail for mail configuration in Laravel, We will be using following Gmail SMTP details such as username, password inside the .env file.

MAIL_DRIVER=smtp
MAIL_HOST=smtp.gmail.com 
MAIL_PORT=587 
MAIL_USERNAME=Add your user name here
MAIL_PASSWORD=Add your password here
MAIL_ENCRYPTION=tls

MAIL_DRIVER=smtp

MAIL_HOST=smtp.gmail.com

MAIL_PORT=587

MAIL_USERNAME=Add your user name here

MAIL_PASSWORD=Add your password here

MAIL_ENCRYPTION=tls

Install PDF Library

In this step we will install a pdf library in laravel to send pdf file as email attahcment. we will install niklasravnsborg/laravel-pdf Package via the composer dependency manager. Use the following command to install niklasravnsborg/laravel-pdf Package.

composer require niklasravnsborg/laravel-pdf

1	composer require niklasravnsborg/laravel-pdf

After Installing, we need to add service provider and alias in config/app.php file as following.

config/app.php

'providers' => [
    // ...
    niklasravnsborg\LaravelPdf\PdfServiceProvider::class
]
'aliases' => [
    // ...
    'PDF' => niklasravnsborg\LaravelPdf\Facades\Pdf::class
]

'providers' => [

// ...

niklasravnsborg\LaravelPdf\PdfServiceProvider::class

]

'aliases' => [

// ...

'PDF' => niklasravnsborg\LaravelPdf\Facades\Pdf::class

]

Now, execute the following command to publish package’s config file to your config directory by using following command:

php artisan vendor:publish

1	php artisan vendor:publish

Add Send Email Route

After this, we need to define routes in “routes/web.php” file. Lets open “routes/web.php” file and add the following routes in it.

routes/web.php

use App\Http\Controllers\SendEmailController;

Route::get('send-email-pdf', [SendEmailController::class, 'index']);

use App\Http\Controllers\SendEmailController;

Route::get('send-email-pdf', [SendEmailController::class, 'index']);

Create Directory And Blade View

In this step, we will create a directory name test inside resources/views directory. Then create an test.blade.php blade view file inside resources/views/ directory. And put the following code into it:

test.blade.php

<!DOCTYPE html>
<html>
<head>
 <title>Laravel 9 Send Email Example</title>
</head>
<body>
 
 <h1>This is test mail</h1>
 <p>Laravel 9 send email example</p>
 
</body>
</html>

<!DOCTYPE html>

<html>

<head>

<title>Laravel 9 Send Email Example</title>

</head>

<body>

<p>Laravel 9 send email example</p>

</body>

</html>

Create Send Email Controller

Now, lets create a controller named SendEmailController using command given below –

php artisan make:controller SendEmailController

1	php artisan make:controller SendEmailController

Then go to app/Http/Controllers directory and open SendEmailController.php. Then put the following code into it:

<?php
 
namespace App\Http\Controllers;
 
use Illuminate\Http\Request;
 
use Mail;
 
use PDF;
 
class SendEmailController extends Controller
{
     
    public function sendmail(Request $request){
        $data["email"]=$request->get("email");
        $data["client_name"]=$request->get("client_name");
        $data["subject"]=$request->get("subject");
 
        $pdf = PDF::loadView('test', $data);
 
        try{
            Mail::send('mails.mail', $data, function($message)use($data,$pdf) {
            $message->to($data["email"], $data["client_name"])
            ->subject($data["subject"])
            ->attachData($pdf->output(), "test.pdf");
            });
        }catch(JWTException $exception){
            $this->serverstatuscode = "0";
            $this->serverstatusdes = $exception->getMessage();
        }
        if (Mail::failures()) {
             $this->statusdesc  =   "Error sending mail";
             $this->statuscode  =   "0";
 
        }else{
 
           $this->statusdesc  =   "Message sent Succesfully";
           $this->statuscode  =   "1";
        }
        return response()->json(compact('this'));
 }
}

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use Mail;

use PDF;

class SendEmailController extends Controller

{

public function sendmail(Request $request){

$data["email"]=$request->get("email");

$data["client_name"]=$request->get("client_name");

$data["subject"]=$request->get("subject");

$pdf = PDF::loadView('test', $data);

try{

Mail::send('mails.mail', $data, function($message)use($data,$pdf) {

$message->to($data["email"], $data["client_name"])

->subject($data["subject"])

->attachData($pdf->output(), "test.pdf");

});

}catch(JWTException $exception){

$this->serverstatuscode = "0";

$this->serverstatusdes = $exception->getMessage();

}

if (Mail::failures()) {

$this->statusdesc = "Error sending mail";

$this->statuscode = "0";

}else{

$this->statusdesc = "Message sent Succesfully";

$this->statuscode = "1";

}

return response()->json(compact('this'));

}

Step 7 – Run Development Server

Now we are ready to run our example so lets start the development server using following artisan command –

php artisan serve

1	php artisan serve

Now, open the following URL in browser to see the output –

http://127.0.0.1:8000/send-email-pdf

1	http://127.0.0.1:8000/send-email-pdf

Laravel 9 Send Email Example Tutorial

In this Laravel 9 Send Email Example Tutorial I will show you how to send email in laravel 9 using mailable and mailtrap. We will use Laravel 9 builtin mailable markdown class to send emails. In order to send email using mailtrap we will implement laravel 9 builtin mailable markdown class. In this post I’ll show you how to integrate mailtrap to send email in laravel 9 application.

Laravel 9 Send Email Example Tutorial

In this step by step tutorial you will understand how to send emails in Laravel 9 with the help of using mailable and mailtrap. I will also demonstrate you how to use Laravel 9 builtin mailable markdown class to send emails using Mailtrap. Please follow the instruction given below:

Install Laravel 9 App
Setup Database Credentials
Configuration SMTP in .env
Create Mailable Class
Create Email Controller
Add Email Send Route
Create Directory And Blade View
Run Development Server

Install Laravel 9

First of all we need to create a fresh laravel project, download and install Laravel 9 using the below command

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

1	composer create-project --prefer-dist laravel/laravel lara8blog

Make sure you have composer installed.

Setup Database Credentials

Now, lets create a MySQL database and connect it with laravel application. After creating database we need to set database credential in application’s .env file.

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

DB_CONNECTION=mysql

DB_HOST=127.0.0.1

DB_PORT=3306

DB_DATABASE=lara9blog

DB_USERNAME=root

DB_PASSWORD=

Setting Up Mailtrap Mail Configuration

In this step we will be setting smtp detail for mail configuration in Laravel, We will be using following Gmail SMTP details such as username, password inside the .env file.

MAIL_DRIVER=smtp
MAIL_HOST=smtp.gmail.com
MAIL_PORT=587
MAIL_USERNAME=your_email@gmail.com
MAIL_PASSWORD=
MAIL_ENCRYPTION=tls
MAIL_FROM_ADDRESS=null
MAIL_FROM_NAME="${APP_NAME}"

MAIL_DRIVER=smtp

MAIL_HOST=smtp.gmail.com

MAIL_PORT=587

MAIL_USERNAME=your_email@gmail.com

MAIL_PASSWORD=

MAIL_ENCRYPTION=tls

MAIL_FROM_ADDRESS=null

MAIL_FROM_NAME="${APP_NAME}"

If we are sending email from localhost using Gmail SMTP, then it requires you to turn on the “Allow less secure apps” on?. Go to the link provided:

https://www.google.com/settings/security/lesssecureapps

1	https://www.google.com/settings/security/lesssecureapps

Now, You need to turn on the option “Allow less secure apps”

Create Laravel Markdown Mailable Class

The mailable class in Laravel used for sending emails. Now, lets create a new laravel mailable class using following artisan command:

 php artisan make:mail DemoEmail --markdown=Email.demoEmail

1	php artisan make:mail DemoEmail --markdown=Email.demoEmail

Once the above command executed, it will create a new laravel mailable class DemoEmail.php in app/Mail/ directory. Open the DemoEmail.php file and put the following code in it.

<?php

namespace App\Mail;

use Illuminate\Bus\Queueable;
use Illuminate\Contracts\Queue\ShouldQueue;
use Illuminate\Mail\Mailable;
use Illuminate\Queue\SerializesModels;

class DemoEmail extends Mailable
{
    use Queueable, SerializesModels;
    public $mailData;

    /**
     * Create a new message instance.
     *
     * @return void
     */
    public function __construct($mailData)
    {
        $this->mailData = $mailData;
    }

    /**
     * Build the message.
     *
     * @return $this
     */
    public function build()
    {
        return $this->markdown('Email.demoEmail')
              ->with('mailData', $this->mailData);
    }
}

<?php

namespace App\Mail;

use Illuminate\Bus\Queueable;

use Illuminate\Contracts\Queue\ShouldQueue;

use Illuminate\Mail\Mailable;

use Illuminate\Queue\SerializesModels;

class DemoEmail extends Mailable

{

use Queueable, SerializesModels;

public $mailData;

/**

* Create a new message instance.

* @return void

public function __construct($mailData)

{

$this->mailData = $mailData;

}

/**

* Build the message.

* @return $this

public function build()

{

return $this->markdown('Email.demoEmail')

->with('mailData', $this->mailData);

}

Create Controller to Send and Email

Now, we will create a controller that will handle the logic to send email. Let’s create DemoEmailController Controller using following command:

php artisan make:controller DemoEmailController

1	php artisan make:controller DemoEmailController

Once the above command executed, it will create a controller file DemoEmailController.php in app/Http/Controllers/ directory. Open the DemoEmailController.php file and put the following code in it.

Controllers/DemoEmailController.php

<?php

namespace App\Http\Controllers;
use Illuminate\Http\Request;

use Illuminate\Support\Facades\Mail;
use App\Mail\DemoEmail;
use Symfony\Component\HttpFoundation\Response;

class DemoEmailController extends Controller
{
    public function sendEmail() {
        $email = 'youremail@gmail.com';
   
        $mailData = [
            'title' => 'Demo Email',
            'url' => 'https://www.yoursite.com'
        ];
  
        Mail::to($email)->send(new DemoEmail($mailData));
   
        return response()->json([
            'message' => 'Email has been sent.'
        ], Response::HTTP_OK);
    }
}

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use Illuminate\Support\Facades\Mail;

use App\Mail\DemoEmail;

use Symfony\Component\HttpFoundation\Response;

class DemoEmailController extends Controller

{

public function sendEmail() {

$email = 'youremail@gmail.com';

$mailData = [

'title' => 'Demo Email',

'url' => 'https://www.yoursite.com'

];

Mail::to($email)->send(new DemoEmail($mailData));

return response()->json([

'message' => 'Email has been sent.'

], Response::HTTP_OK);

}

In the DemoEmailController.php we have included DemoEmail Mailable class along with the Mail Facade and Http Response service. Later we have created controller method to send demo email from our laravel 8 application.

Create Route to Send Mail

After this, we need to add following route in “routes/web.php” to send email. Lets open “routes/web.php” file and add following route.

routes/web.php

use App\Http\Controllers\DemoEmailController;
Route::get('/send-demo-email', [DemoEmailController::class, 'sendEmail']);

1 2	use App\Http\Controllers\DemoEmailController; Route::get('/send-demo-email', [DemoEmailController::class, 'sendEmail']);

Create Email Template

In this step, we will create view/blade file to setup email template. Open resources/views/Email/demoEmail.blade.php file, put the following code.

resources/views/Email/demoEmail.blade.php

@component('mail::message')
{{ $mailData['title'] }}

Congratulations! You received demo email.

@component('mail::button', ['url' => $mailData['url']])
Cheers!
@endcomponent

Thanks,<br>
{{ config('app.name') }}
@endcomponent

@component('mail::message')

Congratulations! You received demo email.

@component('mail::button', ['url' => $mailData['url']])

Cheers!

@endcomponent

Thanks,<br>

@endcomponent

Start Development Server

Now we are ready to run our example so lets start the development server using following artisan command:

php artisan serve

1	php artisan serve

Send Email in Laravel

Now, open the following URL in browser to send email:

http://127.0.0.1:8000/send-demo-email

1	http://127.0.0.1:8000/send-demo-email

Output:-

How to Send Email in Laravel 9 using Mailtrap

When you visit the link, you will receive the example email in your inbox.

Laravel 9 Crud Rest Api with Passport Auth

In this Laravel 9 CRUD Api with Passport Auth Tutorial I will show you how to create CRUD REST API with passport authentication In laravel 9. In this tutorial you will learn to create crud and authentication rest api using passport authentication In laravel 9 application. In this article I will share example to create rest api for crud operations and user authentication in laravel 9. We will be creating simple crud operation application with user authentication. We will be using passport authentication package in this example. In this example you will learn how to install passport authentication package in laravel 9. After installing and configure passport authentication in laravel.

Laravel 9 User Authentication API

In this example we will be creating user authentication api means we will be creating rest api for user registration, login and to get user info. We will be using passport authentication for creating rest api for user authentication.

Laravel 9 CRUD REST API

We will be creating simple product crud operation application with user authentication. In this article, you will learn how to create fully functional CRUD (Create, Read, Update and Delete) REST API in laravel 9.

Laravel 9 Crud Rest Api with Passport Auth

In this step by step tutorial I will guide you through create a fully functional CRUD API with passport authentication in Laravel 9. Please follow the instruction given below:

Install Laravel 9
Set Up Database
Install Passport Package
Configure Passport Module
Create Post Model & Run Migration
Create a New Controller
Define API Routes
Test Laravel Passport API

Install Laravel 9

First of all we need to create a fresh laravel project, download and install Laravel using the below command

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

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

Configure Database

Now, lets create a MySQL database and connect it with laravel application. After creating database we need to set database credential in application’s .env file.

DB_CONNECTION=mysql 
 DB_HOST=127.0.0.1 
 DB_PORT=3306 
 DB_DATABASE=here your database name here
 DB_USERNAME=here database username here
 DB_PASSWORD=here database password here

DB_CONNECTION=mysql

DB_HOST=127.0.0.1

DB_PORT=3306

DB_DATABASE=here your database name here

DB_USERNAME=here database username here

DB_PASSWORD=here database password here

Install Passport Package

In this step, we need to install Laravel Passport package via the composer dependency manager. Use the following command to install passport package.

composer require laravel/passport

1	composer require laravel/passport

After successfully install laravel passport, register providers. Open config/app.php . Put the bellow code in it:

config/app.php

  // config/app.php

'providers' =>[
 Laravel\Passport\PassportServiceProvider::class,
 ],

// config/app.php

'providers' =>[

Laravel\Passport\PassportServiceProvider::class,

Now, it is mandatory to install passport using the command below. This command will generate encryption keys required to generate secret access tokens.

php artisan passport:install

1	php artisan passport:install

Passport Configuration

Open User.php model file and add ‘Laravel\Passport\HasApiTokens’ trait in it.

app/Models/User.php

<?php
  
namespace App\Models;
  
use Illuminate\Contracts\Auth\MustVerifyEmail;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Foundation\Auth\User as Authenticatable;
use Illuminate\Notifications\Notifiable;
use Laravel\Passport\HasApiTokens;
  
class User extends Authenticatable
{
    use HasApiTokens, HasFactory, Notifiable;
  
    /**
     * The attributes that are mass assignable.
     *
     * @var array
     */
    protected $fillable = [
        'name',
        'email',
        'password',
    ];
  
    /**
     * The attributes that should be hidden for arrays.
     *
     * @var array
     */
    protected $hidden = [
        'password',
        'remember_token',
    ];
  
    /**
     * The attributes that should be cast to native types.
     *
     * @var array
     */
    protected $casts = [
        'email_verified_at' => 'datetime',
    ];
}

<?php

namespace App\Models;

use Illuminate\Contracts\Auth\MustVerifyEmail;

use Illuminate\Database\Eloquent\Factories\HasFactory;

use Illuminate\Foundation\Auth\User as Authenticatable;

use Illuminate\Notifications\Notifiable;

use Laravel\Passport\HasApiTokens;

class User extends Authenticatable

{

use HasApiTokens, HasFactory, Notifiable;

/**

* The attributes that are mass assignable.

* @var array

protected $fillable = [

'name',

'email',

'password',

];

/**

* The attributes that should be hidden for arrays.

* @var array

protected $hidden = [

'password',

'remember_token',

];

/**

* The attributes that should be cast to native types.

* @var array

protected $casts = [

'email_verified_at' => 'datetime',

];

}

go to app/Providers/AuthServiceProvider.php file and register the registerPolicies() method inside the boot() function.

<?php
namespace App\Providers;
use Laravel\Passport\Passport;
use Illuminate\Support\Facades\Gate;
use Illuminate\Foundation\Support\Providers\AuthServiceProvider as ServiceProvider;
class AuthServiceProvider extends ServiceProvider
{
    /**
     * The policy mappings for the application.
     *
     * @var array
     */
    protected $policies = [
        'App\Model' => 'App\Policies\ModelPolicy',
    ];
    /**
     * Register any authentication / authorization services.
     *
     * @return void
     */
    public function boot()
    {
        $this->registerPolicies();
    }
}

<?php

namespace App\Providers;

use Laravel\Passport\Passport;

use Illuminate\Support\Facades\Gate;

use Illuminate\Foundation\Support\Providers\AuthServiceProvider as ServiceProvider;

class AuthServiceProvider extends ServiceProvider

{

/**

* The policy mappings for the application.

* @var array

protected $policies = [

'App\Model' => 'App\Policies\ModelPolicy',

];

/**

* Register any authentication / authorization services.

* @return void

public function boot()

{

$this->registerPolicies();

}

config/auth.php

<?php
return [
    .....
    'guards' => [
        'web' => [
            'driver' => 'session',
            'provider' => 'users',
        ],
        'api' => [
            'driver' => 'passport',
            'provider' => 'users',
        ],
    ],
    .....
]

<?php

return [

.....

'guards' => [

'web' => [

'driver' => 'session',

'provider' => 'users',

'api' => [

'driver' => 'passport',

'provider' => 'users',

.....

]

Create Product Table and Model

Now, in this step we will create model and migration file. Please run the following command:

php artisan make:model Product -m

1	php artisan make:model Product -m

Once above command is executed there will be a migration file created inside database/migrations/ directory, just open create_products_table.php migration file and update the function up() method as following:

<?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');
    }
}

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

}

Next, go to app/Models/Product.php file and add the $fillable property in the Product model as following.

<?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'
    ];
}

<?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'

];

}

Run Migration

Now, run the migration to create database table using following artisan command:

php artisan migrate

1	php artisan migrate

Create Passport Auth API Controller

Now, lets create a controller named PassportAuthController using command given below –

php artisan make:controller Api\PassportAuthController

1	php artisan make:controller Api\PassportAuthController

Once the above command executed, it will create a controller file PassportAuthController.php in app/Http/Controllers/Api/ directory. Open the PassportAuthController.php file and put the following code in it.

app/Http/Controllers/Api/PassportAuthController.php

<?php
 
namespace App\Http\Controllers\API;
use App\Http\Controllers\Controller;
use Illuminate\Http\Request;
use App\Models\User;
 
class PassportAuthController extends Controller
{
    /**
     * Registration Req
     */
    public function register(Request $request)
    {
        $this->validate($request, [
            'name' => 'required|min:4',
            'email' => 'required|email',
            'password' => 'required|min:8',
        ]);
  
        $user = User::create([
            'name' => $request->name,
            'email' => $request->email,
            'password' => bcrypt($request->password)
        ]);
  
        $token = $user->createToken('Laravel9PassportAuth')->accessToken;
  
        return response()->json(['token' => $token], 200);
    }
  
    /**
     * Login Req
     */
    public function login(Request $request)
    {
        $data = [
            'email' => $request->email,
            'password' => $request->password
        ];
  
        if (auth()->attempt($data)) {
            $token = auth()->user()->createToken('Laravel9PassportAuth')->accessToken;
            return response()->json(['token' => $token], 200);
        } else {
            return response()->json(['error' => 'Unauthorised'], 401);
        }
    }
 
    public function userInfo() 
    {
 
     $user = auth()->user();
      
     return response()->json(['user' => $user], 200);
 
    }
}

<?php

namespace App\Http\Controllers\API;

use App\Http\Controllers\Controller;

use Illuminate\Http\Request;

use App\Models\User;

class PassportAuthController extends Controller

{

/**

* Registration Req

public function register(Request $request)

{

$this->validate($request, [

'name' => 'required|min:4',

'email' => 'required|email',

'password' => 'required|min:8',

]);

$user = User::create([

'name' => $request->name,

'email' => $request->email,

'password' => bcrypt($request->password)

]);

$token = $user->createToken('Laravel9PassportAuth')->accessToken;

return response()->json(['token' => $token], 200);

}

/**

* Login Req

public function login(Request $request)

{

$data = [

'email' => $request->email,

'password' => $request->password

];

if (auth()->attempt($data)) {

$token = auth()->user()->createToken('Laravel9PassportAuth')->accessToken;

return response()->json(['token' => $token], 200);

} else {

return response()->json(['error' => 'Unauthorised'], 401);

}

public function userInfo()

{

$user = auth()->user();

return response()->json(['user' => $user], 200);

}

Create Product CRUD API Controller

Next we will create product crud api controller named ProductController using command given below –

php artisan make:controller Api\ProductController

1	php artisan make:controller Api\ProductController

Once the above command executed, it will create a controller file ProductController.php in app/Http/Controllers/Api/ directory. Open the ProductController.php file and put the following code in it.

app/Http/Controllers/Api/ProductController.php

<?php
namespace App\Http\Controllers\API;
use App\Http\Controllers\Controller;
use App\Models\Product;
use Illuminate\Http\Request;
use Validator;
class ProductController extends Controller
{
/**
* Display a listing of the resource.
*
* @return \Illuminate\Http\Response
*/
public function index()
{
$products = Product::all();
return response()->json([
"success" => true,
"message" => "Product List",
"data" => $products
]);
}
/**
* Store a newly created resource in storage.
*
* @param  \Illuminate\Http\Request  $request
* @return \Illuminate\Http\Response
*/
public function store(Request $request)
{
$input = $request->all();
$validator = Validator::make($input, [
'name' => 'required',
'detail' => 'required'
]);
if($validator->fails()){
return $this->sendError('Validation Error.', $validator->errors());       
}
$product = Product::create($input);
return response()->json([
"success" => true,
"message" => "Product created successfully.",
"data" => $product
]);
} 
/**
* Display the specified resource.
*
* @param  int  $id
* @return \Illuminate\Http\Response
*/
public function show($id)
{
$product = Product::find($id);
if (is_null($product)) {
return $this->sendError('Product not found.');
}
return response()->json([
"success" => true,
"message" => "Product retrieved successfully.",
"data" => $product
]);
}
/**
* Update the specified resource in storage.
*
* @param  \Illuminate\Http\Request  $request
* @param  int  $id
* @return \Illuminate\Http\Response
*/
public function update(Request $request, Product $product)
{
$input = $request->all();
$validator = Validator::make($input, [
'name' => 'required',
'detail' => 'required'
]);
if($validator->fails()){
return $this->sendError('Validation Error.', $validator->errors());       
}
$product->name = $input['name'];
$product->detail = $input['detail'];
$product->save();
return response()->json([
"success" => true,
"message" => "Product updated successfully.",
"data" => $product
]);
}
/**
* Remove the specified resource from storage.
*
* @param  int  $id
* @return \Illuminate\Http\Response
*/
public function destroy(Product $product)
{
$product->delete();
return response()->json([
"success" => true,
"message" => "Product deleted successfully.",
"data" => $product
]);
}
}

100

101

102

103

104

105

<?php

namespace App\Http\Controllers\API;

use App\Http\Controllers\Controller;

use App\Models\Product;

use Illuminate\Http\Request;

use Validator;

class ProductController extends Controller

{

/**

* Display a listing of the resource.

* @return \Illuminate\Http\Response

public function index()

{

$products = Product::all();

return response()->json([

"success" => true,

"message" => "Product List",

"data" => $products

]);

}

/**

* Store a newly created resource in storage.

* @param \Illuminate\Http\Request $request

* @return \Illuminate\Http\Response

public function store(Request $request)

{

$input = $request->all();

$validator = Validator::make($input, [

'name' => 'required',

'detail' => 'required'

]);

if($validator->fails()){

return $this->sendError('Validation Error.', $validator->errors());

}

$product = Product::create($input);

return response()->json([

"success" => true,

"message" => "Product created successfully.",

"data" => $product

]);

}

/**

* Display the specified resource.

* @param int $id

* @return \Illuminate\Http\Response

public function show($id)

{

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

if (is_null($product)) {

return $this->sendError('Product not found.');

}

return response()->json([

"success" => true,

"message" => "Product retrieved successfully.",

"data" => $product

]);

}

/**

* Update the specified resource in storage.

* @param \Illuminate\Http\Request $request

* @param int $id

* @return \Illuminate\Http\Response

public function update(Request $request, Product $product)

{

$input = $request->all();

$validator = Validator::make($input, [

'name' => 'required',

'detail' => 'required'

]);

if($validator->fails()){

return $this->sendError('Validation Error.', $validator->errors());

}

$product->name = $input['name'];

$product->detail = $input['detail'];

$product->save();

return response()->json([

"success" => true,

"message" => "Product updated successfully.",

"data" => $product

]);

}

/**

* Remove the specified resource from storage.

* @param int $id

* @return \Illuminate\Http\Response

public function destroy(Product $product)

{

$product->delete();

return response()->json([

"success" => true,

"message" => "Product deleted successfully.",

"data" => $product

]);

}

Define API Routes

Now we will define authentication and crud rest API routes. Go to the routes directory and open api.php. Then put the following routes into api.php file:

routes/api.php

use App\Http\Controllers\API\PassportAuthController;
use App\Http\Controllers\API\ProductController;
 
Route::post('register', [PassportAuthController::class, 'register']);
Route::post('login', [PassportAuthController::class, 'login']);
  
Route::middleware('auth:api')->group(function () {
    Route::get('get-user', [PassportAuthController::class, 'userInfo']);
 
 Route::resource('products', [ProductController::class]);
 
});

use App\Http\Controllers\API\PassportAuthController;

use App\Http\Controllers\API\ProductController;

Route::post('register', [PassportAuthController::class, 'register']);

Route::post('login', [PassportAuthController::class, 'login']);

Route::middleware('auth:api')->group(function () {

Route::get('get-user', [PassportAuthController::class, 'userInfo']);

Route::resource('products', [ProductController::class]);

});

Start Development Server

Now we are ready to run our example so lets start the development server using following artisan command –

php artisan serve

1	php artisan serve

Laravel 9 User Registration API:

http://localhost:8000/api/register

1	http://localhost:8000/api/register

http://localhost:8000/api/login

1	http://localhost:8000/api/login

Laravel 9 Get User Info. API:

Product List API

http://localhost:8000/api/products

1	http://localhost:8000/api/products

Product Create API

Method:- POST

http://localhost:8000/api/products

1	http://localhost:8000/api/products

Product Fetch API

Method:- GET

http://localhost:8000/api/products/{id}

1	http://localhost:8000/api/products/{id}

Product Update API

Method:- PUT

http://localhost:8000/api/products/{id}

1	http://localhost:8000/api/products/{id}

Product Delete API

Method:- DELETE

http://localhost:8000/api/products/{id}

1	http://localhost:8000/api/products/{id}

Laravel 9 Simple CRUD REST API Using Passport Authentication

In this Laravel 9 Simple CRUD REST API Using Passport Authentication Tutorial I will show you how to create CRUD REST API with passport authentication In laravel 9. In this tutorial you will learn to create rest api for crud operation with passport authentication In laravel 9. In this article I will share example to create crud rest api with passport authentication in laravel. I will also show you how to install passport auth package in laravel. After installing and configure passport authentication in laravel we will create simple crud operation rest api. In this article we will be creating a simple post management crud operation rest api with passport authentication in laravel.

Laravel 9 REST API with Passport Authentication

In this step by step tutorial I will guide you through create a fully functional restful API with passport authentication in Laravel 9. We will be creating fully functional REST API along with passport Authentication. Please follow the instruction given below:

Install New Laravel Project
Set Up Database
Install Passport Package
Configure Passport Module
Create Post Model & Run Migration
Create a New Controller
Define API Routes
Test Laravel Passport API

Install Laravel 9

First of all we need to create a fresh laravel project, download and install Laravel using the below command

composer create-project laravel/laravel laravel-passport-auth --prefer-dist

1	composer create-project laravel/laravel laravel-passport-auth --prefer-dist

Set Up Database

Now, lets create a MySQL database and connect it with laravel application. After creating database we need to set database credential in application’s .env file.

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

DB_CONNECTION=mysql

DB_HOST=127.0.0.1

DB_PORT=3306

DB_DATABASE=laravel

DB_USERNAME=root

DB_PASSWORD=

Install Passport Package

In this step, we need to install Laravel Passport package via the composer dependency manager. Use the following command to install passport package.

composer require laravel/passport

1	composer require laravel/passport

Now, run following command to migrate database schema.

php artisan migrate

1	php artisan migrate

Now, it is mandatory to install passport using the command below. This command will generate encryption keys required to generate secret access tokens.

php artisan passport:install

1	php artisan passport:install

Configure Passport Module

Open App/User.php model file and add ‘Laravel\Passport\HasApiTokens’ trait in it.

<?php

namespace App\Models;

use Illuminate\Contracts\Auth\MustVerifyEmail;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Foundation\Auth\User as Authenticatable;
use Illuminate\Notifications\Notifiable;

use Laravel\Passport\HasApiTokens;

class User extends Authenticatable
{
    use HasFactory, Notifiable, HasApiTokens;

    /**
     * The attributes that are mass assignable.
     *
     * @var array
     */
    protected $fillable = [
        'name',
        'email',
        'password',
    ];

    /**
     * The attributes that should be hidden for arrays.
     *
     * @var array
     */
    protected $hidden = [
        'password',
        'remember_token',
    ];

    /**
     * The attributes that should be cast to native types.
     *
     * @var array
     */
    protected $casts = [
        'email_verified_at' => 'datetime',
    ];
}

<?php

namespace App\Models;

use Illuminate\Contracts\Auth\MustVerifyEmail;

use Illuminate\Database\Eloquent\Factories\HasFactory;

use Illuminate\Foundation\Auth\User as Authenticatable;

use Illuminate\Notifications\Notifiable;

use Laravel\Passport\HasApiTokens;

class User extends Authenticatable

{

use HasFactory, Notifiable, HasApiTokens;

/**

* The attributes that are mass assignable.

* @var array

protected $fillable = [

'name',

'email',

'password',

];

/**

* The attributes that should be hidden for arrays.

* @var array

protected $hidden = [

'password',

'remember_token',

];

/**

* The attributes that should be cast to native types.

* @var array

protected $casts = [

'email_verified_at' => 'datetime',

];

}

Next, open app/Providers/AuthServiceProvider.php file and register the registerPolicies() method inside the boot() function, It will evoke the required routes.

<?php

namespace App\Providers;
use Illuminate\Foundation\Support\Providers\AuthServiceProvider as ServiceProvider;
use Illuminate\Support\Facades\Gate;

use Laravel\Passport\Passport;


class AuthServiceProvider extends ServiceProvider
{
    /**
     * The policy mappings for the application.
     *
     * @var array
     */
    protected $policies = [
        'App\Models\Model' => 'App\Policies\ModelPolicy',
    ];


    /**
     * Register any authentication / authorization services.
     *
     * @return void
     */
    public function boot()
    {
        $this->registerPolicies();
        Passport::routes();
    }
}

<?php

namespace App\Providers;

use Illuminate\Foundation\Support\Providers\AuthServiceProvider as ServiceProvider;

use Illuminate\Support\Facades\Gate;

use Laravel\Passport\Passport;

class AuthServiceProvider extends ServiceProvider

{

/**

* The policy mappings for the application.

* @var array

protected $policies = [

'App\Models\Model' => 'App\Policies\ModelPolicy',

];

/**

* Register any authentication / authorization services.

* @return void

public function boot()

{

$this->registerPolicies();

Passport::routes();

}

'providers' => [
        ...
        ... 
        ...
        Laravel\Passport\PassportServiceProvider::class,

    ],

'providers' => [

...

Laravel\Passport\PassportServiceProvider::class,

Configure driver for the Passport, get inside the config/auth.php file and make the changes as shown below.

<?php
    return [
    ....
    ....
    
        'guards' => [
            'web' => [
                'driver' => 'session',
                'provider' => 'users',
            ],
    
            'api' => [
                'driver' => 'passport',
                'provider' => 'users',
            ],
        ],
    
    ....
    ....
]

<?php

return [

....

'guards' => [

'web' => [

'driver' => 'session',

'provider' => 'users',

'api' => [

'driver' => 'passport',

'provider' => 'users',

....

]

Create Posts Model & Run Migration

Now, in this step we will create model and migration file. Please run the following command:

php artisan make:model Post -m

1	php artisan make:model Post -m

Once above command is executed there will be a migration file created inside database/migrations/ directory, just open timestamp_create_posts_table.php migration file and update the function up() method as following:

<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class CreatePostsTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('posts', function (Blueprint $table) {
            $table->increments('id');
            $table->unsignedBigInteger('user_id');
            $table->text('title');
            $table->longText('description');
            $table->timestamps();

            $table->foreign('user_id')->references('id')->on('users');  
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('posts');
    }
}

<?php

use Illuminate\Database\Migrations\Migration;

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Support\Facades\Schema;

class CreatePostsTable extends Migration

{

/**

* Run the migrations.

* @return void

public function up()

{

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

$table->increments('id');

$table->unsignedBigInteger('user_id');

$table->text('title');

$table->longText('description');

$table->timestamps();

$table->foreign('user_id')->references('id')->on('users');

});

}

/**

* Reverse the migrations.

* @return void

public function down()

{

Schema::dropIfExists('posts');

}

Next, go to app/Models/Post.php file and add the $fillable property in the Post model as following.

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;

class Post extends Model
{
    use HasFactory;
    protected $fillable = [
        'title', 'description'
    ];    
}

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;

use Illuminate\Database\Eloquent\Model;

class Post extends Model

{

use HasFactory;

protected $fillable = [

'title', 'description'

];

}

Now, run the migration to create database table using following artisan command:

Laravel 9 User Registration Login Api with Passport Authentication

In this Laravel 9 User Registration Login Api with Passport Authentication Tutorial I will show you how to create user authentication(registration and login) REST API with passport authentication In laravel. In this tutorial you will learn to create authentication rest api with passport authentication In laravel 9 application. In this article I will share example to create rest api for user authentication using passport authentication in laravel 9. I will also show you how to install passport authentication package in laravel 9. After installing and configure passport authentication in laravel we will create simple user authentication rest api.

Laravel 9 User Authentication API

By user authentication means to validation and authentication valid application users. User authentication allows to register new user into application and to login existing application users. In this tutorial we will be creating user authentication api means we will be creating rest api for user registration, login and to get user info. We will be using passport authentication for creating rest api for user authentication in this example laravel 9 application.

In this step by step tutorial I will guide you through create a fully functional restful API with passport authentication in Laravel 9. Please follow the instruction given below:

Install Laravel 9
Set Up Database
Install Passport Package
Configure Passport Module
Create Post Model & Run Migration
Create a New Controller
Define API Routes
Test Laravel Passport API

Install Laravel 9

First of all we need to create a fresh laravel project, download and install Laravel using the below command

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

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

Configure Database

Now, lets create a MySQL database and connect it with laravel application. After creating database we need to set database credential in application’s .env file.

DB_CONNECTION=mysql 
 DB_HOST=127.0.0.1 
 DB_PORT=3306 
 DB_DATABASE=here your database name here
 DB_USERNAME=here database username here
 DB_PASSWORD=here database password here

DB_CONNECTION=mysql

DB_HOST=127.0.0.1

DB_PORT=3306

DB_DATABASE=here your database name here

DB_USERNAME=here database username here

DB_PASSWORD=here database password here

Install Passport Package

In this step, we need to install Laravel Passport package via the composer dependency manager. Use the following command to install passport package.

composer require laravel/passport

1	composer require laravel/passport

After successfully install laravel passport, register providers. Open config/app.php . Put the bellow code in it:

config/app.php

  // config/app.php

'providers' =>[
 Laravel\Passport\PassportServiceProvider::class,
 ],

// config/app.php

'providers' =>[

Laravel\Passport\PassportServiceProvider::class,

Now, it is mandatory to install passport using the command below. This command will generate encryption keys required to generate secret access tokens.

php artisan passport:install

1	php artisan passport:install

Passport Configuration

Open User.php model file and add ‘Laravel\Passport\HasApiTokens’ trait in it.

app/Models/User.php

<?php
  
namespace App\Models;
  
use Illuminate\Contracts\Auth\MustVerifyEmail;
use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Foundation\Auth\User as Authenticatable;
use Illuminate\Notifications\Notifiable;
use Laravel\Passport\HasApiTokens;
  
class User extends Authenticatable
{
    use HasApiTokens, HasFactory, Notifiable;
  
    /**
     * The attributes that are mass assignable.
     *
     * @var array
     */
    protected $fillable = [
        'name',
        'email',
        'password',
    ];
  
    /**
     * The attributes that should be hidden for arrays.
     *
     * @var array
     */
    protected $hidden = [
        'password',
        'remember_token',
    ];
  
    /**
     * The attributes that should be cast to native types.
     *
     * @var array
     */
    protected $casts = [
        'email_verified_at' => 'datetime',
    ];
}

<?php

namespace App\Models;

use Illuminate\Contracts\Auth\MustVerifyEmail;

use Illuminate\Database\Eloquent\Factories\HasFactory;

use Illuminate\Foundation\Auth\User as Authenticatable;

use Illuminate\Notifications\Notifiable;

use Laravel\Passport\HasApiTokens;

class User extends Authenticatable

{

use HasApiTokens, HasFactory, Notifiable;

/**

* The attributes that are mass assignable.

* @var array

protected $fillable = [

'name',

'email',

'password',

];

/**

* The attributes that should be hidden for arrays.

* @var array

protected $hidden = [

'password',

'remember_token',

];

/**

* The attributes that should be cast to native types.

* @var array

protected $casts = [

'email_verified_at' => 'datetime',

];

}

go to app/Providers/AuthServiceProvider.php file and register the registerPolicies() method inside the boot() function.

<?php
namespace App\Providers;
use Laravel\Passport\Passport;
use Illuminate\Support\Facades\Gate;
use Illuminate\Foundation\Support\Providers\AuthServiceProvider as ServiceProvider;
class AuthServiceProvider extends ServiceProvider
{
    /**
     * The policy mappings for the application.
     *
     * @var array
     */
    protected $policies = [
        'App\Model' => 'App\Policies\ModelPolicy',
    ];
    /**
     * Register any authentication / authorization services.
     *
     * @return void
     */
    public function boot()
    {
        $this->registerPolicies();
    }
}

<?php

namespace App\Providers;

use Laravel\Passport\Passport;

use Illuminate\Support\Facades\Gate;

use Illuminate\Foundation\Support\Providers\AuthServiceProvider as ServiceProvider;

class AuthServiceProvider extends ServiceProvider

{

/**

* The policy mappings for the application.

* @var array

protected $policies = [

'App\Model' => 'App\Policies\ModelPolicy',

];

/**

* Register any authentication / authorization services.

* @return void

public function boot()

{

$this->registerPolicies();

}

config/auth.php

<?php
return [
    .....
    'guards' => [
        'web' => [
            'driver' => 'session',
            'provider' => 'users',
        ],
        'api' => [
            'driver' => 'passport',
            'provider' => 'users',
        ],
    ],
    .....
]

<?php

return [

.....

'guards' => [

'web' => [

'driver' => 'session',

'provider' => 'users',

'api' => [

'driver' => 'passport',

'provider' => 'users',

.....

]

Run Migration

Now, run the migration to create database table using following artisan command:

php artisan migrate

1	php artisan migrate

Create Passport Auth Controller

Now, lets create a controller named PassportAuthController using command given below –

php artisan make:controller Api\PassportAuthController

1	php artisan make:controller Api\PassportAuthController

app/Http/Controllers/Api/PassportAuthController.php

<?php
 
namespace App\Http\Controllers\API;
 
use Illuminate\Http\Request;
 
use App\Models\User;
 
class AuthController extends Controller
{
    /**
     * Registration Req
     */
    public function register(Request $request)
    {
        $this->validate($request, [
            'name' => 'required|min:4',
            'email' => 'required|email',
            'password' => 'required|min:8',
        ]);
  
        $user = User::create([
            'name' => $request->name,
            'email' => $request->email,
            'password' => bcrypt($request->password)
        ]);
  
        $token = $user->createToken('Laravel-9-Passport-Auth')->accessToken;
  
        return response()->json(['token' => $token], 200);
    }
  
    /**
     * Login Req
     */
    public function login(Request $request)
    {
        $data = [
            'email' => $request->email,
            'password' => $request->password
        ];
  
        if (auth()->attempt($data)) {
            $token = auth()->user()->createToken('Laravel-9-Passport-Auth')->accessToken;
            return response()->json(['token' => $token], 200);
        } else {
            return response()->json(['error' => 'Unauthorised'], 401);
        }
    }
 
    public function userInfo() 
    {
 
     $user = auth()->user();
      
     return response()->json(['user' => $user], 200);
 
    }
}

<?php

namespace App\Http\Controllers\API;

use Illuminate\Http\Request;

use App\Models\User;

class AuthController extends Controller

{

/**

* Registration Req

public function register(Request $request)

{

$this->validate($request, [

'name' => 'required|min:4',

'email' => 'required|email',

'password' => 'required|min:8',

]);

$user = User::create([

'name' => $request->name,

'email' => $request->email,

'password' => bcrypt($request->password)

]);

$token = $user->createToken('Laravel-9-Passport-Auth')->accessToken;

return response()->json(['token' => $token], 200);

}

/**

* Login Req

public function login(Request $request)

{

$data = [

'email' => $request->email,

'password' => $request->password

];

if (auth()->attempt($data)) {

$token = auth()->user()->createToken('Laravel-9-Passport-Auth')->accessToken;

return response()->json(['token' => $token], 200);

} else {

return response()->json(['error' => 'Unauthorised'], 401);

}

public function userInfo()

{

$user = auth()->user();

return response()->json(['user' => $user], 200);

}

Define API Routes

Now we will define authentication rest API routes. Go to the routes directory and open api.php. Then put the following routes into api.php file:

routes/api.php

use App\Http\Controllers\API\PassportAuthController;
 
Route::post('register', [PassportAuthController::class, 'register']);
Route::post('login', [PassportAuthController::class, 'login']);
  
Route::middleware('auth:api')->group(function () {
    Route::get('get-user', [PassportAuthController::class, 'userInfo']);
});

use App\Http\Controllers\API\PassportAuthController;

Route::post('register', [PassportAuthController::class, 'register']);

Route::post('login', [PassportAuthController::class, 'login']);

Route::middleware('auth:api')->group(function () {

Route::get('get-user', [PassportAuthController::class, 'userInfo']);

});

Start Development Server

Now we are ready to run our example so lets start the development server using following artisan command –

php artisan serve

1	php artisan serve

Laravel 9 User Registration API:

http://localhost:8000/api/register

1	http://localhost:8000/api/register

http://localhost:8000/api/login

1	http://localhost:8000/api/login

Laravel 9 Get User Info. API:

Laravel 9 Ajax CRUD with Image Upload Tutorial

In this Laravel 9 Ajax Crud with Image Upload Example tutorial, I’ll show you how to create basic CRUD application with Image upload using DataTables in laravel 9. In this tutorial you learn to create simple CRUD application with image upload using DataTables. In this step by step tutorial we will be creating simple crud application with image upload using DataTables in laravel.

Laravel 9 Ajax CRUD with Image Upload Tutorial

In this step by step guide, we will be creating a simple laravel 9 application to demonstrate you how to install yajra datatable package and implement ajax based CRUD operations with datatable js.

Step 1 – Install laravel 9
Step 2 – Connecting App to Database
Step 3 – Create Migration And Model
Step 4 – Install Yajra DataTables In App
Step 5 – Add Routes
Step 6 – Create Controller
Step 7 – Create Blade View
Step 8 – Run Development Server

Step 1 – Install Fresh Laravel Setup

First of all we need to create a fresh laravel project, download and install Laravel 9 using the below command

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

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

Step 2 – Connecting App to Database

Now, lets create a MySQL database and connect it with laravel application. After creating database we need to set database credential in application’s .env file.

DB_CONNECTION=mysql 
 DB_HOST=127.0.0.1 
 DB_PORT=3306 
 DB_DATABASE=here your database name here
 DB_USERNAME=here database username here
 DB_PASSWORD=here database password here

DB_CONNECTION=mysql

DB_HOST=127.0.0.1

DB_PORT=3306

DB_DATABASE=here your database name here

DB_USERNAME=here database username here

DB_PASSWORD=here database password here

Step 3 – Create Migration And Model

Now, in this step we will create model and migration file. Please run the following command:

php artisan nake:modal Product -m

1	php artisan nake:modal Product -m

Now, go to database/migrations/ and open create_products_table.php file. Then put the following code into this file:

<?php
 
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;
 
class CreateProductsTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('products', function (Blueprint $table) {
            $table->id();
            $table->string('title');
            $table->string('product_code')->nullable();
            $table->string('image')->nullable();
            $table->text('description');
            $table->timestamps();
        });
    }
 
    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::dropIfExists('products');
    }
}

<?php

use Illuminate\Database\Migrations\Migration;

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Support\Facades\Schema;

class CreateProductsTable extends Migration

{

/**

* Run the migrations.

* @return void

public function up()

{

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

$table->id();

$table->string('title');

$table->string('product_code')->nullable();

$table->string('image')->nullable();

$table->text('description');

$table->timestamps();

});

}

/**

* Reverse the migrations.

* @return void

public function down()

{

Schema::dropIfExists('products');

}

Now, run following command to migrate database schema.

php artisan migrate

1	php artisan migrate

Now, go to App directory and open Product.php file and then put the following code to into Product.php file as follow:

<?php


namespace App\Models;


use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;


class Product extends Model
{
    use HasFactory;


    protected $fillable = [
                           'title',
                           'product_code',
                           'description',
                           'image'
                       ];
                        
}

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;

use Illuminate\Database\Eloquent\Model;

class Product extends Model

{

use HasFactory;

protected $fillable = [

'title',

'product_code',

'description',

'image'

];

}

Step 4 – Install Yajra Datatables Package in Laravel

In this step, we will install Yajra Datatables Package via the composer dependency manager. Use the following command to install Yajra Datatables.

composer require yajra/laravel-datatables-oracle

1	composer require yajra/laravel-datatables-oracle

After installing Yajra Datatables Packages in your laravel application. Open config/app.php file and add service provider and alias

 config/app.php
 
 
 'providers' =&gt; [
 
 
 Yajra\Datatables\DatatablesServiceProvider::class,
 ],
 
 
 'aliases' =&gt; [
 
 
 'Datatables' =&gt; Yajra\Datatables\Facades\Datatables::class,
 ]

config/app.php

'providers' => [

Yajra\Datatables\DatatablesServiceProvider::class,

'aliases' => [

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

]

After set providers and aliases then publish vendor run by following command.

php artisan vendor:publish

1	php artisan vendor:publish

Step 5 – Add Routes

After this, we need to define routes in “routes/web.php” file. Lets open “routes/web.php” file and add the following routes in it.

routes/web.php

use App\Http\Controllers\ProductController;

Route::get('product-list', [ProductController::class, 'index']);
Route::get('product-list/{id}/edit', [ProductController::class, 'edit']);
Route::post('product-list/store', [ProductController::class, 'store']);
Route::get('product-list/delete/{id}', [ProductController::class, 'destroy']);

use App\Http\Controllers\ProductController;

Route::get('product-list', [ProductController::class, 'index']);

Route::get('product-list/{id}/edit', [ProductController::class, 'edit']);

Route::post('product-list/store', [ProductController::class, 'store']);

Route::get('product-list/delete/{id}', [ProductController::class, 'destroy']);

Step 6 – Create Controller

Now, lets create a controller named ProductController using command given below –

php artisan make:controller ProductController

1	php artisan make:controller ProductController

Next navigate to app/Http/Controllers and open ProductController.php file. Then update the following methods for add products, edit product and delete the product into this controller file:

The Product Controller, will include following methods:
Index() :- The index method will be used to display list of all products.
Store() :- The store method will be used to save and update the product into a database.
Edit() :- The edit method will be used to edit product detail.
Destroy() :- The delete method will be used to delete product from list and database as well.

Now, update all methods into your ProductController.php file as follow:

<?php
   
namespace App\Http\Controllers;
   
use App\Product;
use Illuminate\Http\Request;
use Redirect,Response,DB;
use File;
use PDF;
   
class ProductController extends Controller
{
    public function index()
    {
        if(request()->ajax()) {
            return datatables()->of(Product::select('*'))
            ->addColumn('action', 'product-button')
            ->addColumn('image', 'image')
            ->rawColumns(['action','image'])
            ->addIndexColumn()
            ->make(true);
        }
        return view('list');
    } 
 
    public function store(Request $request)
    {  
        request()->validate([
            'image' => 'image|mimes:jpeg,png,jpg,gif,svg|max:2048',
       ]);
 
        $productId = $request->product_id;
 
        $details = ['title' => $request->title, 'product_code' => $request->product_code, 'description' => $request->description];
 
        if ($files = $request->file('image')) {
            
           //delete old file
           \File::delete('public/product/'.$request->hidden_image);
         
           //insert new file
           $destinationPath = 'public/product/'; // upload path
           $profileImage = date('YmdHis') . "." . $files->getClientOriginalExtension();
           $files->move($destinationPath, $profileImage);
           $details['image'] = "$profileImage";
        }
         
        $product   =   Product::updateOrCreate(['id' => $productId], $details);  
               
        return Response::json($product);
    } 
 
    public function edit($id)
    {   
        $where = array('id' => $id);
        $product  = Product::where($where)->first();
      
        return Response::json($product);
    }
    public function destroy($id) 
    {
        $data = Product::where('id',$id)->first(['image']);
        \File::delete('public/product/'.$data->image);
        $product = Product::where('id',$id)->delete();
      
        return Response::json($product);
    }
}

<?php

namespace App\Http\Controllers;

use App\Product;

use Illuminate\Http\Request;

use Redirect,Response,DB;

use File;

use PDF;

class ProductController extends Controller

{

public function index()

{

if(request()->ajax()) {

return datatables()->of(Product::select('*'))

->addColumn('action', 'product-button')

->addColumn('image', 'image')

->rawColumns(['action','image'])

->addIndexColumn()

->make(true);

}

return view('list');

}

public function store(Request $request)

{

request()->validate([

'image' => 'image|mimes:jpeg,png,jpg,gif,svg|max:2048',

]);

$productId = $request->product_id;

$details = ['title' => $request->title, 'product_code' => $request->product_code, 'description' => $request->description];

if ($files = $request->file('image')) {

//delete old file

\File::delete('public/product/'.$request->hidden_image);

//insert new file

$destinationPath = 'public/product/'; // upload path

$profileImage = date('YmdHis') . "." . $files->getClientOriginalExtension();

$files->move($destinationPath, $profileImage);

$details['image'] = "$profileImage";

}

$product = Product::updateOrCreate(['id' => $productId], $details);

return Response::json($product);

}

public function edit($id)

{

$where = array('id' => $id);

$product = Product::where($where)->first();

return Response::json($product);

}

public function destroy($id)

{

$data = Product::where('id',$id)->first(['image']);

\File::delete('public/product/'.$data->image);

$product = Product::where('id',$id)->delete();

return Response::json($product);

}

Step 7 – Create Blade View

Create the directory and create blade view file for CRUD operations as following: Now, Navigate to resources/views directory and create action.blade.php file.

<a href="javascript:void(0)" data-toggle="tooltip"  data-id="{{ $id }}" data-original-title="Edit" class="edit btn btn-success edit-product">
    Edit
</a>
<a href="javascript:void(0);" id="delete-product" data-toggle="tooltip" data-original-title="Delete" data-id="{{ $id }}" class="delete btn btn-danger">
    Delete
</a>

Edit

</a>

Delete

</a>

Next, create a list.blade.php file inside resources/views/ folder and update the below code in your product list file.

<!DOCTYPE html>
<html lang="en">
<head>
<!-- CSRF Token -->
<meta name="csrf-token" content="{{ csrf_token() }}">
<title>Laravel Ajax Crud Example with Image Upload Tutorial</title>
<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">
<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>
</head>
<body>
<div class="container">
<a href="javascript:void(0)" class="btn btn-info ml-3" id="create-new-product">Add New</a>
<br><br></br><br>
<table class="table table-bordered table-striped" id="laravel_datatable">
<thead>
<tr>
<th>ID</th>
<th>S. No</th>
<th>Image</th>
<th>Title</th>
<th>Product Code</th>
<th>Description</th>
<th>Created at</th>
<th>Action</th>
</tr>
</thead>
</table>
</div>
<div class="modal fade" id="ajax-product-modal" aria-hidden="true">
<div class="modal-dialog">
<div class="modal-content">
<div class="modal-header">
<h4 class="modal-title" id="productCrudModal"></h4>
</div>
<div class="modal-body">
<form id="productForm" name="productForm" class="form-horizontal" enctype="multipart/form-data">
<input type="hidden" name="product_id" id="product_id">
<div class="form-group">
<label for="name" class="col-sm-2 control-label">Title</label>
<div class="col-sm-12">
<input type="text" class="form-control" id="title" name="title" placeholder="Enter Tilte" value="" maxlength="50" required="">
</div>
</div>
<div class="form-group">
<label for="name" class="col-sm-2 control-label">Product Code</label>
<div class="col-sm-12">
<input type="text" class="form-control" id="product_code" name="product_code" placeholder="Enter Tilte" value="" maxlength="50" required="">
</div>
</div>
<div class="form-group">
<label class="col-sm-2 control-label">Description</label>
<div class="col-sm-12">
<input type="text" class="form-control" id="description" name="description" placeholder="Enter Description" value="" required="">
</div>
</div>
<div class="form-group">
<label class="col-sm-2 control-label">Image</label>
<div class="col-sm-12">
<input id="image" type="file" name="image" accept="image/*" onchange="readURL(this);">
<input type="hidden" name="hidden_image" id="hidden_image">
</div>
</div>
<img id="modal-preview" src="https://via.placeholder.com/150" alt="Preview" class="form-group hidden" width="100" height="100">
<div class="col-sm-offset-2 col-sm-10">
<button type="submit" class="btn btn-primary" id="btn-save" value="create">Save changes
</button>
</div>
</form>
</div>
<div class="modal-footer">
</div>
</div>
</div>
</div> 
</body>
</html>

<!DOCTYPE html>

<head>

<title>Laravel Ajax Crud Example with Image Upload Tutorial</title>

</head>

<body>

<thead>

<tr>

<th>Image</th>

<th>Title</th>

<th>Product Code</th>

<th>Description</th>

<th>Created at</th>

<th>Action</th>

</tr>

</thead>

</table>

</div>

</div>

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

</div>

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

</div>

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

</div>

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

</div>

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

</button>

</div>

</form>

</div>

</div>

</body>

</html>

Next, you will create a script code for performing create, store, update and delete products from the database table products using jQuery ajax request in laravel. So update this code in your list.blade.php file:

<script>
var SITEURL = '{{URL::to('')}}';
$(document).ready( function () {
$.ajaxSetup({
headers: {
'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
}
});
$('#laravel_datatable').DataTable({
processing: true,
serverSide: true,
ajax: {
url: SITEURL + "product-list",
type: 'GET',
},
columns: [
{data: 'id', name: 'id', 'visible': false},
{data: 'DT_RowIndex', name: 'DT_RowIndex', orderable: false,searchable: false},
{data: 'image', name: 'image', orderable: false},
{ data: 'title', name: 'title' },
{ data: 'product_code', name: 'product_code' },
{ data: 'description', name: 'description' },
{ data: 'created_at', name: 'created_at' },
{data: 'action', name: 'action', orderable: false},
],
order: [[0, 'desc']]
});
/*  When user click add user button */
$('#create-new-product').click(function () {
$('#btn-save').val("create-product");
$('#product_id').val('');
$('#productForm').trigger("reset");
$('#productCrudModal').html("Add New Product");
$('#ajax-product-modal').modal('show');
$('#modal-preview').attr('src', 'https://via.placeholder.com/150');
});
/* When click edit user */
$('body').on('click', '.edit-product', function () {
var product_id = $(this).data('id');
$.get('product-list/' + product_id +'/edit', function (data) {
$('#title-error').hide();
$('#product_code-error').hide();
$('#description-error').hide();
$('#productCrudModal').html("Edit Product");
$('#btn-save').val("edit-product");
$('#ajax-product-modal').modal('show');
$('#product_id').val(data.id);
$('#title').val(data.title);
$('#product_code').val(data.product_code);
$('#description').val(data.description);
$('#modal-preview').attr('alt', 'No image available');
if(data.image){
$('#modal-preview').attr('src', SITEURL +'public/product/'+data.image);
$('#hidden_image').attr('src', SITEURL +'public/product/'+data.image);
}
})
});
$('body').on('click', '#delete-product', function () {
var product_id = $(this).data("id");
if(confirm("Are You sure want to delete !")){
$.ajax({
type: "get",
url: SITEURL + "product-list/delete/"+product_id,
success: function (data) {
var oTable = $('#laravel_datatable').dataTable(); 
oTable.fnDraw(false);
},
error: function (data) {
console.log('Error:', data);
}
});
}
});  
});
$('body').on('submit', '#productForm', function (e) {
e.preventDefault();
var actionType = $('#btn-save').val();
$('#btn-save').html('Sending..');
var formData = new FormData(this);
$.ajax({
type:'POST',
url: SITEURL + "product-list/store",
data: formData,
cache:false,
contentType: false,
processData: false,
success: (data) => {
$('#productForm').trigger("reset");
$('#ajax-product-modal').modal('hide');
$('#btn-save').html('Save Changes');
var oTable = $('#laravel_datatable').dataTable();
oTable.fnDraw(false);
},
error: function(data){
console.log('Error:', data);
$('#btn-save').html('Save Changes');
}
});
});
function readURL(input, id) {
id = id || '#modal-preview';
if (input.files && input.files[0]) {
var reader = new FileReader();
reader.onload = function (e) {
$(id).attr('src', e.target.result);
};
reader.readAsDataURL(input.files[0]);
$('#modal-preview').removeClass('hidden');
$('#start').hide();
}
}
</script>

100

101

102

103

104

105

106

107

108

109

110

111

112

var SITEURL = '{{URL::to('')}}';

$(document).ready( function () {

$.ajaxSetup({

headers: {

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

}

});

$('#laravel_datatable').DataTable({

processing: true,

serverSide: true,

ajax: {

url: SITEURL + "product-list",

type: 'GET',

columns: [

{data: 'id', name: 'id', 'visible': false},

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

{data: 'image', name: 'image', orderable: false},

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

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

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

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

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

order: [[0, 'desc']]

});

/* When user click add user button */

$('#create-new-product').click(function () {

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

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

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

$('#productCrudModal').html("Add New Product");

$('#ajax-product-modal').modal('show');

$('#modal-preview').attr('src', 'https://via.placeholder.com/150');

});

/* When click edit user */

$('body').on('click', '.edit-product', function () {

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

$.get('product-list/' + product_id +'/edit', function (data) {

$('#title-error').hide();

$('#product_code-error').hide();

$('#description-error').hide();

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

$('#btn-save').val("edit-product");

$('#ajax-product-modal').modal('show');

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

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

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

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

$('#modal-preview').attr('alt', 'No image available');

if(data.image){

$('#modal-preview').attr('src', SITEURL +'public/product/'+data.image);

$('#hidden_image').attr('src', SITEURL +'public/product/'+data.image);

}

})

});

$('body').on('click', '#delete-product', function () {

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

if(confirm("Are You sure want to delete !")){

$.ajax({

type: "get",

url: SITEURL + "product-list/delete/"+product_id,

success: function (data) {

var oTable = $('#laravel_datatable').dataTable();

oTable.fnDraw(false);

error: function (data) {

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

}

});

}

});

$('body').on('submit', '#productForm', function (e) {

e.preventDefault();

var actionType = $('#btn-save').val();

$('#btn-save').html('Sending..');

var formData = new FormData(this);

$.ajax({

type:'POST',

url: SITEURL + "product-list/store",

data: formData,

cache:false,

contentType: false,

processData: false,

success: (data) => {

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

$('#ajax-product-modal').modal('hide');

$('#btn-save').html('Save Changes');

var oTable = $('#laravel_datatable').dataTable();

oTable.fnDraw(false);

error: function(data){

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

$('#btn-save').html('Save Changes');

}

});

function readURL(input, id) {

id = id || '#modal-preview';

if (input.files && input.files[0]) {

var reader = new FileReader();

reader.onload = function (e) {

$(id).attr('src', e.target.result);

};

reader.readAsDataURL(input.files[0]);

$('#modal-preview').removeClass('hidden');

$('#start').hide();

}

</script>

Next, navigate to resources/views and create image.blade.php file. Then update the following code into your image.blade.php file:

@if($image)
<img id="preview" src="{{ ('public/product/'.$image) }}" alt="Preview" class="form-group hidden" width="100" height="100">
@else
<img id="preview" src="https://via.placeholder.com/150" alt="Preview" class="form-group hidden" width="100" height="100">
@endif

@if($image)

@else

@endif

Step 8 – Run Development Server

Now we are ready to run our example so lets start the development server using following artisan command –

php artisan serve

1	php artisan serve

Now, open the following URL in browser to see the output –

http://localhost:8000/product-list

1	http://localhost:8000/product-list

Laravel 9 Ajax CRUD Example Tutorial

In this Laravel 9 Ajax CRUD Example Tutorial I’ll show you how to create a simple ajax crud application using Datatables in laravel 9. In this example we will learn how to create a simple ajax crud operation application using Datatables in laravel 9. In this article I will share example to implement ajax based CRUD (Create, Read, Update and Delete) operations using datatable js. In this tutorial, we will be using yajra datatable package for listing of records with pagination, sorting and filter (search) feature.

Laravel 9 Ajax CRUD Example Tutorial

In this step by step guide, we will be creating a simple laravel 9 ajax crud application to demonstrate you how to install yajra datatable package and implement ajax based CRUD operations with datatable js. Please follow the instruction given below:

Install laravel 9
Configure Database
Create Migration And Model
Install Yajra DataTables
Make Route
Create Controller
Create Blade View
Start Development Server

Install laravel 9

First of all we need to create a fresh laravel project, download and install Laravel 9 using the below command

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

1	composer create-project --prefer-dist laravel/laravel larablog

Configure Database

Now, lets create a MySQL database and connect it with laravel application. After creating database we need to set database credential in application’s .env file.

.env

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

DB_CONNECTION=mysql

DB_HOST=127.0.0.1

DB_PORT=3306

DB_DATABASE=larablog

DB_USERNAME=root

DB_PASSWORD=

Create Migration And Model

Now, in this step we will create model and migration file. Please run the following command:

php artisan make:model Employee -m

1	php artisan make:model Employee -m

Now go to database/migrations/ and open create_employees_table.php file. Then update the up() method as following:

public function up()
    {
        Schema::create('employees', function (Blueprint $table) {
            $table->id();
            $table->string('name');
            $table->string('email');
            $table->string('address');
            $table->timestamps();
        });
    }

public function up()

{

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

$table->id();

$table->string('name');

$table->string('email');

$table->string('address');

$table->timestamps();

});

}

Now, run following command to migrate database schema.

php artisan migrate

1	php artisan migrate

Next, go to app/Models/Employee.php file and add the $fillable property in the Employee model as following.

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;
use Illuminate\Database\Eloquent\Model;

class Employee extends Model
{
    use HasFactory;

    protected $fillable = [ 'name', 'email', 'address' ];
}

<?php

namespace App\Models;

use Illuminate\Database\Eloquent\Factories\HasFactory;

use Illuminate\Database\Eloquent\Model;

class Employee extends Model

{

use HasFactory;

protected $fillable = [ 'name', 'email', 'address' ];

}

Install Yajra DataTables

In this step, we will install Yajra Datatables Package via the composer dependency manager. Use the following command to install Yajra Datatables Package.

composer require yajra/laravel-datatables-oracle

1	composer require yajra/laravel-datatables-oracle

After Installing Yajra Datatables package, we need to add service provider and alias in config/app.php file as following.

config/app.php

'providers' => [
      // Other service providers…
  Yajra\DataTables\DataTablesServiceProvider::class,
 ],

'aliases' => [
 // Other aliases…
 'Datatables' => Yajra\Datatables\Facades\Datatables::class,
 ],

'providers' => [

// Other service providers…

Yajra\DataTables\DataTablesServiceProvider::class,

'aliases' => [

// Other aliases…

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

Now, we need to publish laravel datatables vendor package by using the following command:

php artisan vendor:publish

1	php artisan vendor:publish

Make Route

After this, we need to define routes in “routes/web.php” file. Lets open “routes/web.php” file and add the following routes in it.

routes/web.php

use App\Http\Controllers\EmployeeAjaxCRUDController;
 
Route::get('employee-dt-ajax-crud', [EmployeeAjaxCRUDController::class, 'index']);
Route::post('store-employee', [EmployeeAjaxCRUDController::class, 'store']);
Route::post('edit-employee', [EmployeeAjaxCRUDController::class, 'edit']);
Route::post('delete-employee', [EmployeeAjaxCRUDController::class, 'destroy']);

use App\Http\Controllers\EmployeeAjaxCRUDController;

Route::get('employee-dt-ajax-crud', [EmployeeAjaxCRUDController::class, 'index']);

Route::post('store-employee', [EmployeeAjaxCRUDController::class, 'store']);

Route::post('edit-employee', [EmployeeAjaxCRUDController::class, 'edit']);

Route::post('delete-employee', [EmployeeAjaxCRUDController::class, 'destroy']);

Create Controller

Next, we have to create a controller for laravel ajax crud operations. Lets Create a controller named EmployeeAjaxCRUDController using command given below –

php artisan make:controller EmployeeAjaxCRUDController

1	php artisan make:controller EmployeeAjaxCRUDController

Open the EmployeeAjaxCRUDController.php file and put the following code in it.

app/Http/Controllers/EmployeeAjaxCRUDController.php

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use App\Models\Employee;
 
use Datatables;

class EmployeeAjaxCRUDController extends Controller
{
   
    public function index()
    {
        if(request()->ajax()) {
            return datatables()->of(Employee::select('*'))
            ->addColumn('action', 'employee_dt_ajax_crud/employee-action')
            ->rawColumns(['action'])
            ->addIndexColumn()
            ->make(true);
        }
        return view('employee_dt_ajax_crud/employees');
    }
      
      
    public function store(Request $request)
    {  
 
        $EmployeeId = $request->id;
 
        $employee   =   Employee::updateOrCreate(
                    [
                     'id' => $EmployeeId
                    ],
                    [
                    'name' => $request->name, 
                    'email' => $request->email,
                    'address' => $request->address
                    ]);    
                         
        return Response()->json($employee);
 
    }
      
      
    public function edit(Request $request)
    {   
        $where = array('id' => $request->id);
        $employee  = Employee::where($where)->first();
      
        return Response()->json($employee);
    }
      
      
    public function destroy(Request $request)
    {
        $employee = Employee::where('id',$request->id)->delete();
      
        return Response()->json($employee);
    }
}

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use App\Models\Employee;

use Datatables;

class EmployeeAjaxCRUDController extends Controller

{

public function index()

{

if(request()->ajax()) {

return datatables()->of(Employee::select('*'))

->addColumn('action', 'employee_dt_ajax_crud/employee-action')

->rawColumns(['action'])

->addIndexColumn()

->make(true);

}

return view('employee_dt_ajax_crud/employees');

}

public function store(Request $request)

{

$EmployeeId = $request->id;

$employee = Employee::updateOrCreate(

[

'id' => $EmployeeId

[

'name' => $request->name,

'email' => $request->email,

'address' => $request->address

]);

return Response()->json($employee);

}

public function edit(Request $request)

{

$where = array('id' => $request->id);

$employee = Employee::where($where)->first();

return Response()->json($employee);

}

public function destroy(Request $request)

{

$employee = Employee::where('id',$request->id)->delete();

return Response()->json($employee);

}

Create Blade View

In this step we will create a directory and create blade view file for CRUD operations in it. Lets create a folder name employee_dt_ajax_crud inside resources/views directory. Next, create following blade view files in it and put the given code in view file.

employees.blade.php

<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>Laravel 9 AJAX CRUD using DataTable</title>
<meta name="csrf-token" content="{{ csrf_token() }}">
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/css/bootstrap.min.css" >
<script src="https://code.jquery.com/jquery-3.5.1.min.js"></script>
<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.5.2/js/bootstrap.min.js"></script>
<link  href="https://cdn.datatables.net/1.10.21/css/jquery.dataTables.min.css" rel="stylesheet">
<script src="https://cdn.datatables.net/1.10.21/js/jquery.dataTables.min.js"></script>
</head>
<body>
<div class="container mt-2">
<div class="row">
<div class="col-lg-12 margin-tb">
<div class="pull-left">
<h2>Laravel 9 AJAX CRUD using DataTable</h2>
</div>
<div class="pull-right mb-2">
<a class="btn btn-success" onClick="add()" href="javascript:void(0)"> Add Employee</a>
</div>
</div>
</div>
@if ($message = Session::get('success'))
<div class="alert alert-success">
<p>{{ $message }}</p>
</div>
@endif
<div class="card-body">
<table class="table table-bordered" id="ajax-crud-datatable">
<thead>
<tr>
<th>Id</th>
<th>Name</th>
<th>Email</th>
<th>Address</th>
<th>Created at</th>
<th>Action</th>
</tr>
</thead>
</table>
</div>
</div>
<!-- boostrap employee model -->
<div class="modal fade" id="employee-modal" aria-hidden="true">
<div class="modal-dialog modal-lg">
<div class="modal-content">
<div class="modal-header">
<h4 class="modal-title" id="EmployeeModal"></h4>
</div>
<div class="modal-body">
<form action="javascript:void(0)" id="EmployeeForm" name="EmployeeForm" class="form-horizontal" method="POST" enctype="multipart/form-data">
<input type="hidden" name="id" id="id">
<div class="form-group">
<label for="name" class="col-sm-2 control-label">Employee Name</label>
<div class="col-sm-12">
<input type="text" class="form-control" id="name" name="name" placeholder="Enter Employee Name" maxlength="50" required="">
</div>
</div>  
<div class="form-group">
<label for="name" class="col-sm-2 control-label">Employee Email</label>
<div class="col-sm-12">
<input type="email" class="form-control" id="email" name="email" placeholder="Enter Employee Email" maxlength="50" required="">
</div>
</div>
<div class="form-group">
<label class="col-sm-2 control-label">Employee Address</label>
<div class="col-sm-12">
<input type="text" class="form-control" id="address" name="address" placeholder="Enter Employee Address" required="">
</div>
</div>
<div class="col-sm-offset-2 col-sm-10">
<button type="submit" class="btn btn-primary" id="btn-save">Save changes
</button>
</div>
</form>
</div>
<div class="modal-footer">
</div>
</div>
</div>
</div>
<!-- end bootstrap model -->
</body>
<script type="text/javascript">
$(document).ready( function () {
$.ajaxSetup({
headers: {
'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
}
});
$('#ajax-crud-datatable').DataTable({
processing: true,
serverSide: true,
ajax: "{{ url('employee-dt-ajax-crud') }}",
columns: [
{ data: 'id', name: 'id' },
{ data: 'name', name: 'name' },
{ data: 'email', name: 'email' },
{ data: 'address', name: 'address' },
{ data: 'created_at', name: 'created_at' },
{data: 'action', name: 'action', orderable: false},
],
order: [[0, 'desc']]
});
});
function add(){
$('#EmployeeForm').trigger("reset");
$('#EmployeeModal').html("Add Employee");
$('#employee-modal').modal('show');
$('#id').val('');
}   
function editFunc(id){
$.ajax({
type:"POST",
url: "{{ url('edit-employee') }}",
data: { id: id },
dataType: 'json',
success: function(res){
$('#EmployeeModal').html("Edit Employee");
$('#employee-modal').modal('show');
$('#id').val(res.id);
$('#name').val(res.name);
$('#address').val(res.address);
$('#email').val(res.email);
}
});
}  
function deleteFunc(id){
if (confirm("Delete Record?") == true) {
var id = id;
// ajax
$.ajax({
type:"POST",
url: "{{ url('delete-employee') }}",
data: { id: id },
dataType: 'json',
success: function(res){
var oTable = $('#ajax-crud-datatable').dataTable();
oTable.fnDraw(false);
}
});
}
}
$('#EmployeeForm').submit(function(e) {
e.preventDefault();
var formData = new FormData(this);
$.ajax({
type:'POST',
url: "{{ url('store-employee')}}",
data: formData,
cache:false,
contentType: false,
processData: false,
success: (data) => {
$("#employee-modal").modal('hide');
var oTable = $('#ajax-crud-datatable').dataTable();
oTable.fnDraw(false);
$("#btn-save").html('Submit');
$("#btn-save"). attr("disabled", false);
},
error: function(data){
console.log(data);
}
});
});
</script>
</html>

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

147

148

149

150

151

152

153

154

155

156

157

158

159

160

161

162

163

164

165

166

167

168

169

<!DOCTYPE html>

<head>

<title>Laravel 9 AJAX CRUD using DataTable</title>

</head>

<body>

<h2>Laravel 9 AJAX CRUD using DataTable</h2>

</div>

<a class="btn btn-success" onClick="add()" href="javascript:void(0)"> Add Employee</a>

</div>

@if ($message = Session::get('success'))

<p>{{ $message }}</p>

</div>

@endif

<thead>

<tr>

<th>Email</th>

<th>Address</th>

<th>Created at</th>

<th>Action</th>

</tr>

</thead>

</table>

</div>

</div>

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

</div>

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

</div>

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

</div>

<button type="submit" class="btn btn-primary" id="btn-save">Save changes

</button>

</div>

</form>

</div>

</div>

</body>

$(document).ready( function () {

$.ajaxSetup({

headers: {

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

}

});

$('#ajax-crud-datatable').DataTable({

processing: true,

serverSide: true,

ajax: "{{ url('employee-dt-ajax-crud') }}",

columns: [

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

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

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

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

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

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

order: [[0, 'desc']]

});

function add(){

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

$('#EmployeeModal').html("Add Employee");

$('#employee-modal').modal('show');

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

}

function editFunc(id){

$.ajax({

type:"POST",

url: "{{ url('edit-employee') }}",

data: { id: id },

dataType: 'json',

success: function(res){

$('#EmployeeModal').html("Edit Employee");

$('#employee-modal').modal('show');

$('#id').val(res.id);

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

$('#address').val(res.address);

$('#email').val(res.email);

}

});

}

function deleteFunc(id){

if (confirm("Delete Record?") == true) {

var id = id;

// ajax

$.ajax({

type:"POST",

url: "{{ url('delete-employee') }}",

data: { id: id },

dataType: 'json',

success: function(res){

var oTable = $('#ajax-crud-datatable').dataTable();

oTable.fnDraw(false);

}

});

}

$('#EmployeeForm').submit(function(e) {

e.preventDefault();

var formData = new FormData(this);

$.ajax({

type:'POST',

url: "{{ url('store-employee')}}",

data: formData,

cache:false,

contentType: false,

processData: false,

success: (data) => {

$("#employee-modal").modal('hide');

var oTable = $('#ajax-crud-datatable').dataTable();

oTable.fnDraw(false);

$("#btn-save").html('Submit');

$("#btn-save"). attr("disabled", false);

error: function(data){

console.log(data);

}

});

</script>

</html>

employee-action.blade.php

<a href="javascript:void(0)" data-toggle="tooltip" onClick="editFunc({{ $id }})" data-original-title="Edit" class="edit btn btn-success edit">
Edit
</a>
<a href="javascript:void(0);" id="delete-employee" onClick="deleteFunc({{ $id }})" data-toggle="tooltip" data-original-title="Delete" class="delete btn btn-danger">
Delete
</a>

Edit

</a>

Delete

</a>

Start Development Server

Now we are ready to run our example so lets start the development server using following artisan command –

php artisan serve

1	php artisan serve

Now, open the following URL in browser to see the output –

http://localhost:8000/employee-dt-ajax-crud

1	http://localhost:8000/employee-dt-ajax-crud

Output:-

Laravel_9_Ajax_CRUD_Example_Tutorial_1

Laravel 9 daily, monthly, weekly Automatic Database Backup Example

Create Command

Register Command In Kernel.php

Edit the DbBackup.php

Backup Files

Laravel 9 Find Nearest Location By Latitude and Longitude

Install Laravel 9

Connecting App to Database

Add Route

Generate Controller by Command

Run Development Server

Laravel 9 Get Country, City Name & Address From IP Address Example

Install Laravel 9

Connecting App to Database

Install “stevebauman/location”

Add Routes

Create Controller By Command

Start Development Server

Laravel 9 Multiple Image Upload with Preview

Install Laravel 9

Configure Database

Create Model & Migration

Create Routes

Create Controller By Artisan Command

Create Blade View

Run Development Server

Laravel 9 Multiple File Upload Example

Install Laravel 9

Configure Database

Create Model & Migration

Create Routes

Create Controller By Artisan Command

Create Multiple File Upload Form

Create Directory inside Storage/app/public

Run Development Server

Laravel 9 Send Email with PDF Attachment Tutorial

Install Laravel 9

Configuration SMTP in .env

Install PDF Library

Add Send Email Route

Create Directory And Blade View

Create Send Email Controller

Step 7 – Run Development Server

Laravel 9 Send Email Example Tutorial

Install Laravel 9

Setup Database Credentials

Setting Up Mailtrap Mail Configuration

Create Laravel Markdown Mailable Class

Create Controller to Send and Email

Create Route to Send Mail

Create Email Template

Start Development Server

Send Email in Laravel

Laravel 9 User Authentication API

Laravel 9 CRUD REST API

Laravel 9 Crud Rest Api with Passport Auth

Install Laravel 9

Configure Database

Install Passport Package

Passport Configuration

Create Product Table and Model

Run Migration

Create Passport Auth API Controller

Create Product CRUD API Controller

Define API Routes

Start Development Server

Laravel 9 User Registration API:

Laravel 9 User Login API:

Laravel 9 Get User Info. API:

Product List API

Product Create API

Product Fetch API

Product Update API

Product Delete API

Laravel 9 REST API with Passport Authentication

Install Laravel 9

Set Up Database

Install Passport Package

Configure Passport Module

Create Posts Model & Run Migration