SelectDatabase() public method

Selects a different database and character set
public SelectDatabase ( string $database, string $charset = "" ) : boolean
$database string Database name
$charset string (Optional) Character set (i.e. utf8)
return boolean Returns TRUE on success or FALSE on error
MySQL Class Documentation
コード例 #1
0
 $db = new MySQL();
 //
 // Try database connection
 //
 if (!$db->Open(null, $_SESSION['variables']['db_host'], $_SESSION['variables']['db_user'], $_SESSION['variables']['db_pass'], 'utf8', 'utf8_unicode_ci')) {
     $errors[] = 'Error: could not connect to the database engine';
     $errors[] = $db->Error();
     $errors[] = $db->MyDyingMessage();
     $err++;
 } else {
     $log[] = "Database engine connection successful";
 }
 //
 // Either Select the database or create it when it does not exist yet
 //
 if (!$db->SelectDatabase($_SESSION['variables']['db_name'])) {
     if (!$db->CreateDatabase($_SESSION['variables']['db_name'])) {
         $errors[] = 'Error: could not create the database "' . $_SESSION['variables']['db_name'] . '"';
         $errors[] = $db->Error();
         $errors[] = $db->MyDyingMessage();
         $err++;
     } else {
         $log[] = "Database creation successful";
     }
     // and once created, try to select it, again:
     if (!$db->SelectDatabase($_SESSION['variables']['db_name'])) {
         $errors[] = 'Error: could not switch to the newly created database "' . $_SESSION['variables']['db_name'] . '"';
         $errors[] = $db->Error();
         $errors[] = $db->MyDyingMessage();
         $err++;
     } else {
コード例 #2
0
ファイル: 60_db_select_mysql.php プロジェクト: kimai/kimai 
    foreach ($useDatabases as $db_name) {
        if ($database == $db_name) {
            echo '<option selected="selected" value="' . htmlspecialchars($db_name) . '">' . htmlspecialchars($db_name) . '</option>';
        } else {
            echo '<option value="' . htmlspecialchars($db_name) . '">' . htmlspecialchars($db_name) . '</option>';
        }
    }
    echo '</select> <strong id="db_select_label"></strong><br/><br/>';
}
if ($createDatabaseAllowed) {
    if ($database === '' && $create_database !== '') {
        if (!preg_match('/^[a-zA-Z0-9_]+$/', $create_database)) {
            $databaseErrorMessage = $lang == 'de' ? 'Nur Buchstaben, Zahlen und Unterstriche.' : 'Only letters, numbers and underscores.';
        } elseif (strlen($create_database) > 64) {
            $databaseErrorMessage = $lang == 'de' ? 'Maximal 64 Zeichen.' : 'At most 64 characters.';
        } elseif ($con->SelectDatabase($create_database)) {
            $databaseErrorMessage = $lang == 'de' ? 'Datenbank existiert bereits.' : 'Database already exists.';
        }
    }
    if ($lang == 'de') {
        echo 'Neue Datenbank anlegen: (der angegebene DB-Nutzer muss die entsprechenden Rechte besitzen!)<br/><input id="db_create" type="text" value="' . $create_database . '"/>';
    } else {
        echo 'Create a blank database: (the db-user you entered must have appropriate rights!)<br/><input id="db_create" type="text" value="' . $create_database . '"/>';
    }
    if (isset($databaseErrorMessage)) {
        $errors = true;
        echo '<strong id="db_create_label" class="arrow">' . $databaseErrorMessage . '</strong><br/><br/>';
    } else {
        echo '<strong id="db_create_label"></strong><br/><br/>';
    }
} else {