c_pattle Posted April 24, 2010 Share Posted April 24, 2010 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). <?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> 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 Link to comment https://forums.phpfreaks.com/topic/199583-mysql-error/ Share on other sites More sharing options...
Mchl Posted April 24, 2010 Share Posted April 24, 2010 The function mysql_create_db() is deprecated. It is preferable to use mysql_query() to issue a sql CREATE DATABASE statement instead. Link to comment https://forums.phpfreaks.com/topic/199583-mysql-error/#findComment-1047584 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.