PHP restoreTables Examples

Example #1

File: database.php Project: krievley/schedule

function processFunctions()
{
    global $ax, $repair, $compact, $backup, $restore, $events, $delevt, $fromD, $tillD;
    echo "<table><tr><td>\n";
    if ($repair) {
        checkDb();
    }
    if ($compact) {
        compactTables();
    }
    if ($backup) {
        backupTables();
    }
    if ($restore) {
        restoreTables();
    }
    if ($events) {
        processEvents();
    }
    echo "</td></tr></table>\n";
    echo "<form action='index.php?lc' method='post'>\n\t\t<input type='hidden' name='repair' id='repair' value='{$repair}'>\n\t\t<input type='hidden' name='compact' id='compact' value='{$compact}'>\n\t\t<input type='hidden' name='backup' id='backup' value='{$backup}'>\n\t\t<input type='hidden' name='restore' id='restore' value='{$restore}'>\n\t\t<input type='hidden' name='events' id='events' value='{$events}'>\n\t\t<input type='hidden' name='delevt' id='delevt' value='{$delevt}'>\n\t\t<input type='hidden' name='fromD' id='fromD' value='" . IDtoDD($fromD) . "'>\n\t\t<input type='hidden' name='tillD' id='tillD' value='" . IDtoDD($tillD) . "'>\n\t\t<input class='noPrint' type='submit' name='back' value=\"{$ax['back']}\">\n\t</form>\n";
}

Example #2

File: database.php Project: sanluca/py-acqua-hw

function processFunctions()
{
    global $ax, $compact, $backup, $restore, $events, $delEvt, $fromD, $tillD;
    $fName = false;
    if ($compact) {
        compactDb();
    }
    if ($backup) {
        $fName = backupTables();
    }
    if ($restore) {
        restoreTables();
    }
    if ($events) {
        delEvents($delEvt, $fromD, $tillD);
    }
    echo "<form action='index.php?lc' method='post'>\n\t\t<input type='hidden' name='token' value='{$_SESSION['token']}'>\n\t\t<input type='hidden' name='compact' id='compact' value='{$compact}'>\n\t\t<input type='hidden' name='backup' id='backup' value='{$backup}'>\n\t\t<input type='hidden' name='restore' id='restore' value='{$restore}'>\n\t\t<input type='hidden' name='events' id='events' value='{$events}'>\n\t\t<input type='hidden' name='delEvt' id='delEvt' value='{$delEvt}'>\n\t\t<input type='hidden' name='fromD' id='fromD' value='" . IDtoDD($fromD) . "'>\n\t\t<input type='hidden' name='tillD' id='tillD' value='" . IDtoDD($tillD) . "'>\n\t\t<input class='noPrint' type='submit' name='back' value=\"{$ax['back']}\">\n";
    if ($fName) {
        echo "&nbsp;&nbsp;&nbsp;&nbsp;<button class='noPrint' type='button' onclick=\"location.href='dloader.php?ftd={$fName}&amp;rName={$fName}'\">{$ax['iex_download_file']}</button>\n";
    }
    echo "</form>\n";
}

Example #3

File: db_restore.php Project: mavewei/Mandra

        /**
        		 Call function to restore all informations from tables.
        		 **/
        restoreTables($dbHost, $dbUsername, $dbPasswd, $dbName, 'db-backup-company.sql');
        restoreTables($dbHost, $dbUsername, $dbPasswd, $dbName, 'db-backup-county.sql');
        restoreTables($dbHost, $dbUsername, $dbPasswd, $dbName, 'db-backup-departments.sql');
        restoreTables($dbHost, $dbUsername, $dbPasswd, $dbName, 'db-backup-employees.sql');
        restoreTables($dbHost, $dbUsername, $dbPasswd, $dbName, 'db-backup-initFlag.sql');
        restoreTables($dbHost, $dbUsername, $dbPasswd, $dbName, 'db-backup-loginDetails.sql');
        restoreTables($dbHost, $dbUsername, $dbPasswd, $dbName, 'db-backup-nationality.sql');
        restoreTables($dbHost, $dbUsername, $dbPasswd, $dbName, 'db-backup-partsMasterFile.sql');
        restoreTables($dbHost, $dbUsername, $dbPasswd, $dbName, 'db-backup-position.sql');
        restoreTables($dbHost, $dbUsername, $dbPasswd, $dbName, 'db-backup-taxCode.sql');
        restoreTables($dbHost, $dbUsername, $dbPasswd, $dbName, 'db-backup-tempSession.sql');
        restoreTables($dbHost, $dbUsername, $dbPasswd, $dbName, 'db-backup-unit.sql');
        restoreTables($dbHost, $dbUsername, $dbPasswd, $dbName, 'db-backup-userAccounts.sql');
    } else {
        /**
        		 Redirect to dashboard if not Superuser.
        		 **/
        $_SESSION['STATUS'] = 10;
        header('Location: status.php');
    }
} else {
    header('Location: status.php');
}
function restoreTables($host, $user, $pass, $name, $filename)
{
    $link = mysql_connect($host, $user, $pass);
    mysql_select_db($name, $link);
    /**