Home >>MySQL Tutorial >PHP Create MySQLi Database
<?php $host = "localhost"; $user = "root"; $pass = ""; // Create database connection $con = new mysqli($host, $user, $pass); // Check database connection if ($con->connect_error) { die("Connection failed: " . $con->connect_error); } // Create database demo $query = "CREATE DATABASE demo"; if ($con->query($query) === TRUE) { echo "Database created successfully"; } else { echo "Error creating database: " . $con->error; } ?>
<?php $host = "localhost"; $user = "root"; $pass = ""; // Create database connection $con = mysqli_connect($host, $user, $pass); // Check database connection if (!$con) { die("Connection failed: " . mysqli_connect_error() ); } // Create database demo $query = "CREATE DATABASE demo"; if (mysqli_query($con,$query)) { echo "Database created successfully"; } else { echo "Error creating database: " . mysqli_error($con); } ?>
Note : Here $host(localhost) is servername, $user(root) is default database user name. $pass("") default database password