PHP/MySQL Database/mysql drop db

Материал из Web эксперт
Перейти к: навигация, поиск

Deleting databases

   <source lang="html4strict">

<?php $conn = @mysql_connect( "localhost", "userName", "password" )

 or die( "Sorry - could not connect to MySQL" );

$rs1 = @mysql_drop_db( $_REQUEST["db"] ); $rs2 = mysql_list_dbs( $conn ); for( $row = 0; $row < mysql_num_rows( $rs2 ); $row++ ) {

 $list .= mysql_tablename( $rs2, $row ) . " | "; 

} ?> <html>

<head>
 <title>Deleting databases</title>
</head>
<body>
<form action = "<?php echo( $_SERVER["PHP_SELF"] ); ?>" method = "post">
Current databases: <?php echo( $list ); ?> 

Name:<input type = "text" name = "db"> 
<input type = "submit" value = "Delete database">
</form>
</body>

</html>

 </source>