<?php
ini_set('display_errors', 1);
include 'sql-helper.php';
require_once "json-util.php";
if (!empty($_GET['prefix'])) {
$prefix = db_noquote($_GET['prefix']);
$query = "SELECT name FROM users WHERE name LIKE '" . $prefix . "%'";
$result = db_select($query);
if ($result === false) {
die('SQL Error: ' . db_error());
}
echo json_encode(array_slice($result, 0, 5));
}
<?php
ini_set('display_errors', 1);
include 'sql-helper.php';
$uid = $_COOKIE['userid'];
$counter = $_COOKIE['counter'];
$lorqid = unserialize($_COOKIE['lorqid']);
$qid = $lorqid[$counter - 1]['id'];
$nsystems = db_noquote($_POST['nsystems']);
$ntopres = db_noquote($_POST['mincount']);
for ($s = 0; $s < $nsystems; $s++) {
for ($i = 0; $i < $ntopres; $i++) {
$systyp = db_quote($_POST[chr($s + 65) . '-value']);
$oldrank = $i + 1;
$newrank = db_noquote($_POST['newrank-' . chr($s + 65) . '-' . strval($i)]);
$pid = db_noquote($_POST['pid-' . chr($s + 65) . '-' . strval($i)]);
$relevant = db_quote($_POST['rel-bar-' . chr($s + 65) . '-' . strval($i)]);
$query = "INSERT INTO evalresults (uid, systyp, qid, oldrank, newrank, pid, relevant) \n\t\t\t\tVALUES (" . $uid . ", " . $systyp . ", " . $qid . ", " . $oldrank . ", " . $newrank . ", " . $pid . ", " . $relevant . " )";
$result = db_query($query);
if ($result === false) {
die("SQL Error: " . db_error());
}
}
}
setcookie('counter', $counter + 1, time() + 3600);
header('Location: evaluation.php');