Untitled

<?php
    try {
        $servername = "127.0.0.1";
        $username = "dba";
        $password = "__DB__PASSWORD__";

        // Create connection
        $conn = new mysqli($servername, $username, $password);

        echo "<html><head></head><body>";

        // Check connection
        if ($conn->connect_error) {
            die("<div>Connection failed: " . $conn->connect_error . "</div>");
        }

        echo "<div>Connected successfully</div>";

        $starttime = microtime(true);
        if ($result = $conn->query("USE eatsy_dev")) {
            //$result->close();
        } else {
            die('<div>Invalid query: ' . mysql_error() . '</div>');
        }
        $endtime = microtime(true);
        $duration = $endtime - $starttime;
        echo "<div>Using eatsy_dev database ($duration microsecs )</div>";

        $starttime = microtime(true);
        if ($result = $conn->query("RESET QUERY CACHE")) {
            //$result->close();
        } else {
            die('<div>Invalid query: ' . mysql_error() . '</div>');
        }
        $endtime = microtime(true);
        $duration = $endtime - $starttime;
        echo "<div>Cache reset: ($duration microsecs )</div>";


        $testQuery = "SELECT id FROM driver WHERE id = 8";

        $starttime = microtime(true);
        if ($result = $conn->query($testQuery)) {
            $result->close();
        } else {
            die('<div>Invalid query $testQuery : ' . mysql_error() . '</div>');
        }
        $endtime = microtime(true);
        $duration = $endtime - $starttime;
        echo "<div>QUERY 1 - $testQuery: ($duration microsecs )</div>";

        $starttime = microtime(true);
        if ($result = $conn->query($testQuery)) {
            $result->close();
        } else {
            die('<div>Invalid query $testQuery : ' . mysql_error() . '</div>');
        }
        $endtime = microtime(true);
        $duration = $endtime - $starttime;
        echo "<div>QUERY 2 - $testQuery: ($duration microsecs )</div>";

        echo "</body></html>";
    } catch (Exception $e) {
        echo "<div>".$e->getMessage()."</div>";
    }
?>