MySQLiでFOUND_ROWS(全件数取得)

MySQLiでFOUND_ROWS(全件数取得)。

$sql = '
SELECT SQL_CALC_FOUND_ROWS *
FROM test_table
LIMIT ' . $offset . ', ' . $limit . '
';
$row = $mysqli->query($sql);
$num_query = $mysqli->query('SELECT FOUND_ROWS()');
list($max_num) = $num_query->fetch_row(); //ここに総件数
while ($rs = $row->fetch_array(MYSQLI_ASSOC)) {
//先に打ったSQL文の処理
}