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"; }
/** * Functions to wrap around MySQL database functions. This is basically made * to allow charset conversion, but later may be useful for other stuff. */ function PMA_mysql_dbname($result, $row, $field = FALSE) { if ($field != FALSE) { return PMA_convert_display_charset(mysql_dbname($result, $row, $field)); } else { return PMA_convert_display_charset(mysql_dbname($result, $row)); } }
/** * Get the list and number of available databases. * * @param string the url to go back to in case of error * * @return boolean always true * * @global array the list of available databases * @global integer the number of available databases */ function PMA_availableDatabases($error_url = '') { global $dblist; global $num_dbs; $num_dbs = count($dblist); // 1. A list of allowed databases has already been defined by the // authentification process -> gets the available databases list if ($num_dbs) { $true_dblist = array(); for ($i = 0; $i < $num_dbs; $i++) { $dblink = @mysql_select_db($dblist[$i]); if ($dblink) { $true_dblist[] = $dblist[$i]; } // end if } // end for $dblist = array(); $dblist = $true_dblist; unset($true_dblist); $num_dbs = count($dblist); } else { $dbs = mysql_list_dbs() or PMA_mysqlDie('', 'mysql_list_dbs()', FALSE, $error_url); $num_dbs = @mysql_num_rows($dbs); $real_num_dbs = 0; for ($i = 0; $i < $num_dbs; $i++) { $db_name_tmp = mysql_dbname($dbs, $i); $dblink = @mysql_select_db($db_name_tmp); if ($dblink) { $dblist[] = $db_name_tmp; $real_num_dbs++; } } // end for mysql_free_result($dbs); $num_dbs = $real_num_dbs; } // end else return TRUE; }
echo "<input type='hidden' name='adresse_db' value=\"$adresse_db\" size='40' />\n"; echo "<input type='hidden' name='login_db' value=\"$login_db\" />\n"; echo "<input type='hidden' name='pass_db' value=\"$pass_db\" />\n"; $link = mysql_connect("$adresse_db","$login_db","$pass_db"); $result = @mysql_list_dbs(); echo "<fieldset><label><b>Choisissez votre base :</b><br /></label>\n"; if ($result AND (($n = @mysql_num_rows($result)) > 0)) { echo "<p><b>Le serveur $dbsys contient plusieurs bases de données.<br />Sélectionnez celle dans laquelle vous voulez implanter GRR</b></p>\n"; echo "<ul>\n"; $bases = ""; $checked = FALSE; for ($i = 0; $i < $n; $i++) { $table_nom = mysql_dbname($result, $i); $base = "<li><input name=\"choix_db\" value=\"".$table_nom."\" type=\"radio\" id='tab$i'"; $base_fin = " /><label for='tab$i'>".$table_nom."</label></li>\n"; if ($table_nom == $login_db) { $bases = "$base checked=\"checked\"".$bases; $checked = TRUE; } else { $bases .= "$base$base_fin\n"; } } echo $bases."</ul>\n"; echo "ou... "; } else { echo "<b>Le programme d'installation n'a pas pu lire les noms des bases de données installées.</b>Soit aucune base n'est disponible, soit la fonction permettant de lister les bases a été désactivée pour des raisons de sécurité.<br />\n";
public function GetDBs() { $this->Free(); $dbs = array(); $this->DB_result = mysql_list_dbs($this->DB_conn); $this->DB_qstr = "none (List Databases)"; if ($this->CheckError()) { $this->Error("Could not List Databases"); } $dbs = array(); $num_dbs = mysql_num_rows($this->DB_result); for ($i = 0; $i < $num_dbs; $i++) { $dbs[] = mysql_dbname($this->DB_result, $i); } $this->Free(); return $dbs; }
echo "NUM\n"; var_dump(mysql_fetch_array($result, MYSQL_NUM)); $result = @mysql_query("SELECT * FROM mysql.user") or die("Could not query: " . mysql_error()); echo "\n1result is: " . mysql_result($result, 4, 'password'); echo "\n2result is: " . mysql_result($result, 4, 'user.password'); $result = mysql_query("SELECT * FROM mysql.user") or die("Could not query: " . mysql_error()); echo "\nresult is: " . mysql_result($result, 4, 1); var_dump(mysql_fetch_field($result)); $result = mysql_query("SELECT * FROM mysql.user") or die("Could not query: " . mysql_error()); echo "\nresult is: " . mysql_dbname($result, 6, 0); // from phpmyadmin $dbs = mysql_list_dbs(); echo "\ndbs:\n"; $num_dbs = $dbs ? mysql_num_rows($dbs) : 0; var_dump($num_dbs); $real_num_dbs = 0; for ($i = 0; $i < $num_dbs; $i++) { $db_name_tmp = mysql_dbname($dbs, $i); var_dump($db_name_tmp); $dblink = mysql_select_db($db_name_tmp); if ($dblink) { $dblist[] = $db_name_tmp; $real_num_dbs++; } } mysql_free_result($dbs); var_dump($dblist); mysql_select_db("test"); $result = mysql_query("UPDATE my_table SET field1 = 'test one' WHERE id=1"); var_dump($result); mysql_close($link);
function lcm_list_databases($host, $login, $pass, $port = 0) { $databases = array(); if ($port > 0) { $host = "{$host}:{$port}"; } $link = @mysql_connect($host, $login, $pass, $port); if ($link) { $result = @mysql_list_dbs(); if ($result and ($num = mysql_num_rows($result)) > 0) { for ($i = 0; $i < $num; $i++) { $name = mysql_dbname($result, $i); if ($name != 'test' && $name != 'information_schema') { array_push($databases, $name); } } } return $databases; } else { echo "<!-- NO LINK -->\n"; return NULL; } }
function get_current_database() { return mysql_dbname(); }