<!-- Collection of code snippets by Arne Vajhøj -->
<!-- posted to eksperten.dk, usenet and other places (2002-now) -->
<?php
function con_dump($con) {
    $stats = $con->get_connection_stats();
    echo 'Host: ' . $con->host_info . "\r\n";
    echo 'Server version: ' . $con->server_info . "\r\n";
    echo 'Server status: ' . $con->stat() . "\r\n";
    echo 'Client version: ' . $con->client_info . "\r\n";
    echo 'Character set: ' . $con->character_set_name() . "\r\n";
    echo 'Affected rows for last SQL: ' . $con->affected_rows . "\r\n";
    echo 'Returned fields for last SQL: ' . $con->field_count . "\r\n";
    echo 'Last auto increment id: ' . $con->insert_id . "\r\n";
    echo 'Bytes sent: ' . $stats['bytes_sent'] . "\r\n";
    echo 'Bytes received: ' . $stats['bytes_received'] . "\r\n";
}

$con = new mysqli('localhost', 'root', '', 'test');
if(mysqli_connect_errno()) {
    die(mysqli_connect_error());
}
if($rs = $con->query('SELECT * FROM t1')) {
    while ($row = $rs->fetch_array()) {
        echo $row['f1'] . ' ' . $row['f2'] . "\r\n";
    }
} else {
    die($con->error);
}
$rs->free();
con_dump($con);
$con->close();
?>