Page 1 of 1

Unable to create database

Posted: Tue Feb 28, 2006 2:55 am
by onlykishor
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)

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>
Thanks in advance..
Kishor.

Posted: Tue Feb 28, 2006 9:18 am
by feyd
Where's $dbname coming from?

Thanks for reply

Posted: Thu Mar 02, 2006 12:02 am
by onlykishor
The $dbname is coming from the HTML at the end of script.

Posted: Thu Mar 02, 2006 12:03 am
by feyd
Only if register_globals is on. Is it?