php 显示mysql服务器所有数据库 SHOW DATABASES
<?php
$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>";
}
}教程网址:http://www.phprm.com/code/php-mysql-show-databases.html
欢迎收藏∩_∩但请保留本文链接。