Web Prepration

Web Concept Tutorials

Laravel

Import Export Excel & CSV File in Laravel 6

by Leave a Comment

In this post, I will be show you how to import export csv file in laravel 6,  using maatwebsite/excel we can import export excel or csv from database in laravel 6 application.

In this post i will create full script “how to import csv file in database in laravel 6” and how to export csv file from database in laravel.

For import and export csv file from database we will use maatwebsite/excel composer package for import and export task. maatwebsite/excel package provide easy to import and export data from database. maatwebsite/excel package updated version 3 provide great way to import export data from database with validations, so first follow few step to get example.

Step 1 :  Install Laravel 6

first, we need install Laravel 6 using bellow command, So that open your terminal OR command prompt and run bellow command:

1
2
3
 
composer create-project --prefer-dist laravel/laravel laravel6
 

Step 2: Install maatwebsite/excel Package

In this step we need to install maatwebsite/excel package, So copy below command and run your terminal:

1
2
3
 
composer require maatwebsite/excel
 

Now we need some configuration for excel package, open config/app.php file and add service provider and aliase.

config/app.php

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
 
'providers' => [
 
....
 
Maatwebsite\Excel\ExcelServiceProvider::class,
 
],
 
'aliases' => [
 
....
 
'Excel' => Maatwebsite\Excel\Facades\Excel::class,
 
],
 

 

Step 3: Add Routes

In this step, we need to create route of import export file. so open your “routes/web.php” file and add following route.

routes/web.php

1
2
3
4
5
 
Route::get('importView', 'TestController@importView');
Route::get('exportData', 'TestController@exportData')->name('exportData');
Route::post('importData', 'TestController@importData')->name('importData');
 

 

Step 5: Create Import Class

Now we need to create Import class and use that class in your controller. So you have to run following command and change following code on that file:

1
2
3
 
php artisan make:import UsersImport --model=User
 

app/Imports/UsersImport.php

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
 
<?php
   
namespace App\Imports;
   
use App\User;
use Maatwebsite\Excel\Concerns\ToModel;
use Maatwebsite\Excel\Concerns\Importable;
use Maatwebsite\Excel\Concerns\SkipsOnError;
use Maatwebsite\Excel\Concerns\WithValidation;
use Maatwebsite\Excel\Concerns\WithHeadingRow;
    
class UsersImport implements ToModel,WithHeadingRow,SkipsOnError,WithValidation
{
    /**
     * @param array $row
     *
     * @return User|null
     */
      /*
    * Save Excel File Data  
    */
    public function model(array $row)
    {
        return new User([
            'name'     => $row['name'],
            'email'    => $row['email'], 
            'password' => \Hash::make($row['password']),
        ]);
    }
 
    /*
    * @author Mohsin Khan
    * Skip top heading Data  
    */
    public function headingRow(): int
    {
        return 1;
    }
 
    /* @author Mohsin Khan
    ** validating each row
    */
    public function rules(): array
    {
        return [
            'name' => 'required',
            'email' => 'required',
            'password' => 'required'
        ];
    }
 
    /**
     * @param \Throwable $e
     */
    public function onError(\Throwable $e)
    {
        // Handle the exception how you'd like.
        \Log::error($e->getMessage());
         return back();
    }
 
}
 

Step 6: Create Export Class

maatwebsite 3 version package provide way to built export class and we have to use in controller. For create Export Class you have to run following command and change following code on that file:

1
2
3
 
php artisan make:export UsersExport --model=User
 

app/Exports/UsersExport.php

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
 
<?php
  
namespace App\Exports;
  
use App\User;
use Maatwebsite\Excel\Concerns\FromCollection;
use Maatwebsite\Excel\Concerns\WithHeadings;
  
class UsersExport implements FromCollection,WithHeadings
{
    /**
    * @return \Illuminate\Support\Collection
    */
    public function collection()
    {
        return User::all();
    }
 
    public function headings(): array
    {
        return [
            'Name',
            'Email',
            'Password'
        ];
    }
 
}
 

Step 7: Create Controller

Now we should create a new controller as TestController in this path “app/Http/Controllers/TestController.php”. this controller will manage all importExportView, export and import request and return response, so put bellow content in controller file:

app/Http/Controllers/TestController.php

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
 
<?php
   
namespace App\Http\Controllers;
  
use Illuminate\Http\Request;
use App\Exports\UsersExport;
use App\Imports\UsersImport;
use Maatwebsite\Excel\Facades\Excel;
  
class TestController extends Controller
{
    /**
    * @return \Illuminate\Support\Collection
    */
    public function importView()
    {
       return view('import');
    }
   
    /**
    * @return \Illuminate\Support\Collection
    */
    public function exportData() 
    {
        return Excel::download(new UsersExport, 'users.xlsx');
    }
   
    /**
    * @return \Illuminate\Support\Collection
    */
    public function importData() 
    {
        Excel::import(new UsersImport,request()->file('file'));
           
        return back();
    }
}
 

 

Step 8: Create Import Blade File

In Last step, we need to create view file for import data as import.blade.php(resources/views/import.blade.php).

resources/views/import.blade.php

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
 
<!DOCTYPE html>
<html>
<head>
    <title>Laravel 6 Import Export Excel to database Example - webprepration.com</title>
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/4.1.3/css/bootstrap.min.css" />
</head>
<body>
   
<div class="container">
    <div class="card bg-light mt-3">
        <div class="card-header">
            Laravel 6 Import Export Excel to database Example - webprepration.com
        </div>
        <div class="card-body">
            <form action="{{ route('importData') }}" method="POST" enctype="multipart/form-data">
                @csrf
                <input type="file" name="file" class="form-control">
                <br>
                <button class="btn btn-success" type="submit">Import User Data</button>
                <a class="btn btn-warning" href="{{ route('exportData') }}">Export User Data</a>
            </form>
        </div>
    </div>
</div>   
</body>
</html>
 

Now we are ready to run our example so run bellow command:

1
2
3
 
php artisan serve
 

Now you can open bellow URL on your browser:

http://localhost:8000/importView

I hope it can help you…

CORS Middleware in Laravel 6

by Leave a Comment

Do you have issue like cors header ‘access-control-allow-origin’ missing in laravel or how to use cors middleware in laravel  than i will show you how to work with cors(Cross-Origin Resource Sharing) in laravel application.

Here I will show you step by step explanation “How to use cors middleware in laravel 6”.

 

Step 1:-  First we will install barryvdh/laravel-cors composer package by following composer command in your laravel application for manage cors.

1
2
3
 
composer require barryvdh/laravel-cors
 

After successfully install package, need to add service provider and alias in config app.php file

 

1
2
3
4
5
6
 
'providers' =&gt; [
....
Barryvdh\Cors\ServiceProvider::class,
],
 

Now we need to use in middleware kernel file

1
2
3
4
5
6
 
protected $middleware = [
    ...
    \Barryvdh\Cors\HandleCors::class,
];
 

Step 2:-  In this step we need to create aPI Routes for testing. so open your “routes/api.php” file and add routes.

 

1
2
3
4
5
 
Route::get('/testcors', function (Request $request) {
    return response()-&gt;json(['Laravel 6 CORS Example']);
});
 

Step 3:-  Now I am going to access this api route from another server, For that I have created a html file and try to access my api using jquery ajax.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
 
<html>
<head>
    <title>Laravel 6 CORS Middleware Tutorial - Webprepration</title>
    <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.4.1/jquery.min.js"></script>
</head>
<body>
   
<script type="text/javascript">
  $.ajax({
    type: "GET",
    dataType: "json",
    url: 'http://localhost:8000/api/testcors',
    success: function(data){
      console.log(data);
    }
  });
</script>
   
</body>
</html>
 

 

I hope you might have understood it properly, keep reading our other blogs posts for more coding tricks.

Thanks!!

Paytm Payment Gateway Integration in Laravel

by Leave a Comment

In this post, I am going to explain “How to Integrate Paytm Payment Gateway in Web”.

Paytm is the most popular mobile wallet and payment method used in India. As we know today market, all the things digital and as specially for India. India become digital india.Paytm is the most popular E commerce and payment tool in India.

There is the official documentation about integrating Paytm but that is very confusing if you are newbie.

Here I will show you step by step explanation “How to Integrate Paytm Payment Gateway”.

Step 1:- Install laravel using below command

1
2
3
 
composer create-project --prefer-dist laravel/laravel PaytmIntegration_Laravel
 

Step 2:-  In this step we need to install required packages anandsiddharth/laravel-paytm-wallet package for paytm developer api so open your terminal and fire bellow command:

1
2
3
 
composer require anandsiddharth/laravel-paytm-wallet
 

After install package open config/app.php file and add service provider.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
 
'providers' => [
 
....
 
Anand\LaravelPaytmWallet\PaytmWalletServiceProvider::class,
 
],
 
'aliases' => [
 
....
 
'PaytmWallet' => Anand\LaravelPaytmWallet\Facades\PaytmWallet::class,
 
],
 

After that add configuration of API keys in service.php file

1
2
3
4
5
6
7
8
9
10
 
'paytm-wallet' => [
        'env' => 'local', // values : (local | production)
        'merchant_id' => env('YOUR_MERCHANT_ID'),
        'merchant_key' => env('YOUR_MERCHANT_KEY'),
        'merchant_website' => env('YOUR_WEBSITE'),
        'channel' => env('YOUR_CHANNEL'),
        'industry_type' => env('YOUR_INDUSTRY_TYPE'),
    ],
 

Step 3:- In this step we need to add the variable in .env file, So let’s open .env file and add the variable. 

1
2
3
4
5
6
7
 
YOUR_MERCHANT_ID="enter your merchant id"
YOUR_MERCHANT_KEY="enter your merchant key"
YOUR_WEBSITE="your website"
YOUR_CHANNEL=WEB
YOUR_INDUSTRY_TYPE=Retail
 

Step 4:-  Create event registration table and model

1
2
3
 
php artisan make:migration create_event_registration_table
 

After this command you will find one file in following     path  database/migrations and you have to put bellow code in your migration file for create categories table. 

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
 
<?php
 
 
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
 
 
class CreateEventRegisterTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('event_registration', function (Blueprint $table) {
            $table->increments('id');
            $table->string('name');
            $table->string('mobile_no');
            $table->text('desc');
            $table->tinyInteger('status')->default(0);
            $table->integer('fee');
            $table->string('order_id');
            $table->string('transaction_id')->default(0);
            $table->timestamps();
        });
    }
 
 
    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::drop("event_registration");
    }
}
 

Now run the below migration command

1
2
3
 
php artisan migrate
 

Step 5:- Now create the event registration model file, So let’s create new file in app/EventRegistration.php

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
 
<?php
 
 
namespace App;
 
 
use Illuminate\Database\Eloquent\Model;
 
 
class EventRegistration extends Model
{
    protected $table = 'event_registration';
 
 
    protected $fillable = ['name','mobile_no','desc','status','fee','order_id','transaction_id'];
 
 
    /*
status : 0 => progress, 1 => Fail, 2 => Successful
    */
}
 

Step 6:- Now create the web and API routes in web.php and api.php

web.php

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
 
<?php
 
 
/*
|--------------------------------------------------------------------------
| Web Routes
|--------------------------------------------------------------------------
|
| Here is where you can register web routes for your application. These
| routes are loaded by the RouteServiceProvider within a group which
| contains the "web" middleware group. Now create something great!
|
*/
 
 
Route::get('eventRegistration', 'OrderController@register');
Route::post('paytmPayment', 'OrderController@order');
 

api.php

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
 
<?php
 
 
/*
|--------------------------------------------------------------------------
| API Routes
|--------------------------------------------------------------------------
|
| Here is where you can register API routes for your application. These
| routes are loaded by the RouteServiceProvider within a group which
| is assigned the "api" middleware group. Enjoy building your API!
|
*/
 
 
Route::post('payment/status', 'OrderController@paymentCallback');
 

Step 7:- Now we need to create the controller file, So let’s create the controller file.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
 
<?php
 
 
namespace App\Http\Controllers;
 
 
use PaytmWallet;
use Illuminate\Http\Request;
use App\EventRegistration;
 
 
class OrderController extends Controller
{
 
 
    /**
     * Redirect the user to the Payment Gateway.
     *
     * @return Response
     */
    public function register()
    {
        return view('payment_form');
    }
 
 
    /**
     * Redirect the user to the Payment Gateway.
     *
     * @return Response
     */
    public function order(Request $request)
    {
 
 
        $this->validate($request, [
            'name' => 'required',
            'mobile_no' => 'required|numeric|digits:10|unique:event_registration,mobile_no',
            'desc' => 'required',
        ]);
 
 
        $input = $request->all();
        $input['order_id'] = $request->mobile_no.rand(1,100);
        $input['fee'] = 50;
 
 
        EventRegistration::create($input);
 
 
        $payment = PaytmWallet::with('receive');
        $payment->prepare([
          'order' => $input['order_id'],
          'user' => 'your paytm user',
          'mobile_number' => 'your paytm number',
          'email' => 'your paytm email',
          'amount' => $input['fee'],
          'callback_url' => url('api/payment/status')
        ]);
        return $payment->receive();
    }
 
 
    /**
     * Obtain the payment information.
     *
     * @return Object
     */
    public function paymentCallback()
    {
        $transaction = PaytmWallet::with('receive');
 
 
        $response = $transaction->response();
        $order_id = $transaction->getOrderId();
 
 
        if($transaction->isSuccessful()){
          EventRegistration::where('order_id',$order_id)->update(['status'=>2, 'transaction_id'=>$transaction->getTransactionId()]);
 
 
          dd('Payment Successfully Paid.');
        }else if($transaction->isFailed()){
          EventRegistration::where('order_id',$order_id)->update(['status'=>1, 'transaction_id'=>$transaction->getTransactionId()]);
          dd('Payment Failed.');
        }
    }    
}
 

Step 8:- Now create the view file with payment form payment_form.blade.php 

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
 
<!DOCTYPE html>
<html>
<head>
    <title>Laravel 5.8 - Payment gateway using Paytm</title>
    <link href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" rel="stylesheet">
</head>
<body>
<div class="container">
    <div class="panel panel-primary" style="margin-top:30px;">
        <div class="panel-heading"><h2 class="text-center">Laravel 5.8 - Payment gateway using Paytm</h2></div>
        <div class="panel-body">
            <form action="{{ url('paytmPay') }}" class="form-image-upload" method="POST" enctype="multipart/form-data">
                {!! csrf_field() !!}
                @if (count($errors) > 0)
                    <div class="alert alert-danger">
                        <strong>Whoops!</strong> There were some problems with your input.<br><br>
                        <ul>
                            @foreach ($errors->all() as $error)
                                <li>{{ $error }}</li>
                            @endforeach
                        </ul>
                    </div>
                @endif
                <div class="row">
                    <div class="col-md-12">
                        <strong>Name:</strong>
                        <input type="text" name="name" class="form-control" placeholder="Name">
                    </div>
                    <div class="col-md-12">
                        <strong>Mobile No:</strong>
                        <input type="text" name="mobile_no" class="form-control" placeholder="Mobile No.">
                    </div>
                    <div class="col-md-12">
                        <strong>Message:</strong>
                        <textarea class="form-control" placeholder="Message" name="desc"></textarea>
                    </div>
                    <div class="col-md-12">
                        <br/>
                        <div class="btn btn-info btn-block">
                            Event Fee : 50 Rs/-
                        </div>
                    </div>
                    <div class="col-md-12">
                        <br/>
                        <button type="submit" class="btn btn-success btn-block">Pay by Paytm</button>
                    </div>
                </div>
            </form>
        </div>
    </div>
</div>
</body>
</html>
 

Now we are ready to run example, So just run below command

1
2
3
 
php artisan serve
 

 

View Demo

 

I hope you might have understood it properly, keep reading our other blogs posts for more coding tricks.

Thanks!!

Laravel Interview Questions & Answers

by Leave a Comment

In this post, I am going to share some important questions for laravel interview. In this post share from basics to advance level questions and answers of laravel, which is mostly asked in interview.

1)  What is Laravel ?

Answer:- Laravel is a free open source “PHP Framework ” based on MVC design pattern. It is created by Taylor Otwell. Laravel provides expressive and elegant syntax that helps in creating a wonderful web application easily and quickly.

2) How to install laravel via composer ?

Answer:-  You can install Laravel via composer by running below command.

1
2
3
 
composer create-project laravel/laravel your-project-name version
 

3) What is Lumen?

Answer:-  Lumen is PHP micro-framework that built on Laravel’s top components.It is created by Taylor Otwell. It is perfect option for building Laravel based micro-services and fast REST API’s. It’s one of the fastest micro-frameworks available.

4) List some features of laravel 5.0 ?

Answer:-  

  • Inbuilt CRSF (cross-site request forgery ) Protection.
  • Authentication Scaffolding
  • Inbuilt paginations
  • Reverse Routing
  • Query builder
  • Route caching
  • Database Migration
  • IOC (Inverse of Control) Container Or service container.
  • Laravel schedular
  • Method Injection

5)  What is PHP artisan. List out some artisan commands ?

Answer:- Laravel provides a number of  helpful commands that can help you while you build your application easily. 

Here are the list of some artisan command:-

  • php artisan list
  • php artisan help
  • php artisan tinker
  • php artisan make
  • php artisan –versian
  • php artisan make model model_name
  • php artisan make controller controller_name
  • php artisan make: console FooCommand

6) Compare Laravel With CodeIgniter?

Answer:- Laravel

    • Laravel is a framework with expressive, elegant syntax
    • Development is enjoyable, creative experience
    • Laravel is built for latest version of PHP
    • It is more object oriented compared to CodeIgniter
    • Laravel community is still small, but it is growing very fast.

CodeIgnitor:-

    • CodeIgniter is a powerful PHP framework
    • Simple and elegant toolkit to create full-featured web applications.
    • Codeigniter is an older more mature framework
    • It is less object oriented compared to Laravel.
    • Codeigniter community is large.

7) Laravel Support Caching?

Answer:- Yes, Its provide.

8) Types of relationships available in Laravel Eloquent?

Answer:-  Below are types of relationships supported by Laravel Eloquent ORM.

  • One To One
  • One To Many
  • One To Many (Inverse)
  • Many To Many
  • Has Many Through
  • Polymorphic Relations
  • Many To Many Polymorphic Relations

9) What is database migration. How to create migration via artisan ?

Answer:-  Database migrations are like version controls for your database, that’s allow you to easily modify and share the application’s database schema. Migrations are typically paired with Laravel’s schema builder to easily build your application’s database schema.

Use below commands to create migration data via artisan.

1
2
3
 
php artisan make:migration create_users_table
 

10) Explain Facades in Laravel ?

Answer:- Laravel Facades provides static like an interface to classes that are available in the application’s service container. Laravel facades serve as “static proxies” to underlying classes in the service container and provide benefits of a terse, expressive syntax while maintaining more test-ability and flexibility than traditional static methods of classes. All of Laravel’s facades are defined in the Illuminate\Support\Facades namespace. You can easily access a facade like so:

1
2
3
4
5
6
7
 
use Illuminate\Support\Facades\Cache;
 
Route::get('/cache', function () {
    return Cache::get('key');
});
 

11) How to enable Query log in Laravel ?

Answer:- 

1
2
3
 
DB::enableQueryLog(); 
 

12) How to use custom table in Laravel Modal ?

Answer:- 

1
2
3
4
5
6
7
8
9
10
11
12
13
 
namespace App;
use Illuminate\Database\Eloquent\Model;
class Note extends Model
{
   protected $table= "user_note";
}
 

 

13) List some packages provide by Laravel 5.6 ?

Answer:- 

  • Cashier
  • Envoy
  • Passport
  • Scout
  • Socialite
  • Horizon

14) How do you define Middleware?

Answer:- To create middleware using artisan command like 

1
2
3
 
php artisan make:middleware CheckAge 
 

This command create new file within your app/http/middleware directory

15) Exceptions are handled by which class?

Answer:- All exceptions in laravel are handled by the App/Exceptions/Handler/ class. This class contains two methods report and render.

16) What are blade templates ?

Answer:- Blade is a simple and powerful templating engine provided with laravel. Laravel does not restrict you from using plain php code in view.

17) Where do you locate Route files?

Answer:- All routes are defined in routes file which is located in your app routes directory.

18) How to use custom join Query in Laravel ?

Answer:-

1
2
3
4
5
6
7
 
DB::table('users')
->select('users.id','users.name','profiles.photo')
->join('profiles','profiles.id','=','users.id')
->where(['something' => 'something', 'otherThing' => 'otherThing'])
->get();
 

19)  How to implement you own package in Laravel?

Answer:- You can create a package in laravel using the following steps:

  1. Package folder and Name
  2. Composer.json file for the package
  3. Loading package via main composer.json and PSR-4
  4. Creating a service provider
  5. Create a controller for your package
  6. Create routes

20) What is the purpose of using dd() function in laravel ?

Answer:- dd(); Stands for Dump and Die.

dd() is a laravel helper function, which will dump a variables content to the browser and stop further execution.

How to implement DataTables server-side in laravel

by Leave a Comment

In this post, I will be show you the easiest  way to implement  DataTables  server side processing in Laravel. Here I will show you how to fetch data  using ajax in laravel and render that data in DataTable with searching, Pagination and sorting with server side processing.

This post is an extension to a previous post on DataTables, where we initiated data tables with basic initialization. As many readers suggested to make a tutorial on DataTables server-side. . In this post we have explain step by step. Because Jquery DataTables will add some advance features like quick search of table data, it will make automatic pagination without write of code, table column ordering, sorting of table column and many more.

Now before we start coding include Datatables CSS file and Javascript files from CDN in your view page as follows.

1
2
3
4
5
 
<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/v/dt/dt-1.10.12/datatables.min.css"/>
 
<script type="text/javascript" src="https://cdn.datatables.net/v/dt/dt-1.10.12/datatables.min.js"></script>
 





Now let’s understand what all tasks we need to do

  1. We need to limit the size of the table. (By default 10,25,50 or 100 entries)
  2. Now Implement search functionality and sort.
  3. The Pagination task.

All above task will be done in the controller and it will be explained later in this tutorial.

Now let’s start coding.

In the view page code for HTML table is given below.

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
 
<div class="panel-body">
        <div class="panel-body">  
         <div class="row">        
         <table class="table table-bordered" id="institute_table" style="width:100%">
 
                      <thead>
 
                             <th>Id</th>
 
                             <th>Brand Name</th>
                             <th>Model Name</th>
<th>Description</th>
<th>Price</th>
<th>Action</th>
 
                        </thead>        
 
         </table>
      </div>
        </div>
 
       </div>
 

 

Now we need to add javascript code, you can add that code in your view file or any javascript file which is include with this view. Please copy the given code and paste in your file

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
 
<script>
 
      $(document).ready(function(){
 
        // Data table for serverside
 
       $('#institute_table').DataTable({
 
            "processing": true,
 
            "serverSide": true,
 
            "ajax":{
 
                     "url": "{{ url('productList') }}",
 
                     "dataType": "json",
 
                     "type": "POST",
 
                     "data":{ _token: "{{csrf_token()}}",route:'products'}
 
                   },
 
            "columns": [
 
                { "data": "id" },
 
                { "data": "brand_name" },
{ "data": "model_name" },
{ "data": "description" },
{ "data": "price" },
 
                { "data": "action" }
 
            ],
 
            aoColumnDefs: [
 
            {
 
               bSortable: false,
 
               aTargets: [ -1 ]
 
            }
 
          ]  
 
 
 
        });
});
</script>
 

 

Note:- Don’t forgot to pass CSRF Token along with ajax POST request as above. Otherwise ajax occurs internal server 500, Laravel checks  CSRF Token in all post request by default ensure maximum protection.

Now we need to create routes for list data and load view

1
2
3
4
 
Route::get('products','DemoController@products');
Route::post('productList','DemoController@productList');
 

Now create product model file, Please copy below code and paste

1
2
3
4
5
6
7
8
9
10
11
12
13
14
 
<?php
 
namespace App;
 
use Illuminate\Database\Eloquent\Model;
 
class Prodcut extends Model
{
    
protected $table = 'proucts';
protected $fillable = ['brand_name','model_name','price','description'];
}
 

 

Note:  If you don’t know the basic concept of Laravel Eloquent ORM then all controller code may find little confusing to you. Please consider learning that before proceeding this tutorial.



Now create Demo controller file in app/Http/Controllers/DemoController.php

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
 
<?php
namespace App\Http\Controllers;
 
 
use Illuminate\Http\Request;
use App\Http\Controllers\Controller;
use PDF;
use App\Products;
 
 
class DemoController extends Controller
{
 
  
    function products(Request $request){
        return view('server_side_table');
    }
    function productList(Request $request){
 
       $columns = array(
            0 =>'id',
            1 =>'brand_name',
            2 =>'model_name',
            3 =>'description',
            4 =>'price',
        );  
        $totalData = Products::count();            
        $totalFiltered = $totalData;
        $limit = $request->input('length');
        $start = $request->input('start');
        $order = $columns[$request->input('order.0.column')];
        $dir = $request->input('order.0.dir');
            
        if(empty($request->input('search.value')))
        {            
            $institutes = Products::offset($start)
                         ->limit($limit)
                         ->orderBy($order,$dir)
                         ->get();
        }else {
            $search = $request->input('search.value');
 
            $institutes =  Products::where('id','LIKE',"%{$search}%")
                            ->orWhere('brand_name', 'LIKE',"%{$search}%")
->orWhere('model_name', 'LIKE',"%{$search}%")
->orWhere('price', 'LIKE',"%{$search}%")
                            ->offset($start)
                            ->limit($limit)
                            ->orderBy($order,$dir)
                            ->get();
 
            $totalFiltered = Products::where('id','LIKE',"%{$search}%")
                             ->orWhere('brand_name', 'LIKE',"%{$search}%")
->orWhere('model_name', 'LIKE',"%{$search}%")
->orWhere('price', 'LIKE',"%{$search}%")
                             ->count();
        }
        $data = array();
        if(!empty($institutes))
        {
            foreach ($institutes as $key=>$institute)
            {
                
                $nestedData['id'] = $key+1;
                $nestedData['brand_name'] = $institute->brand_name;
                $nestedData['model_name'] = $institute->model_name;
                $nestedData['price'] = $institute->price;
                $nestedData['description'] = $institute->description;
                $nestedData['action'] = '<a href="#" class="del"><span class="glyphicon glyphicon-trash"></span>
</a><a href="#" class="edit"><span class="glyphicon glyphicon-edit"></span></a>';
                $data[] = $nestedData;
            }
 
        }
        $json_data = array(
        "draw"            => intval($request->input('draw')),  
        "recordsTotal"    => intval($totalData),  
        "recordsFiltered" => intval($totalFiltered),
        "data"            => $data  
        );            
        echo json_encode($json_data);
     }          
        
}
 
?>
 

 

 

View Demo
 

I hope you might have understood it properly, keep reading our other blog posts for more coding tricks.

Thanks!!