<?php
$servername = "localhost";
$username = "your_username";
$password = "your_password";
$dbname = "your_database";
try {
$conn = new PDO("mysql:host=$servername;dbname=$dbname", $username, $password);
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$query = "SELECT 1 FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = ?";
$stmt = $conn->prepare($query);
$stmt->bindParam(1, $dbname);
$stmt->execute();
if ($stmt->fetchColumn())
{
echo "Database already exists. No action required.";
}
else
{
$query = "CREATE DATABASE $dbname";
$conn->exec($query);
echo "Database created successfully.";
}
} catch(PDOException $e) {
echo "Connection failed: " . $e->getMessage();
}
?>