PHP and MySQLi Create Database

To create MySQL database using PHP with MySQLi, following are the two ways:

Create MySQL database manually.
Create MySQL database using PHP with MySQLi

Let's learn about the above two ways to create MySQL database, that is, by using PHP with MySQLi or by manual operation.

Create MySQL Database Manually

To create MySQL database manually, follow the following steps:

Open XAMPP
Start Apache Module
Start MySQL Module
Click on Admin of MySQL Module
Click on Database link
Enter Database name say codescracker in the Create database input box
Click on Create button

Here is the screenshot of the window that will appear after performing the 4^th option.

And below is the screenshot of the window that will appear after performing the 7^th (last) option

Now you have created a database named codescracker recently. Now let's learn how to create MySQL database using PHP with Mysqli.

Create MySQL Database using PHP with MySQLi

Here is an example shows how to create MySQL database using PHP with MySQLi.

<?php 
	// below code used to connect to the server 
	// here localhost is the local server name
	// root is the local username of the XAMPP
	// and password is blank
	$conn = mysqli_connect('localhost', 'root', '');
	// below code will check whether the server connection 
	// is successfully done or not
	if(mysqli_connect_error())
	{
		echo "<p>Error occurred while connecting to the server.</p>";
		echo "<p>Please visit us later.</p>";
		echo "<p>Exiting....</p>";
		exit();
	}
?>
<html>
<head>
	<title>PHP and MySQLi Create Database Example</title>
</head>
<body>
<?php
	// place the database name in some variable 
	// say $databaseName here
	$databaseName = "codescrackerTwo";
	// place the query in another variable
	// say $querySQL here
	$querySQL = "create database $databaseName";
	// now query the above SQL statement and 
	// store the returned result into another variable 
	// say $returnRes here to check whether the 
	// query has done successfully or not
	$returnRes = $conn->query($querySQL);
	if($returnRes)
	{
		// query has done successfully
		echo "<p>Database <b>codescrackerTwo</b> is created successfully.</p>";
	}
	else 
	{
		// error occurred in querying the above given sql statement
		echo "<p>Error occurred while creating the database.</p>";
		echo "<p>Exiting....</p>";
		exit();
	}
?>
</body>
</html>

Now type the above code or just do copy and past in your text editor, and save the above file inside the directory C:\xampp\htdocs\ with name codescracker.php and open your browser then type localhost/codescracker.php

After performing the above action, you have successfully run the above given example code of creating MySQL database using PHP with MySQLi and created a MySQL database named codescrackerTwo.

Here is the sample output produced by the above PHP and MySQLi create database example code:

To see the created database, just click on the Database link, here is the screenshot after clicking on the database link.

And to see the database link at the left pannel, then close the browser and again click on the Admin button of the MySQL module in XAMPP. Here is the screenshot of the browser window, that is, phpMyAdmin window after clicking on the Admin button:

As you can see your database name, that is, codescrackerTwo is present in the left pannel of the phpMyAdmin window.

PHP Online Test

« Previous Tutorial Next Tutorial »