Unable to create database
Posted: Tue Feb 28, 2006 2:55 am
Hi All,
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)
Thanks in advance..
Kishor.
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.