PHP MySQLi Create DB

To create a MySQLi database in PHP, PHP mysqli_connect() function and PHP mysqli_query() function are used.

PHP mysqli_connect() function:

PHP mysqli_connect() function is used to open a new connection to the MySQL server. If the connection is established this function returns the resource, else it returns a null.

PHP mysqli_query() function:

PHP mysqli_query() function is used to perform a query against the MySQL database.



Connection: This is a required parameter which is used to specify the MySQL connection to use.

Query: This is an optional parameter which is used to specify the query string.

Resultmode: This is an optional parameter which is used to specify a constant either MYSQLI_USE_RESULT or MYSQLI_STORE_RESULT.

MYSQLI_STORE_RESULT is the default value of the resultmode. MYSQLI_USE_RESULT is used when a large amount of data need to be retrieved.


<!DOCTYPE html>
$phpconnect = mysqli_connect("localhost","Ben","Ben_password");
if (mysqli_connect_errno())
echo "Connection Failed; " . mysqli_connect_error();
echo "Connection Established.<br>";
$phpdatabase = 'CREATE Database Ben_db';  
if(mysqli_query( $phpconnect,$phpdatabase))
echo "Database Created successfully.<br>";  
echo "Database Creation Failed; ".mysqli_error($phpconnect);  
echo “Connection Closed.”


Connection Established.
Database Created successfully.
Connection Closed.
Please Share