How do I make a database with php?

To create a database using PHP, you need to follow these steps:

1. Connect to your MySQL server: Before creating a database, you need to establish a connection to your MySQL server using PHP. You can use the mysqli_connect() function to connect to your MySQL server.

Here’s an example:

// Database credentials 
$host = "localhost"; 
$username = "root"; 
$password = "your_password"; 
// Create connection $conn = mysqli_connect($host, $username, $password);

// Check connection if (!$conn) { die("Connection failed: " . mysqli_connect_error()); } echo "Connected successfully";

Create a database: Once you have established a connection, you can use the mysqli_query() function to create a new database. Here’s an example:

// Create database
$sql = "CREATE DATABASE mydatabase";
if (mysqli_query($conn, $sql)) {
  echo "Database created successfully";
} else {
  echo "Error creating database: " . mysqli_error($conn);
}

Close the connection: After creating a database, you should close the connection to your MySQL server using the mysqli_close() function. Here’s an example:

// Close connection
mysqli_close($conn);

That’s it! You have successfully created a database using PHP.