FOTO GALERI

Jenis Foto :
"; echo "- Foto Tempo Dulu   |  "; echo "- Foto Kegiatan Siswa   |   "; echo "- Foto Kegiatan-Sarana Sekolah

"; echo "- Foto Kreasi Siswa

"; $query = "select * from photo_gallery order by idfoto desc"; $hasil = mysql_query($query); $limit="9"; $total = mysql_num_rows($hasil); echo "Tampilkan Semua Foto ( ada $total foto )

"; $jmlhalaman = ceil( $total / $limit); // ambil data sejumlah besarnya pesan per halaman $page = $_GET[page]; if(!isset($page)) { $page = 1; } $offset = ($page - 1) * $limit; $query = "select * from photo_gallery order by idfoto desc LIMIT $offset,$limit"; $hasil = mysql_query($query); if ($page == 1) { $start = 0; $end = $limit; } elseif ($page <= $jmlhalaman && $page > 1) { $start = ($page - 1) * $limit; $end = $start + $limit; } else { $page = 1; } echo ""; for ($i=1;$i<=$limit;$i++){ //while($data = mysql_fetch_array($hasil)) //{ if ($data = mysql_fetch_row($hasil)) { $idfoto=$data[0]; $nama_foto=$data[1]; $judul_foto=$data[2]; $jenis_foto=$data[3]; //echo ""; } } } echo "

"; echo "	"; //} if (($i % 3)==0){ echo "

"; if ($page >= 1 && $page <= $jmlhalaman && $total > $limit) { if ($page != 1) { echo ("« Sebelumnya  "); } for($i=1;$i<=$jmlhalaman;$i++) { if ($_GET[page] == $i) { echo "$i | "; } else { echo "$i | "; } } if ($page <= ($jmlhalaman - 1)) { echo (" Selanjutnya »"); } } ?>