Building Dynamic Databases with Laravel: Step-by-Step

How to create Database dynamically in Laravel

In this article we will see how can you create Database dynamically with code in Laravel . Laravel provide lots of solution to your DB related problem as we can use its built in methods as well as raw PHP in our code it opens a lots of way to solve a problem in Laravel .

Here we will see to create database dynamically but you can also perform the following actions also dynamically with laravel .

• Run migrations dynamically in Laravel

• Import SQL file to a table in Laravel dynamically

OK , let's see how can we create Database dynamically .

Create you route :-

First create a route to redirect to your controller .

Route::get('createdb', [HomeController::class,'createDB']);

Code on Controller :-

Now understand the following code written on controller and implement as you need for your application .

<?php

namespace App\Http\Controllers;

use Illuminate\Http\Request;

class HomeController extends Controller
{
    public function createDB()
    {
        try{
            $new_db_name = "DB_".rand()."_".time();
            $new_mysql_username = "root";
            $new_mysql_password = "";

            $conn = mysqli_connect(
                config('database.connections.mysql.host'), 
                env('DB_USERNAME'), 
                env('DB_PASSWORD')
            );
            if(!$conn ) {
                return false;
            }
            $sql = 'CREATE Database IF NOT EXISTS '.$new_db_name;
            $exec_query = mysqli_query( $conn, $sql);
            if(!$exec_query) {
                die('Could not create database: ' . mysqli_error($conn));
            }
            return 'Database created successfully with name '.$new_db_name;
        }
        catch(\Exception $e){
            return false;
        }
    }
}

Output :-

Now run this API as you need , for me i am running this API on my postman and this is the response and created Database on PhpMyAdmin .

Thank you for reading this article 😊

For any query do not hesitate to comment 💬

Also Read :

Run migration on Laravel on code

How to get DB size in laravel

How to use Foreach() loop in Blade file

Get config data in Laravel

Service Repository architecture pattern - Laravel

Send Image file using Postman

Change Default Email Logo in Laravel

Activity Logger - Laravel Spatie

Send SMS with Nexmo Laravel 

How to get string data as object from DB in Laravel

How to get string data as array from DB in Laravel