<!-- Collection of code snippets by Arne Vajhøj -->
<!-- posted to eksperten.dk, usenet and other places (2002-now) -->
<?php
    $con = new mysqli('localhost', 'root', '', 'Test');
    if(mysqli_connect_errno()) die(mysqli_connect_error());
    if($stmt = $con->prepare('SELECT f2 FROM t1 WHERE f1 BETWEEN ? AND ?')) {
        $stmt->bind_param('ii', $v1, $v2);
        $start = microtime(TRUE);
        for($i  = 0; $i < 10000; $i++) {
            $v1 = 2;
            $v2 = 3;
            $stmt->execute();
            $stmt->store_result();
            $stmt->bind_result($f2);
            while ($stmt->fetch()) {
                if($f2 != 'BB' && $f2 != 'CCC') die('Oops');
            }
        }
        $end = microtime(TRUE);
        print ($end - $start) . "\n";
        $stmt->close();
    } else {
        die($con->error);
    }
    $con->close();
?>