<?php
$servername = “localhost”;
$username = “root”;
$password = “”;

// Create connection
$conn = mysqli_connect($servername, $username, $password);

// Check connection
if (!$conn) {
die(“Connection failed: ” . mysqli_connect_error());
}

// SQL query to create database
$sql = “CREATE DATABASE IF NOT EXISTS my_database”;

// Execute query
if (mysqli_query($conn, $sql)) {
echo “Database created successfully”;
} else {
echo “Error creating database: ” . mysqli_error($conn);
}

// Close connection
mysqli_close($conn);
?>

Q. Create database and  table and insert data in that table in php 

<?php
/* ———- 1. Connection ———- */
$host = “localhost”;
$user = “root”;
$pass = “”;
$db = “my_database”;
$table = “students”;

$conn = mysqli_connect($host, $user, $pass);

if (!$conn) {
die(“Connection failed”);
}
echo “Connected successfully<br>”;

/* ———- 2. Create Database ———- */
$create_db = “CREATE DATABASE IF NOT EXISTS $db”;
mysqli_query($conn, $create_db);
echo “Database created<br>”;

/* ———- 3. Select Database ———- */
mysqli_select_db($conn, $db);
echo “Database selected<br>”;

/* ———- 4. Create Table ———- */
$create_table = “CREATE TABLE IF NOT EXISTS $table (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(50),
email VARCHAR(50)
)”;
mysqli_query($conn, $create_table);
echo “Table created<br>”;

/* ———- 5. Insert Data ———- */
$name = “John”;
$email = “john@gmail.com”;

$insert = “INSERT INTO $table (name, email) VALUES (‘$name’, ‘$email’)”;
mysqli_query($conn, $insert);
echo “Data inserted successfully<br>”;

/* ———- Close Connection ———- */
mysqli_close($conn);
?>