PHP MySQL Create Database

This article will provide you with a step-by-step guide on PHP MySQL create database. Upon completion of this article, you will be able to manage and create MySQL databases through PHP.

PHP MySQL create database doesn’t take a lot of time and effort, and it can be accomplished with a few lines of code at most.

There can be one or more tables in a database. In order to create or delete a MySQL database, you will need special privileges known as CREATE privileges.

Why Create a MySQL Database with PHP?

Creating a MySQL database with PHP allows you to store and retrieve data from your web application.

This is useful for a wide range of applications, including e-commerce sites, social networks, and online forums.

PHP MySQL Create Database

Now that we have a basic understanding of why we might want to create MySQL database with PHP, let’s take a look at the steps involved in creating a MySQL database with PHP.

Step1 – Connect to MySQL

The first step in creating a MySQL database with PHP is to establish a connection to the MySQL server. This can be done using the mysqli_connect() function, which takes four parameters: the server name, the username, the password, and the database name.

// Connect to MySQL
$conn = mysqli_connect("localhost", "username", "password", "database_name");

// Check connection
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}

Step2 – Create a Database

Once we have established a connection to the MySQL server, we can create a new database using the mysqli_query() function.

This function takes two parameters:

• The connection to the MySQL server.
• The SQL statement to execute.

// Create a new database
$sql = "CREATE DATABASE my_database";
if (mysqli_query($conn, $sql)) {
echo "Database created successfully";
} else {
echo "Error creating database: " . mysqli_error($conn);
}

Step3 – Close the Connection

Once we have created the database, we can close the connection to the MySQL server using the mysqli_close() function.

// Close the connection
mysqli_close($conn);

MySQL Database Through MySQLi and PDO

Creating a database in MySQL can be done by using the CREATE DATABASE statement.

Following are a few examples of creating a database called “mrx_test_db” as shown below:

Below is an example using MySQLi’s Object-Oriented method:

<?php
$servername = "localhost";
$username = "my_user";
$password = "my_pass";

// Creating connection
$conn = new mysqli($servername, $username, $password);
// Checking connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
// Creating database
$sql = "CREATE DATABASE mrx_test_db";
if ($conn->query($sql) === TRUE) {
echo "Database successfully created";
} else {
echo "Error creating database: " . $conn->error;
}
$conn->close();
?>

<?php
$servername = "localhost";
$username = "my_user";
$password = "my_pass";

// Creating connection
$conn = mysqli_connect($servername, $username, $password);
// Checking connection
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
// Creating database
$sql = "CREATE DATABASE mrx_test_db";
if (mysqli_query($conn, $sql)) {
echo "Database successfully created";
} else {
echo "Error creating database: " . mysqli_error($conn);
}
mysqli_close($conn);
?>

<?php
$servername = "localhost";
$username = "my_user";
$password = "my_pass";

try {
$conn = new PDO("mysql:host=$servername", $username, $password);
// Specify the exception error mode in the PDO
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$sql = "CREATE DATABASE mrx_test_dbPDO"; // Due to the fact that no results are returned, use exec() instead
$conn->exec($sql);
echo "Database successfully created";
}
catch (PDOException $e) {
echo $sql . " " . $e->getMessage();
}
$conn = null;
?>