PHP mysql_list_dbs函数代码示例

function createDB()
{
    global $DEBUG;
    $host = urldecode($_GET['host']);
    $name = $_GET['name'];
    $user = $_GET['user'];
    $pwd = $_GET['pwd'];
    $ret = "<p>";
    $dbExists = false;
    $con = mysql_connect($host, $user, $pwd);
    // try to connect
    if (!$con) {
        die('Could not connect: ' . mysql_error());
    }
    $dblist = mysql_list_dbs($con);
    // check if the database already exists
    while ($row = mysql_fetch_object($dblist)) {
        $db = $row->Database;
        if ($db == $name) {
            $dbExists = true;
        }
    }
    if (!$dbExists) {
        if (mysql_query("CREATE DATABASE " . $name, $con)) {
            $ret .= "Created database '{$name}' at '{$host}' for user '{$user}' with password '{$pwd}'</p>";
        } else {
            $ret .= "Error creating database: " . mysql_error() . "</p>";
        }
    } else {
        $ret .= "The database '{$name}' already exists. We are ready to create an RDF store.</p>";
    }
    mysql_close($con);
    return $ret;
}

function listDbData()
{
    $link = mysqli_connect('localhost', 'root', '') or die(mysql_error());
    $db_list = mysql_list_dbs($link);
    print "<table width=100% bgcolor='BLACK' cellspacing=1 cellpadding=0>";
    print "<tr bgcolor=#BBBBBB><td align='center'>";
    print "<b>Database list</b>";
    print "</td></tr>";
    while ($row = mysqli_fetch_object($link, $db_list)) {
        print "<tr bgcolor='WHITE'><td align='center'>";
        print $row->Database;
        //echo $row->Database . "<br>";
        print "</td></tr>";
    }
    print "<tr bgcolor=#BBBBBB><td align='center'>";
    print "<b>Tables</b>";
    print "</td></tr>";
    $db_selected = mysqli_select_db('maxinedb', $link);
    $sql = "SHOW TABLES";
    $result = mysqli_query($link, $sql);
    if (!$result) {
        throw new man_exception('MySQL Error: ' . mysql_error());
    }
    while ($row = mysqli_fetch_row($link, $result)) {
        print "<tr bgcolor='WHITE'><td align='center'>";
        print $row[0] . "";
        print "</td></tr>";
    }
    print "</table>";
}

 /**
  * list all databases
  **/
 function listdbs($assoc = false)
 {
     $i = @mysql_list_dbs($this->link_id);
     $r = $this->_fetch_all($i, $assoc);
     $this->_release($i);
     return $r;
 }

function listDatabases() {
global $mysqlHandle, $PHP_SELF;

echo "<h1>Database List</h1>\n";

echo "<form action='$PHP_SELF'>\n";
echo "<input type=hidden name=action value=createDB>\n";
echo "<input type=text name=dbname>\n";
echo "<input type=submit value='Create Database'>\n";
echo "</form>\n";
echo "<hr>\n";

echo "<table cellspacing=1 cellpadding=5>\n";

$pDB = mysql_list_dbs( $mysqlHandle );
$num = mysql_num_rows( $pDB );
for( $i = 0; $i < $num; $i++ ) {
  $dbname = mysql_dbname( $pDB, $i );
  echo "<tr>\n";
  echo "<td>$dbname</td>\n";
  echo "<td><a href='$PHP_SELF?action=listTables&dbname=$dbname'>Table</a></td>\n";
  echo "<td><a href='$PHP_SELF?action=dropDB&dbname=$dbname' onClick=\"return confirm('Drop Database \'$dbname\'?')\">Drop</a></td>\n";
  echo "<td><a href='$PHP_SELF?action=dumpDB&dbname=$dbname'>Dump</a></td>\n";
  echo "</tr>\n";
}
echo "</table>\n";
}

function db_mysql_listdbase()
{
    $array_modules = array();
    $link = mysql_connect(_CFG_MYSQL_SERVER, _CFG_MYSQL_USER, _CFG_MYSQL_PASSWORD);
    mysql_select_db(_CFG_MYSQL_DB, $link);
    $result = mysql_list_dbs($link);
    while ($rs = mysql_fetch_object($result)) {
        $array_modules[] = $rs->Database;
    }
    return $array_modules;
}

function listDBs($connection)
{
    $dbs = array();
    $db_list = mysql_list_dbs($connection);
    while ($row = mysql_fetch_object($db_list)) {
        array_push($dbs, $row->Database);
    }
    if (count($dbs)) {
        return $dbs;
    }
}

 function &MetaDatabases()
 {
     $qid = mysql_list_dbs($this->_connectionID);
     $arr = array();
     $i = 0;
     $max = mysql_num_rows($qid);
     while ($i < $max) {
         $arr[] = mysql_tablename($qid, $i);
         $i += 1;
     }
     return $arr;
 }

 public function has_database()
 {
     $password_file = $this->get_password_file();
     $database = $password_file->get_database();
     #echo "\$database: $database\n";
     $dbh = $this->get_dbh_no_db_selected();
     $db_list = mysql_list_dbs($dbh);
     while ($row = mysql_fetch_object($db_list)) {
         if ($row->Database == $database) {
             return TRUE;
         }
     }
     return FALSE;
 }

function fnDatabaseExists($dbName, $oConn = '')
{
    //Verifies existence of a MySQL database
    $bRetVal = FALSE;
    if ($oConn or $oConn = @xf_db_connect(DB_HOST, DB_USER, DB_PASSWORD)) {
        $result = mysql_list_dbs($oConn);
        while ($row = xf_db_fetch_array($result, MYSQL_NUM)) {
            if ($row[0] == $dbName) {
                $bRetVal = TRUE;
            }
        }
        xf_db_free_result($result);
        xf_db_close($oConn);
    }
    return $bRetVal;
}

function createDatabaseOptions($default, $host, $user, $pass)
{
    $result = "";
    if ($con = @mysql_connect($host, $user, $pass)) {
        if ($res = mysql_list_dbs($con)) {
            $items = array();
            while ($row = mysql_fetch_object($res)) {
                $items[$row->Database] = $row->Database;
            }
            $result = createOptionsFromArray($items, isset($default) ? $default : NULL);
            mysql_free_result($res);
        }
        mysql_close($con);
    }
    return $result;
}

function get_db_list()
{
    global $hostname;
    global $username;
    global $password;
    global $db_remove_list;
    $conn = mysql_connect($hostname, $username, $password);
    $db_list = mysql_list_dbs($conn);
    $html = "<ul id='user_list'>";
    while ($row = mysql_fetch_object($db_list)) {
        $db_name = $row->Database;
        if (!preg_match($db_remove_list, $db_name)) {
            $html .= "<li ><a href=\"tables.php?q={$db_name}\" target=\"form\">{$db_name}</a></li>\n";
        }
    }
    $html .= "</ul>";
    return $html;
}

function dbconnect($host, $uname, $passwd, $mydb)
{
    global $dbarr;
    $db = mysql_connect($host, $uname, $passwd);
    $db_list = mysql_list_dbs($db);
    echo "\nDatabases: <select name=\"sel_db\" onChange=\"JavaScript:form.submit();\">\n";
    echo "<option value=\"\">select database ....</option>\n";
    while ($row = mysql_fetch_object($db_list)) {
        foreach ($dbarr as $myvalue) {
            if ($row->Database == $myvalue) {
                if ($mydb == "{$row->Database}") {
                    echo "<option value=\"{$row->Database}\" selected>{$row->Database}</option>\n";
                } else {
                    echo "<option value=\"{$row->Database}\">{$row->Database}</option>\n";
                }
            }
        }
    }
    echo "</select>";
}

 public function setDBName($dbName = '*')
 {
     if ($dbName == '*') {
         $rs = mysql_list_dbs();
         $rows = mysql_num_rows($rs);
         if ($rows) {
             for ($i = 0; $i < $rows; $i++) {
                 $dbName = mysql_tablename($rs, $i);
                 $block = array('information_schema', 'mysql');
                 if (!in_array($dbName, $block)) {
                     $this->dbName[] = $dbName;
                 }
             }
         } else {
             $this->error('没有任何数据库!');
         }
     } else {
         $this->dbName = func_get_args();
     }
 }

 function dbnames($options)
 {
     $options = $options['base'];
     $link = @mysql_connect($options['database.host'], $options['database.username'], $options['database.password']);
     if (!$link) {
         return array();
     } else {
         if (function_exists('mysql_list_dbs')) {
             $db_list = mysql_list_dbs($link);
         } else {
             $db_list = mysql_query('SHOW databases');
         }
         //todo: 加强兼容性
         $i = 0;
         $cnt = mysql_num_rows($db_list);
         $rows = array();
         while ($i < $cnt) {
             $dbname = trim(mysql_db_name($db_list, $i++));
             $rows[$dbname] = $dbname;
         }
         return $rows;
     }
 }

 function init(&$c)
 {
     $errors = pfcContainerInterface::init($c);
     // connect to the db
     $db = $this->_connect($c);
     if ($db === FALSE) {
         $errors[] = _pfc("Mysql container: connect error");
         return $errors;
     }
     // create the db if it doesn't exists
     $db_exists = false;
     $db_list = mysql_list_dbs($db);
     while (!$db_exists && ($row = mysql_fetch_object($db_list))) {
         $db_exists = $c->container_cfg_mysql_database == $row->Database;
     }
     if (!$db_exists) {
         $query = 'CREATE DATABASE ' . $c->container_cfg_mysql_database;
         $result = mysql_query($query, $db);
         if ($result === FALSE) {
             $errors[] = _pfc("Mysql container: create database error '%s'", mysql_error($db));
             return $errors;
         }
         mysql_select_db($c->container_cfg_mysql_database, $db);
     }
     // create the table if it doesn't exists
     $query = $this->_sql_create_table;
     $query = str_replace('%engine%', $c->container_cfg_mysql_engine, $query);
     $query = str_replace('%table%', $c->container_cfg_mysql_table, $query);
     $query = str_replace('%fieldtype_server%', $c->container_cfg_mysql_fieldtype_server, $query);
     $query = str_replace('%fieldtype_group%', $c->container_cfg_mysql_fieldtype_group, $query);
     $query = str_replace('%fieldtype_subgroup%', $c->container_cfg_mysql_fieldtype_subgroup, $query);
     $query = str_replace('%fieldtype_leaf%', $c->container_cfg_mysql_fieldtype_leaf, $query);
     $query = str_replace('%fieldtype_leafvalue%', $c->container_cfg_mysql_fieldtype_leafvalue, $query);
     $query = str_replace('%fieldtype_timestamp%', $c->container_cfg_mysql_fieldtype_timestamp, $query);
     $result = mysql_query($query, $db);
     if ($result === FALSE) {
         $errors[] = _pfc("Mysql container: create table error '%s'", mysql_error($db));
         return $errors;
     }
     return $errors;
 }