Database Creation in MySQLi using PHP

Database Creation in MySQL using PHP

In the last post we discussed about the MySQL database connectivity in PHP, but there is a situation when the database is not created so in that case first we have to create a database and then insert some tables in that database to save data into it so today in this post, we will see how to create a database in PHP and then create a table in that database using PHP MySQL queries.

We see both objects oriented and procedural way of creating a database in MySQL.

The first thing we need to know that how to create a database, then we will see how to run that query in PHP. So Create Database keywords are used to create a database in MySQL.

“Create Database db_name”;

Above is the simple SQL query that will create a database, now I show how to run this query in PHP.

Create Database in MySQL (object-oriented method):

To create a database first, we need to create and check the connection which we learned in the last post; then we can create a database in MySQL.

<?php

    $servername = "localhost";
    $username = "root";
    $password = "  ";
    $db_name = "database_name";
    $conn = new mysqli($server, $username, $password,$db_name);

?>

<?php

$servername = "localhost";

$username = "root";

$password = " ";

$db_name = "database_name";

$conn = new mysqli($server, $username, $password,$db_name);

Above is the simple code to create the connection which we already covered in the last post and the below code checks whether the connection is established or not?

<?php

    if ($conn->connect_error) {
        die("Connection Not Establish: " . $conn->connect_error);
    }

    echo "Successfully Connected To Database";

?>

<?php

if ($conn->connect_error) {

die("Connection Not Establish: " . $conn->connect_error);

}

echo "Successfully Connected To Database";

Now if we combine the above code and then write code for how to create a database it works fine.

<?php

    $query = "CREATE DATABASE any_db_name";

    if ($conn->query($query) === TRUE) {
        echo "Data base was created Successfully ";
    } else {
        echo "Error in Creation of Database: " . $conn->error;
    }

    $conn->close();

?>

<?php

$query = "CREATE DATABASE any_db_name";

if ($conn->query($query) === TRUE) {

echo "Data base was created Successfully ";

} else {

echo "Error in Creation of Database: " . $conn->error;

}

$conn->close();

Create Database in MySQLi (procedural method):

<?php

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

    $db_name = "database_name"
    $conn = mysqli_connect($servername, $username, $password,$db_name);

    if (!$conn) {
        die("Connection Not Establish: " . mysqli_connect_error());
    }

    echo "Successfully Connected To Database";
    $query = "CREATE DATABASE any_name_DB";

    if (mysqli_query($conn, $query)) {
        echo "Created Successfully ";
    } else {
        echo "Error in Query : " . mysqli_error($conn);
    }
    mysqli_close($conn);

?>

<?php

$server = "localhost";

$username = "root";

$password = " ";

$db_name = "database_name"

$conn = mysqli_connect($servername, $username, $password,$db_name);

if (!$conn) {

die("Connection Not Establish: " . mysqli_connect_error());

}

echo "Successfully Connected To Database";

$query = "CREATE DATABASE any_name_DB";

if (mysqli_query($conn, $query)) {

echo "Created Successfully ";

} else {

echo "Error in Query : " . mysqli_error($conn);

}

mysqli_close($conn);

Above are the two methods of creating MySqli Database using PHP they both use slandered SQL query Create database to create the database, then use Object-Oriented method $conn->query($sql) to run the query and Procedural method use mysqli_query($conn,$sql) to run the query.

See Also

Share this: