Show Databases in Laravel

I assume you mean to show the tables not the databases

$tables = DB::select('SHOW TABLES');
foreach($tables as $table)
{
      $tableNames[] = $table->Tables_in_db_name;
}
dd($tableNames);

Not here, that's the point, I wanted to know if the "Show Databases" that I did on MySQL can be done on a Laravel App

I'd like to post an Image but seems I can't here

All the tutorials that I wanted to find show how to display tables, not the databases.

You can just post it to imgur.com and post the link

Does the database user have access to all databases?

Okay, that's just the list of databases I can show with this SQL line : https://imgur.com/SNMaXHN

And yes, I have the access to all databases

@igenezys just right click, view image, get url, and put in an image tag here, a regular image tag.

this will return all the databases

$tables = \DB::select('SHOW DATABASES');
dd($tables);

Set a default database in the config. Then run the SHOW DATABASES and make a nested loop to get the tables for each (set the database using config()

$tableNames = [];
foreach (\DB::select('SHOW DATABASES') as $database) {
    config('database.connections.mysql.database', $database->Database);
    $tables = \DB::select('SHOW TABLES');
     foreach($tables as $table) {
        $tableNames[$database->Database][] = $table->Tables_in_db_name;
    }
    
}
dd($tableNames);

In config/database.php add multiple connections, one for each database, and you can add name for each that corrispond to your database name. For example:

// default
        'mysql' => [
            'driver' => 'mysql',
            'url' => env('DATABASE_URL'),
            'host' => env('DB_HOST', '127.0.0.1'),
            'port' => env('DB_PORT', '3306'),
            'database' => env('DB_DATABASE', 'forge'),
            'username' => env('DB_USERNAME', 'forge'),
            'password' => env('DB_PASSWORD', ''),
            'unix_socket' => env('DB_SOCKET', ''),
            'charset' => 'utf8mb4',
            'collation' => 'utf8mb4_unicode_ci',
            'prefix' => '',
            'prefix_indexes' => true,
            'strict' => true,
            'engine' => null,
            'options' => extension_loaded('pdo_mysql') ? array_filter([
                PDO::MYSQL_ATTR_SSL_CA => env('MYSQL_ATTR_SSL_CA'),
            ]) : [],
        ],

// Another database
        'database_name' => [
            'driver' => 'mysql',
            'url' => env('DATABASE_URL'),
            'host' => env('DB_HOST', '127.0.0.1'),
            'port' => env('DB_PORT', '3306'),
            'database' => 'database_name', // change database name
            'username' => env('DB_USERNAME', 'forge'),
            'password' => env('DB_PASSWORD', ''),
            'unix_socket' => env('DB_SOCKET', ''),
            'charset' => 'utf8mb4',
            'collation' => 'utf8mb4_unicode_ci',
            'prefix' => '',
            'prefix_indexes' => true,
            'strict' => true,
            'engine' => null,
            'options' => extension_loaded('pdo_mysql') ? array_filter([
                PDO::MYSQL_ATTR_SSL_CA => env('MYSQL_ATTR_SSL_CA'),
            ]) : [],
        ],

// ...etc...

Then somewhere in your php code do something like:

// Using default connection to get all databases
$databases = array_map('reset', \DB::select('SHOW DATABASES'));

// Get first all tables of default connection
$data['default'] = array_map('reset', \DB::select('SHOW TABLES'));

// Loop over databases
foreach($databases as $database) {

// Get all tables of the new connection, maybe add check if you want to skip some database
 $data[$database] = array_map('reset', \DB::connection($database)->select('SHOW TABLES'));
}


dd($data);

If you need also to show fields of each table, add in the loop something like:

 foreach($data[$database] as $key => $table) {
   $data[$database][$table] = \DB::select(\DB::raw("SHOW FIELDS FROM $table"));
}

I didn't test, but it should works.

Hope it helps.

All the replies helps, thanks a lot ! The major problem here was that I needed to set up a default database, then I can use @sauravs012 or @sinnbeck response for getting my databases

From here I can move on the next phase, and @sinnbeck & @zoroaster reps show me a way to do it.

Thanks again !

    $tableNames = [];
    foreach (FacadesDB::select('SHOW DATABASES') as $database) {
        config('database.connections.mysql.database', $database->Database);
        $tables = FacadesDB::select('SHOW TABLES');
        foreach ($tables as $table) {
            foreach ($table as $item) {
                $tableNames[$database->Database][] = $item;
            }
        }

    }
    dd($tableNames);

If you are using Laravel with MongoDB, you can use below code to get names of all the collections in the database:

$collections = DB::connection('mongodb')->getMongoDB()->listCollections();

For more details, you can look through the official documentation.