Help me out for the below code. Able to list all the existing database but new database is not getting created. I'm using PHP 5 on MySql 4.0 (there is no default password set for MySql)
Code: Select all
<?
$conn = @mysql_connect("localhost","root") or die("Unable to connect : " . mysql_error() );
if ( strlen($dbname) > 0 )
{
$sql = 'CREATE DATABASE $dbname';
if (mysql_query($sql, $conn)) {
echo "Database created successfully\n";
} else {
echo 'Error creating database: ' . mysql_error() . "\n";
}
} else {
echo "<br>please specify database name to create<br>" ;
}
$rs = @mysql_list_dbs($conn);
for($row=0; $row < mysql_num_rows($rs); $row++)
{
$list .= mysql_tablename($rs, $row) . " | " ;
}
mysql_close($conn);
?>
<html><head><title>Create Databases</title></head>
<body>
<form action="<? echo($PHP_SELF); ?>" method="post">
Current databases: <? echo($list); ?> <hr>
Name: <input type="text" name="dbname">
<input type="submit" value="Create Database">
</form>
</body>
</html>Kishor.