select - Selecting all record in mysqli -

i want select record in mysqli, using following syntax

$stmt->get_result();

but getting single data, want select data , apply while loop on data.

thanks in advance

wrap in while loop:

$stmt->get_result(); while ($row = $result->fetch_array(mysqli_num)) {   $rs[]=$row;   //or process here. } 

or use http://php.net/manual/en/mysqli-result.fetch-all.php