Using mysqlnd stats to track development errors

gistfile1.aw

<?php
class ComutoMysqli extends Mysqli
{
    public function __destruct()
    {
	$stats = $this->get_connection_stats();
	$this->close();
	if($diff = $stats["rows_fetched_from_server_normal"] - ($stats["rows_fetched_from_client_normal_unbuffered"] + $stats["rows_fetched_from_client_normal_buffered"])) {
            trigger_error("You didn't use *$diff* selected results, that's wasted!", E_USER_NOTICE);
        }
    }
}


$db = new ComutoMysqli(/* params */);
$result = mysqli_query($db,"SELECT user_id FROM users LIMIT 5");
mysqli_data_seek($result, 5);
$data = mysqli_fetch_row($result);

/* Notice: You didn't use *4* selected results, that's wasted! */