php - 检测/创建MySQL数据库

Question

为什么此代码无法识别现有数据库？

$result = mysql_query("SHOW DATABASES LIKE $database", $conn);
echo $result."       aaaaaaaaaaaaaaaaaaa<br>";
if ($result) 
{
    echo ("Datebase <font color='#FF0000'><b> $database </b></font> already exist.<br /><br />");
}
else
{
    mysql_query("create database IF NOT EXISTS $database CHARACTER SET utf8 COLLATE utf8_general_ci");
    echo ("Datebase <font color='#FF0000'><b> $database </b></font> is succesfully created.<br /><br />");
}

Answer 1

这段代码让我有点恶心......

这是一个很好的代码:

<?php

$query = "SHOW DATABASES LIKE ". $database;
$mysqlquery = mysql_query($query);
if($mysqlquery){
    echo '<b>Database already exist.<br>';
}
else
{
    $createquery = "CREATE DATABASE IF NOT EXISTS ". $database ." CHARACTER SET utf8 COLLATE utf8_general_ci";
    $mysqlcreatequery = mysql_query($createquery);
    if($mysqlcreatequery){
        echo 'Database '. $database .' created. ';
    }
    else
    {
        echo 'Database is not created!';
    }
}
?>