A simple code to get the next auto increment id from a table in laravel

UserController.php

<?php

namespace App\Http\Controllers;

use Illuminate\Support\Facades\DB;

class UserController extends Controller
{
    /**
     * @return mixed
     */
    private function getNextUserId()
    {
        $statement  = DB::select("SHOW TABLE STATUS LIKE 'users'");
        $nextUserId = $statement[0]->Auto_increment;
      
        return $nextUserId;
    }
}

In MySQL 8 and above, the auto_increment value is cached which is why you're seeing the wrong value when executing your query.

To get the up to date auto_increment value, run SET information_schema_stats_expiry = 0; before the query.

In MySQL 8 and above, the auto_increment value is cached which is why you're seeing the wrong value when executing your query.

To get the up to date auto_increment value, run SET information_schema_stats_expiry = 0; before the query.

Thank's for your hep! :)