coba saja

<?php
$batas=5;
$mysqli = new mysqli("localhost", "root", "", "movie-view");
 $res = $mysqli->query("SELECT count(*) c FROM movie");
$jmldata = $res['c']; //cmiiw
$jmlhalaman = ceil($jmldata/$batas);
$halaman = isset($_GET['halaman'])?$_GET['halaman']:1;
echo "<br> Halaman : ";

for($i=1;$i<=$jmlhalaman;$i++)
if ($i != $halaman){
echo " <a href=\"pages/mymovie.php?halaman={$i}\">$i</a> | ";
}
else{
echo " <b>$i</b> | ";
}
echo "<p>Total anggota : <b>$jmldata</b> orang</p>";
///========================

//if(empty($halaman)){
//$posisi = 0;
//$halaman = 1;
//}
//else{
$posisi = ($halaman-1) * $batas;
if($posisi<0)$posisi=0;
//}
$res = $mysqli->query("SELECT * FROM movie LIMIT $posisi, $batas");
//check apakah query benar