Category Archives: Laravel

Laravel Tutorials

Use Join Query in Laravel 8 Eloquent to Boost Performance

In this Use Join Query in Laravel 8 Eloquent to Boost Performance tutorial I will show you how to use join query in laravel 8. In this tutorial you will learn about various types of join and subquery join in laravel. You will also learn to use laravel join with eloquent queries. In this tutorial you will learn about various joins in laravel eloquent model. In this article I’ll demonstrate the use of various types of laravel joins. In this step by step laravel 8 join tutorial I will share example of laravel eloquent join (join, left join, right join, cross join, and advance join) and subquery join.

Use Join Query in Laravel 8 Eloquent to Boost Performance

In this Laravel 8 Join query Example Tutorial we will learn about following laravel eloquent join query with examples:

Inner Join Clause in Laravel

In laravel inner join if we join two tables it selects records if the given column values matching in both tables.

<?php
namespace App\Http\Controllers;

use App\Http\Controllers\Controller;
use App\Student;

class MyController extends Controller
{

    public function index()
    {
        $result = Student::join('students', 'students.id', '=', 'posts.id')
                ->select('students.*')
                ->get();

        print_r($result);
    }

}

<?php

namespace App\Http\Controllers;

use App\Http\Controllers\Controller;

use App\Student;

class MyController extends Controller

{

public function index()

{

$result = Student::join('students', 'students.id', '=', 'posts.id')

->select('students.*')

->get();

print_r($result);

}

Cross Join Clause in Laravel

In laravel cross join selects every row from the first table with every row from the second table.

<?php
namespace App\Http\Controllers;

use App\Http\Controllers\Controller;
use App\Student;

class MyController extends Controller
{

    public function index()
    {
        $result = Student::crossJoin('posts')
                ->get();                

        print_r($result);
    }

}

<?php

namespace App\Http\Controllers;

use App\Http\Controllers\Controller;

use App\Student;

class MyController extends Controller

{

public function index()

{

$result = Student::crossJoin('posts')

->get();

print_r($result);

}

Laravel Left Join Clause Example

Laravel left join query returns all rows from the left table, even if there is no matches in the right table.

<?php
namespace App\Http\Controllers;

use App\Http\Controllers\Controller;
use App\Student;

class MyController extends Controller
{

    public function index()
    {
        $result = Student::leftJoin('students', 'students.id', '=', 'posts.id')
                ->select('students.*')
                ->get();

        print_r($result);
    }

}

<?php

namespace App\Http\Controllers;

use App\Http\Controllers\Controller;

use App\Student;

class MyController extends Controller

{

public function index()

{

$result = Student::leftJoin('students', 'students.id', '=', 'posts.id')

->select('students.*')

->get();

print_r($result);

}

Laravel Right Join Clause Example

Laravel right join query returns all rows from the right table, even if there is no matches in the left table.

<?php
namespace App\Http\Controllers;

use App\Http\Controllers\Controller;
use App\Student;

class MyController extends Controller
{

    public function index()
    {
        $result = Student::rightJoin('students', 'students.id', '=', 'posts.id')
                ->select('students.*')
                ->get();

        print_r($result);
    }

}

<?php

namespace App\Http\Controllers;

use App\Http\Controllers\Controller;

use App\Student;

class MyController extends Controller

{

public function index()

{

$result = Student::rightJoin('students', 'students.id', '=', 'posts.id')

->select('students.*')

->get();

print_r($result);

}

Laravel 8 Group By Example groupBy() Value in Laravel

In this Laravel 8 Group By Example tutorial I will show you how to use groupby function in laravel query. In this tutorial you will learn to use groupby function in laravel query. In this article I will share various example to use groupby function in laravel queries. In this example I will share groupby syntax and example in laravel queries.

Laravel groupBy()

The laravel groupBy() function is used for grouping the query results in Laravel. It allow us to group the data by specified criteria.

Example:-

<?php
namespace App\Http\Controllers;
use Illuminate\Http\Request;
use App\User;
use DB;
class UserController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    public function index()
    {
        $users = User::select("*", DB::raw("count(*) as user_count"))
                        ->groupBy('status')
                        ->get();
         dd($users);
    }
}

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use App\User;

use DB;

class UserController extends Controller

{

/**

* Display a listing of the resource.

* @return \Illuminate\Http\Response

public function index()

{

$users = User::select("*", DB::raw("count(*) as user_count"))

->groupBy('status')

->get();

dd($users);

}

Laravel 8 Eloquent whereBetween() Between Database Query Example

In this laravel whereBetween eloquent tutorial, I’ll show you how use whereBetween method in laravel queries. In this tutorial you will learn to use whereBetween function with laravel queries. You will also learn to use whereBetween in laravel query builder and laravel model. With whereBetween we can fetch data between provided range from table in laravel.

Laravel whereBetween

The laravel whereBetween clause is used to query data between provided range for specific column criteria. Suppose you want to know How many users have registered between two dates range. You can query this data using whereBetween eloquent methods.

Laravel whereBetween with provided range

In this example we will fetch the records with specified column value is in provided range.

<?php
   
namespace App\Http\Controllers;
    
use Illuminate\Http\Request;
use App\Student;
  
class StudentController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    
    public function index()
    {
        $students = Student::select("*")
                        ->whereBetween('points', [1, 150])
                        ->get();
  
        print_r($students);
    }
}

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use App\Student;

class StudentController extends Controller

{

/**

* Display a listing of the resource.

* @return \Illuminate\Http\Response

public function index()

{

$students = Student::select("*")

->whereBetween('points', [1, 150])

->get();

print_r($students);

}

Laravel whereBetween with start date and end date

In this example we will use Laravel whereBetween method to get records in between two provided dates.

<?php
   
namespace App\Http\Controllers;
    
use Illuminate\Http\Request;
use Carbon\Carbon;
use App\Student;
  
class StudentController extends Controller
{
    /**
     * Display a listing of the resource.
     *
     * @return \Illuminate\Http\Response
     */
    
    public function index()
    {
        $startDate = Carbon::now()->subDays(30);
        $endDate = Carbon::now();
  
        $students = User::select("*")
                        ->whereBetween('created_at', [$startDate, $endDate])
                        ->get();
  
        print_r($students);
    }
}

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use Carbon\Carbon;

use App\Student;

class StudentController extends Controller

{

/**

* Display a listing of the resource.

* @return \Illuminate\Http\Response

public function index()

{

$startDate = Carbon::now()->subDays(30);

$endDate = Carbon::now();

$students = User::select("*")

->whereBetween('created_at', [$startDate, $endDate])

->get();

print_r($students);

}

How to SortBy Collection in Laravel 8

In this How to SortBy Collection in Laravel 8 tutorial I will show you how to sort laravel collection using laravel SortBy method. In this tutorial you will learn to use laravel sortby function to sort laravel collection. In this article I will share various example to use sortby method in laravel. In this example we will be using sortby() method to sort laravel collection by name, two fields, dates and relation.

Laravel SortBy() Method

The laravel SortBy() method is used to sorts the collection by given key.

How to SortBy Collection in Laravel 8

In this step by step tutorial I will demonstrate the use of laravel SortBy() method with example.

Collection Sort By Name
Collection Sort By Two Fields in Laravel
Collection Sort By Date in Laravel
Collection Sort By Count in Laravel
Collection Sort By Relation in Laravel

Laravel Collection Sort By Name Example

In this example we will be using SortBy() method to sort laravel collection by name.

public function index()
{
    $collection = collect([
        ['id' => 1, 'name' => 'John', 'email' => 'john@gmail.com'],
        ['id' => 2, 'name' => 'Sam', 'email' => 'sam@gmail.com'],
        ['id' => 3, 'name' => 'Bilal', 'email' => 'bilal@gmail.com'],
        ['id' => 4, 'name' => 'Lisa', 'email' => 'lisa@gmail.com'],
        ['id' => 5, 'name' => 'Samuel', 'email' => 'samuel@gmail.com']
    ]);
  
    $filterd = $collection->sortBy('name');
  
    $filterd->all();
    
    print_r($filterd);
}

public function index()

{

$collection = collect([

['id' => 1, 'name' => 'John', 'email' => 'john@gmail.com'],

['id' => 2, 'name' => 'Sam', 'email' => 'sam@gmail.com'],

['id' => 3, 'name' => 'Bilal', 'email' => 'bilal@gmail.com'],

['id' => 4, 'name' => 'Lisa', 'email' => 'lisa@gmail.com'],

['id' => 5, 'name' => 'Samuel', 'email' => 'samuel@gmail.com']

]);

$filterd = $collection->sortBy('name');

$filterd->all();

print_r($filterd);

}

Collection Sort By Two Fields in Laravel

In this example we will be using SortBy() method to sort laravel collection by two fields.

public function index()
{
    $collection = collect([
        ['id' => 1, 'name' => 'John', 'email' => 'john@gmail.com'],
        ['id' => 2, 'name' => 'Sam', 'email' => 'sam@gmail.com'],
        ['id' => 3, 'name' => 'Bilal', 'email' => 'bilal@gmail.com'],
        ['id' => 4, 'name' => 'Lisa', 'email' => 'lisa@gmail.com'],
        ['id' => 5, 'name' => 'Samuel', 'email' => 'samuel@gmail.com']        
    ]);
    
    $filterd = $collection->sortBy(function ($data, $key) {
        return $data['name'].$data['email'];
    });

    $filterd->all();

    print_r($filterd);
}

public function index()

{

$collection = collect([

['id' => 1, 'name' => 'John', 'email' => 'john@gmail.com'],

['id' => 2, 'name' => 'Sam', 'email' => 'sam@gmail.com'],

['id' => 3, 'name' => 'Bilal', 'email' => 'bilal@gmail.com'],

['id' => 4, 'name' => 'Lisa', 'email' => 'lisa@gmail.com'],

['id' => 5, 'name' => 'Samuel', 'email' => 'samuel@gmail.com']

]);

$filterd = $collection->sortBy(function ($data, $key) {

return $data['name'].$data['email'];

});

$filterd->all();

print_r($filterd);

}

Collection Sort By Date in Laravel

In this example we will be using SortBy() method to sort laravel collection by date.

Set Up Laravel Valet on Mac and Serve Sites with Laravel Valet

In this Set Up Laravel Valet on Mac and Serve Sites with Laravel Valet tutorial I will show you how to set up or configure a Laravel development environment on the Mac and how to run laravel web applications through Laravel Valet mechanism. In this tutorial you will learn to Set Up Laravel Valet on Mac and Serve Sites with Laravel Valet.

Set Up Laravel Valet on Mac and Serve Sites with Laravel Valet

In this step by step tutorial I will guide you through how to Set Up Laravel Valet on Mac and Serve Sites with Laravel Valet. Please follow the instruction given below:

Installing Homebrew in Mac

In this step we will install Homebrew package manager on your development machine.

/bin/bash -c "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install.sh)"

1	/bin/bash -c "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install.sh)"

Configure PHP in Mac

Since Laravel is a PHP framework, so we need to install the latest PHP version using Homebrew.

brew install php

1	brew install php

MySQL Installation

Now we will install MySql using following command.

brew install mysql

1	brew install mysql

Lets start the MySQL services using following command.

brew services start mysql

1	brew services start mysql

On MySQL startup the following message will be displayed on your terminal window:

Laravel 8 Dynamic Google Charts Integration Tutorial with Example

In this Laravel 8 Dynamic Google Charts Integration Tutorial with Example I’ll will show how to integrate and use dynamic google charts in laravel 8 application. In this tutorial you will learn to integrate google charts in laravel 8 application. With Google Charts we can visualize data in your laravel web application. In this tutorial I’ll share example to demonstrate use of dynamic google charts in laravel.

Laravel 8 Dynamic Google Charts Integration Tutorial with Example

In this step by step tutorial I will demonstrate you how to create Dynamic Google Charts in laravel 8 application. Please follow the instruction given below:

Install Laravel Project

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

composer create-project laravel/laravel --prefer-dist laravel-google-charts-demo

1	composer create-project laravel/laravel --prefer-dist laravel-google-charts-demo

Switch into the project directory using following command.

cd laravel-google-charts-demo

1	cd laravel-google-charts-demo

Add 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=localhost
DB_PORT=3306
DB_DATABASE=demo
DB_USERNAME=root
DB_PASSWORD=

DB_CONNECTION=mysql

DB_HOST=localhost

DB_PORT=3306

DB_DATABASE=demo

DB_USERNAME=root

DB_PASSWORD=

Now we will add some dummy records in the database. Go to PHPMyAdmin and run following sql query to add fake records.

Laravel 8 Socialite Login with Facebook Tutorial with Example

In this Laravel 8 Socialite Login with Facebook Tutorial with Example tutorial I’ll show you how to implement login with facebook in laravel 8 using Socialite and Jetstream package. Integrating login with facebook in Laravel 8 using Socialite and Jetstream package is much easier. Allowing users to login with their social media accounts makes registration/login process much easier, it also encourages more users to register for your application.

In this step by step tutorial, you will learn to integrate Facebook login in your laravel 8 application using Socialite and Jetstream. Please follow the steps give below:

Install Laravel

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

composer create-project laravel/laravel --prefer-dist laravel-socialite-login-facebook-example

1	composer create-project laravel/laravel --prefer-dist laravel-socialite-login-facebook-example

Switch into the project directory using following command.

Laravel 8 Carbon Add Minutes Example

In this Laravel 8 Carbon Add Minutes Example tutorial I will show you how to add minute, minutes and sub minutes in Laravel. In this tutorial you will learn to add minutes with Laravel Carbon in Laravel application. In this example we will be using laravel carbon package add minutes on a current date. In this tutorial I will demonstrate you how to use addMinute(), addMinutes(), subMinutes() methods using Carbon date object.

Laravel 8 Carbon Add Minutes Example

In this tutorial I will share various example to add minute, minutes and sub minutes in Laravel using laravel carbon package.

Install Laravel

composer create-project laravel/laravel --prefer-dist laravel-carbon-example

1	composer create-project laravel/laravel --prefer-dist laravel-carbon-example

Start development server using following command.

How to Add Hours with Laravel Carbon

In this laravel carbon add hour tutorial I will show you how to add hours using carbon package in laravel. In this tutorial you will learn add hour, hours and sub hours using laravel carbon addHour() and addHours() method. In this article I will share various example to add hour, hours and sub hour.

How to Add Hours with Laravel Carbon

In this tutorial I will share various example to add hour, hours and sub hour in Laravel using laravel carbon package.

Install Laravel

composer create-project laravel/laravel --prefer-dist laravel-carbon-tutorial

1	composer create-project laravel/laravel --prefer-dist laravel-carbon-tutorial

Get into the app:

composer create-project laravel/laravel --prefer-dist laravel-carbon-tutorial

1	composer create-project laravel/laravel --prefer-dist laravel-carbon-tutorial

Start the application:

Laravel Carbon Add Years Tutorial with Example

In this Laravel 8 Carbon Add Years Example tutorial I will show you how to add year, years and sub years in Laravel. In this tutorial you will learn to add year with Laravel Carbon in Laravel application. In this example we will be using laravel carbon package to add year on a current date. In this tutorial I will demonstrate you how to use addYear(), addYears(), subYear() and subYears() methods using Carbon date object.

Laravel Carbon Add Years Tutorial with Example

In this tutorial I will share various example to add year, years and sub years in Laravel using laravel carbon package.

Setting up Laravel Project

composer create-project laravel/laravel --prefer-dist laravel-carbon-years-example

1	composer create-project laravel/laravel --prefer-dist laravel-carbon-years-example

Get into the project root:

cd laravel-carbon-tutorial

1	cd laravel-carbon-tutorial

Run the application:

Laravel Carbon Add Months Tutorial with Example

In this Laravel 8 Carbon Add months Example tutorial I will show you how to add month, months and sub months in Laravel. In this tutorial you will learn to add months with Laravel Carbon in Laravel application. In this example we will be using laravel carbon package add months on a current date. In this tutorial I will demonstrate you how to use addMonth(), addMonths(), subMonths() methods using Carbon date object.

Laravel Carbon Add Months Tutorial with Example

In this tutorial I will share various example to add month, months and sub months in Laravel using laravel carbon package.

Create Laravel Application

composer create-project laravel/laravel --prefer-dist laravel-carbon-months-example

1	composer create-project laravel/laravel --prefer-dist laravel-carbon-months-example

Get into the project root:

cd laravel-carbon-months-example

1	cd laravel-carbon-months-example

Start the laravel application:

php artisan serve

1	php artisan serve

Open below URL in browser:

http://127.0.0.1:8000

1	http://127.0.0.1:8000

Next, generate a brand new controller and add months and sub months in Laravel:

Laravel Carbon Add Month with addMonth()

addMonth():- The Laravel carbon addMonth() method is used to add month to carbon date object.

Example:-

In this example we will add month to carbon date using addMonth() method.

<?php

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

class DateTimeController extends Controller
{
    // view
    public function index()
    {
        return view('home');
    }

    // define month
    public function addMonth()
    {
        $nowTimeDate = Carbon::now();
        $newTime = Carbon::now()->addMonth();
        
        print("<pre>".print_r($nowTimeDate,true)."</pre>");
        print("<pre>".print_r($newTime,true)."</pre>");
    }

}

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use Carbon\Carbon;

class DateTimeController extends Controller

{

// view

public function index()

{

return view('home');

}

// define month

public function addMonth()

{

$nowTimeDate = Carbon::now();

$newTime = Carbon::now()->addMonth();

print("<pre>".print_r($nowTimeDate,true)."</pre>");

print("<pre>".print_r($newTime,true)."</pre>");

}

Laravel Carbon Add Months with addMonths()

addMonths():- The Laravel carbon addMonths() method is used to add months to carbon date object.

Example:-

In this example we will add months to carbon date using addMonths() method.

How to Change Date Format in Laravel App with Carbon

In this How to Change Date Format in Laravel with Carbon tutorial I will show you how to change the date format in laravel with carbon. In this tutorial you will learn to change date format with carbon date in laravel. In this article I will share various example to change date format using carbon date object in laravel. In this example I will show you how to change date format using carbon createFromFormat() and format() methods. The laravel carbon createFromFormat() method take two argument first give format of date and second one date and format() take one argument give format as you want.

Laravel Carbon createFromFormat() Methods

The laravel carbon createFromFormat() method take two argument first will specify the format of date and second one date object.

Laravel Carbon Format() Methods

The laravel carbon Format() method take one argument which specify the required format of date.

How to Change Date Format in Laravel App with Carbon

In this step by step tutorial I will demonstrate you with example on how to change date format using carbon method in laravel.

Setting Up Laravel App

composer create-project laravel/laravel --prefer-dist laravel-carbon-example

1	composer create-project laravel/laravel --prefer-dist laravel-carbon-example

Run the application:

php artisan serve

1	php artisan serve

Open below URL in browser:

Use Join Query in Laravel 8 Eloquent to Boost Performance

Inner Join Clause in Laravel

Cross Join Clause in Laravel

Laravel Left Join Clause Example

Laravel Right Join Clause Example

Laravel groupBy()

Laravel whereBetween

Laravel whereBetween with provided range

Laravel whereBetween with start date and end date

Laravel SortBy() Method

How to SortBy Collection in Laravel 8

Laravel Collection Sort By Name Example

Collection Sort By Two Fields in Laravel

Collection Sort By Date in Laravel

Collection Sort By Count in Laravel

Collection Sort By Relation in Laravel

Set Up Laravel Valet on Mac and Serve Sites with Laravel Valet

Installing Homebrew in Mac

Configure PHP in Mac

MySQL Installation

Install Composer on MacOS

Install Laravel Valet via Composer

Create Laravel Application with Valet

Laravel 8 Dynamic Google Charts Integration Tutorial with Example

Install Laravel Project

Add Database Credentials

Model and Migration

Setting Up Route

Generate and Configure Controller

Show Google Line Chart in View

Run Development Server

Laravel 8 Socialite Login with Facebook Tutorial with Example

Install Laravel

Add Database Details

Setting up Jetstream in Laravel

Install Socialite Package in Laravel

Add Facebook ID in Users Table

Add Facebook App ID and Secret

Generate and Configure Controller

Setting Up Route

Add Login with Facebook Button in Login View

Laravel 8 Carbon Add Minutes Example

Install Laravel

Laravel Carbon Add Minute using addMinute

Laravel Carbon Add Minutes Using addMinutes

Laravel Carbon Add Sub Minutes Using subMinute

How to Add Hours with Laravel Carbon

Install Laravel

Laravel Carbon Add Hour with addHour()

Laravel Carbon Add Hours with addHours()

Laravel Carbon Add Sub Hour with subHour()

Laravel Carbon Add Sub Hours with subHours()

Laravel Carbon Add Years Tutorial with Example

Setting up Laravel Project

Laravel Carbon Add Year with addYear()

Laravel Carbon Add Years with addYears()

Laravel Carbon Add Sub Year with subYear()

Laravel Carbon Add Sub Years with subYears()

Laravel Carbon Add Months Tutorial with Example

Create Laravel Application

Laravel Carbon Add Month with addMonth()

Laravel Carbon Add Months with addMonths()

Laravel Carbon Add Sub Month with subMonth()

Laravel Carbon Add Sub Months with subMonths()

Laravel Carbon createFromFormat() Methods

Laravel Carbon Format() Methods

How to Change Date Format in Laravel App with Carbon

Setting Up Laravel App

Change Laravel Date Format Example