PHP MySQL Create Database

In this tutorial you will learn how to create a database in MySQL using PHP.

Creating MySQL Database Using PHP

Now that you've understood how to open a connection to the MySQL database server. In this tutorial you will learn how to execute SQL query to create a database.

Before saving or accessing the data, we need to create a database first. The CREATE DATABASE statement is used to create a new database in MySQL.

Let's make a SQL query using the CREATE DATABASE statement, after that we will execute this SQL query through passing it to the PHP mysqli_query() function to finally create our database. The following example creates a database named demo.

Example

Procedural Object Oriented PDO
Download
  • <?php
  • /* Attempt MySQL server connection. Assuming you are running MySQL
  • server with default setting (user 'root' with no password) */
  • $link = mysqli_connect("localhost", "root", "");
  •  
  • // Check connection
  • if($link === false){
  •     die("ERROR: Could not connect. " . mysqli_connect_error());
  • }
  •  
  • // Attempt create database query execution
  • $sql = "CREATE DATABASE demo";
  • if(mysqli_query($link, $sql)){
  •     echo "Database created successfully";
  • } else{
  •     echo "ERROR: Could not able to execute $sql. " . mysqli_error($link);
  • }
  •  
  • // Close connection
  • mysqli_close($link);
  • ?>
  • <?php
  • /* Attempt MySQL server connection. Assuming you are running MySQL
  • server with default setting (user 'root' with no password) */
  • $mysqli = new mysqli("localhost", "root", "");
  •  
  • // Check connection
  • if($mysqli === false){
  •     die("ERROR: Could not connect. " . $mysqli->connect_error);
  • }
  •  
  • // Attempt create database query execution
  • $sql = "CREATE DATABASE demo";
  • if($mysqli->query($sql) === true){
  •     echo "Database created successfully";
  • } else{
  •     echo "ERROR: Could not able to execute $sql. " . $mysqli->error;
  • }
  •  
  • // Close connection
  • $mysqli->close();
  • ?>
  • <?php
  • /* Attempt MySQL server connection. Assuming you are running MySQL
  • server with default setting (user 'root' with no password) */
  • try{
  •     $pdo = new PDO("mysql:host=localhost;", "root", "");
  •     // Set the PDO error mode to exception
  •     $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  • } catch(PDOException $error){
  •     die("ERROR: Could not connect. " . $error->getMessage());
  • }
  •  
  • // Attempt create database query execution
  • try{
  •     $sql = "CREATE DATABASE demo";
  •     $pdo->exec($sql);
  •     echo "Database created successfully";
  • } catch(PDOException $error){
  •     die("ERROR: Could not able to execute $sql. " . $error->getMessage());
  • }
  •  
  • // Close connection
  • unset($pdo);
  • ?>
 

Tip:Setting the PDO::ATTR_ERRMODE attribute to PDO::ERRMODE_EXCEPTION tells PDO to throw exceptions whenever a database error occurs.

 
Close

Your Feedback:

 

We would love to hear from you! Please say something.