Create New mySQL Database using PHP

Create New mySQL Database using PHP, in this article i will step through how to create a  new MySQL Data base using PHP.

Prior to that you need to complete  the items listed Below

1. Mamp or xampp with phpMyAdmin install into your Computer , check out here
2.  New User Created . Check out Here

Step 1

Start your My SQL and Apache Server

 

Step 2

Create a new Script

(1) First to connect to the Database

(2) Create anew MySQL database called ” janedb”

<?php

/* Declare User connecting Credential*/

$hostName ="localhost";
$userName ="jane";
$userPassword ="jane";

&nbsp;

/* return connection status through $dbConnectionStatus Boolean Variable*/

/* using mysqli Object*/

$dbConnectionStatus = new mysqli($hostName, $userName, $userPassword);

/* Check whether the User Succesfully connect to localhost and mydata Database*/
/* -> Access the instance "$dbConnectionStatus" variable property "connect_error " boolean */

if ($dbConnectionStatus->connect_error){

die("Connection failed: " . $dbConnectionStatus->connect_error);

}else{

echo " Database Connected " ;
echo "<br>";
}

$sql = "CREATE DATABASE janeDB ";

/* Execute query to create a Database call "janeDB " */

$createStatus =$dbConnectionStatus->query($sql);

/*Check Whether Data Base Successuly created*/
if($createStatus){

echo"DataBase created \n";

}else {

echo"Failed to create Database \n";
}




?>

Before executing the code above , make sure user  Jane is given the privileges to create a new database

 

Step 3

Save this File as “.php” extension in

C:\xampp\htdocs

 

If you want to change the root Location of the mySQL file check out this  article at step 3

 

 

Step 4

Test it

(1)Click Admin

(2) Click the  PHP File you have just created  in this example i name it  ” createDatabase.php”