PDO::FETCH_ASSOC,
PDO::ATTR_EMULATE_PREPARES => false]
);
$statement = $pdo->prepare('SELECT id,randomNumber FROM World WHERE id=?');
$fortune = $pdo->prepare('SELECT id,message FROM Fortune');
function db()
{
global $statement;
ngx_header_set('Content-Type', 'application/json');
$statement->execute([mt_rand(1, 10000)]);
echo json_encode($statement->fetch(), JSON_NUMERIC_CHECK);
}
function query()
{
global $statement;
ngx_header_set('Content-Type', 'application/json');
$query_count = 1;
$params = ngx::query_args()['queries'];
if ($params > 1) {
$query_count = min($params, 500);
}
while ($query_count--) {
$statement->execute([mt_rand(1, 10000)]);
$arr[] = $statement->fetch();
}
echo json_encode($arr, JSON_NUMERIC_CHECK);
}
function update()
{
global $pdo;
ngx_header_set('Content-Type', 'application/json');
$query_count = 1;
$params = ngx::query_args()['queries'];
if ($params > 1) {
$query_count = min($params, 500);
}
$statement = $pdo->prepare('SELECT randomNumber FROM World WHERE id=?');
$update = '';
while ($query_count--) {
$id = mt_rand(1, 10000);
$statement->execute([$id]);
$world = ['id' => $id, 'randomNumber' => $statement->fetchColumn()];
$world['randomNumber'] = mt_rand(1, 10000);
$update .= "UPDATE World SET randomNumber={$world['randomNumber']} WHERE id=$id;";
$arr[] = $world;
}
$pdo->exec($update);
echo json_encode($arr, JSON_NUMERIC_CHECK);
}
function fortune()
{
global $fortune;
ngx_header_set('Content-Type', 'text/html;charset=UTF-8');
$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';
}