Cacher is the code snippet organizer for pro developers

$query = mysqli_query("SELECT ...");
$rows = array();
while($r = mysqli_fetch_assoc($query)) {
    $rows[] = $r;
}
print json_encode($rows);