Category Archives: Blog

Blog

Laravel 7/6 Send Notifications as Voice Call

In this Laravel 7/6 Send Notifications as Voice Call tutorial I will show you how to Send notification as voice call in Laravel. In this tutorial, you will learn send notification as Voice or Phone call in laravel. In this example we will be using nexmo-voice-channel for the send voice notification. In this step by step guide I’ll demonstrate you how to send notification as voice call in Laravel.

Laravel 7/6 Send Notifications as Voice Call

1. Install notifcation package

In first step, we will install voice notification Package via the composer dependency manager. Use the following command to install voice notification Package.

 composer require roomies/nexmo-voice-channel

1	composer require roomies/nexmo-voice-channel

2. Configure nexmo credentials in .env

After installing nexmo-voice-channel voice notification Package we will set require application id and private key as following in .env file:

NEXMO_APPLICATION_ID=
NEXMO_PRIVATE_KEY=

1 2	NEXMO_APPLICATION_ID= NEXMO_PRIVATE_KEY=

Then add your call from number and voice to config/services.php under the nexmo key. You can review the available voices in the Nexmo documentation.

'nexmo' => [
    'call_from' => env('NEXMO_CALL_FROM'),
    'call_voice' => env('NEXMO_CALL_VOICE', 'Kimberly'),
],

'nexmo' => [

'call_from' => env('NEXMO_CALL_FROM'),

'call_voice' => env('NEXMO_CALL_VOICE', 'Kimberly'),

3. Create a Notification channel

Now, in this step we will create notification channel as following:

use Roomies\NexmoVoiceChannel\Markup\Message;
use Roomies\NexmoVoiceChannel\Markup\SayAs;
use Roomies\NexmoVoiceChannel\Markup\Sentence;
use Roomies\NexmoVoiceChannel\NexmoVoiceChannel;
 
/**
 * Get the notification's delivery channels.
 *
 * @param  mixed  $notifiable
 * @return array
 */
public function via($notifiable)
{
    return [NexmoVoiceChannel::class];
}
 
/**
 * Get the voice representation of the notification.
 *
 * @param  mixed  $notifiable
 * @return \Roomies\NexmoVoiceChannel\Markup\Message
 */
public function toVoice($notifiable)
{
    return new Message([
        new Sentence('Hi, thanks for joining Roomies.'),
        new Sentence([
            'Your verification code is',
            new SayAs('ABC123')->interpretAs('spell-out')
        ]),
    ]);
}

use Roomies\NexmoVoiceChannel\Markup\Message;

use Roomies\NexmoVoiceChannel\Markup\SayAs;

use Roomies\NexmoVoiceChannel\Markup\Sentence;

use Roomies\NexmoVoiceChannel\NexmoVoiceChannel;

/**

* Get the notification's delivery channels.

* @param mixed $notifiable

* @return array

public function via($notifiable)

{

return [NexmoVoiceChannel::class];

}

/**

* Get the voice representation of the notification.

* @param mixed $notifiable

* @return \Roomies\NexmoVoiceChannel\Markup\Message

public function toVoice($notifiable)

{

return new Message([

new Sentence('Hi, thanks for joining Roomies.'),

new Sentence([

'Your verification code is',

new SayAs('ABC123')->interpretAs('spell-out')

]),

]);

}

In the below is another example demonstrating the package’s markup types you can use to create a notification:

new Sentence([
    'Hey!',
    (new Pause)->time('1s'),
    (new Prosody('Wake up!'))->volume('loud'),
    (new Substitution(
        (new SayAs('US'))->interpretAs('spell-out'),
    ))->alias('United States'),
])

new Sentence([

'Hey!',

(new Pause)->time('1s'),

(new Prosody('Wake up!'))->volume('loud'),

(new Substitution(

(new SayAs('US'))->interpretAs('spell-out'),

))->alias('United States'),

])

Laravel 7/6 Generate Unique Slug Example

In this Laravel 7/6 Generate Unique Slug Example I will show you how to generate unique slug for blog posts title in laravel application. In this tutorial you will learn to generate unique slug for post title. In this example I will demonstrate you to generate unique slug or seo friendly slug url for post title. We will be using cviebrock eloquent sluggable laravel package for generating seo friendly url in laravel.

Laravel 7/6 Generate Unique Slug Example

Install Laravel Fresh New Setup
Setup Database Credentials
Install Eloquent Sluggable Package
Generate Model and Migration
Create Resource Route & Controller
Create the blade view
Start Development Server
Conclusion

1). Install Laravel Fresh New Setup

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

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

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

2. Setup Database Credentials

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

DB_CONNECTION=mysql 
DB_HOST=127.0.0.1 
DB_PORT=3306 
DB_DATABASE=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 Eloquent Sluggable Package

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

composer require cviebrock/eloquent-sluggable

1	composer require cviebrock/eloquent-sluggable

After installing eloquent sluggable package, run the following command:

php artisan vendor:publish --provider="Cviebrock\EloquentSluggable\ServiceProvider"

1	php artisan vendor:publish --provider="Cviebrock\EloquentSluggable\ServiceProvider"

4. Generate Model and Migration

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

php artisan make:model Post -m

1	php artisan make:model Post -m

The above command will create a model name Post and also create a migration file for the post table. Now put the 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->increments('id'); 
            $table->string('title'); 
            $table->string('slug'); 
            $table->text('description'); 
            $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->increments('id');

$table->string('title');

$table->string('slug');

$table->text('description');

$table->timestamps();

});

}

/**

* Reverse the migrations.

* @return void

public function down()

{

Schema::dropIfExists('posts');

}

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

php artisan migrate

1	php artisan migrate

If you found any query builder error in command prompt go to => app\Providers\AppServiceProvider.php and put the below code here :

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

use Illuminate\Support\Facades\Schema;

public function boot()

{

Schema::defaultStringLength(191);

}

And then run this below command :

 php artisan migrate:fresh

1	php artisan migrate:fresh

Now, add the fillable property inside Post.php file as following:

<?php
 namespace App;
 use Illuminate\Database\Eloquent\Model;
 use Cviebrock\EloquentSluggable\Sluggable;
 class Post extends Model
 {
     protected $fillable = [
     'title',
     'slug',
     'description',
    ];
    public function sluggable()
    {
        return [
            'slug' => [
                'source' => 'title'
            ]
        ];
    }
 }

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

use Cviebrock\EloquentSluggable\Sluggable;

class Post extends Model

{

protected $fillable = [

'title',

'slug',

'description',

];

public function sluggable()

{

return [

'slug' => [

'source' => 'title'

]

];

}

5. Create Resource Route & Controller

In this step we will create a resource route and controller using following command:

php artisan make:controller PostController  --resource

1	php artisan make:controller PostController --resource

now, we have to add the resource route. Go to routes/web.php put the below routes here :

<?php 
 
 Route::get('/', function () {
     return view('welcome');
 });
  
Route::resource('posts', 'PostController');

<?php

Route::get('/', function () {

return view('welcome');

});

Route::resource('posts', 'PostController');

Now, go to app/HTTP/Controller/PostController and put the below code here :

<?php
   
namespace App\Http\Controllers;
   
use App\Post;
use Illuminate\Http\Request;
use Redirect;
use Cviebrock\EloquentSluggable\Services\SlugService;
   
class PostController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
        $data['post'] = Post::orderBy('id','desc')->paginate(10);
   
        return view('post.list',$data);
    }
    
    /**
     * Show the form for creating a new resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function create()
    {
        return view('post.create');
    }
   
    /**
     * Store a newly created resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @return \Illuminate\Http\Response
     */
    public function store(Request $request)
    {
        $request->validate([
            'title' => 'required',
            'description' => 'required',
        ]);
 
        $insert = [
            'slug' => SlugService::createSlug(Post::class, 'slug', $request->title),
            'title' => $request->title,
            'description' => $request->description,
        ];
   
        Post::insertGetId($insert);
    
        return Redirect::to('posts')
       ->with('success','Greate! posts created successfully.');
    }
    
    /**
     * Display the specified resource.
     *
     * @param  \App\Post $post
     * @return \Illuminate\Http\Response
     */
    public function show(Request $request)
    {
         
    }
    
    /**
     * Show the form for editing the specified resource.
     *
     * @param  \App\Post $post
     * @return \Illuminate\Http\Response
     */
    public function edit($id)
    {   
 
    }
   
    /**
     * Update the specified resource in storage.
     *
     * @param  \Illuminate\Http\Request  $request
     * @param  \App\Post $post
     * @return \Illuminate\Http\Response
     */
    public function update(Request $request, $id)
    {
 
    }
   
    /**
     * Remove the specified resource from storage.
     *
     * @param  \App\Post  $post
     * @return \Illuminate\Http\Response
     */
    public function destroy($id)
    {
 
    }
     
}

100

101

102

103

104

<?php

namespace App\Http\Controllers;

use App\Post;

use Illuminate\Http\Request;

use Redirect;

use Cviebrock\EloquentSluggable\Services\SlugService;

class PostController extends Controller

{

/**

* Display a listing of the resource.

* @return \Illuminate\Http\Response

public function index()

{

$data['post'] = Post::orderBy('id','desc')->paginate(10);

return view('post.list',$data);

}

/**

* Show the form for creating a new resource.

* @return \Illuminate\Http\Response

public function create()

{

return view('post.create');

}

/**

* Store a newly created resource in storage.

* @param \Illuminate\Http\Request $request

* @return \Illuminate\Http\Response

public function store(Request $request)

{

$request->validate([

'title' => 'required',

'description' => 'required',

]);

$insert = [

'slug' => SlugService::createSlug(Post::class, 'slug', $request->title),

'title' => $request->title,

'description' => $request->description,

];

Post::insertGetId($insert);

return Redirect::to('posts')

->with('success','Greate! posts created successfully.');

}

/**

* Display the specified resource.

* @param \App\Post $post

* @return \Illuminate\Http\Response

public function show(Request $request)

{

}

/**

* Show the form for editing the specified resource.

* @param \App\Post $post

* @return \Illuminate\Http\Response

public function edit($id)

{

}

/**

* Update the specified resource in storage.

* @param \Illuminate\Http\Request $request

* @param \App\Post $post

* @return \Illuminate\Http\Response

public function update(Request $request, $id)

{

}

/**

* Remove the specified resource from storage.

* @param \App\Post $post

* @return \Illuminate\Http\Response

public function destroy($id)

{

}

6. Create the blade view

Now we will create following blade files:

List.blade.php
Create.blade.php

List.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 Generate Unique Slug For Post With Example</title>
    <link href="//maxcdn.bootstrapcdn.com/bootstrap/4.1.1/css/bootstrap.min.css" rel="stylesheet" id="bootstrap-css">
    <style>
    body{
    background-color: #25274d;
    }
    .container{
    background: #ff9b00;
    padding: 4%;
    border-top-left-radius: 0.5rem;
    border-bottom-left-radius: 0.5rem;
    }
    </style>
  </head>
  <body>
    <div class="container">
      <a href="{{ route('posts.create') }}" class="btn btn-success mb-2">Add Post</a> <br>
      <div class="row">
            <div class="col-12">
              
              <table class="table table-bordered" id="laravel_unique_slug_table">
               <thead>
                  <tr>
                     <th>Id</th>
                     <th>Title</th>
                     <th>Slug</th>
                     <th>Description</th>
                  </tr>
               </thead>
               <tbody>
                  @foreach($posts as $post)
                  <tr>
                     <td>{{ $post->id }}</td>
                     <td>{{ $post->title }}</td>
                     <td>{{ $post->slug }}</td>
                     <td>{{ $post->description }}</td>
                  </tr>
                  @endforeach
               </tbody>
              </table>
              {!! $posts->links() !!}
           </div> 
      </div>
    </div>
  </body>
</html>

<!DOCTYPE html>

<html>

<head>

<title>Laravel Generate Unique Slug For Post With Example</title>

<style>

body{

background-color: #25274d;

}

.container{

background: #ff9b00;

padding: 4%;

border-top-left-radius: 0.5rem;

border-bottom-left-radius: 0.5rem;

}

</style>

</head>

<body>

<thead>

<tr>

<th>Title</th>

<th>Description</th>

</tr>

</thead>

<tbody>

@foreach($posts as $post)

<tr>

<td>{{ $post->title }}</td>

<td>{{ $post->description }}</td>

</tr>

@endforeach

</tbody>

</table>

{!! $posts->links() !!}

</div>

</body>

</html>

Create.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 Create Post With Unique Slug- w3adda.com</title>
    <link href="//maxcdn.bootstrapcdn.com/bootstrap/4.1.1/css/bootstrap.min.css" rel="stylesheet" id="bootstrap-css">
    <style>
    body{
    background-color: #25274d;
    }
    .container{
    background: #ff9b00;
    padding: 4%;
    border-top-left-radius: 0.5rem;
    border-bottom-left-radius: 0.5rem;
    }
    </style>
  </head>
  <body>
    <div class="container">
 
      <form action="{{ route('posts.store') }}" method="POST" name="add_post">
        {{ csrf_field() }}
 
        <div class="row">
            <div class="col-md-12">
                <div class="form-group">
                    <strong>Title</strong>
                    <input type="text" name="title" class="form-control" placeholder="Enter Title">
                    <span class="text-danger">{{ $errors->first('title') }}</span>
                </div>
            </div>
            <div class="col-md-12">
                <div class="form-group">
                    <strong>Description</strong>
                    <textarea class="form-control" col="4" name="description" placeholder="Enter Description"></textarea>
                    <span class="text-danger">{{ $errors->first('description') }}</span>
                </div>
            </div>
            <div class="col-md-12">
                <button type="submit" class="btn btn-primary">Submit</button>
            </div>
        </div>
 
      </form>
 
    </div>
  </body>
</html>

<!DOCTYPE html>

<html>

<head>

<title>Laravel Create Post With Unique Slug- w3adda.com</title>

<style>

body{

background-color: #25274d;

}

.container{

background: #ff9b00;

padding: 4%;

border-top-left-radius: 0.5rem;

border-bottom-left-radius: 0.5rem;

}

</style>

</head>

<body>

<strong>Title</strong>

<span class="text-danger">{{ $errors->first('title') }}</span>

</div>

<strong>Description</strong>

<span class="text-danger">{{ $errors->first('description') }}</span>

</div>

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

</div>

</form>

</div>

</body>

</html>

7. Run Development Server

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

php artisan serve

1	php artisan serve

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

http://localhost:8000/posts

1	http://localhost:8000/posts

Laravel Get Record Last Week, Month, 15 Days, Year

In this Laravel Get Record Last Week, Month, 15 Days, Year tutorial I will show you how to fetch records for last 1, 3, 6, 12 months and get the last date, last week, last, month, last year data records in laravel. In this tutorial you will learn how to get the last 1, 3, 6, 12 months, the last date, last week, last, month, last year data records in laravel.

Laravel Get Record Last Week, Month, 15 Days, Year

Table Of Content

Laravel Get Last Day Records
Get Last Week Data in Laravel
Laravel Get Last Month Records
Get Last 15 Days & 30 Days Records in Laravel
Fetch Month Wise Last Year Data
Fetch Last Year Record

Laravel Get Last Day Records

If you want to fetch records for last day from database tables. Provided eloquent Query can be used to fetch records for last day.

User::where('created_at','>=',Carbon::now()->subdays(1))->get(['name','created_at']);

1	User::where('created_at','>=',Carbon::now()->subdays(1))->get(['name','created_at']);

The output of the above laravel eloquent query looks like:

Array
(
    [0] => Array
        (
            [name] => Денис Борисов
            [created_at] => 2019-12-10 11:23:14
        )
 
    [1] => Array
        (
            [name] => tt
            [created_at] => 2019-12-10 12:07:19
        )
 
    [2] => Array
        (
            [name] => ajay
            [created_at] => 2019-12-10 12:26:25
        )
 
    [3] => Array
        (
            [name] => Ramakrishna P
            [created_at] => 2019-12-10 12:50:06
        )
)

Array

(

[0] => Array

(

[name] => Денис Борисов

[created_at] => 2019-12-10 11:23:14

)

[1] => Array

(

[name] => tt

[created_at] => 2019-12-10 12:07:19

)

[2] => Array

(

[name] => ajay

[created_at] => 2019-12-10 12:26:25

)

[3] => Array

(

[name] => Ramakrishna P

[created_at] => 2019-12-10 12:50:06

)

Get Last Week Data in Laravel

If you want to fetch records for current date from last week. Provided eloquent Query can be used to fetch records for last week. You can use the laravel eloquent method whereBetween to get the last week records from the database table as follow:

 $previous_week = strtotime("-1 week +1 day");
 $start_week = strtotime("last sunday midnight",$previous_week);
 $end_week = strtotime("next saturday",$start_week);
 $start_week = date("Y-m-d",$start_week);
 $end_week = date("Y-m-d",$end_week);

 User::whereBetween('created_at', [$start_week, $end_week])->get(['name','created_at']);

$previous_week = strtotime("-1 week +1 day");

$start_week = strtotime("last sunday midnight",$previous_week);

$end_week = strtotime("next saturday",$start_week);

$start_week = date("Y-m-d",$start_week);

$end_week = date("Y-m-d",$end_week);

User::whereBetween('created_at', [$start_week, $end_week])->get(['name','created_at']);

The output of the above laravel eloquent query looks like:

Array
(
    [0] => Array
        (
            [name] => 1
            [created_at] => 2019-12-01 01:07:28
        )
 
    [1] => Array
        (
            [name] => 2
            [created_at] => 2019-12-03 01:07:38
        )
 
    [2] => Array
        (
            [name] => 3
            [created_at] => 2019-12-04 01:07:46
        )
 
    [3] => Array
        (
            [name] => 4
            [created_at] => 2019-12-06 01:07:52
        )
 
    [4] => Array
        (
            [name] => 5
            [created_at] => 2019-12-07 01:07:57
        )
 )

Array

(

[0] => Array

(

[name] => 1

[created_at] => 2019-12-01 01:07:28

)

[1] => Array

(

[name] => 2

[created_at] => 2019-12-03 01:07:38

)

[2] => Array

(

[name] => 3

[created_at] => 2019-12-04 01:07:46

)

[3] => Array

(

[name] => 4

[created_at] => 2019-12-06 01:07:52

)

[4] => Array

(

[name] => 5

[created_at] => 2019-12-07 01:07:57

)

Laravel Get Last Month records

If you want to fetch records for last month from database tables. Provided eloquent Query can be used to fetch records for last month.

User::whereMonth('created_at', '=', Carbon::now()->subMonth()->month)->get(['name','created_at']);

1	User::whereMonth('created_at', '=', Carbon::now()->subMonth()->month)->get(['name','created_at']);

This query uses laravel method whereMonth() and get().

The output of the above laravel Eloquent query look like

Array
(
    [0] => Array
        (
            [name] => d
            [created_at] => 2019-11-01 02:03:51
        )
 
    [1] => Array
        (
            [name] => vichhai
            [created_at] => 2019-11-05 02:52:43
        )
 
    [2] => Array
        (
            [name] => Dalang Ly
            [created_at] => 2019-11-20 03:06:20
        )
 
    [3] => Array
        (
            [name] => ssa
            [created_at] => 2019-11-25 04:03:42
        )
 
    [4] => Array
        (
            [name] => Razeek
            [created_at] => 2019-11-30 04:57:53
        )
)

Array

(

[0] => Array

(

[name] => d

[created_at] => 2019-11-01 02:03:51

)

[1] => Array

(

[name] => vichhai

[created_at] => 2019-11-05 02:52:43

)

[2] => Array

(

[name] => Dalang Ly

[created_at] => 2019-11-20 03:06:20

)

[3] => Array

(

[name] => ssa

[created_at] => 2019-11-25 04:03:42

)

[4] => Array

(

[name] => Razeek

[created_at] => 2019-11-30 04:57:53

)

Get Last 15 Days & 30 Days Records in Laravel

If you want to fetch records for last 15 days or 30 Days from database tables. Provided eloquent Query can be used to fetch records for last 15 days or 30 days.

last_15_days = User::where('created_at','>=',Carbon::now()->subdays(15))->get(['name','created_at']);

 $last_30_days = User::where('created_at','>=',Carbon::now()->subdays(30))->get(['name','created_at']);

last_15_days = User::where('created_at','>=',Carbon::now()->subdays(15))->get(['name','created_at']);

$last_30_days = User::where('created_at','>=',Carbon::now()->subdays(30))->get(['name','created_at']);

Laravel Get Last Year Record

If you want to fetch records for last year from database tables. Provided eloquent Query can be used to fetch records for last year.

User::whereYear('created_at', date('Y', strtotime('-1 year')))->get(['name','created_at']);

1	User::whereYear('created_at', date('Y', strtotime('-1 year')))->get(['name','created_at']);

This query users laravel method whereYear() and get() to fetch records from db.

The output of above laravel eloquent query looks like

Array
(
    [0] => Array
        (
            [name] => James
            [created_at] => 2018-03-07 21:18:59
        )
 
    [1] => Array
        (
            [name] => Maaf Kan Lah
            [created_at] => 2018-03-07 21:18:59
        )
 
    [2] => Array
        (
            [name] => Helloo
            [created_at] => 2018-03-07 21:18:59
        )
 
    [3] => Array
        (
            [name] => hiiiiii888
            [created_at] => 2018-03-07 21:18:59
        )
 
    [4] => Array
        (
            [name] => Hellogggggg123
            [created_at] => 2018-03-07 21:18:59
        )
 
    [5] => Array
        (
            [name] => Df
            [created_at] => 2018-03-07 21:18:59
        )
 
)

Array

(

[0] => Array

(

[name] => James

[created_at] => 2018-03-07 21:18:59

)

[1] => Array

(

[name] => Maaf Kan Lah

[created_at] => 2018-03-07 21:18:59

)

[2] => Array

(

[name] => Helloo

[created_at] => 2018-03-07 21:18:59

)

[3] => Array

(

[name] => hiiiiii888

[created_at] => 2018-03-07 21:18:59

)

[4] => Array

(

[name] => Hellogggggg123

[created_at] => 2018-03-07 21:18:59

)

[5] => Array

(

[name] => Df

[created_at] => 2018-03-07 21:18:59

)

Fetch Month Wise Last Year Data

If you want to fetch month wise records from database tables. Provided eloquent Query can be used to fetch month wise records. You can use the laravel db::raw(), whereYear() and groupBy() to get previous year data month wise from the database table as follow:

User::select(DB::raw("(COUNT(*)) as count"),DB::raw("MONTHNAME(created_at) as monthname"))
 ->whereYear('created_at', date('Y', strtotime('-1 year')))
 ->groupBy('monthname')
 ->get();

User::select(DB::raw("(COUNT(*)) as count"),DB::raw("MONTHNAME(created_at) as monthname"))

->whereYear('created_at', date('Y', strtotime('-1 year')))

->groupBy('monthname')

->get();

The output of the above laravel eloquent query looks like

Array
(
    [0] => Array
        (
            [count] => 6
            [monthname] => March
        )
 
)

Array

(

[0] => Array

(

[count] => 6

[monthname] => March

)

Laravel Get Current Date, Week, Month Wise, YEAR Data

In this Laravel Get Current Date, Week, Month Wise, YEAR Data tutorial I will show you how to get current date, current week, current, month, current year data in laravel. In this tutorial you will learn to get current date, current week, current, month, current year data in laravel.

Laravel Get Current Date, Week, Month Wise, YEAR Data

Table Of Content

Current Date Record Laravel
Get Current Week Data in Laravel
To Get Current Month Data in Laravel
Laravel Get Month Wise Current Year Data
Get Day Wise Current Week Data Laravel
Laravel Get Data Year Wise

Current Date Record Laravel

If you want to fetch records for current date from database tables. Provided eloquent Query can be used to fetch records for current date.

User::whereDate('created_at', Carbon::today())->get(['name','created_at']);

1	User::whereDate('created_at', Carbon::today())->get(['name','created_at']);

The output of the above laravel eloquent query looks like:

Array
(
    [0] => Array
        (
            [name] => dsfds
            [created_at] => 2019-12-08 17:58:41
        )
 
)

Array

(

[0] => Array

(

[name] => dsfds

[created_at] => 2019-12-08 17:58:41

)

Get Current Week Data in Laravel

If you want to fetch records for current week from database tables. Provided eloquent Query can be used to fetch records for current week.

$current_week = User::whereBetween('created_at', [Carbon::now()->startOfWeek(), Carbon::now()->endOfWeek()])->get();

1	$current_week = User::whereBetween('created_at', [Carbon::now()->startOfWeek(), Carbon::now()->endOfWeek()])->get();

This query uses laravel eloquent method whereBetween().

The output of the above laravel eloquent query looks like:

Array
(
    [0] => Array
        (
            [name] => Gowsegan
            [created_at] => 2019-12-09 00:38:03
        )
 
    [1] => Array
        (
            [name] => Brookside Dairy Best
            [created_at] => 2019-12-09 05:13:17
        )
 
    [2] => Array
        (
            [name] => abc
            [created_at] => 2019-12-09 05:21:20
        )
 
    [3] => Array
        (
            [name] => test
            [created_at] => 2019-12-09 05:34:00
        )
 
    [4] => Array
        (
            [name] => StartBit Solutions
            [created_at] => 2019-12-09 06:00:04
        )
 )

Array

(

[0] => Array

(

[name] => Gowsegan

[created_at] => 2019-12-09 00:38:03

)

[1] => Array

(

[name] => Brookside Dairy Best

[created_at] => 2019-12-09 05:13:17

)

[2] => Array

(

[name] => abc

[created_at] => 2019-12-09 05:21:20

)

[3] => Array

(

[name] => test

[created_at] => 2019-12-09 05:34:00

)

[4] => Array

(

[name] => StartBit Solutions

[created_at] => 2019-12-09 06:00:04

)

To Get Current Month Data in Laravel

If you want to fetch records for current month from database tables. Provided eloquent Query can be used to fetch records for current month.

User::whereMonth('created_at', date('m'))
->whereYear('created_at', date('Y'))
->get(['name','created_at']);

User::whereMonth('created_at', date('m'))

->whereYear('created_at', date('Y'))

->get(['name','created_at']);

This query users laravel method whereMonth, whereYear and get().

The output of the above laravel eloquent query looks like:

Array
(
    [0] => Array
        (
            [name] => dsfds
            [created_at] => 2019-12-08 17:58:41
        )
 
)

Array

(

[0] => Array

(

[name] => dsfds

[created_at] => 2019-12-08 17:58:41

)

Laravel Get Month Wise Current Year Data

If you want to fetch month wise records from database tables. Provided eloquent Query can be used to fetch month wise records.

User::select(DB::raw("(COUNT(*)) as count"),DB::raw("MONTHNAME(created_at) as monthname"))
->whereYear('created_at', date('Y'))
->groupBy('monthname')
->get();

User::select(DB::raw("(COUNT(*)) as count"),DB::raw("MONTHNAME(created_at) as monthname"))

->whereYear('created_at', date('Y'))

->groupBy('monthname')

->get();

This query uses db::raw(), whereYear(), and groupBy() methods.

Output of the above laravel eloquent query is look like

Array
(
    [0] => Array
        (
            [count] => 9
            [monthname] => February
        )
 
    [1] => Array
        (
            [count] => 2
            [monthname] => September
        )
 
)

Array

(

[0] => Array

(

[count] => 9

[monthname] => February

)

[1] => Array

(

[count] => 2

[monthname] => September

)

Get Day Wise Current Week Data Laravel

If you want to fetch day wise records from database tables. Provided eloquent Query can be used to fetch day wise records.

User::select(DB::raw("(COUNT(*)) as count"),DB::raw("DAYNAME(created_at) as dayname"))
     ->whereBetween('created_at', [Carbon::now()->startOfWeek(), Carbon::now()->endOfWeek()])
    ->whereYear('created_at', date('Y'))
    ->groupBy('dayname')
    ->get();
;

User::select(DB::raw("(COUNT(*)) as count"),DB::raw("DAYNAME(created_at) as dayname"))

->whereBetween('created_at', [Carbon::now()->startOfWeek(), Carbon::now()->endOfWeek()])

->whereYear('created_at', date('Y'))

->groupBy('dayname')

->get();

;

The output of the above laravel eloquent query looks like:

Array
(
    [0] => Array
        (
            [count] => 45
            [dayname] => Monday
        )
 
    [1] => Array
        (
            [count] => 41
            [dayname] => Tuesday
        )
 
    [2] => Array
        (
            [count] => 12
            [dayname] => Wednesday
        )
 
)

Array

(

[0] => Array

(

[count] => 45

[dayname] => Monday

)

[1] => Array

(

[count] => 41

[dayname] => Tuesday

)

[2] => Array

(

[count] => 12

[dayname] => Wednesday

)

Laravel Get Data Year Wise

If you want to fetch year wise records from database tables. Provided eloquent Query can be used to fetch year wise records.

User::select(DB::raw("(COUNT(*)) as count"),DB::raw("YEAR(created_at) as year"))
->groupBy('year')
->get();

User::select(DB::raw("(COUNT(*)) as count"),DB::raw("YEAR(created_at) as year"))

->groupBy('year')

->get();

The output of the above laravel eloquent query looks like:

Array
(
    [0] => Array
        (
            [count] => 6
            [year] => 2018
        )
 
    [1] => Array
        (
            [count] => 9618
            [year] => 2019
        )
 
)

Array

(

[0] => Array

(

[count] => 6

[year] => 2018

)

[1] => Array

(

[count] => 9618

[year] => 2019

)

Laravel 7/6 Highcharts Example Tutorial

In this Laravel 7/6 Highcharts Example Tutorial I will show you how to implement highchart in laravel application. In this tutorial you will learn to implement highchart in laravel. In this example I will demonstrate the use of highchart in laravel application. In this example we will fetch month wise data and display month wise data in highcharts for analytics on laravel application.

Laravel 7/6 Highcharts Example Tutorial

1. Create web routes

In the first step we will define routes in “routes/web.php” file. Lets open “routes/web.php” file and add the following routes in it.

routes/web.php

Route::get('highchart', 'ChartController@index');

1	Route::get('highchart', 'ChartController@index');

2. Create Controller

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

php artisan make:controller ChartController

1	php artisan make:controller ChartController

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

app/Http/Controllers/ChartController.php

<?php
   
namespace App\Http\Controllers;
 
use App\User;
use Illuminate\Http\Request;
use Redirect,Response;
Use DB;
 
class ChartController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
 
     $record['chart'] = User::select(\DB::raw("COUNT(*) as count"))
                    ->whereYear('created_at', date('Y'))
                    ->groupBy(\DB::raw("Month(created_at)"))
                    ->pluck('count');
      
      return view('highchart', $record);
    }
 
}

<?php

namespace App\Http\Controllers;

use App\User;

use Illuminate\Http\Request;

use Redirect,Response;

Use DB;

class ChartController extends Controller

{

/**

* Display a listing of the resource.

* @return \Illuminate\Http\Response

public function index()

{

$record['chart'] = User::select(\DB::raw("COUNT(*) as count"))

->whereYear('created_at', date('Y'))

->groupBy(\DB::raw("Month(created_at)"))

->pluck('count');

return view('highchart', $record);

}

3. Create Blade File

Now, we will create a blade view file. Go to the resources/views/highchart.blade.php and put the below javascript and HTML code for displaying the highchart

<!DOCTYPE html>
<html>
<head>
    <title>Laravel 7/6 Highcharts Example - Tutsmake.com</title>
<script src="https://code.highcharts.com/highcharts.js"></script>
<script src="https://code.highcharts.com/modules/exporting.js"></script>
<script src="https://code.highcharts.com/modules/export-data.js"></script>
<script src="https://code.highcharts.com/modules/accessibility.js"></script>
</head>
    
<body>
 
<div id="container"></div>
</body>
 
<figure class="highcharts-figure">
    <div id="container"></div>
</figure>
 
<script type="text/javascript">
   let chart =  JSON.parse(`<?php echo $chart ?>`);
    
    Highcharts.chart('container', {
        title: {
            text: 'New User Growth, 2019'
        },
        subtitle: {
            text: 'Source: tutsmake.com'
        },
         xAxis: {
            categories: ['Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec']
        },
        yAxis: {
            title: {
                text: 'Number of New Users'
            }
        },
        legend: {
            layout: 'vertical',
            align: 'right',
            verticalAlign: 'middle'
        },
        plotOptions: {
            series: {
                allowPointSelect: true
            }
        },
        series: [{
            name: 'New Users',
            data: chart
        }],
        responsive: {
            rules: [{
                condition: {
                    maxWidth: 500
                },
                chartOptions: {
                    legend: {
                        layout: 'horizontal',
                        align: 'center',
                        verticalAlign: 'bottom'
                    }
                }
            }]
        }
});
</script>
</html>

<!DOCTYPE html>

<html>

<head>

<title>Laravel 7/6 Highcharts Example - Tutsmake.com</title>

</head>

<body>

</body>

</figure>

let chart = JSON.parse(`<?php echo $chart ?>`);

Highcharts.chart('container', {

title: {

text: 'New User Growth, 2019'

subtitle: {

text: 'Source: tutsmake.com'

xAxis: {

categories: ['Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec']

yAxis: {

title: {

text: 'Number of New Users'

}

legend: {

align: 'right',

verticalAlign: 'middle'

plotOptions: {

series: {

allowPointSelect: true

}

series: [{

data: chart

}],

responsive: {

rules: [{

condition: {

maxWidth: 500

chartOptions: {

legend: {

align: 'center',

verticalAlign: 'bottom'

}

}]

}

});

</script>

</html>

Remember to include highchart js libraries on your blade file:

<script src="https://code.highcharts.com/highcharts.js"></script>
<script src="https://code.highcharts.com/modules/exporting.js"></script>
<script src="https://code.highcharts.com/modules/export-data.js"></script>
<script src="https://code.highcharts.com/modules/accessibility.js"></script>

Use below javascript as per requirement :

<script type="text/javascript">
   let chart =  JSON.parse(`<?php echo $chart ?>`);
    
    Highcharts.chart('container', {
        title: {
            text: 'New User Growth, 2019'
        },
        subtitle: {
            text: 'Source: tutsmake.com'
        },
         xAxis: {
            categories: ['Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec']
        },
        yAxis: {
            title: {
                text: 'Number of New Users'
            }
        },
        legend: {
            layout: 'vertical',
            align: 'right',
            verticalAlign: 'middle'
        },
        plotOptions: {
            series: {
                allowPointSelect: true
            }
        },
        series: [{
            name: 'New Users',
            data: chart
        }],
        responsive: {
            rules: [{
                condition: {
                    maxWidth: 500
                },
                chartOptions: {
                    legend: {
                        layout: 'horizontal',
                        align: 'center',
                        verticalAlign: 'bottom'
                    }
                }
            }]
        }
});
</script>

let chart = JSON.parse(`<?php echo $chart ?>`);

Highcharts.chart('container', {

title: {

text: 'New User Growth, 2019'

subtitle: {

text: 'Source: tutsmake.com'

xAxis: {

categories: ['Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun', 'Jul', 'Aug', 'Sep', 'Oct', 'Nov', 'Dec']

yAxis: {

title: {

text: 'Number of New Users'

}

legend: {

align: 'right',

verticalAlign: 'middle'

plotOptions: {

series: {

allowPointSelect: true

}

series: [{

data: chart

}],

responsive: {

rules: [{

condition: {

maxWidth: 500

chartOptions: {

legend: {

align: 'center',

verticalAlign: 'bottom'

}

}]

}

});

</script>

Run Development Server

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

php artisan serve

1	php artisan serve

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

http://127.0.0.1:8000/highchart

1	http://127.0.0.1:8000/highchart

Laravel 7/6 Pie Chart using Charts JS Example Tutorial

In this Laravel 7/6 Pie Chart using Charts JS Example Tutorial I will show you how to implement pie chart using a chart js in laravel. In this tutorial you will learn to implement pie chart using a chart js in laravel applications. In this example we will be using charts.js to implement pie chart in laravel application.

Laravel 7/6 Pie Chart using Charts JS Example Tutorial

1. Create a route

First we will define routes in “routes/web.php” file. Lets open “routes/web.php” file and add the following routes in it.

routes/web.php

Route::get('chart-js', 'ChartController@index');

1	Route::get('chart-js', 'ChartController@index');

2. Create Controller

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

php artisan make:controller ChartController

1	php artisan make:controller ChartController

app/Http/Controllers/ChartController.php

<?php
   
namespace App\Http\Controllers;
 
use App\User;
use Illuminate\Http\Request;
use Redirect,Response;
Use DB;
use Carbon\Carbon;
 
class ChartController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
 
 $record = User::select(\DB::raw("COUNT(*) as count"), \DB::raw("DAYNAME(created_at) as day_name"), \DB::raw("DAY(created_at) as day"))
    ->where('created_at', '>', Carbon::today()->subDay(6))
    ->groupBy('day_name','day')
    ->orderBy('day')
    ->get();
  
     $data = [];
 
     foreach($record as $row) {
        $data['label'][] = $row->day_name;
        $data['data'][] = (int) $row->count;
      }
 
    $data['chart_data'] = json_encode($data);
    return view('chart-js', $data);
    }
 
}

<?php

namespace App\Http\Controllers;

use App\User;

use Illuminate\Http\Request;

use Redirect,Response;

Use DB;

use Carbon\Carbon;

class ChartController extends Controller

{

/**

* Display a listing of the resource.

* @return \Illuminate\Http\Response

public function index()

{

$record = User::select(\DB::raw("COUNT(*) as count"), \DB::raw("DAYNAME(created_at) as day_name"), \DB::raw("DAY(created_at) as day"))

->where('created_at', '>', Carbon::today()->subDay(6))

->groupBy('day_name','day')

->orderBy('day')

->get();

$data = [];

foreach($record as $row) {

$data['label'][] = $row->day_name;

$data['data'][] = (int) $row->count;

}

$data['chart_data'] = json_encode($data);

return view('chart-js', $data);

}

3. Create Blade View File

Now, we will create a blade file. Go to the resources/views/chart-js.blade.php and put the following javascript and HTML code for displaying the pie chart using the chart js:

<!DOCTYPE html>
<html>
<head>
  <title>Laravel Chart JS Example Tutorial - Pie Chart</title>
  <!-- Latest CSS -->
 <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css">
 <script src="https://cdnjs.cloudflare.com/ajax/libs/Chart.js/2.8.0/Chart.js"></script>
 <script src="https://code.jquery.com/jquery-3.3.1.min.js"></script> 
</head>
<body>
  <div class="chart-container">
    <div class="pie-chart-container">
      <canvas id="pie-chart"></canvas>
    </div>
  </div>
 
  <!-- javascript -->
 
   <script>
  $(function(){
      //get the pie chart canvas
      var cData = JSON.parse(`<?php echo $chart_data; ?>`);
      var ctx = $("#pie-chart");
 
      //pie chart data
      var data = {
        labels: cData.label,
        datasets: [
          {
            label: "Users Count",
            data: cData.data,
            backgroundColor: [
              "#DEB887",
              "#A9A9A9",
              "#DC143C",
              "#F4A460",
              "#2E8B57",
              "#1D7A46",
              "#CDA776",
            ],
            borderColor: [
              "#CDA776",
              "#989898",
              "#CB252B",
              "#E39371",
              "#1D7A46",
              "#F4A460",
              "#CDA776",
            ],
            borderWidth: [1, 1, 1, 1, 1,1,1]
          }
        ]
      };
 
      //options
      var options = {
        responsive: true,
        title: {
          display: true,
          position: "top",
          text: "Last Week Registered Users -  Day Wise Count",
          fontSize: 18,
          fontColor: "#111"
        },
        legend: {
          display: true,
          position: "bottom",
          labels: {
            fontColor: "#333",
            fontSize: 16
          }
        }
      };
 
      //create Pie Chart class object
      var chart1 = new Chart(ctx, {
        type: "pie",
        data: data,
        options: options
      });
 
  });
</script>
</body>
</html>

<!DOCTYPE html>

<html>

<head>

<title>Laravel Chart JS Example Tutorial - Pie Chart</title>

</head>

<body>

</div>

$(function(){

//get the pie chart canvas

var cData = JSON.parse(`<?php echo $chart_data; ?>`);

var ctx = $("#pie-chart");

//pie chart data

var data = {

labels: cData.label,

datasets: [

{

label: "Users Count",

data: cData.data,

backgroundColor: [

"#DEB887",

"#A9A9A9",

"#DC143C",

"#F4A460",

"#2E8B57",

"#1D7A46",

"#CDA776",

borderColor: [

"#CDA776",

"#989898",

"#CB252B",

"#E39371",

"#1D7A46",

"#F4A460",

"#CDA776",

borderWidth: [1, 1, 1, 1, 1,1,1]

}

]

};

//options

var options = {

responsive: true,

title: {

display: true,

position: "top",

text: "Last Week Registered Users - Day Wise Count",

fontSize: 18,

fontColor: "#111"

legend: {

display: true,

position: "bottom",

labels: {

fontColor: "#333",

fontSize: 16

}

};

//create Pie Chart class object

var chart1 = new Chart(ctx, {

type: "pie",

data: data,

options: options

});

</script>

</body>

</html>

Below is the list of javascript libraries need to be included before implementing charts.

<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css">
 <script src="https://cdnjs.cloudflare.com/ajax/libs/Chart.js/2.8.0/Chart.js"></script>
 <script src="https://code.jquery.com/jquery-3.3.1.min.js"></script>

Or also don’t forget to add this javascript code. The chart js library also provides so many options for the chart js. You can change or modify according to your requirements.

  <script>
  $(function(){
      //get the pie chart canvas
      var cData = JSON.parse(`<?php echo $chart_data; ?>`);
      var ctx = $("#pie-chart");
 
      //pie chart data
      var data = {
        labels: cData.label,
        datasets: [
          {
            label: "Users Count",
            data: cData.data,
            backgroundColor: [
              "#DEB887",
              "#A9A9A9",
              "#DC143C",
              "#F4A460",
              "#2E8B57",
              "#1D7A46",
              "#CDA776",
            ],
            borderColor: [
              "#CDA776",
              "#989898",
              "#CB252B",
              "#E39371",
              "#1D7A46",
              "#F4A460",
              "#CDA776",
            ],
            borderWidth: [1, 1, 1, 1, 1,1,1]
          }
        ]
      };
 
      //options
      var options = {
        responsive: true,
        title: {
          display: true,
          position: "top",
          text: "Last Week Registered Users -  Day Wise Count",
          fontSize: 18,
          fontColor: "#111"
        },
        legend: {
          display: true,
          position: "bottom",
          labels: {
            fontColor: "#333",
            fontSize: 16
          }
        }
      };
 
      //create Pie Chart class object
      var chart1 = new Chart(ctx, {
        type: "pie",
        data: data,
        options: options
      });
 
  });
</script>

$(function(){

//get the pie chart canvas

var cData = JSON.parse(`<?php echo $chart_data; ?>`);

var ctx = $("#pie-chart");

//pie chart data

var data = {

labels: cData.label,

datasets: [

{

label: "Users Count",

data: cData.data,

backgroundColor: [

"#DEB887",

"#A9A9A9",

"#DC143C",

"#F4A460",

"#2E8B57",

"#1D7A46",

"#CDA776",

borderColor: [

"#CDA776",

"#989898",

"#CB252B",

"#E39371",

"#1D7A46",

"#F4A460",

"#CDA776",

borderWidth: [1, 1, 1, 1, 1,1,1]

}

]

};

//options

var options = {

responsive: true,

title: {

display: true,

position: "top",

text: "Last Week Registered Users - Day Wise Count",

fontSize: 18,

fontColor: "#111"

legend: {

display: true,

position: "bottom",

labels: {

fontColor: "#333",

fontSize: 16

}

};

//create Pie Chart class object

var chart1 = new Chart(ctx, {

type: "pie",

data: data,

options: options

});

</script>

Laravel Get Next and Previous Record and Url Tutorial

In this Laravel Get Next and Previous Record and Url Tutorial I will show you how to get the next or previous record or data with URL in laravel application. In this tutorial you will learn to get the next or previous record or data with URL in laravel application. Working with any blog application in laravel we have to show the next or previous URL on posts. At that time we need to get the next record from the database table and the previous record from the database table. In this step by step tutorial I’ll demonstrate you to get the next or previous record or data with URL in laravel.

Laravel Get Next and Previous Record and Url Tutorial

1. Get previous record or data

We can access the previous record as following:

$previous_record = Post::where('id', '<', $post->id)->orderBy('id','desc')->first();

1	$previous_record = Post::where('id', '<', $post->id)->orderBy('id','desc')->first();

This laravel eloquent query is users where() and orderBy() methods to fetch previous records like title, URL, slug, etc from the database table in laravel

2. Get Next record or data

We can access the next record as following:

$next_record = Post::where('id', '>', $post->id)->orderBy('id')->first();

1	$next_record = Post::where('id', '>', $post->id)->orderBy('id')->first();

This laravel query is uses where(), first() and orderBy() to fetch next records from DB table.

Note: – To access data obtained from $next or $ previous variable. You can use it like this:

//id
 $previous->id
 //slug
 $previous->slug
 //id

 $next->id
 //slug
 $next->slug

//id

$previous->id

//slug

$previous->slug

//id

$next->id

//slug

$next->slug

You can display the next and previous posts url as following:

<div class="row">
    <div class="col-md-6">
 
        @if (isset($previous_record))
            <div class="alert alert-success">
            <a href="{{ url($previous_record->slug) }}">
                <div class="btn-content">
                    <div class="btn-content-title"><i class="fa fa-arrow-left"></i> Previous Post</div>
                    <p class="btn-content-subtitle">{{ $previous_record->title }}</p>
                </div>
            </a>
            </div>
        @endif
    </div>
    <div class="col-md-6">
 
        @if (isset($next_record))
        <div class="alert alert-success">
        <a href="{{ url($next_record->slug) }}">
            <div class="btn-content">
                <div class="btn-content-title">Next Post <i class="fa fa-arrow-right"></i></div>
                <p class="btn-content-subtitle">{{ $next_record->title }}</p>
            </div>
        </a>
        </div>
        @endif
    </div>
</div>

@if (isset($previous_record))

<div class="btn-content-title"><i class="fa fa-arrow-left"></i> Previous Post</div>

<p class="btn-content-subtitle">{{ $previous_record->title }}</p>

</div>

</a>

</div>

@endif

</div>

@if (isset($next_record))

<p class="btn-content-subtitle">{{ $next_record->title }}</p>

</div>

</a>

</div>

@endif

</div>

Laravel 7/6 Create Newsletter Example Tutorial

In this Laravel 7/6 Create Newsletter Example Tutorial I’ll show you how to implement newsletter functionality in laravel application. In this tutorial you will learn to create newsletter feature in your laravel application. In this example we will be using MailChimp for setting up newsletter functionality in laravel project.

Install Laravel Fresh New Setup
Setup Database Credentials
Install Newsletter Package
Sign Up in MailChimp Get MailChimp API Key And List Id
Set MailChimp API Key And List Id in .env file
Create Resource Route & Controller
Create the blade view
Start Development Server

1. Install Laravel Fresh New Setup

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

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

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

2. Setup Database Credentials

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

DB_CONNECTION=mysql 
DB_HOST=127.0.0.1 
DB_PORT=3306 
DB_DATABASE=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

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

composer require spatie/laravel-newsletter

1	composer require spatie/laravel-newsletter

The package will automatically register itself. Use following command to publish the config file to config/newsletter.php:

php artisan vendor:publish --provider="Spatie\Newsletter\NewsletterServiceProvider"

1	php artisan vendor:publish --provider="Spatie\Newsletter\NewsletterServiceProvider"

Now, we have to sign up in MailChimp from https://mailchimp.com/. If you already have Mailchimp account then login directly. After successfully sign up or sign we can get api key and list id from mailchimp

5. Set MailChimp API Key And List Id in .env file

In this step we will set Mailchimp API key and list id in .env file:

MAILCHIMP_APIKEY=xxxx 
MAILCHIMP_LIST_ID=xxxx

1 2	MAILCHIMP_APIKEY=xxxx MAILCHIMP_LIST_ID=xxxx

6. Create Resource Route & Controller

Now, we will create a resource route along with controller:

php artisan make:controller NewsletterController --resource

1	php artisan make:controller NewsletterController --resource

This command will create a controller name NewsletterController and also inside by default seven methods like index, store.Next, We need to add the resource route. Go to routes/web.php put the below routes here :

Route::get('newsletter','NewsletterController@create');
Route::post('newsletter','NewsletterController@store');

1 2	Route::get('newsletter','NewsletterController@create'); Route::post('newsletter','NewsletterController@store');

Next open controller, Go to app/HTTP/Controller/NewsletterController and put the below code here :

<?php
 
namespace App\Http\Controllers;
 
use Illuminate\Http\Request;
use Newsletter;
 
class NewsletterController extends Controller
{
    public function index()
    {
        return view('newsletter');
    }
 
    public function store(Request $request)
    {
        if ( ! Newsletter::isSubscribed($request->email) ) 
        {
            Newsletter::subscribePending($request->email);
            return redirect('newsletter')->with('success', 'Thanks For Subscribe');
        }
        return redirect('newsletter')->with('failure', 'Sorry! You have already subscribed ');
             
    }
}

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use Newsletter;

class NewsletterController extends Controller

{

public function index()

{

return view('newsletter');

}

public function store(Request $request)

{

if ( ! Newsletter::isSubscribed($request->email) )

{

Newsletter::subscribePending($request->email);

return redirect('newsletter')->with('success', 'Thanks For Subscribe');

}

return redirect('newsletter')->with('failure', 'Sorry! You have already subscribed ');

}

7. Create the blade view

In this step, we will create a blade file, Go to app/resources/views/ and create one blade view name newsletter.blade.php. After creating the blade file, put the given code into your newsletter.blade.php file:

newsletter.blade.php

<!DOCTYPE html>
<html>
  <head>
    <meta charset="utf-8">
    <title>Laravel 6 Newsletter Tutorial With Example</title>
    <link rel="stylesheet" href="{{asset('css/app.css')}}">
    <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.1.3/css/bootstrap.min.css">  
  </head>
  <body>
    <div class="container">
    @if (\Session::has('success'))
      <div class="alert alert-success">
        <p>{{ \Session::get('success') }}</p>
      </div><br />
     @endif
     @if (\Session::has('failure'))
      <div class="alert alert-danger">
        <p>{{ \Session::get('failure') }}</p>
      </div><br />
     @endif
      <h2 class="mb-2 mt-2">Laravel Newsletter Tutorial With Example</h2>
      <form method="post" action="{{url('newsletter')}}">
        @csrf
        </div>
        <div class="row">
          <div class="col-md-8"></div>
            <div class="form-group col-md-2">
              <label for="Email">Email:</label>
              <input type="text" class="form-control" name="email">
            </div>
          </div>
        <div class="row">
          <div class="col-md-4"></div>
          <div class="form-group col-md-4">
            <button type="submit" class="btn btn-success">Submit</button>
          </div>
        </div>
      </form>
    </div>
  </body>
</html>

<!DOCTYPE html>

<html>

<head>

<title>Laravel 6 Newsletter Tutorial With Example</title>

</head>

<body>

@if (\Session::has('success'))

<p>{{ \Session::get('success') }}</p>

</div><br />

@endif

@if (\Session::has('failure'))

<p>{{ \Session::get('failure') }}</p>

</div><br />

@endif

<h2 class="mb-2 mt-2">Laravel Newsletter Tutorial With Example</h2>

@csrf

</div>

<label for="Email">Email:</label>

</div>

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

</div>

</form>

</div>

</body>

</html>

8. Run Development Server

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

php artisan serve

1	php artisan serve

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

http://localhost:8000/newsletter

1	http://localhost:8000/newsletter

Laravel 7/6 Currency Exchange Rate Calculator

In this Laravel 7/6 Currency Exchange Rate Calculator tutorial I will show you how to create currency exchange rates calculator in laravel. In this tutorial you will learn to integrate or implement live currency exchange rates calculator in laravel. In this tutorial, we will learn how to create currency exchange rates calculator in laravel applications without using any package with examples.

Laravel 7/6 Currency Exchange Rate Calculator

Install Laravel Fresh New Setup
Signup and Get API KEY
Create Route & Controller
Create the blade view
Start Development Server

Step 1:- Install Laravel Fresh New Setup

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

composer create-project --prefer-dist laravel/laravel lara-currency

1	composer create-project --prefer-dist laravel/laravel lara-currency

Now, go to the below link:

https://free.currencyconverterapi.com/

1	https://free.currencyconverterapi.com/

Now obtain API Key from here.

Step 3 :- Create Route & Controller

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

php artisan make:controller CurrencyController

1	php artisan make:controller CurrencyController

Create Routes

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

routes/web.php

 Route::get('currency','CurrencyController@index');
 Route::post('currency','CurrencyController@exchangeCurrency');

1 2	Route::get('currency','CurrencyController@index'); Route::post('currency','CurrencyController@exchangeCurrency');

Now open controller, Go to app/HTTP/Controller/CurrencyController and put the below code here :

<?php
 
namespace App\Http\Controllers;
 
use Illuminate\Http\Request;
 
use AshAllenDesign\LaravelExchangeRates\ExchangeRate;
 
use Guzzle\Http\Exception\ClientErrorResponseException;
 
use carbon\Carbon;
 
class CurrencyController extends Controller
{
    //
 
    public function index() {
 
     return view('currency');
    }    
 
    public function exchangeCurrency(Request $request) {
         
      $amount = ($request->amount)?($request->amount):(1);
 
      $apikey = 'd1ded944220ca6b0c442';
 
      $from_Currency = urlencode($request->from_currency);
      $to_Currency = urlencode($request->to_currency);
      $query =  "{$from_Currency}_{$to_Currency}";
 
      // change to the free URL if you're using the free version
      $json = file_get_contents("http://free.currencyconverterapi.com/api/v5/convert?q={$query}&compact=y&apiKey={$apikey}");
 
      $obj = json_decode($json, true);
       
      $val = $obj["$query"];
 
      $total = $val['val'] * 1;
 
      $formatValue = number_format($total, 2, '.', '');
       
      $data = "$amount $from_Currency = $to_Currency $formatValue";
 
      echo $data; die;
 
 
     
   }
 
}

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use AshAllenDesign\LaravelExchangeRates\ExchangeRate;

use Guzzle\Http\Exception\ClientErrorResponseException;

use carbon\Carbon;

class CurrencyController extends Controller

{

public function index() {

return view('currency');

}

public function exchangeCurrency(Request $request) {

$amount = ($request->amount)?($request->amount):(1);

$apikey = 'd1ded944220ca6b0c442';

$from_Currency = urlencode($request->from_currency);

$to_Currency = urlencode($request->to_currency);

$query = "{$from_Currency}_{$to_Currency}";

// change to the free URL if you're using the free version

$json = file_get_contents("http://free.currencyconverterapi.com/api/v5/convert?q={$query}&compact=y&apiKey={$apikey}");

$obj = json_decode($json, true);

$val = $obj["$query"];

$total = $val['val'] * 1;

$formatValue = number_format($total, 2, '.', '');

$data = "$amount $from_Currency = $to_Currency $formatValue";

echo $data; die;

}

Step 4:- Create the blade view

In this step we will create a blade files, Go to app/resources/views/ and create one blade view name currency.blade.php. After successfully create the blade view file, update the below-given code into your currency.blade.php file:

currency.blade.php

<!DOCTYPE html>
<html>
<head>
<title>Laravel Currency Exchange Rate Calculator</title> 
<meta name="csrf-token" content="{{ csrf_token() }}">
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.4.1/css/bootstrap.min.css">
<script src="https://code.jquery.com/jquery-3.4.1.js"></script> 
</head>
<body>
<div class="container mt-5">
<div class="card">
<div class="card-header">
Laravel Currency Exchange Rate Calculator
</div>
<div class="card-body">
<form id="currency-exchange-rate" action="#" method="post" class="form-group">
<div class="row mb-3">
<div class="col-md-4">
<input type="text" name="amount" class="form-control" value="1">  
</div>
<div class="col-md-4">
<select name="from_currency" class="form-control"> 
<option value='AUD'>AUD</option>
<option value='BGN'>BGN</option>
<option value='BRL'>BRL</option>
<option value='CAD'>CAD</option>
<option value='CHF'>CHF</option>
<option value='CNY'>CNY</option>
<option value='CZK'>CZK</option>
<option value='DKK'>DKK</option>
<option value='EUR'>EUR</option>
<option value='GBP'>GBP</option>
<option value='HKD'>HKD</option>
<option value='HRK'>HRK</option>
<option value='HUF'>HUF</option>
<option value='IDR'>IDR</option>
<option value='ILS'>ILS</option>
<option value='INR'>INR</option>
<option value='ISK'>ISK</option>
<option value='JPY'>JPY</option>
<option value='KRW'>KRW</option>
<option value='MXN'>MXN</option>
<option value='MYR'>MYR</option>
<option value='NOK'>NOK</option>
<option value='NZD'>NZD</option>
<option value='PHP'>PHP</option>
<option value='PLN'>PLN</option>
<option value='RON'>RON</option>
<option value='RUB'>RUB</option>
<option value='SEK'>SEK</option>
<option value='SGD'>SGD</option>
<option value='THB'>THB</option>
<option value='TRY'>TRY</option>
<option value='USD'>USD</option>
<option value='ZAR'>ZAR</option>
</select>
</div>
<div class="col-md-4">
<select name="to_currency" class="form-control">
<option value='AUD'>AUD</option>
<option value='BGN'>BGN</option>
<option value='BRL'>BRL</option>
<option value='CAD'>CAD</option>
<option value='CHF'>CHF</option>
<option value='CNY'>CNY</option>
<option value='CZK'>CZK</option>
<option value='DKK'>DKK</option>
<option value='EUR'>EUR</option>
<option value='GBP'>GBP</option>
<option value='HKD'>HKD</option>
<option value='HRK'>HRK</option>
<option value='HUF'>HUF</option>
<option value='IDR'>IDR</option>
<option value='ILS'>ILS</option>
<option value='INR'>INR</option>
<option value='ISK'>ISK</option>
<option value='JPY'>JPY</option>
<option value='KRW'>KRW</option>
<option value='MXN'>MXN</option>
<option value='MYR'>MYR</option>
<option value='NOK'>NOK</option>
<option value='NZD'>NZD</option>
<option value='PHP'>PHP</option>
<option value='PLN'>PLN</option>
<option value='RON'>RON</option>
<option value='RUB'>RUB</option>
<option value='SEK'>SEK</option>
<option value='SGD'>SGD</option>
<option value='THB'>THB</option>
<option value='TRY'>TRY</option>
<option value='USD'>USD</option>
<option value='ZAR'>ZAR</option>
</select>
</div>
</div>  
<div class="row">
<div class="col-md-4">
<input type="submit" name="submit" id="btnSubmit" class="btn btn-primary " value="Click To Exchange Rate">
</div>
</div>
</form> 
</div>
<div class="card-footer">
<span id="output"></span>
</div>
</div>
</div>
<script>
$(document).ready(function () {
$.ajaxSetup({
headers: {
'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content')
}
});
$("#btnSubmit").click(function (event) {
//stop submit the form, we will post it manually.
event.preventDefault();
// Get form
var form = $('#currency-exchange-rate')[0];
// Create an FormData object 
var data = new FormData(form);
// disabled the submit button
$("#btnSubmit").prop("disabled", true);
$.ajax({
type: "POST",
url: "{{ url('currency') }}",
data: data,
processData: false,
contentType: false,
cache: false,
timeout: 800000,
success: function (data) {
$("#output").html(data);
$("#btnSubmit").prop("disabled", false);
},
error: function (e) {
$("#output").html(e.responseText);
console.log("ERROR : ", e);
$("#btnSubmit").prop("disabled", false);
}
});
});
});
</script>
</body>
</html>

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

117

118

119

120

121

122

123

124

125

126

127

128

129

130

131

132

133

134

135

136

137

138

139

140

141

142

143

144

145

146

<!DOCTYPE html>

<html>

<head>

<title>Laravel Currency Exchange Rate Calculator</title>

</head>

<body>

Laravel Currency Exchange Rate Calculator

</div>

</div>

</select>

</div>

</select>

</div>

</div>

</form>

</div>

</div>

$(document).ready(function () {

$.ajaxSetup({

headers: {

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

}

});

$("#btnSubmit").click(function (event) {

//stop submit the form, we will post it manually.

event.preventDefault();

// Get form

var form = $('#currency-exchange-rate')[0];

// Create an FormData object

var data = new FormData(form);

// disabled the submit button

$("#btnSubmit").prop("disabled", true);

$.ajax({

type: "POST",

url: "{{ url('currency') }}",

data: data,

processData: false,

contentType: false,

cache: false,

timeout: 800000,

success: function (data) {

$("#output").html(data);

$("#btnSubmit").prop("disabled", false);

error: function (e) {

$("#output").html(e.responseText);

console.log("ERROR : ", e);

$("#btnSubmit").prop("disabled", false);

}

});

</script>

</body>

</html>

Step 5 :- Run Development Server

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

php artisan serve

1	php artisan serve

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

http://localhost:8000/currency

1	http://localhost:8000/currency

Laravel Query Scope Example Tutorial

In this Laravel Query Scope Example Tutorial I will show you how to use query scopes in laravel eloquent model. In this tutorial you will learn to implement and use query scopes in laravel eloquent model. I will Also show you how to create and use dynamic query scope in laravel applications.

Laravel Query Scope Example Tutorial

In this step by step guide I will demonstrate you to create and use dynamic query scope in laravel applications.

Create Basic Scope in Model

Here we will first create a basic scope. Go to app/Post.php and create a scope here:

<?php
  
namespace App;
  
use Illuminate\Database\Eloquent\Model;
  
class Post extends Model
{
    public $table = "posts";
      
    /**
     * The attributes that are mass assignable.
     *
     * @var array
     */
    protected $fillable = [
        'id', 'title', 'body', 'status'
    ];
    /**
     * Scope a query to only include popular users.
     *
     * @param \Illuminate\Database\Eloquent\Builder $query
     * @return \Illuminate\Database\Eloquent\Builder
     */

    public function scopeStatus($query)
    {
        return $query->whereDate('status', 1);
    }
}

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Post extends Model

{

public $table = "posts";

/**

* The attributes that are mass assignable.

* @var array

protected $fillable = [

'id', 'title', 'body', 'status'

];

/**

* Scope a query to only include popular users.

* @param \Illuminate\Database\Eloquent\Builder $query

* @return \Illuminate\Database\Eloquent\Builder

public function scopeStatus($query)

{

return $query->whereDate('status', 1);

}

Use Basic Query Scope on Controller:

We can use basic query scope as following:

Post::status()->get(['id','title']);

1	Post::status()->get(['id','title']);

Create Dynamic Scope in Model

Now we are creating a dynamic query scope in laravel model as following:

<?php
  
namespace App;
  
use Illuminate\Database\Eloquent\Model;
  
class Post extends Model
{
    public $table = "posts";
      
    /**
     * The attributes that are mass assignable.
     *
     * @var array
     */
    protected $fillable = [
        'id', 'title', 'body', 'status'
    ];
    /**
     * Scope a query to only include popular users.
     *
     * @param \Illuminate\Database\Eloquent\Builder $query
     * @return \Illuminate\Database\Eloquent\Builder
     */
    public function scopeStatus($query, $type)
    {
        return $query->where('status', $type);
    }
}

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Post extends Model

{

public $table = "posts";

/**

* The attributes that are mass assignable.

* @var array

protected $fillable = [

'id', 'title', 'body', 'status'

];

/**

* Scope a query to only include popular users.

* @param \Illuminate\Database\Eloquent\Builder $query

* @return \Illuminate\Database\Eloquent\Builder

public function scopeStatus($query, $type)

{

return $query->where('status', $type);

}

Use Dynamic Scope Query On Controller

We can use dynamic scope in laravel as following:

Post::status(1)->get(['id',title']);

1	Post::status(1)->get(['id',title']);

Apply Scope to Relationship Laravel

Here, you will learn how to use query scopes with laravel relationship. Go to your App/Category.php and create a relationship between Categories and Posts Tables:

class Category extends \Eloquent

{

    public function posts()

    {

        return $this->HasMany('Post');

    }

}

class Category extends \Eloquent

{

public function posts()

{

return $this->HasMany('Post');

}

Go to your App/Post.php and create a relationship between Posts and Categories Tables:

class Post extends \Eloquent
 {
    public function category()
    {
        return $this->belongsTo('Category');
    }
 public function scopePublished($query)
    {
        return $query->where('published', 1);
    }
 }

class Post extends \Eloquent

{

public function category()

{

return $this->belongsTo('Category');

}

public function scopePublished($query)

{

return $query->where('published', 1);

}

Use query scope with relationship

Here we can use query scope with relationship as following:

$categories = Category::with(['posts' => function ($q) {

  $q->published();

}])->get();

$categories = Category::with(['posts' => function ($q) {

$q->published();

}])->get();

Laravel 7 Google Autocomplete Address Example Tutorial

In this Laravel 7 Google Autocomplete Address Example Tutorial, I’ll show you how to integrate Address or location Autocomplete using Google Autocomplete in laravel 7. In this tutorial you will learn to implement google autocomplete in laravel 7.

Google Autocomplete

Google autocomplete widget is used to display suggestions for places, address and location as soon as the user starts typing in the given input box.

Laravel 7 Google Autocomplete Address Example Tutorial

In this laravel 7 google autocomplete tutorial I’ll demonstrate you step by step process to integrate google autocomplete in laravel 7 project. Pleasae follow the instructions given below:

Install Laravel Application
Get Api Key From Google
Create Route
Generate Controller by Command
Create Blade View
Run Development Server
Conclusion

Step 1: Install Laravel Application

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

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

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

Step 2: Get Api Key From Google

Now, we need to get Google API key to enable the communication between client and Google server. Now follow the instructions given below to get Google API Key:

Visit Google Cloud Platform.
Click on the project dropdown at the top to create the project.
Click APIs & Services > Credentials.
Now, click on Create Credentials > API key.
Copy google API and store in some text file.
Now we need to enable few services, so click on Credentials > “Enable APIs and Services”, additionally enable “Maps JavaScript API” and “Places API” services.

Step 3: Create Route

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

routes/web.php

Route::get("auto-complete", "GoogleController@index");

1	Route::get("auto-complete", "GoogleController@index");

Step 4: Generate Controller by Command

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

php artisan make:controller GoogleController

1	php artisan make:controller GoogleController

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

<?php
 
namespace App\Http\Controllers;
 
use Illuminate\Http\Request;
 
class GoogleController extends Controller
{
    // ---------------- [ Load View ] ----------------
    public function index(Request $request) {
 
        return view("auto-complete");
 
    }
}

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

class GoogleController extends Controller

{

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

public function index(Request $request) {

return view("auto-complete");

}

Step 5: Create Blade view

Now, we will create a blade view file. Go to app/resources/views and create one file name auto-complete.blade.php :

<!doctype html>
<html lang="en">
<head>
<title>Google Autocomplete Address Example</title>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no">
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css" integrity="sha384-ggOyR0iXCbMQv3Xipma34MD+dH/1fQ784/j6cY/iJTQUOhcWr7x9JvoRxT2MZw1T" crossorigin="anonymous">
<script src="https://code.jquery.com/jquery-3.4.1.js" integrity="sha256-WpOohJOqMqqyKL9FccASB9O0KwACQJpFTUBLTYOVvVU="crossorigin="anonymous"></script>
</head>
<body>
<div class="container mt-5">
<div class="row">
<div class="col-xl-6 col-lg-6 col-md-8 col-sm-12 col-12 m-auto">
<div class="card shadow">
<div class="card-header bg-primary">
<h5 class="card-title text-white"> Google Autocomplete Address</h5>
</div>
<div class="card-body">
<div class="form-group">
<label for="autocomplete"> Location/City/Address </label>
<input type="text" name="autocomplete" id="autocomplete" class="form-control" placeholder="Select Location">
</div>
<div class="form-group" id="lat_area">
<label for="latitude"> Latitude </label>
<input type="text" name="latitude" id="latitude" class="form-control">
</div>
<div class="form-group" id="long_area">
<label for="latitude"> Longitude </label>
<input type="text" name="longitude" id="longitude" class="form-control">
</div>
</div>
<div class="card-footer">
<button type="submit" class="btn btn-success"> Submit </button>
</div>
</div>
</div>
</div>
</div>
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.7/umd/popper.min.js" integrity="sha384-UO2eT0CpHqdSJQ6hJty5KVphtPhzWj9WO1clHTMGa3JDZwrnQq4sF86dIHNDz0W1" crossorigin="anonymous"></script>
<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.min.js" integrity="sha384-JjSmVgyd0p3pXB1rRibZUAYoIIy6OrQ6VrjIEaFf/nJGzIxFDsf4x0xIM+B07jRM" crossorigin="anonymous"></script>
</body>
</html>

<!doctype html>

<head>

<title>Google Autocomplete Address Example</title>

</head>

<body>

<h5 class="card-title text-white"> Google Autocomplete Address</h5>

</div>

<label for="autocomplete"> Location/City/Address </label>

</div>

<label for="latitude"> Latitude </label>

</div>

<label for="latitude"> Longitude </label>

</div>

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

</div>

</body>

</html>

Add Autocomplete Script

{{-- javascript code --}}
<script src="https://maps.google.com/maps/api/js?key=AIzaSyDxTV3a6oL6vAaRookXxpiJhynuUpSccjY&libraries=places&callback=initAutocomplete" type="text/javascript"></script>
<script>
$(document).ready(function() {
$("#lat_area").addClass("d-none");
$("#long_area").addClass("d-none");
});
</script>
<script>
google.maps.event.addDomListener(window, 'load', initialize);
function initialize() {
var input = document.getElementById('autocomplete');
var autocomplete = new google.maps.places.Autocomplete(input);
autocomplete.addListener('place_changed', function() {
var place = autocomplete.getPlace();
$('#latitude').val(place.geometry['location'].lat());
$('#longitude').val(place.geometry['location'].lng());
// --------- show lat and long ---------------
$("#lat_area").removeClass("d-none");
$("#long_area").removeClass("d-none");
});
}
</script>

$(document).ready(function() {

$("#lat_area").addClass("d-none");

$("#long_area").addClass("d-none");

});

</script>

google.maps.event.addDomListener(window, 'load', initialize);

function initialize() {

var input = document.getElementById('autocomplete');

var autocomplete = new google.maps.places.Autocomplete(input);

autocomplete.addListener('place_changed', function() {

var place = autocomplete.getPlace();

$('#latitude').val(place.geometry['location'].lat());

$('#longitude').val(place.geometry['location'].lng());

// --------- show lat and long ---------------

$("#lat_area").removeClass("d-none");

$("#long_area").removeClass("d-none");

});

}

</script>

Step 6: Run Development Server

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

php artisan serve

1	php artisan serve

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

 http://localhost:8000/auto-complete

1	http://localhost:8000/auto-complete

Laravel 7/6 Ajax Multiple Image Upload with Preview

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

Laravel 7/6 Ajax Multiple Image Upload with Preview

Install Laravel Fresh Setup
Setup Database Credentials
Create Route
Generate Controller By Command
Create the blade view
Start Development Server

1: Install Laravel Fresh Setup

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

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

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

2: Setup Database Credentials

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

DB_CONNECTION=mysql 
DB_HOST=127.0.0.1 
DB_PORT=3306 
DB_DATABASE=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: Create Route

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

routes/web.php

Route::get('images-upload', 'ImageController@imagesUpload');
 
Route::post('images-upload', 'ImageController@imagesUploadPost')->name('images.upload');

Route::get('images-upload', 'ImageController@imagesUpload');

Route::post('images-upload', 'ImageController@imagesUploadPost')->name('images.upload');

4: Generate Controller by Command

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

php artisan make:controller ImageController

1	php artisan make:controller ImageController

The above command will create a controller name ImageController. Now, open controller app/HTTP/Controller/ImageController and put the following code in it:

<?php
 
namespace App\Http\Controllers;
 
use Illuminate\Http\Request;
 
class HomeController extends Controller
 
{
 
    /**
 
     * Create a new controller instance.
 
     *
 
     * @return void
 
     */
 
    public function imagesUpload()
 
    {
 
        return view('image');
 
    }
 
 
 
    /**
 
     * Create a new controller instance.
 
     *
 
     * @return void
 
     */
 
    public function imagesUploadPost(Request $request)
 
    {
 
        request()->validate([
 
            'uploadFile' => 'required',
 
        ]);
 
 
 
        foreach ($request->file('uploadFile') as $key => $value) {
 
            $imageName = time(). $key . '.' . $value->getClientOriginalExtension();
 
            $value->move(public_path('images'), $imageName);
 
        }
 
 
 
        return response()->json(['success'=>'Images Uploaded Successfully.']);
 
    }
 
}

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

class HomeController extends Controller

{

/**

* Create a new controller instance.

* @return void

public function imagesUpload()

{

return view('image');

}

/**

* Create a new controller instance.

* @return void

public function imagesUploadPost(Request $request)

{

request()->validate([

'uploadFile' => 'required',

]);

foreach ($request->file('uploadFile') as $key => $value) {

$imageName = time(). $key . '.' . $value->getClientOriginalExtension();

$value->move(public_path('images'), $imageName);

}

return response()->json(['success'=>'Images Uploaded Successfully.']);

}

5: Create the blade view

Now, we will create some blade views files, Go to app/resources/views/ and create a blade file name image.blade.php and put the following code into your file:

image.blade.php

<!DOCTYPE html>
 
<html>
 
<head>
 
  <title>Laravel Ajax Multiple Image Upload with Preview Example</title>
 
  <link href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css" rel="stylesheet">
 
  <script src="//ajax.googleapis.com/ajax/libs/jquery/1.12.4/jquery.min.js"></script>
 
  <script src="https://cdnjs.cloudflare.com/ajax/libs/jquery.form/4.2.2/jquery.form.min.js"></script>
 
 
 
  <style type="text/css">
 
    input[type=file]{
 
      display: inline;
 
    }
 
    #imgPreview{
 
      border: 1px solid black;
 
      padding: 10px;
 
    }
 
    #imgPreview img{
 
      width: 200px;
 
      padding: 5px;
 
    }
 
  </style>
 
 
 
</head>
 
<body>
 
<div class="container">
 
  <h1>Laravel Multiple Image Upload using Ajax with Preview Example</h1>
 
  <form action="{{ route('images.upload') }}" method="post" enctype="multipart/form-data">
 
      {{ csrf_field() }}
 
      <input type="file" id="uploadFile" name="uploadFile[]" multiple/>
 
      <input type="submit" class="btn btn-success" name='submitImage' value="Upload Image"/>
 
  </form>
 
 
 
  <br/>
 
  <div id="imgPreview"></div>
 
</div>
 
 
 
</body>
 
 
 
<script type="text/javascript">
 
 
 
  $("#uploadFile").change(function(){
 
     $('#imgPreview').html("");
 
     var total_file=document.getElementById("uploadFile").files.length;
 
     for(var i=0;i<total_file;i++)
 
     {
 
      $('#imgPreview').append("<img src='"+URL.createObjectURL(event.target.files[i])+"'>");
 
     }
 
  });
 
 
 
  $('form').ajaxForm(function() 
 
   {
 
    alert("Uploaded SuccessFully");
 
   }); 
 
 
 
</script>
 
</html>

100

101

102

103

104

105

106

107

108

109

110

111

<!DOCTYPE html>

<html>

<head>

<title>Laravel Ajax Multiple Image Upload with Preview Example</title>

input[type=file]{

display: inline;

}

#imgPreview{

border: 1px solid black;

padding: 10px;

}

#imgPreview img{

width: 200px;

padding: 5px;

}

</style>

</head>

<body>

<h1>Laravel Multiple Image Upload using Ajax with Preview Example</h1>

</form>

<br/>

</div>

</body>

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

$('#imgPreview').html("");

var total_file=document.getElementById("uploadFile").files.length;

for(var i=0;i<total_file;i++)

{

$('#imgPreview').append("<img src='"+URL.createObjectURL(event.target.files[i])+"'>");

}

});

$('form').ajaxForm(function()

{

alert("Uploaded SuccessFully");

});

</script>

</html>

6: Run Development Server

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

php artisan serve

1	php artisan serve

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

http://localhost:8000/images-upload

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

Laravel 7/6 Send Notifications as Voice Call

1. Install notifcation package

2. Configure nexmo credentials in .env

3. Create a Notification channel

Laravel 7/6 Generate Unique Slug Example

1). Install Laravel Fresh New Setup

2. Setup Database Credentials

3. Install Eloquent Sluggable Package

4. Generate Model and Migration

5. Create Resource Route & Controller

6. Create the blade view

7. Run Development Server

Laravel Get Record Last Week, Month, 15 Days, Year

Table Of Content

Laravel Get Last Day Records

Get Last Week Data in Laravel

Laravel Get Last Month records

Get Last 15 Days & 30 Days Records in Laravel

Laravel Get Last Year Record

Fetch Month Wise Last Year Data

Laravel Get Current Date, Week, Month Wise, YEAR Data

Table Of Content

Current Date Record Laravel

Get Current Week Data in Laravel

To Get Current Month Data in Laravel

Laravel Get Month Wise Current Year Data

Get Day Wise Current Week Data Laravel

Laravel Get Data Year Wise

Laravel 7/6 Highcharts Example Tutorial

1. Create web routes

2. Create Controller

3. Create Blade File

Run Development Server

Laravel 7/6 Pie Chart using Charts JS Example Tutorial

1. Create a route

2. Create Controller

3. Create Blade View File

Laravel Get Next and Previous Record and Url Tutorial

1. Get previous record or data

2. Get Next record or data

Laravel 7/6 Create Newsletter Example Tutorial

1. Install Laravel Fresh New Setup

2. Setup Database Credentials

3. Install Newsletter Package

4. Sign Up in MailChimp Get MailChimp API Key And List Id

5. Set MailChimp API Key And List Id in .env file

6. Create Resource Route & Controller

7. Create the blade view

8. Run Development Server

Laravel 7/6 Currency Exchange Rate Calculator

Step 1:- Install Laravel Fresh New Setup

Step 2 :- SignUp and Get API KEY

Step 3 :- Create Route & Controller

Create Routes

Step 4:- Create the blade view

Step 5 :- Run Development Server

Laravel Query Scope Example Tutorial

Create Basic Scope in Model

Use Basic Query Scope on Controller:

Create Dynamic Scope in Model

Use Dynamic Scope Query On Controller

Apply Scope to Relationship Laravel

Use query scope with relationship

Google Autocomplete

Laravel 7 Google Autocomplete Address Example Tutorial

Step 1: Install Laravel Application

Step 2: Get Api Key From Google

Step 3: Create Route

Step 4: Generate Controller by Command

Step 5: Create Blade view

Add Autocomplete Script

Step 6: Run Development Server

Laravel 7/6 Ajax Multiple Image Upload with Preview

1: Install Laravel Fresh Setup

2: Setup Database Credentials

3: Create Route

4: Generate Controller by Command

5: Create the blade view

6: Run Development Server