Laravel

Generate PDF from Html in Laravel

September 30, 2018 by Webprepration 1 Comment

In this tutorial, I am going to explain “How to create PDF from html in Laravel” by using laravel dompdf package.

There are lots of pdf packages that are using to generate pdf from html with CSS, you can easily set the beautiful layout for pdf file using css most of the packages support css in pdf.

Using laravel-dompdf library, you can easily generate pdf file in your Laravel web application.

When you are need to sending report in email from large amount of data then you can convert your html view in pdf file and attach that file with mail or if we work on big ERP level project on laravel, we require to generate PDF file for data from database table.

In this tutorials we are using on of the best package barryvdh/laravel-dompdf it provide very easy way to generate html to pdf in laravel.

We are explain all code step by step:-

Step 1:- First need to install dompdf package in our laravel application using following command.


composer require barryvdh/laravel-dompdf

composer require barryvdh/laravel-dompdf

Step 2:- After install DOM PDF package for laravel we must be configure, So just open your config/app.php file and set following value for providers array and aliases array


'providers' => [
	....
	Barryvdh\DomPDF\ServiceProvider::class,
],
'aliases' => [
	....
	'PDF' => Barryvdh\DomPDF\Facade::class,
],

'providers' => [

....

Barryvdh\DomPDF\ServiceProvider::class,

'aliases' => [

....

'PDF' => Barryvdh\DomPDF\Facade::class,

Step 3:- In this step we need to set route for generate view. So just open your app/Http/routes.php file and add following route.


Route::get('html-to-pdf','DemoController@pdfDownload');

Route::get('html-to-pdf','DemoController@pdfDownload');

Step 4:- Now we should create controller as DemoController in this path app/Http/Controllers/DemoController.php

This controller will manage data and generate pdf file, so put bellow content in controller file


<?php
namespace App\Http\Controllers;


use Illuminate\Http\Request;
use App\Http\Controllers\Controller;
use PDF;



class DemoController extends Controller
{


    function pdfDownload(Request $request){

        $pdf = PDF::loadView('pdf_view');
        $filename = time().'.pdf';
        return $pdf->download($filename);
    }
        
        
 
}

?>

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use App\Http\Controllers\Controller;

use PDF;

class DemoController extends Controller

{

function pdfDownload(Request $request){

$pdf = PDF::loadView('pdf_view');

$filename = time().'.pdf';

return $pdf->download($filename);

}

Step 5:- In last step, we have to create view file “pdf_view.blade.php” for generate view and also pdf file, so create pdf_view file and put bellow code:


<html>
<head>
<style>
table {
    font-family: arial, sans-serif;
    border-collapse: collapse;
    width: 100%;
}

td, th {
    border: 1px solid #dddddd;
    text-align: left;
    padding: 8px;
}

tr:nth-child(even) {
    background-color: #dddddd;
}
</style>
</head>
<body>

<h2>HTML Table</h2>

<table>
  <tr>
    <th>Company</th>
    <th>Contact</th>
    <th>Country</th>
  </tr>
  <tr>
    <td>Alfreds Futterkiste</td>
    <td>Maria Anders</td>
    <td>Germany</td>
  </tr>
  <tr>
    <td>Centro comercial Moctezuma</td>
    <td>Francisco Chang</td>
    <td>Mexico</td>
  </tr>
  <tr>
    <td>Ernst Handel</td>
    <td>Roland Mendel</td>
    <td>Austria</td>
  </tr>
  <tr>
    <td>Island Trading</td>
    <td>Helen Bennett</td>
    <td>UK</td>
  </tr>
  <tr>
    <td>Laughing Bacchus Winecellars</td>
    <td>Yoshi Tannamuri</td>
    <td>Canada</td>
  </tr>
  <tr>
    <td>Magazzini Alimentari Riuniti</td>
    <td>Giovanni Rovelli</td>
    <td>Italy</td>
  </tr>
</table>

</body>
</html>

<html>

<head>

<style>

table {

font-family: arial, sans-serif;

border-collapse: collapse;

width: 100%;

}

td, th {

border: 1px solid #dddddd;

text-align: left;

padding: 8px;

}

tr:nth-child(even) {

background-color: #dddddd;

}

</style>

</head>

<body>

<h2>HTML Table</h2>

<table>

<tr>

<th>Company</th>

<th>Contact</th>

<th>Country</th>

</tr>

<tr>

<td>Alfreds Futterkiste</td>

<td>Maria Anders</td>

<td>Germany</td>

</tr>

<tr>

<td>Centro comercial Moctezuma</td>

<td>Francisco Chang</td>

<td>Mexico</td>

</tr>

<tr>

<td>Ernst Handel</td>

<td>Roland Mendel</td>

<td>Austria</td>

</tr>

<tr>

<td>Island Trading</td>

<td>Helen Bennett</td>

</tr>

<tr>

<td>Laughing Bacchus Winecellars</td>

<td>Yoshi Tannamuri</td>

<td>Canada</td>

</tr>

<tr>

<td>Magazzini Alimentari Riuniti</td>

<td>Giovanni Rovelli</td>

<td>Italy</td>

</tr>

</table>

</body>

</html>

View Demo

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

Thanks!!

Webprepration

I’m a full-stack developer. My hobby and profession to write blog and programming tips that helps to others. I am a great admirer of PHP, Laravel, Codeigniter, AngularJS, Vue.js, Javascript, JQuery, WordPress, Plugin Development, Theme Development and Bootstrap from the early stage.

webprepration.com/

How To Create Custom Validation Rules in Laravel

August 10, 2018 by Webprepration Leave a Comment

Laravel is the most powerful and very popular framework in PHP, Laravel provides so many helpful validations rules but if you want to define own validation rules then you can easily define rules. In this post, I am going to explain “How to create custom validation rule in Laravel 5”.

Custom validation rule is very useful and interesting concept of laravel, So I will show you how to create custom validation and use same as predefined laravel validation rules.

In this post, I will show you step by step create custom validation rule to validate Indian phone number that start with +91 .

Step 1 :- Create routes for display form and check validation before submit form

app/Http/routes.php


Route::get('custom-validation','DemoController@customValidation');
Route::post('savedata','DemoController@savedata');

Route::get('custom-validation','DemoController@customValidation');

Route::post('savedata','DemoController@savedata');

Step 2 :- In this create controller file like DemoController.php and copy below code and paste it in your file.

app/Http/Controllers/DemoController.php


<?php
namespace App\Http\Controllers;


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



class DemoController extends Controller
{

    
    function customValidation(){
        return view('form_view');
    }
    function savedata(Request $request){
       $this->validate($request, [
            'phone' => 'required|indian_phone',
        ]);
        return 'successfully';
    }
    
 
}

?>

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use App\Http\Controllers\Controller;

class DemoController extends Controller

{

function customValidation(){

return view('form_view');

}

function savedata(Request $request){

$this->validate($request, [

'phone' => 'required|indian_phone',

]);

return 'successfully';

}

Step 3 :- In this step we will declare and write code for custom validation rule, So first open app/Providers/AppServiceProvider.php

file and put the given code.


<?php

namespace App\Providers;

use Illuminate\Support\ServiceProvider;
use Illuminate\Support\Facades\Schema;
use Validator;


class AppServiceProvider extends ServiceProvider
{
    /**
     * Bootstrap any application services.
     *
     * @return void
     */
    public function boot()
    {
       Schema::defaultStringLength(191);
        Validator::extend('indian_phone', function($attribute, $value, $parameters) {
            return substr($value, 0, 3) == '+91';
        });
    }

    /**
     * Register any application services.
     *
     * @return void
     */
    public function register()
    {
        //
    }
}

<?php

namespace App\Providers;

use Illuminate\Support\ServiceProvider;

use Illuminate\Support\Facades\Schema;

use Validator;

class AppServiceProvider extends ServiceProvider

{

/**

* Bootstrap any application services.

* @return void

public function boot()

{

Schema::defaultStringLength(191);

Validator::extend('indian_phone', function($attribute, $value, $parameters) {

return substr($value, 0, 3) == '+91';

});

}

/**

* Register any application services.

* @return void

public function register()

{

}

Now, we have to give error message for new created custom validation rules, so register custom message open resoueces/lang/en/validation.phpand put one line as i did bellow

resoueces/lang/en/validation.php


'custom' => [
    'phone' => [
        'indian_phone' => 'Please enter Indian phone number which starts with +91',
        ],
    ],

'custom' => [

'phone' => [

'indian_phone' => 'Please enter Indian phone number which starts with +91',

Step 4:- This is last step and you have to create one view for demo. so just copy bellow code and put on following file.


<!DOCTYPE html>
<html lang="en">
<head>
  <title>Custom Validation In Laravel</title>
  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width, initial-scale=1">
  <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css">
  <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
  <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script> 
</head>
<body>

<div class="container">
<div class="panel panel-primary">
 <div class="panel-heading">Custom Validation In Laravel
    </div>

      <div class="panel-body"> 
       <div class="panel-body">   
         <div class="row">
          @if (count($errors) > 0)
                <div class="alert alert-danger">
                    <ul>
                        @foreach ($errors->all() as $error)
                            <li>{{ $error }}</li>
                        @endforeach
                    </ul>
                </div>
            @endif
          <form action="{{url('/')}}/savedata" method="post" id="sitelogo">
           {{csrf_field() }}
            <div class="form-group">
              <label for="phone">Phone: </label>
              <input type="text" class="form-control" id="phone" name="phone">
            </div>
             <button type="submit" class="btn btn-default">Submit</button>
          </form>         
      </div>
        </div>

       </div>
       </div>
   
</div>

</body>
</html>

<!DOCTYPE html>

<head>

<title>Custom Validation In Laravel</title>

</head>

<body>

<div class="panel-heading">Custom Validation In Laravel

</div>

@if (count($errors) > 0)

<ul>

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

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

@endforeach

</ul>

</div>

@endif

<label for="phone">Phone: </label>

</div>

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

</form>

</div>

</body>

</html>

Laravel custom validation rule

View Demo

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

Thanks!!

Webprepration

webprepration.com/

Ajax Image Upload Example with Validation in PHP Laravel Framework

July 25, 2018 by Webprepration 7 Comments

In this post, I am going to explain “How to upload image using ajax in laravel “. Laravel provide very simple way to store image or file on server. Laravel also provide validation for max file size, Image mime type and height width etc.

So, If we make image upload using jquery ajax then it become good for our GUI and best. So Today in this post we will learn how to upload image using jquery ajax.

Here i give you full example of ajax image uploading step by step like create laravel project, migration, model, route, blade file etc. So you have to just follow few step as listed bellow.

Step 1:- Install laravel using below command


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

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

Step 2:- After installation need to setup database configuration in .env file like


DB_HOST=localhost
DB_DATABASE=homestead
DB_USERNAME=homestead
DB_PASSWORD=secret

DB_HOST=localhost

DB_DATABASE=homestead

DB_USERNAME=homestead

DB_PASSWORD=secret

Step 3:- Now create image table, Model and Migration for store image in database


php artisan make:migration create_image_tabel

php artisan make:migration create_image_tabel

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


<?php


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


class CreateImageTabel extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('ajax_images', function (Blueprint $table) {
            $table->increments('id');
            $table->string('image');
            $table->timestamps();
        });
    }


    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::drop("images");
    }
}

<?php

use Illuminate\Support\Facades\Schema;

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Database\Migrations\Migration;

class CreateImageTabel extends Migration

{

/**

* Run the migrations.

* @return void

public function up()

{

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

$table->increments('id');

$table->string('image');

$table->timestamps();

});

}

/**

* Reverse the migrations.

* @return void

public function down()

{

Schema::drop("images");

}

Now we need to run migration command


php artisan migrate

php artisan migrate

After create table, Now we need to create Model using below command


php artisan make:model Image

php artisan make:model Image

Now copy below code and paste in Image model file


<?php


namespace App;


use Illuminate\Database\Eloquent\Model;


class Image extends Model
{
    /**
     * The attributes that are mass assignable.
     *
     * @var array
     */
    protected $fillable = [
        'image'
    ];
}

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Image extends Model

{

/**

* The attributes that are mass assignable.

* @var array

protected $fillable = [

'image'

];

}

Step 4:- In this step we need to create route for ajax image upload in route file

routes/web.php


Route::get('ajax-upload-image','DemoController@index');
Route::post('uploadImage','DemoController@uploadImage');

Route::get('ajax-upload-image','DemoController@index');

Route::post('uploadImage','DemoController@uploadImage');

Step 5:- Now we should create controller as DemoController.php file

app/Http/Controllers/DemoController.php


<?php


namespace App\Http\Controllers;


use Illuminate\Http\Request;
use Validator;
use App\Image;


class DemoController extends Controller
{
	/**
     * Show the application .
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
    	return view('ajaxImageUpload');
    }


    /**
     * Show the application .
     *
     * @return \Illuminate\Http\Response
     */
    public function uploadImage(Request $request)
    {
      $validator = Validator::make($request->all(), [
        'image' => 'required|image|mimes:jpeg,png,jpg,gif,svg|max:2048',
      ]);


      if ($validator->passes()) {


        $input = $request->all();
        $input['image'] = time().'.'.$request->image->getClientOriginalExtension();
        $request->image->move(public_path('images'), $input['image']);


        Image::create($input);


        return response()->json(['success'=>'done']);
      }


      return response()->json(['error'=>$validator->errors()->all()]);
    }
}

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use Validator;

use App\Image;

class DemoController extends Controller

{

/**

* Show the application .

* @return \Illuminate\Http\Response

public function index()

{

return view('ajaxImageUpload');

}

/**

* Show the application .

* @return \Illuminate\Http\Response

public function uploadImage(Request $request)

{

$validator = Validator::make($request->all(), [

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

]);

if ($validator->passes()) {

$input = $request->all();

$input['image'] = time().'.'.$request->image->getClientOriginalExtension();

$request->image->move(public_path('images'), $input['image']);

Image::create($input);

return response()->json(['success'=>'done']);

}

return response()->json(['error'=>$validator->errors()->all()]);

}

Step 6:- Now we should create view file ajaxImageUpload.blade.php for layout, So just copy below code paste in view file.

resources/views/ajaxImageUpload.blade.php


<!DOCTYPE html>
<html lang="en">
  <head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">   

    <!-- The above 3 meta tags *must* come first in the head; any other head content must come *after* these tags -->
    <title>Webprepration Demo</title>
<link rel="icon" href="https://webprepration.com/wp-content/uploads/2017/11/wp-65x65.png" sizes="32x32" />
<link rel="icon" href="https://webprepration.com/wp-content/uploads/2017/11/wp-300x300.png" sizes="192x192" />
<link rel="apple-touch-icon-precomposed" href="https://webprepration.com/wp-content/uploads/2017/11/wp-300x300.png" />
<meta name="msapplication-TileImage" content="https://webprepration.com/wp-content/uploads/2017/11/wp-300x300.png" />
    <!-- Bootstrap -->
    <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/css/bootstrap.min.css" integrity="sha384-BVYiiSIFeK1dGmJRAkycuHAHRg32OmUcww7on3RYdg4Va+PmSTsz/K68vbdEjh4u" crossorigin="anonymous">
    <link href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.css" rel="stylesheet">
     <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
  <script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.7/js/bootstrap.min.js"></script>
   <link rel="stylesheet" type="text/css" href="https://webprepration.com/demo/css/style.css">
<link href="public/css/sweetalert.css" rel="stylesheet">
  </head>
  <body>

    <nav class="navbar navbar-default navbar-static-top">
      <div class="container">
        <div class="navbar-header">
          <button type="button" class="navbar-toggle collapsed" data-toggle="collapse" data-target="#navbar" aria-expanded="false" aria-controls="navbar">
            <span class="sr-only">WEB PREPRATION</span>
            <span class="icon-bar"></span>
          </button>
          <a class="navbar-brand" href="https://webprepration.com/">WEB PREPRATION</a>
        </div>
        <div id="navbar" class="navbar-collapse collapse">         
          <ul class="nav navbar-nav navbar-right">
            <li class="sa"><a href="https://webprepration.com/category/php/">PHP</a></li>
            <li class="sa"><a href="https://webprepration.com/category/wordpress/">WordPress</a></li>
            <li class="sa"><a href="https://webprepration.com/category/wordpress/">Plugins</a></li>
            <li class="sa"><a href="https://webprepration.com/category/codeignitor/">CodeIgnitor</a></li>
            <li class="sa"><a href="https://webprepration.com/category/laravel/">Laravel</a></li>
          </ul>
        </div><!--/.nav-collapse -->
      </div>
    </nav><!--/nav-->

<div class="container">
<div class="panel panel-primary">
 <div class="panel-heading">Upload Image Using Ajax in Laravel
    </div>

      <div class="panel-body"> 

       <div class="panel-body">   
         <div class="row">
          <form action="" method="post" id="sitelogo">
            <div class="form-group">
              <input type="file" class="form-control" id="logo" name="logo">              
            </div>
            <div class="form-group">
              <img id="myImg" src="{{url('/')}}/public/uploads/{{ (isset($setting->logo) && $setting->logo) !='' ? $setting->logo : 'images.jpg'}}" style="max-width: 500px;max-height: 400px;width: 100%;">            
            </div>
          </form>         
      </div>
        </div>

       </div>
       </div>
   
</div>   

<div class="footer-bottom">
   <div class="container">
      <div class="row">
         <div class="col-xs-12 col-sm-4 col-md-4 col-lg-4">
            <div class="copyright" style="font-family: sans-serif;">
               Web Prepration <span style="color: #504f4f;">Copyright © 2017.</span>
            </div>
         </div>
         <div class="col-xs-12 col-sm-4 col-md-4 col-lg-4">
            <div class="copyright" align="center">
               <a href="https://webprepration.com" style="color: #337ab7;">Home</a>|
               <a href="https://webprepration.com/about-us/" style="color: #337ab7;">About Us</a>| 
               <a href="https://webprepration.com/contact-us/" style="color: #337ab7;">Contact</a>
            </div>
         </div>
         <div class="col-xs-12 col-sm-4 col-md-4 col-lg-4">
            <div class="design">
               <a href="https://webprepration.com" style="color: #0274be;">Back to Top</a>
            </div>
         </div>
      </div>
   </div>
</div>
<script src="{{asset('public/js/ajaxscript.js')}}"></script>
<script src="{{asset('public/js/sweetalert.min.js')}}"></script>
<script type="text/javascript">
$("#logo").change(function () {

    jQuery.ajax({
      url:"{{url('/')}}/uploadImage",
       headers: {
         'X-CSRF-TOKEN': "{{csrf_token()}}"
         },

      data:new FormData($("#sitelogo")[0]),
      method:"POST",
      processData: false,
      contentType: false,
      success:function(data){  
      	console.log(data);
      },
      error:function(error){
          console.log(error);
      }
   });
};
</script>
</body>
</html>

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

<!DOCTYPE html>

<head>

<title>Webprepration Demo</title>

</head>

<body>

<span class="sr-only">WEB PREPRATION</span>

</button>

<a class="navbar-brand" href="https://webprepration.com/">WEB PREPRATION</a>

</div>

<li class="sa"><a href="https://webprepration.com/category/wordpress/">WordPress</a></li>

<li class="sa"><a href="https://webprepration.com/category/wordpress/">Plugins</a></li>

<li class="sa"><a href="https://webprepration.com/category/codeignitor/">CodeIgnitor</a></li>

<li class="sa"><a href="https://webprepration.com/category/laravel/">Laravel</a></li>

</ul>

</div>

</div>

</nav>

<div class="panel-heading">Upload Image Using Ajax in Laravel

</div>

</div>

<img id="myImg" src="{{url('/')}}/public/uploads/{{ (isset($setting->logo) && $setting->logo) !='' ? $setting->logo : 'images.jpg'}}" style="max-width: 500px;max-height: 400px;width: 100%;">

</div>

</form>

</div>

</div>

<a href="https://webprepration.com" style="color: #337ab7;">Home</a>|

<a href="https://webprepration.com/about-us/" style="color: #337ab7;">About Us</a>|

<a href="https://webprepration.com/contact-us/" style="color: #337ab7;">Contact</a>

</div>

</div>

$("#logo").change(function () {

jQuery.ajax({

url:"{{url('/')}}/uploadImage",

headers: {

'X-CSRF-TOKEN': "{{csrf_token()}}"

data:new FormData($("#sitelogo")[0]),

method:"POST",

processData: false,

contentType: false,

success:function(data){

console.log(data);

error:function(error){

console.log(error);

}

});

};

</script>

</body>

</html>

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


php artisan serve

php artisan serve

Now you can open below command on browser


http://localhost:8000

http://localhost:8000

View Demo

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

Thanks!!

Webprepration

webprepration.com/

Twitter oAuth login api using php

July 22, 2018 by Webprepration 2 Comments

In this post, I am going to explain “How to create Twitter oAuth Login in php”. Twitter is the most popular social networks and millions of users on twitter, you can increase website subscriber using twitter login because Now a days every web application will have this social network OAuth to improve user comfort level. So user would not need to create separate login credential for each application. By using one twitter account you can register with several websites or applications.It’s really useful when you want to avoid long signup forms for user and let them login with existing popular social media account.

What Is OAuth?

OAuth is the most common authorization framework today, and it is used on most common web applications and services, like GitHub, Google, Facebook and Twitter etc.

This framework allows users to grant you permission to act on their behalf without sharing the account password. After the user has given permission, OAuth will return you a token. This token itself grants access to make requests on behalf of the user.

In this article we will explain that how you can integrate login with twitter in your website. So you have just follow few steps which is given below:-

Step 1:- To access twitter API you need to create twitter app and get the Consumer Key and Consumer Secret. Let’s create new application on the application management page.

After logging in, you need to click the Create New App button and fill in the form with your application details: name, description, website and callback URL.

What is the callback URL?

The URL where Twitter should redirect a user after successful authentication. And change the apps permission to Read and Write or Read, Write and Access direct messages. For changing the apps permission, you need to add a mobile number to your twitter account. Once Twitter App creation is completed, click on Test OAuth for testing OAuth. After testing you would be redirected to the OAuth Settings page. From the OAuth Settings page, you’ll get the Consumer key and Consumer secret.

Step 2:- Create Database Table


CREATE TABLE `users` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `oauth_provider` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
 `oauth_uid` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
 `oauth_token` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
 `oauth_secret_token` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
 `oauth_name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
 `created` datetime NOT NULL,
 `modified` datetime NOT NULL,
 PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

CREATE TABLE `users` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`oauth_provider` varchar(100) COLLATE utf8_unicode_ci NOT NULL,

`oauth_uid` varchar(100) COLLATE utf8_unicode_ci NOT NULL,

`oauth_token` varchar(250) COLLATE utf8_unicode_ci NOT NULL,

`oauth_secret_token` varchar(250) COLLATE utf8_unicode_ci NOT NULL,

`oauth_name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,

`created` datetime NOT NULL,

`modified` datetime NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

Step 3:- Let’s Start Coding

Before start coding we need to download twitter PHP library, I will use I will use TwitterOAuthas the most popular and easy to use. We can install it from the command line with Composer:


composer require abraham/twitteroauth

composer require abraham/twitteroauth

Step 4:- Now after installation we need to create config.php file to define Consumer Key, Consumer Secret and database configuration settings. So just create config.php file and copy below code and paste.


<?php



define("Consumer_Key", "put your consumer Key");

define("Consumer_Secret", "put your consumer secret key");

define("Callback_URL", "put your callback URL ");


define('DB_SERVER', 'localhost');

define('DB_USERNAME', 'database username');

define('DB_PASSWORD', 'enter database password');

define('DB_DATABASE', 'enter database name');

$db = mysqli_connect(DB_SERVER,DB_USERNAME,DB_PASSWORD,DB_DATABASE);

	



?>

<?php

define("Consumer_Key", "put your consumer Key");

define("Consumer_Secret", "put your consumer secret key");

define("Callback_URL", "put your callback URL ");

define('DB_SERVER', 'localhost');

define('DB_USERNAME', 'database username');

define('DB_PASSWORD', 'enter database password');

define('DB_DATABASE', 'enter database name');

$db = mysqli_connect(DB_SERVER,DB_USERNAME,DB_PASSWORD,DB_DATABASE);

Step 5:- Now create index.php file to display button Login with Twitter, If user already login then display Logout button.


<?php 

  session_start();

?>
<!doctype html>
<html>
<head>
<meta charset="utf-8">
<title>Twitter Login using PHP</title>
<style>
.wrapper

{

	width: 800px;

	margin:0 auto;

}

h1

{

	font-size:28px;

	font-family:Gotham, "Helvetica Neue", Helvetica, Arial, sans-serif;

}

</style>

</head>
<body>
<div class="wrapper">
<h1><a href="https://webprepration.com/twitter-login-using-php/">Twitter Login using TwitterOAuth and PHP</a></h1>
<?php	
	if(!isset($_SESSION['name']))
	{
		echo "<a href='twitterLogin.php'><img src='../img/twitter_login_button.png' style='width: 47%;'></a>";

	}else

	{

		echo "User's Name: ". $_SESSION['name'] . "<br>";

		echo "Screen Name: ". $_SESSION['username'] . "<br>";

		echo "Last Tweet: " .$text = $_SESSION['text'].'<br><br>';
		echo "<a href='logout.php'>Logout</a>";
	}

?>
</div>

</body>

</html>

<?php

session_start();

<!doctype html>

<html>

<head>

<title>Twitter Login using PHP</title>

<style>

.wrapper

{

width: 800px;

margin:0 auto;

}

{

font-size:28px;

font-family:Gotham, "Helvetica Neue", Helvetica, Arial, sans-serif;

}

</style>

</head>

<body>

<h1><a href="https://webprepration.com/twitter-login-using-php/">Twitter Login using TwitterOAuth and PHP</a></h1>

<?php

if(!isset($_SESSION['name']))

{

echo "<a href='twitterLogin.php'><img src='../img/twitter_login_button.png' style='width: 47%;'></a>";

}else

{

echo "User's Name: ". $_SESSION['name'] . "<br>";

echo "Screen Name: ". $_SESSION['username'] . "<br>";

echo "Last Tweet: " .$text = $_SESSION['text'].'<br><br>';

echo "<a href='logout.php'>Logout</a>";

}

</div>

</body>

</html>

Start the Login Script

Now create new php file twitterLogin.php and include Composer autoload file, TwitterOAuth library, start session, and import the settings of our application from the config file.


<?php


session_start();

include ('config.php');
require "lib/autoload.php";
use Abraham\TwitterOAuth\TwitterOAuth;


$connection = new TwitterOAuth(Consumer_Key, Consumer_Secret);

$request_token = $connection->oauth("oauth/request_token", array("oauth_callback" => Callback_URL));


$_SESSION['oauth_token'] = $request_token['oauth_token'];

$_SESSION['oauth_token_secret'] = $request_token['oauth_token_secret'];

$url = $connection->url("oauth/authorize", array("oauth_token" => $request_token['oauth_token']));

header('Location: ' . $url);

?>

<?php

session_start();

include ('config.php');

require "lib/autoload.php";

use Abraham\TwitterOAuth\TwitterOAuth;

$connection = new TwitterOAuth(Consumer_Key, Consumer_Secret);

$request_token = $connection->oauth("oauth/request_token", array("oauth_callback" => Callback_URL));

$_SESSION['oauth_token'] = $request_token['oauth_token'];

$_SESSION['oauth_token_secret'] = $request_token['oauth_token_secret'];

$url = $connection->url("oauth/authorize", array("oauth_token" => $request_token['oauth_token']));

header('Location: ' . $url);

Now create new php file Twitterback.php file and handle all the process like authorization and database process. So just copy below code and paste.


<?php
session_start();

include ('config.php');
require "lib/autoload.php";
use Abraham\TwitterOAuth\TwitterOAuth;

if($_GET['oauth_token'] || $_GET['oauth_verifier'])
{
	
$connection = new TwitterOAuth(Consumer_Key, Consumer_Secret, $_SESSION['oauth_token'], $_SESSION['oauth_token_secret']);
$access_token = $connection->oauth('oauth/access_token', array('oauth_verifier' => $_REQUEST['oauth_verifier'], 'oauth_token'=> $_GET['oauth_token']));

	$connection = new TwitterOAuth(Consumer_Key, Consumer_Secret, $access_token['oauth_token'], $access_token['oauth_token_secret']);

	$user_info = $connection->get('account/verify_credentials');
	
	$oauth_token = $access_token['oauth_token'];
	$oauth_token_secret = $access_token['oauth_token_secret'];
//echo "<pre>";
//print_r($user_info);
    $user_id = $user_info->id;
	$user_name = $user_info->name;
	$user_pic = $user_info->profile_image_url_https;
	$text = $user_info->status->text;
	$username = $user_info->screen_name;
	
	$sql="SELECT uid FROM users WHERE oauth_provider = 'twitter' and oauth_id = $user_id";
	$result=mysqli_query($db,$sql);
	$row=mysqli_fetch_array($result,MYSQLI_ASSOC);
		
	if(mysqli_num_rows($result) == 1)
	{
		$query = mysqli_query($db, "UPDATE users SET oauth_token = '$oauth_token', oauth_secret_token = '$oauth_token_secret' WHERE oauth_provider = 'twitter' and oauth_id = $user_id");

		if($query)
		{
			$_SESSION['name'] = $user_name;
			$_SESSION['dp'] = $user_pic;
			$_SESSION['text'] = $text;
			$_SESSION['username'] = $username;
				
			header('Location: index.php');
		}else
		{
			echo mysqli_error($db);
		}

	}else
	{
		 $query = mysqli_query($db, "INSERT INTO users (oauth_id, oauth_provider, oauth_token, oauth_secret_token, oauth_name) VALUES ($user_id, 'twitter', '$oauth_token', '$oauth_token_secret', '$user_name')");
		
		if($query)
		{
			$_SESSION['username'] = $username;
			$_SESSION['text'] = $text;
			$_SESSION['name'] = $user_name;
			$_SESSION['dp'] = $user_pic;
			header('Location: index.php');
		}else
		{
			echo mysqli_error($db);
		}
	}
}else
{
	header('Location: twitterLogin.php');
}

?>

<?php

session_start();

include ('config.php');

require "lib/autoload.php";

use Abraham\TwitterOAuth\TwitterOAuth;

if($_GET['oauth_token'] || $_GET['oauth_verifier'])

{

$connection = new TwitterOAuth(Consumer_Key, Consumer_Secret, $_SESSION['oauth_token'], $_SESSION['oauth_token_secret']);

$access_token = $connection->oauth('oauth/access_token', array('oauth_verifier' => $_REQUEST['oauth_verifier'], 'oauth_token'=> $_GET['oauth_token']));

$connection = new TwitterOAuth(Consumer_Key, Consumer_Secret, $access_token['oauth_token'], $access_token['oauth_token_secret']);

$user_info = $connection->get('account/verify_credentials');

$oauth_token = $access_token['oauth_token'];

$oauth_token_secret = $access_token['oauth_token_secret'];

//echo "<pre>";

//print_r($user_info);

$user_id = $user_info->id;

$user_name = $user_info->name;

$user_pic = $user_info->profile_image_url_https;

$text = $user_info->status->text;

$username = $user_info->screen_name;

$sql="SELECT uid FROM users WHERE oauth_provider = 'twitter' and oauth_id = $user_id";

$result=mysqli_query($db,$sql);

$row=mysqli_fetch_array($result,MYSQLI_ASSOC);

if(mysqli_num_rows($result) == 1)

{

$query = mysqli_query($db, "UPDATE users SET oauth_token = '$oauth_token', oauth_secret_token = '$oauth_token_secret' WHERE oauth_provider = 'twitter' and oauth_id = $user_id");

if($query)

{

$_SESSION['name'] = $user_name;

$_SESSION['dp'] = $user_pic;

$_SESSION['text'] = $text;

$_SESSION['username'] = $username;

header('Location: index.php');

}else

{

echo mysqli_error($db);

}

}else

{

$query = mysqli_query($db, "INSERT INTO users (oauth_id, oauth_provider, oauth_token, oauth_secret_token, oauth_name) VALUES ($user_id, 'twitter', '$oauth_token', '$oauth_token_secret', '$user_name')");

if($query)

{

$_SESSION['username'] = $username;

$_SESSION['text'] = $text;

$_SESSION['name'] = $user_name;

$_SESSION['dp'] = $user_pic;

header('Location: index.php');

}else

{

echo mysqli_error($db);

}

}else

{

header('Location: twitterLogin.php');

}

View Demo

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

Thanks!!

Webprepration

webprepration.com/

How to create and use Middleware in Laravel 5

July 12, 2018 by Webprepration Leave a Comment

Laravel is the best framework in php. Laravel framework provide saveral functionality and you can also find from this site. But now in this post you can learn middleware. Middleware as a filter in laravel all HTTP requests entering your application.Middleware works between request and response of our application.It sits between Request and Response like a firewall.

What are middlewares in Laravel

In Laravel middleware as filter that are used to filter all HTTP requests entering your application. Middleware works between request and response of our application. It sits between Request and Response like a

firewall that examine whether to route a request. Laravel has several inbuilt middleware like EncryptCookies, RedirectIfAuthenticated, TrimStrings, TrustProxies etc . All middleware located in app/Http/Middleware folder.

Types of Middleware in laravel

There are three types of middleware in laravel

Global Middleware
Route Middleware Groups
Route Middleware

Create Admin Middleware

In this example, I added middleware for check if user is admin then it can open admin routes. So i added userType column in my users table. If user have userType admin then it can access “admin ” routes.

So first create IsAdmin middleware using below command.


php artisan make:middleware IsAdmin

php artisan make:middleware IsAdmin

Now you can found IsAdmin.php file in app/Http/Middleware directory and open IsAdmin.php file and paste below code in that file.


<?php

namespace App\Http\Middleware;

use Closure;
use Illuminate\Support\Facades\Auth;

class IsAdmin
{
    /**
     * Handle an incoming request.
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  \Closure  $next
     * @return mixed
     */
    public function handle($request, Closure $next)
    {
         if (Auth::user() &&  Auth::user()->userType == 'admin') {
                return $next($request);
         }

        return redirect('/');
    }
}

<?php

namespace App\Http\Middleware;

use Closure;

use Illuminate\Support\Facades\Auth;

class IsAdmin

{

/**

* Handle an incoming request.

* @param \Illuminate\Http\Request $request

* @param \Closure $next

* @return mixed

public function handle($request, Closure $next)

{

if (Auth::user() && Auth::user()->userType == 'admin') {

return $next($request);

}

return redirect('/');

}

Now we need to register and create alias of above created middleware in Kernel.php file, So first open Kernel.php file and below line.

app/Http/Kernel.php


<?php

namespace App\Http;
use Illuminate\Foundation\Http\Kernel as HttpKernel;
class Kernel extends HttpKernel
{
	......
	protected $routeMiddleware = [
        ......
        'admin' => \App\Http\Middleware\IsAdmin::class,
    ];
}

<?php

namespace App\Http;

use Illuminate\Foundation\Http\Kernel as HttpKernel;

class Kernel extends HttpKernel

{

......

protected $routeMiddleware = [

......

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

];

}

Now we are ready to use admin Middleware in routes.php file, So you can see how to use middleware in routes.php file

routes/web.php


/// Admin Route
Route::group(['prefix' => 'admin','middleware' => ['auth', 'admin']], function () {    
    Route::get('/','Admin\AdminController@index')->name('admin');
});

/// Admin Route

Route::group(['prefix' => 'admin','middleware' => ['auth', 'admin']], function () {

Route::get('/','Admin\AdminController@index')->name('admin');

});

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

Thanks!!

Webprepration

webprepration.com/