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