PHP Create a Database

This PHP script creates a MySQL database.

<?php

/**
* Create a Database
*
* This script creates a MySQL database.
* 
* @author		PHP Simple
* @website		http://phpsimple.com
* @date			August 2021
*/

$dc_host = "localhost";		// Host Name

$dc_user = "admin";			// Username

$dc_pass = "password";		// Password

$dc_db = "database";		// Database Name to Create

// Create connection
$dc_conn = new mysqli($dc_host, $dc_user, $dc_pass);

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

// Create database
$cd_sql = "CREATE DATABASE $dc_db";
if ($dc_conn->query($cd_sql) === TRUE) {
    echo "Database created successfully";
} else {
    echo "Error creating database: " . $dc_conn->error;
}

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

?>