To create a database using MySQLi in PHP, you can follow these steps:

1. Connect to the MySQL server.

2. Execute the SQL query to create the database.

3. Check if the query was successful.

Here’s an example of how you can create a database using MySQLi in PHP:

1. Create a Database Using MySQLi (Procedural Style)

<?php// Database connection parameters$host = "localhost";  // Host name$username = "root";   // Database username$password = "";       // Database password// Create connection$conn = mysqli_connect($host, $username, $password);// Check connectionif (!$conn) {    die("Connection failed: " . mysqli_connect_error());}// SQL query to create a new database$sql = "CREATE DATABASE my_new_database";// Execute the queryif (mysqli_query($conn, $sql)) {    echo "Database created successfully";} else {    echo "Error creating database: " . mysqli_error($conn);}// Close the connectionmysqli_close($conn);?>

2. Create a Database Using MySQLi (Object-Oriented Style)

<?php// Database connection parameters$host = "localhost";  // Host name$username = "root";   // Database username$password = "";       // Database password// Create connection$conn = new mysqli($host, $username, $password);// Check connectionif ($conn->connect_error) {    die("Connection failed: " . $conn->connect_error);}// SQL query to create a new database$sql = "CREATE DATABASE my_new_database";// Execute the queryif ($conn->query($sql) === TRUE) {    echo "Database created successfully";} else {    echo "Error creating database: " . $conn->error;}// Close the connection$conn->close();?>

Explanation:

• Connection:

  • The first step is to connect to the MySQL server using mysqli_connect() (procedural) or new mysqli() (object-oriented).

  • You don’t need to specify a database name when connecting because you’re only creating a new database.

• SQL Query:

  • The SQL query "CREATE DATABASE my_new_database" creates a new database named my_new_database. You can replace the database name with any name you prefer.

• Execute the Query:

  • You can use mysqli_query() (procedural) or $conn->query() (object-oriented) to execute the SQL query.

  • After executing the query, check whether it was successful.

• Error Handling:

  • If the query executes successfully, a success message is displayed. Otherwise, an error message is shown.

• Close Connection:

  • It's good practice to close the connection using mysqli_close() (procedural) or $conn->close() (object-oriented) once you're done.

Error Handling:

If the database already exists, the query will fail. You can handle this by checking if the database already exists before trying to create it, or simply handling the error gracefully.

Notes:

• Ensure that your MySQL server is running and that you have sufficient privileges to create databases.

• In a production environment, always handle errors gracefully (e.g., logging errors rather than displaying them to the user).

Let me know if you need more details or modifications!