create database rogers

gistfile1.txt

<?php
$host = "localhost";
$username = "adistatescu"
$password = "Adidas88statescu";
$database_name = "gallery_database";

try {
    
    $mysqli = new mysqli($host, $username, $password);
    
    if ($mysqli->connect_error) {
        die('Connection failed: ' . $mysqli->connect_error);
    }
    
    
    $sql = "CREATE DATABASE IF NOT EXISTS `$database_name`";
    
    if ($mysqli->query($sql) === TRUE) {
        echo "Database '$database_name' created successfully!";
    } else {
        echo "Error creating database: " . $mysqli->error;
    }
    
    $mysqli->close();
    
} catch(Exception $e) {
    echo "Error: " . $e->getMessage();
}
?>