PHP Create a MySQL Database

There may be more than one table in a database.

If you want to create or delete a MySQL database, you will need to CREATE privileges.

Build a MySQL database. Using MySQLi and PDO

In MySQL, you use the CREATE DATABASE statement to make a database.

The examples below show how to make a database called \”Student\”:

Example (MySQLi Object-oriented)

<?php
$servername = \”localhost\”;
$username = \”root\”;
$password = \”12345\”;

// Connection Create
$link = new mysqli($servername, $username, $password);
// Connection Check
if ($link->connect_error) {
die(\”Connection failed: \” . $link->connect_error);
}

// Create database
$sql = \”CREATE DATABASE Student\”;
if ($link->query($sql) === TRUE) {
echo \”Database created successfully\”;
} else {
echo \”Error creating in database: \” . $link->error;
}

$link->close();
?>

Example (MySQLi Procedural)

<?php
$servername = \”localhost\”;
$username = \”root\”;
$password = \”12345\”;

// Create connection
$link = mysqli_connect($servername, $username, $password);
// Check connection
if (!$link) {
die(\”Connection failed: \” . mysqli_connect_error());
}

// Create database
$sql = \”CREATE DATABASE Student\”;
if (mysqli_query($link, $sql)) {
echo \”Database created successfully\”;
} else {
echo \”Error creating in database: \” . mysqli_error($link);
}

mysqli_close($link);
?>

Example (PDO)

<?php
$servername = \”localhost\”;
$username = \”root\”;
$password = \”12345\”;

try {
$link = new PDO(\”mysql:host=$servername\”, $username, $password);
// set PDO error mode to exception
$link->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$sql = \”CREATE DATABASE  Student\”;
// use exec() because no results returned
$link->exec($sql);
echo \”Database created successfully<br>\”;
} catch(PDOException $e) {
echo $sql . \”<br>\” . $e->getMessage();
}

$link = null;
?>