prepare("SELECT id,randomNumber FROM World WHERE id=?");
$statement->execute([mt_rand(1, 10000)]);
echo json_encode($statement->fetch(PDO::FETCH_ASSOC), JSON_NUMERIC_CHECK);
}
function query()
{
global $pdo;
$statement = $pdo->prepare("SELECT id,randomNumber FROM World WHERE id=?");
$query_count = 1;
if ($_GET["queries"] > 1) {
$query_count = min($_GET["queries"], 500);
}
while ($query_count--) {
$statement->execute([mt_rand(1, 10000)]);
$arr[] = $statement->fetch(PDO::FETCH_ASSOC);
}
echo json_encode($arr, JSON_NUMERIC_CHECK);
}
function update()
{
global $pdo;
$query_count = 1;
if ($_GET["queries"] > 1) {
$query_count = min($_GET["queries"], 500);
}
$statement = $pdo->prepare("SELECT randomNumber FROM World WHERE id=?");
$updateStatement = $pdo->prepare("UPDATE World SET randomNumber=? WHERE id=?");
while ($query_count--) {
$id = mt_rand(1, 10000);
$statement->execute([$id]);
$world = ["id" => $id, "randomNumber" => $statement->fetchColumn()];
$updateStatement->execute(
[$world["randomNumber"] = mt_rand(1, 10000), $id]
);
$arr[] = $world;
}
echo json_encode($arr, JSON_NUMERIC_CHECK);
}
function fortune()
{
global $pdo;
$fortune = $pdo->prepare("SELECT id,message FROM Fortune");
$fortune->execute();
$arr = $fortune->fetchAll(PDO::FETCH_KEY_PAIR);
$arr[0] = "Additional fortune added at request time.";
asort($arr);
$html = "";
foreach ($arr as $id => $message) {
$message = htmlspecialchars($message, ENT_QUOTES, "UTF-8");
$html .= "| {$id} | {$message} |
";
}
echo "Fortunes";
}