Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- try {
- $servername = "127.0.0.1";
- $username = "dba";
- $password = "xEdEQXyNyCM8thEZ";
- // 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>";
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement