How to check if a database exists in codeigniter 4 before creating a new database using forge

Question

I was working on a web application using CI4. I wanted to create a kind of install script if the database does not exist (implying the webapp is not installed). The best I could get from CI4 was $forge->createDabase('db_name', True) to implement create database if not exists. How can I check if the database exists so that if it exists, the work flows otherwise, the webapp is installed?

This question is similar to: How to check if mysql database exists. If you believe it’s different, please edit the question, make it clear how it’s different and/or how the answers on that question are not helpful for your problem. — steven7mwesigwa
– steven7mwesigwa, Commented Feb 5 at 22:09

Prabath Abeysinghe · Accepted Answer · 2025-01-29 08:15:16Z

0

CodeIgniter 4 does not provide a built-in method like databaseExists()

You can use the INFORMATION_SCHEMA.SCHEMATA table to check if the database exists before creating it like below function

function checkAndCreateDatabase($dbName)
{
    // Load default database connection
    $db = Config::connect();

    $query = $db->query("SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = ?", [$dbName]);

    // If database does not exist, create it
    if ($query->getNumRows() == 0) {
        $forge = \Config\Database::forge();
        if ($forge->createDatabase($dbName)) {
            echo "Database '{$dbName}' created successfully.";
        } else {
            echo "Failed to create database.";
        }
    } else {
        echo "Database '{$dbName}' already exists.";
    }
}

answered Jan 29 at 8:15

Prabath Abeysinghe

468 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to check if a database exists in codeigniter 4 before creating a new database using forge

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related