示例#1
0
function requireParams($param1)
{
    $want = array_flip(func_get_args());
    $have = array_filter($_GET);
    $miss = array_diff_key($want, $have);
    if ($miss) {
        return missingParams(array_keys($miss));
    }
    $values = array();
    foreach ($want as $name => $foo) {
        $values[] = $have[$name];
    }
    return $values;
}
示例#2
0
<?php

$tables = $db->getTables();
if (!isset($tables[$_tbl])) {
    return missingParams(array('tbl'));
}
$objTbl = (object) $tables[$_tbl];
示例#3
0
    $result = mysqli_multi_query($con, $sql);
    if ($result) {
        sendPackage($con, $package, true, "", "ATTENDANCE ADDED");
    } else {
        queryFailed($con, 2.1);
    }
} else {
    if (isset($_POST["PostComment"], $_POST["LoginID"], $_POST["LoginPass"], $_POST["Data"], $_POST["To"]) && $_POST["PostComment"] != "" && $_POST["LoginID"] != "" && $_POST["LoginPass"] != "" && $_POST["Data"] != "" && $_POST["To"] != "") {
        #Connect to database
        $con = dbConnect();
        #Get clean variables from POST
        $EventID = mysqli_real_escape_string($con, $_POST["PostComment"]);
        $CommentText = mysqli_real_escape_string($con, $_POST["Data"]);
        $To = mysqli_real_escape_string($con, $_POST["To"]);
        $LoginID = mysqli_real_escape_string($con, $_POST["LoginID"]);
        $LoginPass = mysqli_real_escape_string($con, $_POST["LoginPass"]);
        #Verify User
        verifyUser($con, $LoginID, $LoginPass);
        $CommentDate = currentDate();
        $package = array();
        $sql = "UPDATE comments SET commenttext = '{$CommentText}', commentdate = '{$CommentDate}' WHERE author = '{$LoginID}' AND username = '******' AND eventid = '{$EventID}'";
        $result = mysqli_multi_query($con, $sql);
        if ($result) {
            sendPackage($con, $package, true, "", "COMMENT TEXT ADDED");
        } else {
            queryFailed($con, 2.1);
        }
    } else {
        missingParams();
    }
}
示例#4
0
<?php

// Select db meta record
$objDb = $g_objUser->getAliasByAlias($_db);
if (!$objDb) {
    return missingParams(array('db'));
}
// Actual db connection
$db = db_sqlite::open($objDb->path);
if (!$db->connected()) {
    exit("Can't connect: " . html($db->error));
}
// set encoding
$db->query('PRAGMA encoding="UTF-8"');
// screw ACID, go SPEED!
$db->query('PRAGMA synchronous=OFF');
$db->query('PRAGMA journal_mode=OFF');
$g_objUser->loadAlias($objDb->alias);