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.

Table of Contents

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;
?>