Category Archives: Laravel

Laravel Tutorials

How to Increase Column Size using Laravel Migration

In this tutorial, we will learn how to change column length using laravel migration. It is easy to change column length using laravel migration. We will use laravel migration to change column length.

Create Table Migration

<?php

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

class CreateBlogsTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */

    public function up()
    {
        Schema::create('blogs', function (Blueprint $table) {
            $table->bigIncrements('id');
            $table->string('title', 50);
            $table->text('body');
            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */

    public function down()
    {
        Schema::dropIfExists('blogs');
    }
}

<?php

use Illuminate\Support\Facades\Schema;

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Database\Migrations\Migration;

class CreateBlogsTable extends Migration

{

/**

* Run the migrations.

* @return void

public function up()

{

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

$table->bigIncrements('id');

$table->string('title', 50);

$table->text('body');

$table->timestamps();

});

}

/**

* Reverse the migrations.

* @return void

public function down()

{

Schema::dropIfExists('blogs');

}

Change Column Length using Migration

Now, we will change title string length 50 to 100. We will use laravel migration to change column length. We will following composer package before creating change column length migration:

Install Composer Package

composer require doctrine/dbal

1	composer require doctrine/dbal

Change Column Length Migration

<?php
   

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

class UpdateBlogsTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::table('blogs', function (Blueprint $table) {
            $table->string('title', 100)->change();
        });
    }
  

    /**
    * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {

    }
}

<?php

use Illuminate\Support\Facades\Schema;

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Database\Migrations\Migration;

class UpdateBlogsTable extends Migration

{

/**

* Run the migrations.

* @return void

public function up()

{

Schema::table('blogs', function (Blueprint $table) {

$table->string('title', 100)->change();

});

}

/**

* Reverse the migrations.

* @return void

public function down()

{

}

Laravel Custom Logout Example

In this article, we will learn to create laravel custom logout in your laravel project. It is easy to create laravel custom logout.

Create Laravel Custom Logout

Follow step by step laravel custom logout tutorial to create custom logout in laravel.

Create Route

Let’s open web.php file add the following route to it:

routes/web.php

<?php


use Illuminate\Support\Facades\Route;

use App\Http\Controllers\UserController;


/*

|--------------------------------------------------------------------------

| Web Routes

|--------------------------------------------------------------------------

|

| Here is where you can register web routes for your application. These

| routes are loaded by the RouteServiceProvider within a group which

| contains the "web" middleware group. Now create something great!

|

*/

Route::get('users/index', [UserController::class, 'index'])->name('users.index');

Route::post('logout', [UserController::class, 'logout'])->name('logout');

<?php

use Illuminate\Support\Facades\Route;

use App\Http\Controllers\UserController;

|--------------------------------------------------------------------------

| Web Routes

|--------------------------------------------------------------------------

| Here is where you can register web routes for your application. These

| routes are loaded by the RouteServiceProvider within a group which

| contains the "web" middleware group. Now create something great!

Route::get('users/index', [UserController::class, 'index'])->name('users.index');

Route::post('logout', [UserController::class, 'logout'])->name('logout');

Create a UserController Controller

Now, create a User Controller Controller name UserController. Use the below command to create controller.

php artisan make:controller <b>UserController</b>

1	php artisan make:controller <b>UserController</b>

Once the above command executed, it will create a resource controller file “UserController.php” in “app/Http/Controllers/” directory. Go to “UserController.php” and put the following code in it.

app/Http/Controllers/UserController.php

<?php


namespace App\Http\Controllers;


use Illuminate\Http\Request;

use App\Models\User;

use Validator;

use Auth;


class UserController extends Controller

{

    /**

     * The attributes that are mass assignable.

     *

     * @var array

     */

    public function index()

    {

        return view('users');

    }


    public function logout(Request $request) {

        Auth::logout();

        return redirect('/login');

    }

}

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

use App\Models\User;

use Validator;

use Auth;

class UserController extends Controller

{

/**

* The attributes that are mass assignable.

* @var array

public function index()

{

return view('users');

}

public function logout(Request $request) {

Auth::logout();

return redirect('/login');

}

Create a User Blade File

In this step, we will create a view file named user.blade.php inside “resources/views/” directory and put the following code inside it –

resources/views/user.blade.php

<!DOCTYPE html>

<html>

<head>

    <title>Laravel Custom Logout</title>

    <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/css/bootstrap.min.css">

</head>

<body> 

   

  <div class="container">

    <h2>Laravel Custom Logout</h2>

    <div class="card">

      <div class="card-header">Laravel Custom Logout</div>

      <div class="card-body"><div class="col-md-12 text-center">

              <form method="POST" action="{{ route('logout') }}">

                  @csrf

                  <button type="button" class="btn btn-primary">Logout</button>

              </form>

          </div></div> 

    </div>

  </div>


</body>

</html>

<!DOCTYPE html>

<html>

<head>

<title>Laravel Custom Logout</title>

</head>

<body>

<h2>Laravel Custom Logout</h2>

<div class="card-header">Laravel Custom Logout</div>

@csrf

<button type="button" class="btn btn-primary">Logout</button>

</form>

</div></div>

</div>

</body>

</html>

Now we have created custom user logout functionality, restart the development server using following artisan command –

php artisan serve

1	php artisan serve

and visit the following URL in browser to see custom logout feature:

http://localhost:8000/users/index

1	http://localhost:8000/users/index

Laravel Custom Env. Variables

In this tutorial, I’ll show you how to create Custom Env. Variables in laravel 8. In this example we will create custom laravel environment variable.

Laravel Custom Env. Variables

In this step by step laravel custom environment variable tutorial, we will learn to add custom env. variable in our laravel application.

using env() helper

.env

API_TOKEN=test-demo

1	API_TOKEN=test-demo

/**

 * The attributes that are mass assignable.

 *

 * @var array

*/


public function customeEnv()

{

    $customeEnv = env('API_TOKEN');

}

/**

* The attributes that are mass assignable.

* @var array

public function customeEnv()

{

$customeEnv = env('API_TOKEN');

}

using config() helper

config/google.php

<?php

return [

    'api_token' => env('GOOGLE_API_TOKEN', 'your-some-default-value'),

];

<?php

return [

'api_token' => env('GOOGLE_API_TOKEN', 'your-some-default-value'),

];

/**

 * The attributes that are mass assignable.

 *

 * @var array

*/


public function helper()

{

    $aPIToken = config('google.api_token');

}

/**

* The attributes that are mass assignable.

* @var array

public function helper()

{

$aPIToken = config('google.api_token');

}

wer

How To Add Default Value of Column in Laravel Migration

In this article, I’ll show you how to add default column value in laravel migration. You will learn learn to set defaule value of column while creating table using laravel migration.

How To Add Default Value of Column in Laravel Migration

Laravel migration provide default() and nullable() method to set default value of a column. In this example we will learn how to add default value as null, boolean, current time etc. In this step by step we will set default value of table column using migration in laravel.

Create Table Migration

Use the following artisan command to create table migration:

php artisan make:migration create_products_table

1	php artisan make:migration create_products_table

After the command executed you will notice a migration file created. Open migration file and put the following code in it:

database/migrations/YYYY_MM_DD_TIMESTAMP_create_products_table.php

<?php

  

use Illuminate\Database\Migrations\Migration;

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Support\Facades\Schema;

  

class CreateProductsTable extends Migration

{

    /**

     * Run the migrations.

     *

     * @return void

     */

    public function up()

    {

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

            $table->id();

            $table->string('name')->nullable();

            $table->text('description')->default('NO BODY');

            $table->decimal('price',8,2)->default(0);

            $table->boolean('is_active')->default(0);

            $table->enum('deleted',[1,2])->default(1);

            $table->timestamps();

        });

    }

 

    /**

     * Reverse the migrations.

     *

     * @return void

     */

    public function down()

    {

        Schema::dropIfExists('products');

    }

}

<?php

use Illuminate\Database\Migrations\Migration;

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Support\Facades\Schema;

class CreateProductsTable extends Migration

{

/**

* Run the migrations.

* @return void

public function up()

{

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

$table->id();

$table->string('name')->nullable();

$table->text('description')->default('NO BODY');

$table->decimal('price',8,2)->default(0);

$table->boolean('is_active')->default(0);

$table->enum('deleted',[1,2])->default(1);

$table->timestamps();

});

}

/**

* Reverse the migrations.

* @return void

public function down()

{

Schema::dropIfExists('products');

}

1) Laravel Migration Default Value Null:

$table->string('name')->nullable();

1	$table->string('name')->nullable();

2) Laravel Migration Default Value Boolean:

$table->boolean('is_active')->default(0);

1	$table->boolean('is_active')->default(0);

3) Laravel Migration Default Value Current Date:

$table->timestamp('created_at')->default(DB::raw('CURRENT_TIMESTAMP'));

1	$table->timestamp('created_at')->default(DB::raw('CURRENT_TIMESTAMP'));

4) Laravel Migration Default Value with Update:

$table->boolean('status')->default(0)->change();

1	$table->boolean('status')->default(0)->change();

Laravel class ‘memcached’ not found

I have onfigured memcached as driver but I am getting following error “laravel class ‘memcached’ not found”. So, I have figured out a solution to share with you.

In this tutorial laravel class ‘memcached’ not found, I’ll show you how to fix the laravel class ‘memcached’ not found error.

Install Memcached in Server

in this step we will install memcached in ubuntu server and php extension for it.

sudo apt-get install memcached

1	sudo apt-get install memcached

Install Memcached Extension

Now, you need to install php extension for memcached. Please verify it’s version with your php version.

sudo apt-get install php-memcached

1	sudo apt-get install php-memcached

I hope this will fix the laravel class ‘memcached’ not found error.

How to Remove Package In Laravel

In this tutorial, I’ll show you how to remove package in laravel.In laravel it is easy to remove uninstall or remove a laravel package.

How to Remove Package In Laravel

In this example, we have already installed the yajra/laravel-datatables-oracle package in our laravel project. Now we will remove yajra/laravel-datatables-oracle package from our laravel project. Please follow this step by step instruction to uninstall or remove laravel package.

Step 1:-

First of all Remove the providers declaration from the config/app.php file

Step 2:-

Now, you need to remove aliases from config/app.php file.

Step 3:-

Next, you have to remove package references from your Controllers, Models, Routes, or any other file.

Step 4:-

If you have published any vendor-related files then manually delete them.

Step 5:-

Run following command with your vendor and package name to remove the package from the vendor folder:

Example:-

composer remove yajra/laravel-datatables-oracle
php artisan config:clear

1 2	composer remove yajra/laravel-datatables-oracle php artisan config:clear

Linux Shell Script For Database Backup

In this tutorial, I’ll show you how to backup database using shell script linux. We will learn with the help of example of linux shell script for database backup. In this example, I just created a MySQL shell script that I use on my Linux servers to make database backups with mysqldump.

Linux Shell Script For Database Backup

Create .sh File

In this step, We will create a database_backup directory in server home directory. Now we will create a hell script file backup.sh in database_backup folder. Let’s open backup.sh file and put the following code in it.

/home/database_backup/backup.sh

username=username

password=password

database=your_database_name

now="$(date +'%d_%m_%Y_%H_%M_%S')"

filename="db_backup_$now".gz

backupfolder="/home/database_backup/"

fullpathbackupfile="$backupfolder/$filename"

logfile="$backupfolder/"backup_log_"$(date +'%Y_%m')".txt

echo "mysqldump started at $(date +'%d-%m-%Y %H:%M:%S')" >> "$logfile"

mysqldump --user=$username --password=$password $database > $fullpathbackupfile

echo "mysqldump finished at $(date +'%d-%m-%Y %H:%M:%S')" >> "$logfile"


echo "remove backup 5 days old" >> "$logfile"

# Delete files older than 5 days

#find $backupfolder=/* -mtime +5 -exec rm {} \;

echo "complete removing" >> "$logfile"


exit 0

username=username

password=password

database=your_database_name

now="$(date +'%d_%m_%Y_%H_%M_%S')"

filename="db_backup_$now".gz

backupfolder="/home/database_backup/"

fullpathbackupfile="$backupfolder/$filename"

logfile="$backupfolder/"backup_log_"$(date +'%Y_%m')".txt

echo "mysqldump started at $(date +'%d-%m-%Y %H:%M:%S')" >> "$logfile"

mysqldump --user=$username --password=$password $database > $fullpathbackupfile

echo "mysqldump finished at $(date +'%d-%m-%Y %H:%M:%S')" >> "$logfile"

echo "remove backup 5 days old" >> "$logfile"

# Delete files older than 5 days

#find $backupfolder=/* -mtime +5 -exec rm {} \;

echo "complete removing" >> "$logfile"

exit 0

Executable .sh File

run .sh file

sudo chmod +x backup.sh

sudo ./backup.sh

run .sh file

sudo chmod +x backup.sh

sudo ./backup.sh

Setup Crontab

In the last step, we will setup a cron job for backup.sh file in crontab. Let’s open crontab file using below command:

crontab -e

1	crontab -e

Add below line in crontab file to run the shell script to take laravel database backup.

0 2 * /home/database_backup/backup.sh

1	0 2 * /home/database_backup/backup.sh

Remove index.php from the URL in Laravel

In this article, I’ll show you how to remove index.php from the URL in your laravel application. if you notice in your laravel application you have to access links like:

route/index.php/login

1	route/index.php/login

In this tutorial, i will share a solution with you to remove index.php from URL of your laravel application.

Remove index.php from the URL in Laravel

if you want remove index.php from URL in laravel application then just open following file and make the changes below:

<?php

  

namespace App\Providers;

  

use Illuminate\Cache\RateLimiting\Limit;

use Illuminate\Foundation\Support\Providers\RouteServiceProvider as ServiceProvider;

use Illuminate\Http\Request;

use Illuminate\Support\Facades\RateLimiter;

use Illuminate\Support\Facades\Route;

use Illuminate\Support\Str;

  

class RouteServiceProvider extends ServiceProvider

{

    /**

     * The path to the "home" route for your application.

     *

     * This is used by Laravel authentication to redirect users after login.

     *

     * @var string

     */

    public const HOME = '/home';

  

    /**

     * Define your route model bindings, pattern filters, etc.

     *

     * @return void

     */

    public function boot()

    {

        $this->removeIndexPHPFromURL();

  

        $this->configureRateLimiting();

  

        $this->routes(function () {

            Route::prefix('api')

                ->middleware('api')

                ->namespace($this->namespace)

                ->group(base_path('routes/api.php'));

 

            Route::middleware('web')

                ->namespace($this->namespace)

                ->group(base_path('routes/web.php'));

        });

    }

  

    /**

     * Write code on Method

     *

     * @return response()

     */

    protected function removeIndexPHPFromURL()

    {

        if (Str::contains(request()->getRequestUri(), '/index.php/')) {

            $url = str_replace('index.php/', '', request()->getRequestUri());

  

            if (strlen($url) > 0) {

                header("Location: $url", true, 301);

                exit;

            }

        }

    }

  

    /**

     * Configure the rate limiters for the application.

     *

     * @return void

     */

    protected function configureRateLimiting()

    {

        RateLimiter::for('api', function (Request $request) {

            return Limit::perMinute(60)->by(optional($request->user())->id ?: $request->ip());

        });

    }

}

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

147

<?php

namespace App\Providers;

use Illuminate\Cache\RateLimiting\Limit;

use Illuminate\Foundation\Support\Providers\RouteServiceProvider as ServiceProvider;

use Illuminate\Http\Request;

use Illuminate\Support\Facades\RateLimiter;

use Illuminate\Support\Facades\Route;

use Illuminate\Support\Str;

class RouteServiceProvider extends ServiceProvider

{

/**

* The path to the "home" route for your application.

* This is used by Laravel authentication to redirect users after login.

* @var string

public const HOME = '/home';

/**

* Define your route model bindings, pattern filters, etc.

* @return void

public function boot()

{

$this->removeIndexPHPFromURL();

$this->configureRateLimiting();

$this->routes(function () {

Route::prefix('api')

->middleware('api')

->namespace($this->namespace)

->group(base_path('routes/api.php'));

Route::middleware('web')

->namespace($this->namespace)

->group(base_path('routes/web.php'));

});

}

/**

* Write code on Method

* @return response()

protected function removeIndexPHPFromURL()

{

if (Str::contains(request()->getRequestUri(), '/index.php/')) {

$url = str_replace('index.php/', '', request()->getRequestUri());

if (strlen($url) > 0) {

header("Location: $url", true, 301);

exit;

}

/**

* Configure the rate limiters for the application.

* @return void

protected function configureRateLimiting()

{

RateLimiter::for('api', function (Request $request) {

return Limit::perMinute(60)->by(optional($request->user())->id ?: $request->ip());

});

}

Create Route

Now, open your route file and add following route to it.

routes/web.php

Route::get('/contact-us', function () {

    dd('Contact Us');

});

Route::get('/contact-us', function () {

dd('Contact Us');

});

now if you open url like bellow then:

https://example.com/index.php/contact-us

1	https://example.com/index.php/contact-us

will redirect to:

https://example.com/contact-us

1	https://example.com/contact-us

How to Http Curl Delete Request in Laravel

In this articel, I’ll show you how to http curl delete request in laravel. It is easy to make http curl delete request in laravel.

How to Http Curl Delete Request in Laravel

In this step by step we will learn how to make curl delete request in laravel. In this example we will be using laravel GuzzleHttp package.

Install guzzlehttp/guzzle Package

First, we have to install guzzlehttp/guzzle composer package in our laravel project. Switch your project directly in command prompt and use the following composer command to install laravel guzzlehttp/guzzle composer package in your project:

composer require guzzlehttp/guzzle

1	composer require guzzlehttp/guzzle

Example:-

namespace App\Http\Controllers;

use Illuminate\Support\Facades\Http;

class TestController extends Controller
{
    /**
     * Write code on Method
     *
     * @return response()
     */

    public function index()
    {
        $deleteID = 10;
        $apiURL = 'https://api.xyz.com/api/users/'. $deleteID;
  
        $response = Http::delete($apiURL);

        $statusCode = $response->status();
        $responseBody = json_decode($response->getBody(), true);

        dd($responseBody);
    }
}

namespace App\Http\Controllers;

use Illuminate\Support\Facades\Http;

class TestController extends Controller

{

/**

* Write code on Method

* @return response()

public function index()

{

$deleteID = 10;

$apiURL = 'https://api.xyz.com/api/users/'. $deleteID;

$response = Http::delete($apiURL);

$statusCode = $response->status();

$responseBody = json_decode($response->getBody(), true);

dd($responseBody);

}

Example:-

Output:-

Array
(
    [message] => User Id: 10 Delete Successfully
)

Array

(

[message] => User Id: 10 Delete Successfully

)

Example:-

namespace App\Http\Controllers;
 
class TestController extends Controller
{
    /**
     * Write code on Method
     *
     * @return response()
     */
    public function index()
    {
        $deleteID = 10;
        $apiURL = 'https://api.nicesnippets.com/api/users/'. $deleteID;

        $client = new \GuzzleHttp\Client();
        $response = $client->request('DELETE', $apiURL);
   
        $statusCode = $response->getStatusCode();
        $responseBody = json_decode($response->getBody(), true);
 
        dd($responseBody);

    }

}

namespace App\Http\Controllers;

class TestController extends Controller

{

/**

* Write code on Method

* @return response()

public function index()

{

$deleteID = 10;

$apiURL = 'https://api.nicesnippets.com/api/users/'. $deleteID;

$client = new \GuzzleHttp\Client();

$response = $client->request('DELETE', $apiURL);

$statusCode = $response->getStatusCode();

$responseBody = json_decode($response->getBody(), true);

dd($responseBody);

}

Output:-

(
    [message] => User Id: 10 Delete Successfully
)

(

[message] => User Id: 10 Delete Successfully

)

Laravel 8 How To Install Font Awesome Icons Example

In this article, I’ll show you how to install font awesome in laravel application. In this example we will learn how to use font awesome icons in laravel. We will use laravel mix add font awesome.

Laravel 8 How To Install Font Awesome Icons Example

In this tutorial I’ll give example of how to install font awesome in laravel. In this example, i will guide you step by step how to install font awesome icons in laravel mix. We will use two example of installing font awesome in laravel. one will be using npm command using laravel mix and another example will using cdn js.

Laravel 8 Install Font Awesome Icons using Npm

Step 1:-

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

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

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

Make sure you have composer installed.

Step 2:-

Now, we need to install npm in our new laravel application.Now, use the following command this will create “mode_modules” folder in your root directory and store all npm module.

npm install

1	npm install

Step 3:-

Now, we are ready to install font awesome library using bellow npm command.

npm install font-awesome --save

1	npm install font-awesome --save

Now we are ready to run npm dev command,

npm run dev

1	npm run dev

Now we are ready to use generated app.css file in our blade file as bellow:

resources/views/welcome.blade.php

<!DOCTYPE html>

<html>

<head>
    <title>How To Use Font Awesome In Laravel</title>
    <link type="text/css" rel="stylesheet" href="{{ mix('css/app.css') }}">
    <style type="text/css">
        i{
        	font-size: 50px !important;
            padding: 10px;
        }
    </style>
</head>
<body>
   <h1>How To Use Font Awesome In Laravel</h1>
   <i class="fa fa-copy"></i>
   <i class="fa fa-save"></i>
   <i class="fa fa-trash"></i>
   <i class="fa fa-home"></i>
</body>
</html>

<!DOCTYPE html>

<html>

<head>

<title>How To Use Font Awesome In Laravel</title>

font-size: 50px !important;

padding: 10px;

}

</style>

</head>

<body>

<h1>How To Use Font Awesome In Laravel</h1>

</body>

</html>

Laravel 8 Install Font Awesome Icons Using CDN

In this example, we will use cdn js file for adding font awesome icons, so let see bellow file code:

resources/views/welcome.blade.php

<!DOCTYPE html>
<html>
<head>
    <title>How To Use Font Awesome In Laravel</title>
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/5.12.0-2/css/fontawesome.min.css" />
    <link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/5.12.0-2/css/all.min.css" />
    <style type="text/css">
        i{
            font-size: 50px !important;
            padding: 10px;
        }
    </style>
</head>
<body>
   <h1>How To Use Font Awesome In Laravel</h1>
   <i class="fa fa-copy"></i>
   <i class="fa fa-save"></i>
   <i class="fa fa-trash"></i>
   <i class="fa fa-home"></i>
</body>
</html>

<!DOCTYPE html>

<html>

<head>

<title>How To Use Font Awesome In Laravel</title>

font-size: 50px !important;

padding: 10px;

}

</style>

</head>

<body>

<h1>How To Use Font Awesome In Laravel</h1>

</body>

</html>

Store Log Of Eloquent SQL Queries In Laravel 8

In this article, I’ll show you how to Store Log of Eloquent SQL Queries In Laravel 8. In this step by step tutorial I’ll explain laravel 8 Store Log of Eloquent SQL Queries. I’ll also show you to Store Log of Eloquent SQL Queries In Laravel.

Store Log Of Eloquent SQL Queries In Laravel 8

Developing a laravel application you come to situations where you may require to log SQL Query. Logging of SQL Queries helps to debug errors and make development easy.

Store In Default Log File

In Laravel, there is default log file located at storage/logs/laravel.log. In this example we will be going to store SQL log in laravel’s default log file. Let’s open AppServiceProvider.php file from app/Providers folder and put this code to boot() method:

app/Providers/AppServiceProvider.php

<?php

namespace App\Providers;
use DB;
use Log;
use Illuminate\Support\ServiceProvider;

class AppServiceProvider extends ServiceProvider
{
    // register() method
    public function boot()
    {
        // add this one
        DB::listen(function($query) {
            Log::info(
                $query->sql,
                $query->bindings,
                $query->time
            );
        });
    }
}

<?php

namespace App\Providers;

use DB;

use Log;

use Illuminate\Support\ServiceProvider;

class AppServiceProvider extends ServiceProvider

{

// register() method

public function boot()

{

// add this one

DB::listen(function($query) {

Log::info(

$query->sql,

$query->bindings,

$query->time

);

});

}

Laravel 8 Create A Custom Log File

We can also create a custom log file to store log data. In this example we will be creating a custom log file. Create query.log file in the storage/logs folder. In the boot() method of AppServiceProvider.php file put the following code:

app/Providers/AppServiceProvider.php

<?php

namespace App\Providers;
 
use DB;
use File;
use Illuminate\Support\ServiceProvider;
class AppServiceProvider extends ServiceProvider
{
    // register() method
    public function boot()
    {
        // add this one
        DB::listen(function($query) {
            File::append(
                storage_path('/logs/query.log'),
                '[' . date('Y-m-d H:i:s') . ']' . PHP_EOL . $query->sql . ' [' . implode(', ', $query->bindings) . ']' . PHP_EOL . PHP_EOL
            );
        });
    }
}

<?php

namespace App\Providers;

use DB;

use File;

use Illuminate\Support\ServiceProvider;

class AppServiceProvider extends ServiceProvider

{

// register() method

public function boot()

{

// add this one

DB::listen(function($query) {

File::append(

storage_path('/logs/query.log'),

'[' . date('Y-m-d H:i:s') . ']' . PHP_EOL . $query->sql . ' [' . implode(', ', $query->bindings) . ']' . PHP_EOL . PHP_EOL

);

});

}

storage/logs

[2021-11-25 10:52:20] local.INFO: select * from `users`
[2021-11-25 10:53:45] local.INFO: select * from `users` limit 5 offset 0

1 2	[2021-11-25 10:52:20] local.INFO: select * from `users` [2021-11-25 10:53:45] local.INFO: select * from `users` limit 5 offset 0

Laravel 8 How To Handle “No Query Results For Model” Error

In this article, I’ll show you how to solve “No Query Results For Model” Error.

Working with restful API in my laravel project with User model I came across following error on show method: “No query results for the model [App\\User] 1”. After lots of effort I came to solution to handle “No Query Results For Model” Error.

Laravel 8 How To Handle “No Query Results For Model” Error

In this article I would like share solution for Handle “No Query Results For Model” Error.

Controller Method :-

<?php

namespace App\Http\Controllers;
use Illuminate\Http\Request;
class ModelController extends Controller
{
    /**
    * Display the specified resource.
    *
    * @param  \App\Models\Model  $Model
    * @return \Illuminate\Http\Response
    */
    public function show(User $user)
    {
        return response()->json($user->toArray());
    }
}

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

class ModelController extends Controller

{

/**

* Display the specified resource.

* @param \App\Models\Model $Model

* @return \Illuminate\Http\Response

public function show(User $user)

{

return response()->json($user->toArray());

}

In this code I am facing error:

No query results for model [App\\User] 1

1	No query results for model [App\\User] 1

I handle this error as following:

Handle Exception : app/Exceptions/Handler.php

<?php

namespace App\Exceptions;

use Exception;
use Illuminate\Foundation\Exceptions\Handler as ExceptionHandler;
use Illuminate\Database\Eloquent\ModelNotFoundException;

class Handler extends ExceptionHandler
{
    /**
    * A list of the exception types that are not reported.
    *
    * @var array
    */
    protected $dontReport = [
        //
    ];

   /**
    * A list of the inputs that are never flashed for validation exceptions.
    *
    * @var array
    */
    protected $dontFlash = [
        'password',
       'password_confirmation',
    ];

   /**
    * Report or log an exception.
    *
    * This is a great spot to send exceptions to Sentry, Bugsnag, etc.
    *
    * @param  \Exception  $exception
    * @return void
    */
    public function report(Exception $exception)
    {
       parent::report($exception);
    }

   /**
    * Render an exception into an HTTP response.
    *
    * @param  \Illuminate\Http\Request  $request
    * @param  \Exception  $exception
    * @return \Illuminate\Http\Response
    */
    public function render($request, Exception $exception)
    {
        if ($e instanceof ModelNotFoundException) {
            return response()->json(['error' => 'Data not found.']);
        }

       return parent::render($request, $exception);
    }
}

<?php

namespace App\Exceptions;

use Exception;

use Illuminate\Foundation\Exceptions\Handler as ExceptionHandler;

use Illuminate\Database\Eloquent\ModelNotFoundException;

class Handler extends ExceptionHandler

{

/**

* A list of the exception types that are not reported.

* @var array

protected $dontReport = [

];

/**

* A list of the inputs that are never flashed for validation exceptions.

* @var array

protected $dontFlash = [

'password',

'password_confirmation',

];

/**

* Report or log an exception.

* This is a great spot to send exceptions to Sentry, Bugsnag, etc.

* @param \Exception $exception

* @return void

public function report(Exception $exception)

{

parent::report($exception);

}

/**

* Render an exception into an HTTP response.

* @param \Illuminate\Http\Request $request

* @param \Exception $exception

* @return \Illuminate\Http\Response

public function render($request, Exception $exception)

{

if ($e instanceof ModelNotFoundException) {

return response()->json(['error' => 'Data not found.']);

}

return parent::render($request, $exception);

}