コード例 #1
0
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";
}
コード例 #2
0
/**
 * 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));
    }
}
コード例 #3
0
 /**
  * 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;
 }
コード例 #4
0
ファイル: install_mysql.php プロジェクト: rhertzog/lcs
    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";
コード例 #5
0
ファイル: mysql.class.php プロジェクト: laiello/mystep-cms
 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;
 }
コード例 #6
0
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);
コード例 #7
0
ファイル: inc_db_mysql.php プロジェクト: nyimbi/legalcase
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;
    }
}
コード例 #8
0
 function get_current_database()
 {
     return mysql_dbname();
 }