mysqli 取得记录个数

if( $result = $mysqli->query($sql) ){

echo ' the number of the result is '.mysqli_num_rows($result)."<br>";

while ($row = $result->fetch_row()) {

printf ("%s/n", $row[0]);

}

}