三、显示数据库



<?php
      $conn=mysql_connect('localhost','root','123456');
   mysql_set_charset("utf8");
   mysql_select_db("db1");
   $sql="show databases;";
   $result=mysql_query($sql);
   if($result==false){
     echo "sql语句执行错误".mysql_error;
   }else{
  echo "<table border='1'>";
     echo "<tr>";
     echo "<td>数据库名</td>";
     echo "</tr>";
      while($arr=mysql_fetch_array($result)){
  echo "<tr>";
  echo "<td>" . $arr['Database'] . "</td>";
  echo "</tr>";
   }
   echo "</table>";
   }
?>