本文整理汇总了PHP中mysql_list_dbs函数的典型用法代码示例。如果您正苦于以下问题:PHP mysql_list_dbs函数的具体用法?PHP mysql_list_dbs怎么用?PHP mysql_list_dbs使用的例子?那么恭喜您, 这里精选的函数代码示例或许可以为您提供帮助。
在下文中一共展示了mysql_list_dbs函数的20个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于我们的系统推荐出更棒的PHP代码示例。
示例1: createDB
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;
}
开发者ID:p6,项目名称:arc2-starter-pack,代码行数:34,代码来源:install.php
示例2: listDbData
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>";
}
开发者ID:RoneilZA,项目名称:dashboards,代码行数:30,代码来源:manapi.php
示例3: listdbs
/**
* 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;
}
开发者ID:notchent,项目名称:linb,代码行数:10,代码来源:MYSQL.php
示例4: listDatabases
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";
}
开发者ID:xl7dev,项目名称:WebShell,代码行数:27,代码来源:Mysql_interface_v1.0.php
示例5: db_mysql_listdbase
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;
}
开发者ID:BackupTheBerlios,项目名称:baifox-svn,代码行数:11,代码来源:include_funciones.php
示例6: listDBs
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;
}
}
开发者ID:cyberwani,项目名称:Snippets-1,代码行数:11,代码来源:restore.php
示例7: mysql_list_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;
}
开发者ID:qoire,项目名称:portal,代码行数:12,代码来源:adodb-mysql.inc.php
示例8: has_database
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;
}
开发者ID:saulhoward,项目名称:haddock-cms,代码行数:14,代码来源:Database_MySQLRootUser.inc.php
示例9: fnDatabaseExists
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;
}
开发者ID:minger11,项目名称:Pipeline,代码行数:16,代码来源:mysql_functions.php
示例10: createDatabaseOptions
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;
}
开发者ID:hyperweb2,项目名称:database-compare,代码行数:16,代码来源:values.lib.php
示例11: get_db_list
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;
}
开发者ID:nmoureyii,项目名称:db-tools,代码行数:18,代码来源:functions.php
示例12: dbconnect
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>";
}
开发者ID:alexzita,项目名称:alex_blog,代码行数:20,代码来源:dataman_functions.php
示例13: setDBName
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();
}
}
开发者ID:liuguogen,项目名称:weixin,代码行数:20,代码来源:MySQLReback.class.php
示例14: dbnames
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;
}
}
开发者ID:453111208,项目名称:bbc,代码行数:23,代码来源:task.php
示例15: init
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;
}
开发者ID:danielheyman,项目名称:EazySubs,代码行数:41,代码来源:mysql.class.php
示例16: db2app
function db2app()
{
require_once 'HTML/QuickForm.php';
$form = new HTML_QuickForm('db2app');
$res = mysql_list_dbs(db());
if (!$res) {
trigger_error(mysql_error(db()), E_USER_ERROR);
}
$options = array('' => 'Please Select Database ...');
while ($row = mysql_fetch_row($res)) {
$options[$row[0]] = $row[0];
}
$form->addElement('hidden', '-action', 'db2app');
$form->addElement('select', 'database_name', 'Select Database' . $this->infoLink('archive2app.database_name'), $options, array('onchange' => 'listeners.database_name.onchange(this)'));
$form->addElement('header', 'db_info', 'Database connection details');
//$form->addElement('html', 'this is a test');
$form->addElement('text', 'mysql_user', 'MySQL Username ' . $this->infoLink('archive2app.mysql_user'));
$form->addElement('password', 'mysql_password', 'MySQL Password');
//$form->addElement('radio','output_format','Output options','Download as tar.gz archive','download');
//$form->addElement('radio','output_format','','Install on webserver in apps directory','install');
$form->addElement('select', 'install_type', 'Installation type ' . $this->infoLink('archive2app.install_type'), array('' => 'Please select ...', 'download_tarball' => 'Download Tarball', 'ftp_install' => 'Install on server (using FTP)'), array('onchange' => "listeners.install_type.onchange(this);"));
$form->addElement('header', 'ftp_info', 'FTP Connection Info');
$form->addElement('text', 'ftp_host', 'FTP Host');
$form->addElement('checkbox', 'ftp_ssl', 'Use SSL');
$form->setDefaults(array('ftp_host' => DB_HOST));
$form->addElement('text', 'ftp_path', 'FTP Path', array('size' => 50));
$form->setDefaults(array('ftp_path' => $_SERVER['DOCUMENT_ROOT']));
$form->addElement('text', 'ftp_username', 'FTP Username');
$form->addElement('password', 'ftp_password', 'FTP Password');
$form->addElement('submit', 'submit', 'Submit');
$form->addRule('database_name', 'Please select a database', 'required', null, 'client');
$form->addRule('mysql_user', 'Please enter a mysql username that the application can connect as.', 'required', null, 'client');
$form->addRule('install_type', 'Please select an installation type and then click submit.', 'required', null, 'client');
$form->setDefaults(array('mysql_user' => $_SERVER['PHP_AUTH_USER'], 'mysql_password' => $_SERVER['PHP_AUTH_PW']));
if ($form->validate()) {
$tarpath = $form->process(array(&$this, 'db2app__process'), true);
header('Content-type: application/x-gzip');
header('Content-Disposition: attachment; filename="' . basename($tarpath) . '.tar.gz"');
echo file_get_contents($tarpath);
exit;
}
require_once 'HTML/QuickForm/Renderer/Array.php';
$renderer = new HTML_QuickForm_Renderer_Array(true, true, true);
$form->accept($renderer);
$context = $renderer->toArray();
//print_r($context);
ob_start();
$form->display();
$out = ob_get_contents();
ob_end_clean();
include 'install' . DIRECTORY_SEPARATOR . 'db2app.inc.php';
}
开发者ID:promoso,项目名称:HVAC,代码行数:52,代码来源:installer.php
示例17: mysql_list_dbs
</head>
<body text="#000000" link="#006600" vlink="#993333" alink="#CC6600" background="rlaemb.JPG">
<?php
$priviledge = '00';
include 'allow_to_show.inc';
?>
<form method="POST" action="php.php">
<p><b>The following database found in MySQL server</b>
<select size="1" name="dblist">
<?php
//list database
$dbcont = "invalid";
include "connet_root.inc";
$result = mysql_list_dbs();
$i = 0;
while ($i < mysql_num_rows($result)) {
$tb_names[$i] = mysql_tablename($result, $i);
if ($i == 0) {
echo '<option selected>';
echo $tb_names[$i];
echo '</option>';
} else {
echo '<option>';
echo $tb_names[$i];
echo '</option>';
}
$i++;
}
?>
开发者ID:CMMCO,项目名称:Intranet,代码行数:31,代码来源:frm_list_dbs.php
示例18: DB_Exists
function DB_Exists($db)
{
global $config;
if (!isset($config['dbconnection'])) {
MSD_mysql_connect();
}
$erg = false;
$dbs = mysql_list_dbs($config['dbconnection']);
while ($row = mysql_fetch_object($dbs)) {
if (strtolower($row->Database) == strtolower($db)) {
$erg = true;
break;
}
}
return $erg;
}
开发者ID:BackupTheBerlios,项目名称:oos-svn,代码行数:16,代码来源:functions_sql.php
示例19: GetDatabaseList
function GetDatabaseList()
{
$xmlOutput = "<RESULTSET><FIELDS><FIELD><NAME>NAME</NAME></FIELD></FIELDS><ROWS>";
$dbList = mysql_list_dbs($this->connectionId);
while ($row = mysql_fetch_object($dbList)) {
$xmlOutput .= "<ROW><VALUE>" . $row->Database . "</VALUE></ROW>";
}
$xmlOutput .= "</ROWS></RESULTSET>";
return $xmlOutput;
}
开发者ID:Himy1118,项目名称:2015FinalTestProject,代码行数:10,代码来源:mysql.php
示例20: MySQL_Db_Name_Test
/**
* Test mysql_db_name
*
* @return boolean
*/
public function MySQL_Db_Name_Test()
{
// Connect
list($mysql, $ourDb) = $this->_getConnection();
$dbs1 = mysql_list_dbs();
$dbs2 = $this->_object->mysql_list_dbs();
$list1 = array();
$list2 = array();
$i = 0;
$cnt = mysql_num_rows($dbs1);
while ($i < $cnt) {
$list1[] = mysql_db_name($dbs1, $i);
$i++;
}
$i = 0;
$cnt = $this->_object->mysql_num_rows($dbs2);
while ($i < $cnt) {
$list2[] = $this->_object->mysql_db_name($dbs2, $i);
$i++;
}
return $list1 === $list2;
}
开发者ID:ReKungPaw,项目名称:mysql,代码行数:27,代码来源:MySQL_Test.php
注:本文中的mysql_list_dbs函数示例整理自Github/MSDocs等源码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。 |
请发表评论