init.php

<?php

// Parse command-line arguments
$options = getopt("h:u:p:d:");

$host = $options['h'] ?? null;
$user = $options['u'] ?? null;
$password = $options['p'] ?? null;
$dbName = $options['d'] ?? null;

// Validate the required parameters
if (!$host || !$user || !$dbName) {
    showError("Database host (-h), user (-u), and name (-d) are required. Password (-p) is optional.");
}

// Main script logic
$mysqli = new mysqli($host, $user, $password);

// Check connection
if ($mysqli->connect_error) {
    die("Connection failed: " . $mysqli->connect_error);
}

// Create the configuration file
createConfigFile($host, $user, $password, $dbName);

// Create the database if it doesn't exist
createDatabase($mysqli, $dbName);

// Switch to the newly created database
$mysqli->select_db($dbName);

// Execute all SQL files from the db/create folder
executeSqlFiles($mysqli, 'db/create');

// Close the connection
$mysqli->close();

echo "Database init complete.\n";

// Function to create the config file
function createConfigFile($host, $user, $password, $dbName) {
    $configContent = "<?php\n";
    $configContent .= "define('DB_HOST', '$host');\n";
    $configContent .= "define('DB_USER', '$user');\n";
    $configContent .= "define('DB_PASSWORD', '$password');\n";
    $configContent .= "define('DB_NAME', '$dbName');\n";
    $configContent .= "?>\n";
    
    file_put_contents("config.php", $configContent);
    echo "Configuration file created: config.php\n";
}

// Function to check if the database exists
function databaseExists($conn, $dbName) {
    $result = $conn->query("SHOW DATABASES LIKE '$dbName'");
    return $result->num_rows > 0;
}

// Function to create the database if it doesn't exist
function createDatabase($conn, $dbName) {
    if (!databaseExists($conn, $dbName)) {
        echo "Database does not exist. Creating database: $dbName...\n";
        $conn->query("CREATE DATABASE $dbName");
        echo "Database created successfully.\n";
    } else {
        showError("Database $dbName already exists");
    }
}

// Function to execute all SQL files from the specified folder
function executeSqlFiles($conn) {
    $sqlFiles = glob('db/create/' . '*.sql');

    foreach ($sqlFiles as $file) {
        echo "Executing SQL file: $file\n";
        $sql = file_get_contents($file);
        if ($conn->multi_query($sql)) {
            do {
                // Processing results of each query
            } while ($conn->next_result());
            echo "Executed SQL file: $file\n";
        } else {
            showError("Error executing SQL file $file: " . $conn->error);
        }
    }
}

// Function to display an error and exit
function showError($message) {
    echo "Error: $message\n";
    exit(1);
}

?>