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


			
							1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980
							<?php

//$db = new mysqli('p:tfb-database', 'benchmarkdbuser', 'benchmarkdbpass', 'hello_world');


function db()
{
    global $db;

    $statement = $db->prepare('SELECT id,randomNumber FROM World WHERE id=?');
    $statement->bind_param('i', $id);

    if ( ! isset($_GET['queries'])) {
        $id = mt_rand(1, 10000);
        $statement->execute();
        return json_encode($statement->get_result()->fetch_assoc(), JSON_NUMERIC_CHECK);
    }

    $query_count = 1;
    if ($_GET['queries'] > 1) {
        $query_count = min($_GET['queries'], 500);
    }

    while ($query_count--) {
        $id = mt_rand(1, 10000);
        $statement->execute();
        $arr[] = $statement->get_result()->fetch_assoc();
    }

    return json_encode($arr, JSON_NUMERIC_CHECK);
}

function fortune()
{
    global $db;

    $arr    = $db->query('SELECT id,message FROM Fortune')->fetch_all(MYSQLI_NUM);
    $arr[] = [0 => 0, 1 => 'Additional fortune added at request time.'];
    usort($arr, function($a, $b){return strcmp($a[1], $b[1]);});

    $html = '';
    foreach ($arr as $item) {
        $message = htmlspecialchars($item[1], ENT_QUOTES, 'UTF-8');
        $html .= "<tr><td>$item[0]</td><td>$message</td></tr>";
    }

    return '<!DOCTYPE html><html><head><title>Fortunes</title></head><body><table><tr><th>id</th><th>message</th></tr>'
            .$html.
            '</table></body></html>';
}

function update()
{
    global $db;

    $query_count = 1;
    if ($_GET['queries'] > 1) {
        $query_count = min($_GET['queries'], 500);
    }

    $statement       = $db->prepare('SELECT randomNumber FROM World WHERE id=?');
    $updateStatement = $db->prepare('UPDATE World SET randomNumber=? WHERE id=?');

    $statement->bind_param('i', $id);
    $updateStatement->bind_param('ii',$update, $id);

    while ($query_count--) {
        $id = mt_rand(1, 10000);
        $statement->execute();

        $world = ['id' => $id, 'randomNumber' => $statement->get_result()->fetch_row()];
        
        $update = mt_rand(1, 10000);
        $updateStatement->execute();

        $arr[] = ['id' => $id, 'randomNumber' => $update];
    }

    return json_encode($arr, JSON_NUMERIC_CHECK);
}