Category Archives: Laravel

Laravel Tutorials

Laravel Pluck Method Example

In this laravel pluck method tutorial, I’ll show you how to use laravel eloquent pluck() method. In this tutorial I’ll demonstrate the use of laravel pluck method.

Laravel Pluck Method Example

The laravel eloquent pluck() method is used to extract specified values from array or given collection.

Example:-

In this laravel pluck method tutorial we will use following collection for example:

$users = collect([
    ['name' => 'Tome Heo', 'email' => 'tom@heo.com', 'city' => 'London'],
    ['name' => 'Jhon Deo', 'email' => 'jhon@deo.com', 'city' => 'New York'],
    ['name' => 'Tracey Martin', 'email' => 'tracey@martin.com', 'city' => 'Cape Town'],
    ['name' => 'Angela Sharp', 'email' => 'angela@sharp.com', 'city' => 'Tokyo'],
    ['name' => 'Zayed Bin Masood', 'email' => 'zayad@masood.com', 'city' => 'Dubai'],
]);

$users = collect([

['name' => 'Tome Heo', 'email' => 'tom@heo.com', 'city' => 'London'],

['name' => 'Jhon Deo', 'email' => 'jhon@deo.com', 'city' => 'New York'],

['name' => 'Tracey Martin', 'email' => 'tracey@martin.com', 'city' => 'Cape Town'],

['name' => 'Angela Sharp', 'email' => 'angela@sharp.com', 'city' => 'Tokyo'],

['name' => 'Zayed Bin Masood', 'email' => 'zayad@masood.com', 'city' => 'Dubai'],

]);

Let suppose now we want to extract only the cities of the users. This can be achieved using laravel pluck method as following:

$cities = $users->pluck('city')

1	$cities = $users->pluck('city')

Extract Single Value From Collection Using Pluck()

Let suppose now we want to extract only the single value from the collection using pluck() method. This can be achieved using laravel pluck method as following:

/**
 * Show the application dashboard.
 *
 * @return \Illuminate\Contracts\Support\Renderable
 */
public function index(){
    
   $name = User::pluck('name');
   
   dd($name);
}

/**

* Show the application dashboard.

* @return \Illuminate\Contracts\Support\Renderable

public function index(){

$name = User::pluck('name');

dd($name);

}

Extract Multiple Value From Collection Using Pluck() in Laravel

Let suppose now we want to extract only the multiple value from the collection using pluck() method. This can be achieved using laravel pluck method as following:

/**
 * Show the application dashboard.
 *
 * @return \Illuminate\Contracts\Support\Renderable
 */
public function index(){
    
   $data = User::pluck('name', 'id');
   
   dd($data);
}

/**

* Show the application dashboard.

* @return \Illuminate\Contracts\Support\Renderable

public function index(){

$data = User::pluck('name', 'id');

dd($data);

}

Laravel Pluck Relationship

Let suppose now we want to extract values from the collection with relationship objects using pluck() method. This can be achieved using laravel pluck method as following:

/**
 * Show the application dashboard.
 *
 * @return \Illuminate\Contracts\Support\Renderable
 */
public function index(){
    
   $users = User::with('profile')->get();
   $bio = $users->pluck('profile.bio'); // Get all bio of all users profile
   
   dd($bio);
}

/**

* Show the application dashboard.

* @return \Illuminate\Contracts\Support\Renderable

public function index(){

$users = User::with('profile')->get();

$bio = $users->pluck('profile.bio'); // Get all bio of all users profile

dd($bio);

}

Laravel Cookies Get, Set, Delete Cookies

In this tutorial, I’ll show you how to use cookies in laravel application. You will learn to Set, Get, and Delete Cookies in laravel.You will also learn how to check cookies exist or not.

what is cookies?

Cookies are a small data file, which is stored in the browser. Cookies are used for tracking/identifying user’s interaction with application. Cookies are mainly used to store user specific data.

Laravel Cookies Get, Set, Delete Cookies

In this tutorial, I’ll demonstrate you how to Get, Set, Delete Cookies in laravel.

Laravel Set Cookies

The cookies::make() method to create or set cookies in laravel:

$cookie = Cookie::make('name', 'value', 120);

1	$cookie = Cookie::make('name', 'value', 120);

Using the cookies::forever method(), you can set cookies forever:

$cookie = Cookie::forever('name', 'value');

1	$cookie = Cookie::forever('name', 'value');

Laravel Get Cookies

The cookie::get() method is used to get cookies in laravel:

$val = Cookie::get('cookieName');

1	$val = Cookie::get('cookieName');

If you want to get all cookies in laravel, you can use cookie::get() method as following:

$get_all_cookies = Cookie::get();

1	$get_all_cookies = Cookie::get();

Laravel Delete Cookies

The cookie::forget() method is used to delete cookies in laravel:

$cookie = Cookie::forget('cookieName');

1	$cookie = Cookie::forget('cookieName');

The Cookie::has() method is used to check cookie exists or not. If you want to check if cookie exists or not.

Cookie::has('cookiename');

OR

$request->hasCookie('cookiename')

Cookie::has('cookiename');

$request->hasCookie('cookiename')

Add Cookies With Response

Sometime, you may want to add cookies in laravel response. So you can add cookies with response in laravel as following:

return response('view')->withCookie($cookie);

1	return response('view')->withCookie($cookie);

Laravel 7/6 Import Export Excel, Csv to Database

In this tutorial, I’ll show you how to import and export excel/csv file into and from database in laravel 6 using maatwebsite version 3 package with example. I’ll guide you through step by step with example of importing and exporting a csv or excel file using maatwebsite/excel version 3 composer package.

When we are developing laravel applications, there may situations where we require to import or export large amount of data into and from the application database. Importing and exporting data through excel or csv files seems a good solution here.

In laravel, maatwebsite/excel composer package made it easy to import or export excel or csv files. The maatwebsite/excel is a composer package used to import and export excel or csv files. The maatwebsite/excel provide number of features for excel or csv file import and exort in laravel.

Install Laravel Fresh Project
Set database Credentials In .env File
Install Maatwebsite Package
Add Fake Records In Database
Create Controller
Add Routes
Create Import Export Classes
Create Blade View
Start Development Server

Create Laravel 7/6 Application

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

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

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

Configure Database In .env file

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=laraImportExportExcel
DB_USERNAME=root
DB_PASSWORD=

DB_CONNECTION=mysql

DB_HOST=127.0.0.1

DB_PORT=3306

DB_DATABASE=laraImportExportExcel

DB_USERNAME=root

DB_PASSWORD=

Create Model and Migration

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

php artisan make:model Contact -m

1	php artisan make:model Contact -m

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

<?php

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

class CreateContactsTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('contacts', function (Blueprint $table) {
            $table->bigIncrements('id');
            $table->string('name');
            $table->string('email');
            $table->string('phone');
            $table->timestamps();
        });
    }

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

<?php

use Illuminate\Support\Facades\Schema;

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Database\Migrations\Migration;

class CreateContactsTable extends Migration

{

/**

* Run the migrations.

* @return void

public function up()

{

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

$table->bigIncrements('id');

$table->string('name');

$table->string('email');

$table->string('phone');

$table->timestamps();

});

}

/**

* Reverse the migrations.

* @return void

public function down()

{

Schema::dropIfExists('contacts');

}

Run Laravel Migration

Now, run following command to migrate database schema.

php artisan migrate

1	php artisan migrate

After, the migration executed successfully the contact table will be created in database along with a model file Contact.php in app directory.

app/Contact.php

<?php
namespace App;
use Illuminate\Database\Eloquent\Model;
class Contact extends Model
{
     protected $fillable = [
        'name', 'email', 'phone'
    ];
}

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Contact extends Model

{

protected $fillable = [

'name', 'email', 'phone'

];

}

Install Maatwebsite Package

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

composer require maatwebsite/excel

1	composer require maatwebsite/excel

Configure Maatwebsite Package

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

config/app.php

'providers' => [
  .......
  Maatwebsite\Excel\ExcelServiceProvider::class,
 
 ],  

'aliases' => [ 
  .......
  'Excel' => Maatwebsite\Excel\Facades\Excel::class,

],

'providers' => [

.......

Maatwebsite\Excel\ExcelServiceProvider::class,

'aliases' => [

.......

'Excel' => Maatwebsite\Excel\Facades\Excel::class,

Now, use following command to publish Maatwesite Package configuration file:

php artisan vendor:publish

1	php artisan vendor:publish

This will create Maatwesite Package configuration file named “config/excel.php”.

Create Import Class

Now we will create a import class for Contact model to use in our ImportExportExcelController. Use the following command to create import class.

php artisan make:import ImportContacts --model=Contact

1	php artisan make:import ImportContacts --model=Contact

After, the above command executed successfully it will create ImportContacts.php file in Imports directory.

Imports/ImportContacts.php

<?php

namespace App\Imports;

use App\Contact;
use Maatwebsite\Excel\Concerns\ToModel;

class ImportContacts implements ToModel
{
    /**
    * @param array $row
    *
    * @return \Illuminate\Database\Eloquent\Model|null
    */
    public function model(array $row)
    {
        return new Contact([
            //
            'name'     => @$row[0],
            'email'    => @$row[1], 
            'phone'    => @$row[2]
        ]);
    }
}

<?php

namespace App\Imports;

use App\Contact;

use Maatwebsite\Excel\Concerns\ToModel;

class ImportContacts implements ToModel

{

/**

* @param array $row

* @return \Illuminate\Database\Eloquent\Model|null

public function model(array $row)

{

return new Contact([

'name' => @$row[0],

'email' => @$row[1],

'phone' => @$row[2]

]);

}

Create Export Class

Now we will create a export class for Contact model to use in our ImportExportExcelController. Use the following command to create import class.

php artisan make:export ExportContacts --model=Contact

1	php artisan make:export ExportContacts --model=Contact

After, the above command executed successfully it will create ExportContacts.php file in Exports directory.

Exports/ExportContacts.php

<?php

namespace App\Exports;

use App\Contact;
use Maatwebsite\Excel\Concerns\FromCollection;

class ExportContacts implements FromCollection
{
    /**
    * @return \Illuminate\Support\Collection
    */
    public function collection()
    {
        return Contact::all();
    }
}

<?php

namespace App\Exports;

use App\Contact;

use Maatwebsite\Excel\Concerns\FromCollection;

class ExportContacts implements FromCollection

{

/**

* @return \Illuminate\Support\Collection

public function collection()

{

return Contact::all();

}

Create Import Excel Controller

Next, we have to create a controller to display a form to upload excel file records. Lets Create a controller named ImportExportExcelController using command given below –

php artisan make:controller ImportExportExcel/ImportExportExcelController

1	php artisan make:controller ImportExportExcel/ImportExportExcelController

Once the above command executed, it will create a controller file ImportExportExcelController.php in app/Http/Controllers/ImportExportExcel directory.

Open the ImportExportExcel/ImportExportExcelController.php file and put the following code in it.

app/Http/Controllers/ImportExportExcel/ImportExportExcelController.php

<?php

namespace App\Http\Controllers\ImportExportExcel;

use Illuminate\Http\Request;
use App\Http\Controllers\Controller;
use App\Imports\ImportContacts;
use App\Exports\ExportContacts;
use Maatwebsite\Excel\Facades\Excel;
use DB;
use App\Contact;

class ImportExportExcelController extends Controller

{

    public function index()
    {
        $contacts = Contact::orderBy('created_at','DESC')->get();
        return view('import_export_excel.index',compact('contacts'));
    }

    public function import(Request $request)
    {
        $request->validate([
            'import_file' => 'required'
        ]);
        Excel::import(new ImportContacts, request()->file('import_file'));
        return back()->with('success', 'Contacts imported successfully.');
    }

    public function export() 
    {
        return Excel::download(new ExportContacts, 'contacts.xlsx');
    }

}

<?php

namespace App\Http\Controllers\ImportExportExcel;

use Illuminate\Http\Request;

use App\Http\Controllers\Controller;

use App\Imports\ImportContacts;

use App\Exports\ExportContacts;

use Maatwebsite\Excel\Facades\Excel;

use DB;

use App\Contact;

class ImportExportExcelController extends Controller

{

public function index()

{

$contacts = Contact::orderBy('created_at','DESC')->get();

return view('import_export_excel.index',compact('contacts'));

}

public function import(Request $request)

{

$request->validate([

'import_file' => 'required'

]);

Excel::import(new ImportContacts, request()->file('import_file'));

return back()->with('success', 'Contacts imported successfully.');

}

public function export()

{

return Excel::download(new ExportContacts, 'contacts.xlsx');

}

Here In the controller, we have following methods –

index() :- It displays File Upload Form and Contact data.

import() :- To Upload excel file and Save records in database .

export() :- To export and download excel file for records in database .

Create Blade / View Files

In this step, we will create view/blade file to upload excel file. Lets create a blade file “index.blade.php” in “resources/views/import_export_excel/” directory and put the following code in it respectively.

resources/views/import_export_excel/index.blade.php

<!DOCTYPE html>
<html>
<head>
    <title>Laravel 6 Export Import Excel to database - W3Adda</title>

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

    <script src="https://code.jquery.com/jquery-3.2.1.slim.min.js"></script>
    <script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.12.9/umd/popper.min.js" ></script>
    <script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/js/bootstrap.min.js" ></script>
</head>

<body>
    
<div class="container">
    <div class="card mt-4">
        <div class="card-header">
            Laravel 6 Import Export Excel to database - W3Adda
        </div>
            @if ($errors->any())
        <div class="alert alert-danger">
            <a href="#" class="close" data-dismiss="alert" aria-label="close">×</a>
            <ul>
                @foreach ($errors->all() as $error)
                    <li>{{ $error }}</li>
                @endforeach
            </ul>
        </div>
    @endif
   @if($message = Session::get('success'))
   <div class="alert alert-success alert-block">
    <button type="button" class="close" data-dismiss="alert">×</button>
           <strong>{{ $message }}</strong>
   </div>
   @endif
        <div class="card-body">
            <form action="{{ url('import-excel') }}" method="POST" name="importform" enctype="multipart/form-data">
                @csrf
                <input type="file" name="import_file" class="form-control">
                <br>
                <button class="btn btn-success">Import File</button>
                <a class="btn btn-info" href="{{ url('export-excel') }}"> 
                 Export File</a>
            </form>
        </div>
    </div>
    <div class="panel panel-default">
    <div class="panel-heading">
     <h3 class="panel-title">Customer Data</h3>
    </div>
    <div class="panel-body">
     <div class="table-responsive">
      <table class="table table-bordered table-striped">
       <tr>
        <th>Name</th>
        <th>Email</th>
        <th>Phone</th>
               </tr>
       @foreach($contacts as $c)
       <tr>
        <td>{{ $c->name }}</td>
        <td>{{ $c->email }}</td>
        <td>{{ $c->phone }}</td>
       </tr>
       @endforeach
      </table>
     </div>
    </div>
</div>

</div>
    
</body>
</html>

<!DOCTYPE html>

<html>

<head>

<title>Laravel 6 Export Import Excel to database - W3Adda</title>

</head>

<body>

Laravel 6 Import Export Excel to database - W3Adda

</div>

@if ($errors->any())

<ul>

@foreach ($errors->all() as $error)

<li>{{ $error }}</li>

@endforeach

</ul>

</div>

@endif

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

<strong>{{ $message }}</strong>

</div>

@endif

@csrf

<br>

<button class="btn btn-success">Import File</button>

Export File</a>

</form>

</div>

<h3 class="panel-title">Customer Data</h3>

</div>

<tr>

<th>Email</th>

<th>Phone</th>

</tr>

@foreach($contacts as $c)

<tr>

<td>{{ $c->email }}</td>

<td>{{ $c->phone }}</td>

</tr>

@endforeach

</table>

</div>

</body>

</html>

Create Import Export Excel 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

Route::get('import-export-excel', 'ImportExportExcel\ImportExportExcelController@index');
Route::post('import-export-excel', 'ImportExportExcel\ImportExportExcelController@import');
Route::get('export-excel', 'ImportExportExcel\ImportExportExcelController@export');

Route::get('import-export-excel', 'ImportExportExcel\ImportExportExcelController@index');

Route::post('import-export-excel', 'ImportExportExcel\ImportExportExcelController@import');

Route::get('export-excel', 'ImportExportExcel\ImportExportExcelController@export');

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/import-export-excel

Output:-

laravel-6-import-export-excel-file-in-database-1

Select excel file to upload, before uploading you must have created an excel file as following:

laravel-6-import-excel-csv-file-in-database-1

laravel-6-import-export-excel-file-in-database-2

Now, import file.

After Upload Screen Output:-

laravel-6-import-export-excel-file-in-database-3

Now, click “Export File” to export data into csv file.

laravel-6-import-export-excel-file-in-database-4

I hope you like this laravel 6 Import Export Excel CSV File to Database tutorial.

Laravel 7/6 Intervention Upload Image Using Ajax

In this Laravel Intervention Image Upload Using Ajax example, we will learn how to upload and resize image using jquery ajax. In this tutorial I have used Intervention Image Package to upload and resize the image using jquery ajax and then save image into the database. This laravel image upload example is works with laravel version7, 6, 5.8 & 5.7 .

In this laravel image upload example, I’ll show you how to upload image into folder and then save it into database. In this tutorial before saving image into database we will resize the image and create it’s thumbnail image and then save it into thumbnail directory using the image intervention package.

Before uploading the image we will validate it using server side validation. In this example we will be uploading the image using jquery ajax without page refresh and reload. After successfully image upload into the database and folder we will display original image along with its thumbnail image (resize image).

Install Laravel Fresh Setup
Setup Database
Install Image Intervention Package
Generate migration file and model
Make Route
Create Controller & Methods
Create Blade View
Make Folder
Run Development Server
Conclusion

1). Install Laravel Fresh Setup

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

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

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

2). Setup 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=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

3). Install Image Intervention Package

In this step, we will install Image intervention Package via the composer dependency manager. Use the following command to install image intervention Package.

 composer  require intervention/image

1	composer require intervention/image

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

config/app.php

config/app.php

 'providers' => [
 Intervention\Image\ImageServiceProvider::class
 ],

 'aliases' => [
 'Image' => Intervention\Image\Facades\Image::class
 ]

config/app.php

'providers' => [

Intervention\Image\ImageServiceProvider::class

'aliases' => [

'Image' => Intervention\Image\Facades\Image::class

]

4). Generate Migration & Model

php artisan make:model Photo -m

1	php artisan make:model Photo -m

It command will create one model name Photo and also create one migration file for the Photo table. After successfully run the command go to database/migrations file and replace function, below here :

public function up()

{

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

    $table->increments('id');

    $table->string('photo_name');

    $table->timestamps();

});

}

public function up()

{

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

$table->increments('id');

$table->string('photo_name');

$table->timestamps();

});

}

Before we run PHP artisan migrate command go to app/providers/AppServiceProvider.php and put the below code :

...
use Illuminate\Support\Facades\Schema;
 
....
function boot()
{
    Schema::defaultStringLength(191);
}
...

...

use Illuminate\Support\Facades\Schema;

....

function boot()

{

Schema::defaultStringLength(191);

}

...

Next, migrate the table using the below command :

php artisan migrate

1	php artisan migrate

5). Make Route

now, create two routes in the web.php file.

web.php

 Route::get('image', 'ImageController@index');
 Route::post('save-image', 'ImageController@save');

1 2	Route::get('image', 'ImageController@index'); Route::post('save-image', 'ImageController@save');

6). Create Controller

Next, we have to create a controller for image uploading and resizing. Create a controller named ImageController using command given below –

php artisan make:controller ImageController

1	php artisan make:controller ImageController

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

app/Http/Controllers/ImageController.php

<?php
 
namespace App\Http\Controllers;
 
use Illuminate\Http\Request;
use Validator,Redirect,Response,File;
Use Image;
Use App\Photo;
use Intervention\Image\Exception\NotReadableException;
 
 
class ImageController extends Controller
{
 
public function index()
{
  return view('image');
}
 
public function save(Request $request)
{
 request()->validate([
      'photo_name' => 'required|image|mimes:jpeg,png,jpg,gif,svg|max:2048',
 ]);
 
 if ($files = $request->file('photo_name')) {
     
    // for save original image
    $ImageUpload = Image::make($files);
    $originalPath = 'public/images/';
    $ImageUpload->save($originalPath.time().$files->getClientOriginalName());
     
    // for save thumnail image
    $thumbnailPath = 'public/thumbnail/';
    $ImageUpload->resize(250,125);
    $ImageUpload = $ImageUpload->save($thumbnailPath.time().$files->getClientOriginalName());
 
  $photo = new Photo();
  $photo->photo_name = time().$files->getClientOriginalName();
  $photo->save();
  }
 
  $image = Photo::latest()->first(['photo_name']);
  return Response()->json($image);
 
 
}
}

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use Validator,Redirect,Response,File;

Use Image;

Use App\Photo;

use Intervention\Image\Exception\NotReadableException;

class ImageController extends Controller

{

public function index()

{

return view('image');

}

public function save(Request $request)

{

request()->validate([

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

]);

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

// for save original image

$ImageUpload = Image::make($files);

$originalPath = 'public/images/';

$ImageUpload->save($originalPath.time().$files->getClientOriginalName());

// for save thumnail image

$thumbnailPath = 'public/thumbnail/';

$ImageUpload->resize(250,125);

$ImageUpload = $ImageUpload->save($thumbnailPath.time().$files->getClientOriginalName());

$photo = new Photo();

$photo->photo_name = time().$files->getClientOriginalName();

$photo->save();

}

$image = Photo::latest()->first(['photo_name']);

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

}

7). Create Blade view

In this step, we need to create a blade view file. Go to app/resources/views and create one file name image.blade.php :

<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="ie=edge">
<meta name="csrf-token" content="{{ csrf_token() }}">
<title>Laravel Ajax Image Upload Using Intervention Package Example</title>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/4.1.3/css/bootstrap.min.css" />
<script src="//ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.js"></script>
<style>
.avatar-pic {
width: 300px;
}
</style>
</head>
<body>
<div class="container">
<h3 style="margin-top: 12px;" class="text-center alert alert-success">Laravel Ajax Image Upload Using Intervention Package Example</h3>
<br>
<div class="row justify-content-center">
<div class="col-md-8">
<form id="imageUploadForm" action="javascript:void(0)" enctype="multipart/form-data">
<div class="file-field">
<div class="row">
<div class=" col-md-8 mb-4">
<img id="original" src="" class=" z-depth-1-half avatar-pic" alt="">
<div class="d-flex justify-content-center mt-3">
<div class="btn btn-mdb-color btn-rounded float-left">
<input type="file" name="photo_name" id="photo_name" required=""> <br>
<button type="submit" class="btn btn-secondary d-flex justify-content-center mt-3">submit</button>
</div>
</div>
</div>
<div class=" col-md-4 mb-4">
<img id="thumbImg" src="" class=" z-depth-1-half thumb-pic"
alt="">
</div>
</div>
</form>
</div>
</div>
</div>
</body>
</html>

<!DOCTYPE html>

<html>

<head>

<title>Laravel Ajax Image Upload Using Intervention Package Example</title>

<style>

.avatar-pic {

width: 300px;

}

</style>

</head>

<body>

<h3 style="margin-top: 12px;" class="text-center alert alert-success">Laravel Ajax Image Upload Using Intervention Package Example</h3>

<br>

<button type="submit" class="btn btn-secondary d-flex justify-content-center mt-3">submit</button>

</div>

<img id="thumbImg" src="" class=" z-depth-1-half thumb-pic"

alt="">

</div>

</form>

</div>

</body>

</html>

Now we will implement a laravel ajax image upload script, put the below script after the closing of the body tag.

<script>
 
$(document).ready(function (e) {
 
$('#imageUploadForm').on('submit',(function(e) {
 
$.ajaxSetup({
 
headers: {
 
  'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
 
}
 
});
 
e.preventDefault();
 
var formData = new FormData(this);
 
 
 
$.ajax({
 
   type:'POST',
 
   url: "{{ url('save-image')}}",
 
   data:formData,
 
   cache:false,
 
   contentType: false,
 
   processData: false,
 
   success:function(data){
 
       $('#original').attr('src', 'public/images/'+ data.photo_name);
 
       $('#thumbImg').attr('src', 'public/thumbnail/'+ data.photo_name);
 
   },
 
   error: function(data){
 
       console.log(data);
 
   }
 
});
 
}));
 
});
 
</script>

$(document).ready(function (e) {

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

$.ajaxSetup({

headers: {

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

}

});

e.preventDefault();

var formData = new FormData(this);

$.ajax({

type:'POST',

url: "{{ url('save-image')}}",

data:formData,

cache:false,

contentType: false,

processData: false,

success:function(data){

$('#original').attr('src', 'public/images/'+ data.photo_name);

$('#thumbImg').attr('src', 'public/thumbnail/'+ data.photo_name);

error: function(data){

console.log(data);

}

});

}));

});

</script>

8). Make Folder

Go to public folder 
=> first create folder name images
=> second create folder name thumbnail

Go to public folder

=> first create folder name images

=> second create folder name thumbnail

9). Run Development Server

php artisan serve
 If you want to run the project diffrent port so use this below command 
 php artisan serve --port=8080

php artisan serve

If you want to run the project diffrent port so use this below command

php artisan serve --port=8080

Now we are ready to run our example so run bellow command to quick run.

http://127.0.0.1:8000/image

1	http://127.0.0.1:8000/image

Laravel 7/6 Yajra DataTables Example Tutorial

In this Laravel 7, 6 Yajra DataTables Example tutorial, I’ll show you how to install and use yajra DataTables in your laravel projects with example. In this tutorial, we will be using yajra datatable package for listing of records with pagination, sorting and filter (search) feature. Laravel Yajra datatables package comes with many built-in features for searching and sorting functionality.

Laravel 7/6 Yajra DataTables Example Tutorial

In this step by step tutorial I’ll guide you through the steps to install and use yajra DataTables with your laravel project:

Install Laravel
Configuration .env file
Run Migration
Install Yajra DataTables
Add Fake Data
Create Route, Controller & Blade View
Start Development Server

Install Laravel 7/6

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

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

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

Configure Database In .env file

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=

Run Migration

Now, we need to create migration of tables using following command:

php artisan migrate

1	php artisan migrate

Install Yajra Datatable Package

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,

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

php artisan vendor:publish

1	php artisan vendor:publish

Add Fake Records

Now, we need to add some fake records in the database.

php artisan tinker

1	php artisan tinker

Running this command will add some fake records in your database table.

>>> factory(App\User::class, 150)->create();

1	>>> factory(App\User::class, 150)->create();

Add Route

Now add routes in web.php file as following:

routes/web.php

Route::get('users', 'UsersController@index');
<strong></strong>Route::get('users-list', 'UsersController@usersList');

1 2	Route::get('users', 'UsersController@index'); <strong></strong>Route::get('users-list', 'UsersController@usersList');

Create Controller

Now, create a new controller UsersController using following artisan command:

php artisan make:controller UsersController

1	php artisan make:controller UsersController

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

app/Http/Controllers/UsersController.php

<?php
 
namespace App\Http\Controllers;
 
use Illuminate\Http\Request;
use Redirect,Response,DB,Config;
use Datatables;
class UsersController extends Controller
{
    public function index()
    {
        return view('users');
    }
    public function usersList()
    {
        $users = DB::table('users')->select('*');
        return datatables()->of($users)
            ->make(true);
    }
}

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use Redirect,Response,DB,Config;

use Datatables;

class UsersController extends Controller

{

public function index()

{

return view('users');

}

public function usersList()

{

$users = DB::table('users')->select('*');

return datatables()->of($users)

->make(true);

}

Create Blade / View Files

In this step, we will create view/blade file. Lets create a blade file “users.blade.php” in “resources/views/” directory and put the following code in it respectively.

resources/views/users.blade.php

<!DOCTYPE html>
 
<html lang="en">
<head>
<title>Laravel DataTable - Tuts Make</title>
<link href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" rel="stylesheet">  
<link  href="https://cdn.datatables.net/1.10.16/css/jquery.dataTables.min.css" rel="stylesheet">
<script src="//ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.js"></script>  
<script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js"></script>
<script src="https://cdn.datatables.net/1.10.16/js/jquery.dataTables.min.js"></script>
</head>
      <body>
         <div class="container">
               <h2>Laravel DataTable - Tuts Make</h2>
            <table class="table table-bordered" id="laravel_datatable">
               <thead>
                  <tr>
                     <th>Id</th>
                     <th>Name</th>
                     <th>Email</th>
                     <th>Created at</th>
                  </tr>
               </thead>
            </table>
         </div>
   <script>
   $(document).ready( function () {
    $('#laravel_datatable').DataTable({
           processing: true,
           serverSide: true,
           ajax: "{{ url('users-list') }}",
           columns: [
                    { data: 'id', name: 'id' },
                    { data: 'name', name: 'name' },
                    { data: 'email', name: 'email' },
                    { data: 'created_at', name: 'created_at' }
                 ]
        });
     });
  </script>
   </body>
</html>

<!DOCTYPE html>

<head>

<title>Laravel DataTable - Tuts Make</title>

</head>

<body>

<h2>Laravel DataTable - Tuts Make</h2>

<thead>

<tr>

<th>Email</th>

<th>Created at</th>

</tr>

</thead>

</table>

</div>

$(document).ready( function () {

$('#laravel_datatable').DataTable({

processing: true,

serverSide: true,

ajax: "{{ url('users-list') }}",

columns: [

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

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

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

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

]

});

</script>

</body>

</html>

Start Development Server

Let’s start the development server using following artisan command:

php artisan serve

1	php artisan serve

Now, visit the following link in browser to see the output:

http://localhost:8000/users

1	http://localhost:8000/users

Laravel 7/6 Yajra DataTables Custom Search Example Tutorial

In this Laravel 7/6 Yajra DataTables Custom Search Example Tutorial, I’ll show you how to add custom search or data filter to datatables. In this tutorial, we will be using yajra datatable package for listing of records with pagination, sorting and filter (search) feature. Laravel Yajra datatables package comes with many built-in features for searching and sorting functionality. In this article you will learn to add custom field for searching data without reloading or refreshing of page.

Install Laravel 7/6

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

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

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

Configure Database In .env file

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=

Generate Application Key

Open terminal and switch to the project directory and run the following command to generate application key and configure cache.

php artisan key:generate

1	php artisan key:generate

php artisan config:cache

1	php artisan config:cache

Set Default String Length

Locate the file “app/Providers/AppServiceProvider”, and add following line of code to the top of the file

use Illuminate\Support\Facades\Schema;

1	use Illuminate\Support\Facades\Schema;

and inside the boot method set a default string length as given below –

Schema::defaultStringLength(191);

1	Schema::defaultStringLength(191);

So this is how “app/Providers/AppServiceProvider” file looks like –

<?php
namespace App\Providers;
use Illuminate\Support\ServiceProvider;
use Illuminate\Support\Facades\Schema;

class AppServiceProvider extends ServiceProvider
{
 public function boot() {
 //
 Schema::defaultStringLength(191);
}
 public function register()
 {
 //
 }
}

<?php

namespace App\Providers;

use Illuminate\Support\ServiceProvider;

use Illuminate\Support\Facades\Schema;

class AppServiceProvider extends ServiceProvider

{

public function boot() {

Schema::defaultStringLength(191);

}

public function register()

{

}

Create Database Table

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

php artisan make:migration create_posts_table --create=posts

1	php artisan make:migration create_posts_table --create=posts

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 –

<?php

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

class CreatePostsTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('posts', function (Blueprint $table) {
            $table->bigIncrements('id');
            $table->string('title');
            $table->string('body');
            $table->timestamps();
        });
    }

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

<?php

use Illuminate\Support\Facades\Schema;

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Database\Migrations\Migration;

class CreatePostsTable extends Migration

{

/**

* Run the migrations.

* @return void

public function up()

{

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

$table->bigIncrements('id');

$table->string('title');

$table->string('body');

$table->timestamps();

});

}

/**

* Reverse the migrations.

* @return void

public function down()

{

Schema::dropIfExists('posts');

}

Run Migration

Now, run following command to migrate database schema.

php artisan migrate

1	php artisan migrate

After, the migration executed successfully the posts table will be created in database along with migrations, password_resets and users table.

Create Model

Next, we need to create a model called Post using below command.

php artisan make:model Post

1	php artisan make:model Post

Once, the above command is executed it will create a model file Post.php in app directory. Next, we have to assign fillable fields using fillable property inside Post.php file. Open app/Post.php file and put the following code in it –

app/Post.php

<?php
namespace App;
use Illuminate\Database\Eloquent\Model;

class Post extends Model
{
    //
    protected $fillable = [
        'title', 'body'
    ];
}

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Post extends Model

{

protected $fillable = [

'title', 'body'

];

}

Install Yajra Datatable Package

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,

Create Controller

Next, we have to create a controller to handle Ajax CRUD Operations. Create a controller named AjaxCrudController using command given below –

php artisan make:controller dtable/AjaxCrudController

1	php artisan make:controller dtable/AjaxCrudController

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

app/Http/Controllers/dtable/AjaxCrudController.php

<?php

namespace App\Http\Controllers\dtable;

use Illuminate\Http\Request;
use App\Http\Controllers\Controller;
use App\Post;
use Redirect,Response;

class AjaxCrudController extends Controller
{

    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
         return view('dtable.custom_filter');
    }

    public function get_custom_posts(){
        $postsQuery = Post::query();

        $start_date = (!empty($_GET["start_date"])) ? ($_GET["start_date"]) : ('');
        $end_date = (!empty($_GET["end_date"])) ? ($_GET["end_date"]) : ('');

        if($start_date && $end_date){
    
         $start_date = date('Y-m-d', strtotime($start_date));
         $end_date = date('Y-m-d', strtotime($end_date));
         
         $postsQuery->whereRaw("date(posts.created_at) >= '" . $start_date . "' AND date(posts.created_at) <= '" . $end_date . "'");
        }
        $posts = $postsQuery->select('*');
        return datatables()->of($posts)
            ->make(true);
    }

}

<?php

namespace App\Http\Controllers\dtable;

use Illuminate\Http\Request;

use App\Http\Controllers\Controller;

use App\Post;

use Redirect,Response;

class AjaxCrudController extends Controller

{

/**

* Display a listing of the resource.

* @return \Illuminate\Http\Response

public function index()

{

return view('dtable.custom_filter');

}

public function get_custom_posts(){

$postsQuery = Post::query();

$start_date = (!empty($_GET["start_date"])) ? ($_GET["start_date"]) : ('');

$end_date = (!empty($_GET["end_date"])) ? ($_GET["end_date"]) : ('');

if($start_date && $end_date){

$start_date = date('Y-m-d', strtotime($start_date));

$end_date = date('Y-m-d', strtotime($end_date));

$postsQuery->whereRaw("date(posts.created_at) >= '" . $start_date . "' AND date(posts.created_at) <= '" . $end_date . "'");

}

$posts = $postsQuery->select('*');

return datatables()->of($posts)

->make(true);

}

Create Blade / View Files

In this step, we will create view/blade file to perform CRUD Operations. Lets create a blade file “custom_filter.blade.php” in “resources/views/dtable/” directory and put the following code in it respectively.

resources/views/dtable/custom_filter.blade.php

<!DOCTYPE html>
 
<html lang="en">
<head>
<!-- CSRF Token -->
<meta name="csrf-token" content="{{ csrf_token() }}">
<title>Laravel Custom Datatables filter and Search</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">
<h2>Laravel Custom Datatables filter and Search</h2>
    <div class="form-group col-md-6">
    <h5>Start Date <span class="text-danger"></span></h5>
    <div class="controls">
        <input type="date" name="start_date" id="start_date" class="form-control datepicker-autoclose" placeholder="Please select start date"> <div class="help-block"></div></div>
    </div>
    <div class="form-group col-md-6">
    <h5>End Date <span class="text-danger"></span></h5>
    <div class="controls">
        <input type="date" name="end_date" id="end_date" class="form-control datepicker-autoclose" placeholder="Please select end date"> <div class="help-block"></div></div>
    </div>
    <div class="text-left" style="
    margin-left: 15px;
    ">
    <button type="text" id="btnFiterSubmitSearch" class="btn btn-info">Submit</button>
    </div>
    
    <br>
 
    <table class="table table-bordered table-striped" id="laravel_datatable">
       <thead>
          <tr>
             <th>ID</th>
             <th>Title</th>
             <th>Body</th>
             <th>Created at</th>
          </tr>
       </thead>
    </table>
</div>
 

</body>
</html>
<script>
$(document).ready( function () {
   $.ajaxSetup({
      headers: {
          'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
      }
  });

  $('#laravel_datatable').DataTable({
         processing: true,
         serverSide: true,
         ajax: {
          url: "{{ url('dtable-custom-posts') }}",
          type: 'GET',
          data: function (d) {
          d.start_date = $('#start_date').val();
          d.end_date = $('#end_date').val();
          }
         },
         columns: [
                  { data: 'id', name: 'id', 'visible': false},
                  { data: 'title', name: 'title' },
                  { data: 'body', name: 'body' },
                  { data: 'created_at', name: 'created_at' },
               ],
        order: [[0, 'desc']]
  });
  
});

$('#btnFiterSubmitSearch').click(function(){
     $('#laravel_datatable').DataTable().draw(true);
}); 

</script>

<!DOCTYPE html>

<head>

<title>Laravel Custom Datatables filter and Search</title>

</head>

<body>

<h2>Laravel Custom Datatables filter and Search</h2>

<h5>Start Date <span class="text-danger"></span></h5>

</div>

</div>

<div class="text-left" style="

margin-left: 15px;

<button type="text" id="btnFiterSubmitSearch" class="btn btn-info">Submit</button>

</div>

<br>

<thead>

<tr>

<th>Title</th>

<th>Created at</th>

</tr>

</thead>

</table>

</div>

</body>

</html>

$(document).ready( function () {

$.ajaxSetup({

headers: {

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

}

});

$('#laravel_datatable').DataTable({

processing: true,

serverSide: true,

ajax: {

url: "{{ url('dtable-custom-posts') }}",

type: 'GET',

data: function (d) {

d.start_date = $('#start_date').val();

d.end_date = $('#end_date').val();

}

columns: [

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

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

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

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

order: [[0, 'desc']]

});

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

$('#laravel_datatable').DataTable().draw(true);

});

</script>

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

Route::get('dtable-posts-lists', 'dtable\AjaxCrudController@index');
Route::get('dtable-custom-posts', 'dtable\AjaxCrudController@get_custom_posts');

1 2	Route::get('dtable-posts-lists', 'dtable\AjaxCrudController@index'); Route::get('dtable-custom-posts', 'dtable\AjaxCrudController@get_custom_posts');

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/dtable-posts-lists

Laravel 7/6 Send Email Using Mailable Class Tutorial

In this Laravel 7 send email example using mailable tutorial I’ll show you how to send email in laravel using a mailable class with example. In this step by step tutorial I’ll guide you through how to send email in laravel using SMTP driver. Laravel provides an API with driver support for SMTP, SendMail, Mailgun, Sendgrid, Mandrill, Amazon SES, SpartPost, etc. In this tutorial we will use simple example of mailable class to send email in laravel application.

Laravel Send Email Using Mailable Class Example

Install laravel Fresh Setup
Configuration SMTP in .env
Mailable Class
Create Route & Blade View
Create Controller & Method
Run Development Server

Install Laravel 8

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

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

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

Configure Database In .env file

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=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=

Configuration SMTP in .env

Now we will configure SMTP credentials in the .env file. Let’s open .env file.

.env

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

Mailable Class

Now, create a mailable class for sending emails, use the following command :

php artisan make:mail MailNotify

1	php artisan make:mail MailNotify

<?php
 
namespace App\Mail;
 
use Illuminate\Bus\Queueable;
use Illuminate\Mail\Mailable;
use Illuminate\Queue\SerializesModels;
use Illuminate\Contracts\Queue\ShouldQueue;
 
class MailNotify extends Mailable
{
    use Queueable, SerializesModels;
 
    /**
     * Create a new message instance.
     *
     * @return void
     */
    public function __construct()
    {
        //
    }
 
    /**
     * Build the message.
     *
     * @return $this
     */
    public function build()
    {
        return $this->view('view.name');
        //here is your blade view name
    }
}

<?php

namespace App\Mail;

use Illuminate\Bus\Queueable;

use Illuminate\Mail\Mailable;

use Illuminate\Queue\SerializesModels;

use Illuminate\Contracts\Queue\ShouldQueue;

class MailNotify extends Mailable

{

use Queueable, SerializesModels;

/**

* Create a new message instance.

* @return void

public function __construct()

{

}

/**

* Build the message.

* @return $this

public function build()

{

return $this->view('view.name');

//here is your blade view name

}

Create Route & Blade View

Now, we need to create a route to send email, open your routes/web.php input the below route :

Route::get('laravel-send-email', 'EmailController@sendEmail');

1	Route::get('laravel-send-email', 'EmailController@sendEmail');

Next, we will create an email blade view file in views folder of view. Go to the resources/views/emails and create a view file name email.blade.php. Put bellow code:

<!DOCTYPE html>
<html>
<head>
 <title>Laravel Send Email Example</title>
</head>
<body>
 
 <h1>This is test mail</h1>
 <p>Thank you, {{ $user->name }}</p>
 
</body>
</html>

<!DOCTYPE html>

<html>

<head>

<title>Laravel Send Email Example</title>

</head>

<body>

<p>Thank you, {{ $user->name }}</p>

</body>

</html>

Create Controller & Method

In this step we will create a new controller EmailController with one method to send email. Open your terminal and run following command to create controller:

php artisan make:controller EmailController

1	php artisan make:controller EmailController

Now open the controller file and put the following code in it:

<?php
 
namespace App\Http\Controllers;
 
use Illuminate\Http\Request;
use Redirect,Response,DB,Config;
use Mail;
class EmailController extends Controller
{
    public function sendEmail()
    {
      $user = auth()->user();
      Mail::to($user)->send(new MailNotify($user));
 
      if (Mail::failures()) {
           return response()->Fail('Sorry! Please try again latter');
      }else{
           return response()->success('Great! Successfully send in your mail');
         }
    }
}

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use Redirect,Response,DB,Config;

use Mail;

class EmailController extends Controller

{

public function sendEmail()

{

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

Mail::to($user)->send(new MailNotify($user));

if (Mail::failures()) {

return response()->Fail('Sorry! Please try again latter');

}else{

return response()->success('Great! Successfully send in your mail');

}

Run Development Server

In this step, we will start the development server using following command:

php artisan serve

1	php artisan serve

Now, visit the following link to send email:

http://localhost:8000/laravel-send-email

1	http://localhost:8000/laravel-send-email

Laravel 7/6 Multi Auth( Authentication) Example Tutorial

In this Laravel multi (auth) authentication tutorial I’ll show you how to create multi auth system in laravel 7/6. In Laravel Multiple authentication multiple users can log in in one application according to roles.

Laravel 7/6 Multi Auth( Authentication) Example Tutorial

While developing a laravel application there comes situations where we want create separate user login or separate user/admin panel for users having different privileges or access rights in same application. In this laravel multi auth system, we will create a middleware for checking the user’s role. It is an admin or normal user. We will create middleware name admin and configuration in the kernal.php file and also in the route file.

Install Laravel 6

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

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

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

Configure Database In .env file

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=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=

Migrations and User Model

After installing laravel, you will see the some migration files created inside database/migrations directory for creating default create users table and password reset table. Open app/database/create_users_table.php migration file and add/update the following field for admin.

$table->boolean('is_admin')->nullable();

1	$table->boolean('is_admin')->nullable();

After you added a column “is_admin” to user table run the migration using following command.

php artisan migrate

1	php artisan migrate

After this, go to app/User.php and add is_admin to fillable attribute in the User Model.

protected $fillable = [
'name', 'email', 'password', 'is_admin'
];

protected $fillable = [

'name', 'email', 'password', 'is_admin'

];

Authentication Scaffolding

Laravel comes with in-built basic authentication system, use the below command to generate default authentication scaffolding –

php artisan make:auth

1	php artisan make:auth

This command will generate required Controller files, views and add routes in our web.php routes file that are required for basic authentication system.

Create Admin Middleware

Now, we will create a middleware that authenticate users. This middleware will help to make sure who can access the admin area or who can access the normal user area. Use the following command to generate a middleware for Admin.

php artisan make:middleware Admin

1	php artisan make:middleware Admin

Next, open app/Http/ Middleware/Admin.php file, and here in handle() method implement the logic to authenticate users like below.

public function handle($request, Closure $next){

    if(auth()->user()->is_admin == 1){
        return $next($request);
    }
        return redirect('home')->with('error','You have no admin access');
}

public function handle($request, Closure $next){

if(auth()->user()->is_admin == 1){

return $next($request);

}

return redirect('home')->with('error','You have no admin access');

}

Register Admin Routes

Now, we need to register admin route in $routeMiddleware property in the app/Http/Kernel.php file. Lets open app/Http/Kernel.php file and update the $routeMiddleware property like below –

protected $routeMiddleware = [
        'auth' => \App\Http\Middleware\Authenticate::class,
        'auth.basic' => \Illuminate\Auth\Middleware\AuthenticateWithBasicAuth::class,
        'bindings' => \Illuminate\Routing\Middleware\SubstituteBindings::class,
        'cache.headers' => \Illuminate\Http\Middleware\SetCacheHeaders::class,
        'can' => \Illuminate\Auth\Middleware\Authorize::class,
        'guest' => \App\Http\Middleware\RedirectIfAuthenticated::class,
        'signed' => \Illuminate\Routing\Middleware\ValidateSignature::class,
        'throttle' => \Illuminate\Routing\Middleware\ThrottleRequests::class,
        'verified' => \Illuminate\Auth\Middleware\EnsureEmailIsVerified::class,
        'admin' => \App\Http\Middleware\Admin::class,
    ];

protected $routeMiddleware = [

'auth' => \App\Http\Middleware\Authenticate::class,

'auth.basic' => \Illuminate\Auth\Middleware\AuthenticateWithBasicAuth::class,

'bindings' => \Illuminate\Routing\Middleware\SubstituteBindings::class,

'cache.headers' => \Illuminate\Http\Middleware\SetCacheHeaders::class,

'can' => \Illuminate\Auth\Middleware\Authorize::class,

'guest' => \App\Http\Middleware\RedirectIfAuthenticated::class,

'signed' => \Illuminate\Routing\Middleware\ValidateSignature::class,

'throttle' => \Illuminate\Routing\Middleware\ThrottleRequests::class,

'verified' => \Illuminate\Auth\Middleware\EnsureEmailIsVerified::class,

'admin' => \App\Http\Middleware\Admin::class,

];

Set Admin Protected Route

Next, create the route for admin. Open the routes/web.php file and add the following code in it.

routes/web.php

Route::get('admin/routes', 'HomeController@admin')->middleware('admin');

1	Route::get('admin/routes', 'HomeController@admin')->middleware('admin');

Create Controller Methods

Open the app/Http/Controllers/HomeController.php controller file and create two separate methods to handle admin and normal users.

app/Http/Controllers/HomeController.php

public function index(){

	return view('home');
}

public function admin(){

	return view('admin');
}

public function index(){

return view('home');

}

public function admin(){

return view('admin');

}

Create Blade/View

Now we will have two separate view files, first is for home page and second is for after login admin page. Open the resources/views/home.blade.php file and update the following code.

resources/views/home.blade.php

@extends('layouts.app')
 
@section('content')
<div class="container">
    <div class="row justify-content-center">
        <div class="col-md-8">
            <div class="card">
                <div class="card-header">Dashboard</div>
 
                <div class="card-body">
                    @if(auth()->user()->is_admin == 1)
                    <a href="{{url('admin/routes')}}">Admin</a>
                    @else
                    <div class="panel-heading">Normal User</div>
                    @endif
                </div>
            </div>
        </div>
    </div>
</div>
@endsection

@extends('layouts.app')

@section('content')

<div class="card-header">Dashboard</div>

@if(auth()->user()->is_admin == 1)

<a href="{{url('admin/routes')}}">Admin</a>

@else

<div class="panel-heading">Normal User</div>

@endif

</div>

@endsection

Here, if(auth()->user()->is_admin == 1) is used to check user is a normal user or an admin user, it will navigate to the admin area. Otherwise, it will redirect to users area.

Now, create a view file called admin.blade.php in the root of the views folder, and add the following code to it.

resources/views/admin.blade.php

@extends('layouts.app')

@section('content')

<div class="row">

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

<div class="panel panel-default">

<div class="panel-heading btn-primary">WELCOME TO ADMIN ROUTE</div>

</div>

</div>

</div>

@endsection

@extends('layouts.app')

@section('content')

<div class="panel-heading btn-primary">WELCOME TO ADMIN ROUTE</div>

</div>

@endsection

Start Development Server

Start the development server using following artisan command –

php artisan serve

1	php artisan serve

In order to test laravel multi auth system first register a user through laravel register and then change the is_admin=1; and try to login again.

User Home 1 :-

laravel-multi-auth-2

After Login Admin Page :-

laravel-multi-auth-1

User Home 2 :-

laravel-multi-auth-3

Laravel 7/6 QR Code Generator Example

In this Laravel 7/6 QR Code Generator Example article, I’ll show you how to generate qr codes with any text, size, color, background color, format like png, eps, svg. In this laravel qr code example, we will be using simple-qrcode package to generate QR codes.The simple-qrcode package is used to generate qr code in your laravel application. The simple-qrcode package has many options for creating qr codes. You can also create qr code for geo, phone number, text message using simple qrcode package. The simple-qrcode package is very easy to install and use.

Install Laravel 7/6

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

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

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

Install simple-qrcode Package

In this step, we will install simple-qrcode Package via the composer dependency manager. Use the following command to install simple-qrcode Package.

composer require simplesoftwareio/simple-qrcode

1	composer require simplesoftwareio/simple-qrcode

Register Package

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

config/app.php

'providers' => [
 ….
 SimpleSoftwareIO\QrCode\QrCodeServiceProvider::class
 ],

'aliases' => [
 ….
 'QrCode' => SimpleSoftwareIO\QrCode\Facades\QrCode::class
 ],

'providers' => [

….

SimpleSoftwareIO\QrCode\QrCodeServiceProvider::class

'aliases' => [

….

'QrCode' => SimpleSoftwareIO\QrCode\Facades\QrCode::class

Basic Usage Of simple-qrcode Package

Qr code with specified string can be generated as follows –

Syntax:-

QrCode::generate("string")

1	QrCode::generate("string")

Simple QR Code :-

Simple Qr code with specified string can be generated using generate() method. Add a simple-qr-code route to your routes/web.php file to return simple QR code as follows –

Route::get('simple-qr-code', function () {
     return QrCode::size(200)->generate('W3Adda Laravel Tutorial');
});

Route::get('simple-qr-code', function () {

return QrCode::size(200)->generate('W3Adda Laravel Tutorial');

});

Here, size() function is used to specify the size of the QR Code. Visit (http://localhost:8000/simple-qr-code) to see the QR code. Scan the QR code and you will see the text. You can also display the QR code in Blade file as follows –

{!! QrCode::size(200)->generate('W3Adda Laravel Tutorial'); !!}

1	{!! QrCode::size(200)->generate('W3Adda Laravel Tutorial'); !!}

QR Code with Color :-

You can also set color for QR code pattern and the background using color(R, G, B) and backgroundColor(R, G, B) methods.

Add a color-qr-code route to your routes/web.php file to return colored QR code as follows –

Route::get('color-qr-code', function () {
     return QrCode::size(200)->backgroundColor(255,55,0)->generate('W3Adda Laravel Tutorial');
});

Route::get('color-qr-code', function () {

return QrCode::size(200)->backgroundColor(255,55,0)->generate('W3Adda Laravel Tutorial');

});

Visit (http://localhost:8000/color-qr-code) to see the colored QR code. Or you can simply display the colored QR code in Blade file as follows –

{!! QrCode::size(200)->backgroundColor(255,55,0)->generate('W3Adda Laravel Tutorial'); !!}

1	{!! QrCode::size(200)->backgroundColor(255,55,0)->generate('W3Adda Laravel Tutorial'); !!}

QR Code with Image :-

You can also place an image in QR code using the merge(“file_name.png”) method, this method only accept png files and you also need to format the response back to png.

Add a qr-code-with-image route to your routes/web.php file to return QR code with image as follows –

Route::get('qr-code-with-image', function () {
 $image = QrCode::format('png')->merge('http://w3adda.com/wp-content/uploads/2019/07/laravel.png', 0.3, true)
                ->size(200)->errorCorrection('H')
                ->generate('W3Adda Laravel Tutorial');
return response($image)->header('Content-type','image/png');
});

Route::get('qr-code-with-image', function () {

$image = QrCode::format('png')->merge('http://w3adda.com/wp-content/uploads/2019/07/laravel.png', 0.3, true)

->size(200)->errorCorrection('H')

->generate('W3Adda Laravel Tutorial');

return response($image)->header('Content-type','image/png');

});

Visit (http://localhost:8000/qr-code-with-image) to see the QR code with Image merged. Or you can simply display the QR code with Image in Blade file using <img> tag as follows –

<img src="data:image/png;base64, {!! base64_encode(QrCode::format('png')->merge('http://w3adda.com/wp-content/uploads/2019/07/laravel.png', 0.3, true)
                        ->size(200)->errorCorrection('H')
                        ->generate('W3Adda Laravel Tutorial')) !!} ">

<img src="data:image/png;base64, {!! base64_encode(QrCode::format('png')->merge('http://w3adda.com/wp-content/uploads/2019/07/laravel.png', 0.3, true)

->size(200)->errorCorrection('H')

->generate('W3Adda Laravel Tutorial')) !!} ">

Email QR code :-

You can encode QR codes that automatically fill-in email address, subject and body of the email.

Syntax:-

QrCode::email($to_address, $subject, $body);

1	QrCode::email($to_address, $subject, $body);

Example:-

//Specify just email address
QrCode::email('john@w3adda.com');

//Specify subject and the body, let user enter the to_address
QrCode::email(null, 'Test message subject', 'This is message body.');

//Specify email address, subject and the body
QrCode::email('john@w3adda.com', 'Thank you for visiting w3adda.com', 'Laravel Tutorial');

//Specify just email address

QrCode::email('john@w3adda.com');

//Specify subject and the body, let user enter the to_address

QrCode::email(null, 'Test message subject', 'This is message body.');

//Specify email address, subject and the body

QrCode::email('john@w3adda.com', 'Thank you for visiting w3adda.com', 'Laravel Tutorial');

QR Code Phone Number :-

You can encode QR codes such that it automatically open up the phone dialer and dial the phone number.

Syntax:-

QrCode::phoneNumber($number);

1	QrCode::phoneNumber($number);

Example:-

QrCode::phoneNumber('123-456-7890');

1	QrCode::phoneNumber('123-456-7890');

QR Code Text Message :-

You can encode QR codes such that it automatically open up the phone messenger and fill-in phone number or the message body.

Syntax:-

QrCode::SMS(<number>, <message>);

1	QrCode::SMS(<number>, <message>);

Example:-

//scan the phone number to send the message
QrCode::SMS('123-456-7890');
 
//scan phone number along with the message
QrCode::SMS('123-456-7890', 'Message Body');

//scan the phone number to send the message

QrCode::SMS('123-456-7890');

//scan phone number along with the message

QrCode::SMS('123-456-7890', 'Message Body');

QR Code Geo co-ordinates :-

You can encode QR codes such that it automatically open up map application with the specified location.

Syntax:-

QrCode::geo(<latitude>, <longitude>);

1	QrCode::geo(<latitude>, <longitude>);

Example:-

QrCode::geo(15.3544, 75.787980);

1	QrCode::geo(15.3544, 75.787980);

Create Blade / View Files

In this step, we will create view/blade file to generate and display QR Codes. Lets create a blade file “index.blade.php” in “resources/views/qrcode/” directory and put the following code in it respectively.

resources/views/qrcode/index.blade.php

<!DOCTYPE html>
<html>
<head>
<title>Laravel Generate QR Code Tutorial with Example</title>
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/twitter-bootstrap/4.1.3/css/bootstrap.min.css" />
<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.1.3/js/bootstrap.min.js"></script>
</head>
<body>
<div class="container">
<h2>Laravel Generate QR Code Tutorial with Example</h2>
<br>
<br>
    <div class="row">
			<div class="col-md-4">
				    <h5>Simple Qr Code With String</h5>
    {!! QrCode::size(200)->generate('Laravel Tutorial'); !!}
			</div>

			<div class="col-md-4">
				<h5>Qr Code With Color</h5>
     {!! QrCode::size(200)->backgroundColor(255,55,0)->generate('Laravel Tutorial'); !!}
				
			</div>
			<div class="col-md-4">
				<h5>Qr Code with Image</h5>
				<img src="data:image/png;base64, {!! base64_encode(QrCode::format('png')->merge('http://w3adda.com/wp-content/uploads/2019/07/laravel.png', 0.3, true)
                        ->size(200)->errorCorrection('H')
                        ->generate('Laravel Tutorial')) !!} ">
				
			</div>
	</div>

</div>

</body>

</html>

<!DOCTYPE html>

<html>

<head>

<title>Laravel Generate QR Code Tutorial with Example</title>

</head>

<body>

<h2>Laravel Generate QR Code Tutorial with Example</h2>

<br>

<h5>Simple Qr Code With String</h5>

{!! QrCode::size(200)->generate('Laravel Tutorial'); !!}

</div>

<h5>Qr Code With Color</h5>

{!! QrCode::size(200)->backgroundColor(255,55,0)->generate('Laravel Tutorial'); !!}

</div>

<h5>Qr Code with Image</h5>

<img src="data:image/png;base64, {!! base64_encode(QrCode::format('png')->merge('http://w3adda.com/wp-content/uploads/2019/07/laravel.png', 0.3, true)

->size(200)->errorCorrection('H')

->generate('Laravel Tutorial')) !!} ">

</div>

</body>

</html>

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

Route::get('generate-qr-code', function(){
	 return view('qrcode.index');
});

Route::get('qr-code-with-image', function () {
 $image = QrCode::format('png')->merge('http://w3adda.com/wp-content/uploads/2019/07/laravel.png', 0.3, true)
                ->size(200)->errorCorrection('H')
                ->generate('W3Adda Laravel Tutorial');
return response($image)->header('Content-type','image/png');
});

Route::get('color-qr-code', function () {
     return QrCode::size(200)->backgroundColor(255,55,0)->generate('W3Adda Laravel Tutorial');
});

Route::get('simple-qr-code', function () {
     return QrCode::size(200)->generate('W3Adda Laravel Tutorial');
});

Route::get('generate-qr-code', function(){

return view('qrcode.index');

});

Route::get('qr-code-with-image', function () {

$image = QrCode::format('png')->merge('http://w3adda.com/wp-content/uploads/2019/07/laravel.png', 0.3, true)

->size(200)->errorCorrection('H')

->generate('W3Adda Laravel Tutorial');

return response($image)->header('Content-type','image/png');

});

Route::get('color-qr-code', function () {

return QrCode::size(200)->backgroundColor(255,55,0)->generate('W3Adda Laravel Tutorial');

});

Route::get('simple-qr-code', function () {

return QrCode::size(200)->generate('W3Adda Laravel Tutorial');

});

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/generate-qr-code

http://localhost:8000/simple-qr-code

http://localhost:8000/color-qr-code

http://localhost:8000/qr-code-with-image

Laravel Eloquent ORM Cheat Sheet

Laravel Select Query

->select('col1','col2')
->select(array('col1','col2'))
->select(DB::raw('businesses.*, COUNT(reviews.id) as no_of_ratings, IFNULL(sum(reviews.score),0) as rating'))  
->addSelect('col3','col4')
->distinct() // distinct select

->select('col1','col2')

->select(array('col1','col2'))

->select(DB::raw('businesses.*, COUNT(reviews.id) as no_of_ratings, IFNULL(sum(reviews.score),0) as rating'))

->addSelect('col3','col4')

->distinct() // distinct select

Laravel From Clause

->from('table')
->from(DB::raw('table, (select @n :=0) dummy'))
->from(DB::raw("({$subQuery->toSql()}) T ")->mergeBindings($subQuery->getQuery())

->from('table')

->from(DB::raw('table, (select @n :=0) dummy'))

->from(DB::raw("({$subQuery->toSql()}) T ")->mergeBindings($subQuery->getQuery())

Where

->where('column','value')
->where('column','LIKE','%'.$value.'%')
->where(function ($query) {
  $query->where('a', '=', 1)
      ->orWhere('b', '=', 1);
})
->orWhere('column','!=', 'value')
->whereRaw('age > ? and votes = 100', array(25))
 
->whereRaw(DB::raw("id in (select city_id from addresses GROUP BY addresses.city_id)"))
 
->whereExists(function($query)
{
  $query->select(DB::raw(1))
      ->from('business_language')
      ->whereRaw('business_language.language_id = languages.id')
      ->groupBy('business_language.language_id')
      ->havingRaw("COUNT(*) > 0");
})
->orWhereExists()
->whereNotExists()
->orWhereNotExists()
 
->whereIn('column',[1,2,3])
->orWhereIn()
->whereNotIn('id', function($query){
  $query->select('city_id')
  ->from('addresses')
  ->groupBy('addresses.city_id');
})
->whereNotIn()
->orWhereNotIn
 
->whereNull('column') //where `column` is null
->orWhereNull('column') //or where `column` is null
->whereNotNull('column')  //where `column` is not null 
->orWhereNotNull('column')  //or where `column` is not null 
 
->whereDay()
->whereMonth('column', '=', 1) //
->whereYear('column', '>', 2000) //uses sql YEAR() function on 'column'
->whereDate('column', '>', '2000-01-01')

->where('column','value')

->where('column','LIKE','%'.$value.'%')

->where(function ($query) {

$query->where('a', '=', 1)

->orWhere('b', '=', 1);

})

->orWhere('column','!=', 'value')

->whereRaw('age > ? and votes = 100', array(25))

->whereRaw(DB::raw("id in (select city_id from addresses GROUP BY addresses.city_id)"))

->whereExists(function($query)

{

$query->select(DB::raw(1))

->from('business_language')

->whereRaw('business_language.language_id = languages.id')

->groupBy('business_language.language_id')

->havingRaw("COUNT(*) > 0");

})

->orWhereExists()

->whereNotExists()

->orWhereNotExists()

->whereIn('column',[1,2,3])

->orWhereIn()

->whereNotIn('id', function($query){

$query->select('city_id')

->from('addresses')

->groupBy('addresses.city_id');

})

->whereNotIn()

->orWhereNotIn

->whereNull('column') //where `column` is null

->orWhereNull('column') //or where `column` is null

->whereNotNull('column') //where `column` is not null

->orWhereNotNull('column') //or where `column` is not null

->whereDay()

->whereMonth('column', '=', 1) //

->whereYear('column', '>', 2000) //uses sql YEAR() function on 'column'

->whereDate('column', '>', '2000-01-01')

Joins

->join('business_category','business_category.business_id','=','businesses.id')
->leftJoin('reviews','reviews.business_id', '=', 'businesses.id')
->join('business_category',function($join) use($cats) {
  $join->on('business_category.business_id', '=', 'businesses.id')
  ->on('business_category.id', '=', $cats, 'and', true);
})
->join(DB::raw('(SELECT *, ROUND(AVG(rating),2) avg FROM reviews WHERE rating!=0 GROUP BY item_id ) T' ), function($join){
  $join->on('genre_relation.movie_id', '=', 'T.id')
})

->join('business_category','business_category.business_id','=','businesses.id')

->leftJoin('reviews','reviews.business_id', '=', 'businesses.id')

->join('business_category',function($join) use($cats) {

$join->on('business_category.business_id', '=', 'businesses.id')

->on('business_category.id', '=', $cats, 'and', true);

})

->join(DB::raw('(SELECT *, ROUND(AVG(rating),2) avg FROM reviews WHERE rating!=0 GROUP BY item_id ) T' ), function($join){

$join->on('genre_relation.movie_id', '=', 'T.id')

})

Eager Loading

->with('table1','table2')
->with(array('table1','table2','table1.nestedtable3'))
->with(array('posts' => function($query) use($name){
  $query->where('title', 'like', '%'.$name.'%')
    ->orderBy('created_at', 'desc');
}))

->with('table1','table2')

->with(array('table1','table2','table1.nestedtable3'))

->with(array('posts' => function($query) use($name){

$query->where('title', 'like', '%'.$name.'%')

->orderBy('created_at', 'desc');

}))

Grouping

->groupBy('state_id','locality')
->havingRaw('count > 1 ')
->having('items.name','LIKE',"%$keyword%")
->orHavingRaw('brand LIKE ?',array("%$keyword%"))

->groupBy('state_id','locality')

->havingRaw('count > 1 ')

->having('items.name','LIKE',"%$keyword%")

->orHavingRaw('brand LIKE ?',array("%$keyword%"))

Cache

->remember($minutes)
->rememberForever()

1 2	->remember($minutes) ->rememberForever()

Offset & Limit

->take(10)
->limit(10)
->skip(10)
->offset(10)
->forPage($pageNo, $perPage)

->take(10)

->limit(10)

->skip(10)

->offset(10)

->forPage($pageNo, $perPage)

Order

->orderBy('id','DESC')
->orderBy(DB::raw('RAND()'))
->orderByRaw('type = ? , type = ? ', array('published','draft'))
->latest() // on 'created_at' column
->latest('column')
->oldest() // on 'created_at' column
->oldest('column')

->orderBy('id','DESC')

->orderBy(DB::raw('RAND()'))

->orderByRaw('type = ? , type = ? ', array('published','draft'))

->latest() // on 'created_at' column

->latest('column')

->oldest() // on 'created_at' column

->oldest('column')

Create

->insert(array('email' => 'john@example.com', 'votes' => 0))
->insert(array(   
  array('email' => 'taylor@example.com', 'votes' => 0),
  array('email' => 'dayle@example.com', 'votes' => 0)
)) //batch insert
->insertGetId(array('email' => 'john@example.com', 'votes' => 0)) //insert and return id

->insert(array('email' => 'john@example.com', 'votes' => 0))

->insert(array(

array('email' => 'taylor@example.com', 'votes' => 0),

array('email' => 'dayle@example.com', 'votes' => 0)

)) //batch insert

->insertGetId(array('email' => 'john@example.com', 'votes' => 0)) //insert and return id

Update

->update(array('email' => 'john@example.com'))
->update(array('column' => DB::raw('NULL')))
->increment('column')
->decrement('column')
->touch() //update timestamp

->update(array('email' => 'john@example.com'))

->update(array('column' => DB::raw('NULL')))

->increment('column')

->decrement('column')

->touch() //update timestamp

Delete

->delete()
->forceDelete() // when softdeletes enabled
->destroy($ids) // delete by array of primary keys
->roles()->detach() //delete from pivot table: associated by 'belongsToMany'

->delete()

->forceDelete() // when softdeletes enabled

->destroy($ids) // delete by array of primary keys

->roles()->detach() //delete from pivot table: associated by 'belongsToMany'

Getters

->find($id)
->find($id, array('col1','col2'))
->findOrFail($id)
->findMany($ids, $columns)
->first(array('col1','col2'))
->firstOrFail()
->all()
->get()
->get(array('col1','col2')) 
->getFresh() // no caching
->getCached() // get cached result
->chunk(1000, function($rows){
  $rows->each(function($row){
 
  });
})
->lists('column') // numeric index
->lists('column','id') // 'id' column as index
->lists('column')->implode('column', ',') // comma separated values of a column
->pluck('column')  //Pluck a single column's value from the first result of a query.
->value('column')  //Get a single column's value from the first result of a query.

->find($id)

->find($id, array('col1','col2'))

->findOrFail($id)

->findMany($ids, $columns)

->first(array('col1','col2'))

->firstOrFail()

->all()

->get()

->get(array('col1','col2'))

->getFresh() // no caching

->getCached() // get cached result

->chunk(1000, function($rows){

$rows->each(function($row){

});

})

->lists('column') // numeric index

->lists('column','id') // 'id' column as index

->lists('column')->implode('column', ',') // comma separated values of a column

->pluck('column') //Pluck a single column's value from the first result of a query.

->value('column') //Get a single column's value from the first result of a query.

Paginated results

->paginate(10)
->paginate(10, array('col1','col2'))
->simplePaginate(10)
->getPaginationCount() //get total no of records

->paginate(10)

->paginate(10, array('col1','col2'))

->simplePaginate(10)

->getPaginationCount() //get total no of records

Aggregate

->count()
->count('column')
->count(DB::raw('distinct column'))
->max('rating')
->min('rating')
->sum('rating')
->avg('rating')
->aggregate('sum', array('rating')) // use of aggregate functions

->count()

->count('column')

->count(DB::raw('distinct column'))

->max('rating')

->min('rating')

->sum('rating')

->avg('rating')

->aggregate('sum', array('rating')) // use of aggregate functions

Others

->toSql() // output sql query
->exists() // check if any row exists
->fresh() // Return a fresh data for current model from database

->toSql() // output sql query

->exists() // check if any row exists

->fresh() // Return a fresh data for current model from database

Object methods

->toArray() //
->toJson()
->relationsToArray() //Get the model's relationships in array form.
->implode('column', ',') // comma separated values of a column
->isDirty()
->getDirty() //Get the attributes that have been changed but not saved to DB

->toArray() //

->toJson()

->relationsToArray() //Get the model's relationships in array form.

->implode('column', ',') // comma separated values of a column

->isDirty()

->getDirty() //Get the attributes that have been changed but not saved to DB

Debugging

DB::enableQueryLog();
DB::getQueryLog();
Model::where()->toSql() // output sql query

DB::enableQueryLog();

DB::getQueryLog();

Model::where()->toSql() // output sql query

Laravel Relationships Cheat Sheet

In this Laravel Eloquent Relationships with example tutorial, I’ll show you how to create and use eloquent relationships in your laravel database model. In laravel , you can define Eloquent Relationships model classes. In eloquent model you can create custom relationship methods along with methods example hasOne(), hasMany(), belongsTo(), belongsToMany(), hasOneThrough() etc.

Eloquent Relationships in Laravel

In laravel eloquent model you are allowed to create following type for relationships.

Types of Eloquent Relationships in Laravel

One To One
One To Many
Many To Many
HasMany Through
Many To Many Polymorphic Relation

Laravel One to One Relationship with Example

In Laravel, one to one relationship is one of basic relationship. Suppose, Post model would be associated with a content model using one to one relationship. This one to one relationship means every post can have one one content associated with it. To demonstrate this relationship, we will create a post_content() method within the Post model and call the hasOne() method to relate the Content model.

<?php
 
namespace App;
 
use Illuminate\Database\Eloquent\Model;
 
class Post extends Model
{
    public function post_content()
    {
        return $this->hasOne('App\Content');
    }
}

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Post extends Model

{

public function post_content()

{

return $this->hasOne('App\Content');

}

It is important to note that Eloquent establishes a foreign key based on the model name and should have a matching value id. Here post_id is the foreign_key of Content.

Laravel inverse of One to One Relationship Example

For now you are allowed to access the content from the post model. Now create an inverse relationship on the content model so that the post can accessed the content model . This can be achieved using laravel belongsTo method to get the post data from the content model.

<?php
 
namespace App;
 
use Illuminate\Database\Eloquent\Model;
 
class Content extends Model
{
    public function post()
    {
        return $this->belongsTo('App\Post');
    }
}

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Content extends Model

{

public function post()

{

return $this->belongsTo('App\Post');

}

you can access the post content using the relation method as following:

$content = Post::find(10)->post_content;

1	$content = Post::find(10)->post_content;

Laravel One to Many Relationship Example

In One of many relationships one single model can associated with multiple number of the other model. For example, an author may have many post.

<?php
 
namespace App;
 
use Illuminate\Database\Eloquent\Model;
 
class Author extends Model
{
    ...
    public function post()
    {
        return $this->hasMany('App\Post');
    }
}

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Author extends Model

{

...

public function post()

{

return $this->hasMany('App\Post');

}

you can now access the collection of post article by using the post() method as.Using this, we get all the posts of a single author. Here we need to get the author details of a single post,for each post there a single author, within the Post model includes belongsTo relation.

$posts = App\Author::find(10)->post()->get();

 foreach ($posts as $post) {
     //do something
 }

$posts = App\Author::find(10)->post()->get();

foreach ($posts as $post) {

//do something

}

Inverse One to Many Relationship Example

The inverse of the one to many relationship is defined using laravel belongsTo method. Since we have access to post articles of an author, now we need to allow a post article to access its parent Author model or access author details by using the post model. This inverse relationship can be established using belongsTo method as following:

<?php
 
namespace App;
 
use Illuminate\Database\Eloquent\Model;
 
class Post extends Model
{
    public function author()
    {
        return $this->belongsTo('App\Author');
    }
}

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Post extends Model

{

public function author()

{

return $this->belongsTo('App\Author');

}

Now we can get the author details by using posts as following:

$post->author->author_name;

1	$post->author->author_name;

Laravel Many to Many Relationship Example

Let suppose now each of the post have multiple tags and each tags can belongs to multiple posts then this type of relationship is defined as many to many relationship. In laravel many to many relationship can be defined using belongsToMany() method.

<?php
 
namespace App;
 
use Illuminate\Database\Eloquent\Model;
 
class Post extends Model
{
   ...
    public function tags()
    {
        return $this->belongsToMany('App\Tag');
    }
}

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Post extends Model

{

...

public function tags()

{

return $this->belongsToMany('App\Tag');

}

Now you can access the tags in post model as following:

$post = App\Post::find(8);

 foreach ($post->tags as $tag) {
    //do something
 }

$post = App\Post::find(8);

foreach ($post->tags as $tag) {

//do something

}

The inverse of Many to Many Relationship Example

The inverse of a many to many relationships can also be defined using belongsToMany method on the associated model as following:

<?php
 
namespace App;
 
use Illuminate\Database\Eloquent\Model;
 
class Tag extends Model
{
    public function posts()
    {
        return $this->belongsToMany('App\Post');
    }
}

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Tag extends Model

{

public function posts()

{

return $this->belongsToMany('App\Post');

}

you can now access the post in tag model as following:

$tag = App\Tag::find(8);

 foreach ($tag->posts as $post) {
     //do something
  }

$tag = App\Tag::find(8);

foreach ($tag->posts as $post) {

//do something

}

Laravel HasMany Through Relationship

The “has-many-through” relationship allows you accessing distant relations via an intermediate model. For example, a Country model might have many Post models through an intermediate User model. In this example, you could easily gather all blog posts for a given country. Let’s look at the tables required to define this relationship:

<?php
 
namespace App;
 
use Illuminate\Database\Eloquent\Model;
 
class Country extends Model
{
    /**
     * Get all of the posts for the country.
     */
    public function posts()
    {
        return $this->hasManyThrough('App\Post', 'App\User');
    }
}

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Country extends Model

{

/**

* Get all of the posts for the country.

public function posts()

{

return $this->hasManyThrough('App\Post', 'App\User');

}

How to Remove Public From URL in Laravel

In this Remove public from URL in laravel tutorial we will learn how to remove the public from URL in laravel.

Remove Public From URL Laravel

In this step by step tutorial I’ll show you how to remove public from URL in your laravel application. In this article I’ll show you two different method to remove public from URL in laravel

Remove public from url using .htaccess
Raname server.php and move .htaccess file

Remove public from url using .htaccess

In this method we will rewrite url using .htaccess file of your laravel project. The .htaccess file can be found in root directory of your laravel application. Before you update your .htacces file you must have mod_rewrite enabled on your Apache server. The rewrite module is required to apply these settings.

Let’s open .htaccess file and put the following code in it.

<IfModule mod_rewrite.c>
   RewriteEngine On 
   RewriteRule ^(.*)$ public/$1 [L]
</IfModule>

RewriteEngine On

RewriteRule ^(.*)$ public/$1 [L]

</IfModule>

Rename server.php and move .htaccess file

In this method you need to follow the below steps to remove public from url in laravel

Step 1:-

Rename server.php to index.php. The server.php file is located at your project’s root directory.

Step 2:-

Copy the .htaccess file from /public directory to your Laravel project’s root directory.

Laravel Pluck Method Example

Extract Single Value From Collection Using Pluck()

Extract Multiple Value From Collection Using Pluck() in Laravel

Laravel Pluck Relationship

what is cookies?

Laravel Cookies Get, Set, Delete Cookies

Laravel Set Cookies

Laravel Get Cookies

Laravel Delete Cookies

Laravel Check if Cookie Exists

Add Cookies With Response

Laravel 7/6 Import Export Excel, Csv to Database

Create Laravel 7/6 Application

Configure Database In .env file

Create Model and Migration

Run Laravel Migration

Install Maatwebsite Package

Configure Maatwebsite Package

Create Import Class

Create Export Class

Create Import Excel Controller

Create Blade / View Files

Create Import Export Excel Routes

Laravel 7/6 Intervention Upload Image Using Ajax

1). Install Laravel Fresh Setup

2). Setup Database

3). Install Image Intervention Package

4). Generate Migration & Model

5). Make Route

6). Create Controller

7). Create Blade view

8). Make Folder

9). Run Development Server

Laravel 7/6 Yajra DataTables Example Tutorial

Install Laravel 7/6

Configure Database In .env file

Run Migration

Install Yajra Datatable Package

Add Fake Records

Add Route

Create Controller

Create Blade / View Files

Start Development Server

Laravel 7/6 Yajra DataTables Custom Search Example Tutorial

Install Laravel 7/6

Configure Database In .env file

Generate Application Key

Set Default String Length

Create Database Table

Run Migration

Create Model

Install Yajra Datatable Package

Create Controller

Create Blade / View Files

Create Routes

Laravel Send Email Using Mailable Class Example

Install Laravel 8

Configure Database In .env file

Configuration SMTP in .env

Mailable Class

Create Route & Blade View

Create Controller & Method

Run Development Server

Laravel 7/6 Multi Auth( Authentication) Example Tutorial

Install Laravel 6

Configure Database In .env file

Migrations and User Model

Authentication Scaffolding

Create Admin Middleware

Register Admin Routes

Set Admin Protected Route

Create Controller Methods

Create Blade/View

Start Development Server

Laravel 7/6 QR Code Generator Example

Install Laravel 7/6

Install simple-qrcode Package

Register Package

Basic Usage Of simple-qrcode Package

Create Blade / View Files