php 顯示mysql伺服器所有資料庫 SHOW DATABASES

php 顯示mysql伺服器所有資料庫 SHOW DATABASES
$mydbname=$_GET['mydbname'];
$selectdbname=$phome_db_dbname;
if($mydbname)
{
 $selectdbname=$mydbname;
}
$db='';
if($canlistdb)
{
 $db.="<option value='".$selectdbname."'

selected>".$selectdbname."</option>";
}
else
{
 $sql=$empire->query("SHOW DATABASES");
 while($r=$empire->fetch($sql))
 {
  if($r[0]==$selectdbname)
  {$select=" selected";}
  else
  {$select="";}
  $db.="<option value='".$r[0]."'".$select.">".$r

[0]."</option>";
 }
}