Example #1
0
function resetDemo()
{
    checkConn();
    unset($_SESSION['lastTextTime']);
    unset($_SESSION['lastAction']);
    $sql = "TRUNCATE TABLE `akshhhlt_blupay`.`users`";
    $result = mysqli_query($GLOBALS['sqli_conn'], $sql);
    logToFile($sql, $result);
    echo "reset successful";
    return "reset successful";
}
function displayExecTime($sql)
{
    ini_set('max_execution_time', 0);
    $msc = microtime(true);
    $result = mysql_query($sql);
    $msc = microtime(true) - $msc;
    echo '<p>Your query was: ' . $sql . '<br/>';
    echo 'Execution time: ' . $msc . '</p>';
}
//set variables here
require_once 'globals.php';
$db = mysql_connect(DBHOST, DBUSER, DBPASS);
$curdb = mysql_select_db(DBNAME, $db);
$sql = "select * from hpq_aquaequip";
$result = mysql_query($sql);
if (!checkConn($db)) {
    echo 'Lost connection...please reconnect.';
    exit;
} else {
    //echo 'Connection established!';
    mysql_free_result($result);
    if (isset($_POST['query'])) {
        switch ($_POST['query']) {
            case "0":
                echo 'Please select a query from the dropdown box in the previous page.';
                exit;
                break;
            case "1":
                displayReport1("SELECT educal, count(id) FROM hpq_mem \n\t\t\t\t\t\tWHERE memno=1 AND jobind = 2 AND entrepind = 2 GROUP BY educal ORDER BY educal");
                break;
            case "2":