PHP访问Mysqli的实例

<?php
$mysqli = new mysqli('localhost', 'root', '', 'world');

if ($mysqli->connect_error) {
    die('Connect Error (' . $mysqli->connect_errno . ') '
            . $mysqli->connect_error);
}

echo 'Success... ' . $mysqli->host_info . "\n";
$sql = "SELECT * from city WHERE ID = 1";
if ($result = $mysqli->query($sql)) {
    printf("Select returned %d rows.\n", $result->num_rows);
    print_r($mysqli->stat());  
    $result->close();
}

$mysqli->close();
?>

返回结果：

Success... localhost via TCP/IP
Select returned 1 rows.
Uptime: 5555  Threads: 1  Questions: 27  Slow queries: 0  Opens: 40  Flush tables: 1  Open tables: 1  Queries per second avg: 0.004