PHP checkTableStatus Examples

Example #1

File: install.php Project: BackupTheBerlios/infobasar

}
if (!isset($db_prefix)) {
    $db_prefix = $session->fDbTablePrefix;
}
$db_status = checkDB($session);
if ($db_status == NO_DB && isset($db_createdb)) {
    $query = "create database {$db_name};";
    $result = mysql_query($query, $session->fDbInfo);
    if (!$result) {
        echo "<p>+++ DB {$db_name} nicht erzeugt: " . htmlentities(mysql_error()) . "</p>\n";
    } else {
        echo "<p>DB {$db_name} wurde erzeugt</p>\n";
        $db_status = checkDB($session);
    }
}
if ($table_status = checkTableStatus($db_status, $tables_exist)) {
    echo "<p>{$table_status}</p>\n";
}
if (isset($db_overwrite)) {
    echo "db_overwrite: {$db_overwrite}<br/>\n";
}
if (isset($db_populate) && (!isset($db_overwrite) || $db_overwrite == "J")) {
    populate($session, $file);
} else {
    echo "<form name=\"form\" action=\"install.php\" method=\"post\">\n";
    echo '<table><tr><td>MySQL-Server</td><td>';
    guiTextField('db_server', $db_server, 16, 0);
    echo "</td></tr>\n<tr><td>Datenbank</td><td>";
    guiTextField('db_name', $db_name, 16, 0);
    echo "</td></tr>\n<tr><td>Benutzer</td><td>";
    guiTextField('db_user', $db_user, 16, 0);

Example #2

File: install.php Project: BackupTheBerlios/infobasar

function instDB(&$session, $message = null)
{
    $session->trace(TC_Init, 'instDB');
    guiHeader($session, 'Schritt 2');
    guiHeadline($session, 2, 'Bestückung der Datenbank');
    if (!empty($message)) {
        guiParagraph($session, $message, false);
    }
    checkDB($session, $message);
    $message = null;
    $path = $session->fFileSystemBase . PATH_DELIM;
    instShowDir($session, $session->fFileSystemBase . PATH_DELIM . '../db' . PATH_DELIM, "DB-Inhalte (Verzeichnis db)", '/[\\.](sql|wiki)$/', 'Installieren', 'db_install', 'db_file');
    guiStartForm($session, 'Form');
    $table_status = checkTableStatus($session, $tables_exists);
    guiParagraph($session, $table_status, false);
    guiParagraph($session, 'Warnung: Wenn die Datenbank initalisiert wird, werden ' . '<b>alle</b> vorhandenen Daten in den Tabellen, deren Name mit "' . $session->fDbTablePrefix . '" beginnen, <b>gelöscht</b>!', false);
    echo '<p>';
    guiButton('inst_populate', 'Datenbank initialisieren');
    echo '</p>';
    instDocu($session, '<li>Datenbank initialisieren</li>', '<li>std_pages.wiki installieren</li><li>update_x-y.sql installieren</li>');
    instStandardEnd($session);
}

Example #3

File: install.php Project: BackupTheBerlios/infobasar

function instDB(&$session, $message = null)
{
    global $db_server, $db_user, $db_passw, $db_name, $db_prefix;
    $session->trace(TC_Init, 'instDB');
    guiHeader($session, 'Schritt 2');
    guiHeadline($session, 2, 'Bestückung der Datenbank');
    if (!empty($message)) {
        guiParagraph($session, $message, false);
    }
    checkDB($session, $message);
    $message = '';
    guiStartForm($session, 'Form');
    guiHiddenField('inst_step', 2);
    $table_status = checkTableStatus($session, $tables_exist);
    guiParagraph($session, $table_status, false);
    guiParagraph($session, 'Warnung: Wenn die Datenbank initalisiert wird, werden 	<b>alle</b> vorhandenen Daten <b>gelöscht</b>!', false);
    guiButton('inst_populate', 'Datenbank initialisieren');
    guiLine($session, 2);
    guiButton('inst_last', 'zurück');
    echo ' | ';
    guiButton('inst_next', 'weiter');
    guiFinishForm($session);
    guiFinishBody($session);
}