Creating databases : mysql_connect « MySQL Database « PHP






  1. PHP
  2. MySQL Database
  3. mysql_connect

Creating databases

 
<?php   

$conn = @mysql_connect( "localhost", "userName", "password" ) 
  or die( "Sorry - could not connect to MySQL" );

$rs1 =  @mysql_create_db( $_REQUEST['db'] );

$rs2=   @mysql_list_dbs($conn);

$list = "";

for( $row=0; $row < mysql_num_rows( $rs2 ); $row++ )
{ 
  $list .= mysql_tablename( $rs2, $row ) . " | "; 
} 

?>

<html>

 <head>
  <title>Creating databases</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>








Related examples in the same category

1.A function to open a connection to mysql
2.Connecting to a MySQL Database
3.Connecting user
4.When connecting to multiple MySQL servers, a link ID must be generated.