Create a MySQL Database Using MySQLi and Object Oriented
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 | <?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; } ?> |
Create a MySQL Database Using MySQLi and Procedural
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 | <?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