MySQL Error
Posted: Sat Apr 24, 2010 7:39 am
Hey everyone. I'm trying to simply just create a php document that allows me to create a database using MySQL. I've copied my code below (password for mysql is correct but I wanted to hide it).
When I try to run the page I get this error "Fatal error: Call to undefined function mysql_create_db() in /var/www/test2.php on line 5"
Does anyone know why this is happening?
Thanks for any help
Code: Select all
<?php
$conn = mysql_connect("localhost","root","******") or die ("Sorry");
$rs1 = mysql_create_db ( $_REQEUST['db'] );
$rs2 = mysql_list_db ($conn );
for( $row = 0; $row < mysql_num_rows ($rs2); $row++) {
$list.= mysql_tablename( $rs2, $row) . " - ";
}
?>
<html>
<head>
<title>Title</title>
</head>
<body>
<form action="<?php echo ( $_SERVER['PHP_SELF'] ); ?>" method="post">Current Databases: <?php echo ( $list); ?>
<hr>Name:<input type="text" name"db">
<input type="submit" value"Create Database">
</form>
</body>
</html>Does anyone know why this is happening?
Thanks for any help