PHP 刪除資料表

1. 撰寫 droptbl.php，刪除資料庫 dywphp 中的資料表 tblphp。

   [root@kvm3 html]# vim droptbl.php
   <?php
   $dbhost = 'localhost:3306';
   $dbuser = 'root';
   $dbpass = '123qwe';
   $conn = mysqli_connect($dbhost, $dbuser, $dbpass) 
   	or die(mysqli_connect_error().PHP_EOL);
   echo 'Connected successfully'.PHP_EOL;
   mysqli_select_db( $conn, 'dywphp' )
   	or die('Error: '.mysqli_error($conn).PHP_EOL);
   $sql = "drop TABLE tblphp;";
   mysqli_query( $conn, $sql )
   	or die('Error: '.mysqli_error($conn).PHP_EOL);
   echo "Table tblphp deleted successfully\n";
   mysqli_close($conn); 
   ?>
   

2. 以 curl 連線 droptbl.php，𢦓功刪除資料表 tblphp。

   [root@kvm3 html]# curl -s http://127.0.0.1/droptbl.php
   Connected successfully
   Table tblphp deleted successfully
   

3. 以 curl 再連線 droptbl.php，回應𢦓功資料表 tblphp 不存在。

   [root@kvm3 html]# curl -s http://127.0.0.1/droptbl.php
   Connected successfully
   Error: Unknown table 'dywphp.tblphp'