How to create a database in MySQL using PHP script

Create a database in MySQL (phpMyAdmin) using PHP script.

In this tutorial, you will learn how to create or make a database in mysql (phpmyadmin) using PHP Script or code.

So, you don't to have to open your mysql application i.e phpMyAdmin, instead we will create it by code by using its host, username and password.

Let's create a file named createdb.php and run this file after pasting below code and the database name will create as blogDB.

1st Example in (MySQLi Object-oriented)

<?php

    $host = "localhost";
    $username = "root";
    $password = "";

    /* Create DB Connection */
    $conn = new mysqli($host, $username, $password);

    /* Check DB connection */
    if ($conn->connect_error) 
    {
        die("Connection failed: " . $conn->connect_error);
    }

    /* Create your database */
    $sql = "CREATE DATABASE blogDB";
    if ($conn->query($sql) === TRUE) 
    {
        echo "Database created successfully";
    }
    else
    {
        echo "Error creating database: " . $conn->error;
    }
    
    $conn->close();
?>

2nd Example in (MySQLi Procedural)

<?php
    $host = "localhost";
    $username = "root";
    $password = "";

    /* Create DB Connection*/
    $conn = mysqli_connect($host, $username, $password);

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

    /* Create your database*/
    $query = "CREATE DATABASE blogDB";
    if (mysqli_query($conn, $query)) 
    {
        echo "Database created successfully";
    }
    else
    {
        echo "Error creating database: " . mysqli_error($conn);
    }

    mysqli_close($conn);
?>

We have successfully created the Database in php mysql.

Thanks for reading...

Latest Posts

Create dynamic SQL insert query in php and mysql How to Export MySQL data to excel sheet in PHP How to import excel file into mysql database in PHP How to make Registration / Signup form in php How to upload an image in PHP mysql How to make Login System with Session in PHP MySQL How to Delete data from database in php mysql How to Update Data in MySQL Database in PHP How to Fetch/Retrieve data from database in php mysql How to Insert data into database in php mysql