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; }
<?php $tables = $db->getTables(); if (!isset($tables[$_tbl])) { return missingParams(array('tbl')); } $objTbl = (object) $tables[$_tbl];
$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(); } }
<?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);