compsci-industry
/
TechEmpower.FrameworkBenchmarks
mirror of https://github.com/TechEmpower/FrameworkBenchmarks.git


			
							12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182
							<?php

global $pdo;
$pdo = new PDO("mysql:host=tfb-database;dbname=hello_world", "benchmarkdbuser", "benchmarkdbpass");


function db()
{
    global $pdo;

    $statement = $pdo->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 .= "<tr><td>$id</td><td>$message</td></tr>";
    }

    echo    "<!DOCTYPE html><html><head><title>Fortunes</title></head><body><table><tr><th>id</th><th>message</th></tr>",
            $html,
            "</table></body></html>";
}