Miscellany

<title>Data Hotel</title>
<font size="4"><u><B><center>DAFTAR HOTEL DI KOTA PADANG</center></B></u></font>
<?php
$host = "localhost"; //nama_url
$user = "palaaorg_dbpd"; //username_database
$password = "padangjakarta"; //password_database
$db = "palaaorg_db_pd"; //nama_database
$tabel = "htl"; //nama_tabel

$konek = mysql_connect($host, $user, $password) or die;
$pilihdb = mysql_select_db($db) or die;
$query = "SELECT * FROM $tabel";
$run = mysql_query($query);

//Penanda halaman aktif
$halaman = $_GET['halaman'];
if($halaman == 0)
 $halaman = 1;

$jumlahDataPerHalaman = 5;
$jumlahData = mysql_num_rows($run);
$jumlahHalaman = ceil($jumlahData / $jumlahDataPerHalaman);
$dataMulai = ($halaman * $jumlahDataPerHalaman)-$jumlahDataPerHalaman;

$query = "SELECT * FROM $tabel LIMIT $dataMulai, $jumlahDataPerHalaman";
$run = mysql_query($query);
while ($kolom = mysql_fetch_array($run)){
 echo "<br>";
 echo "<table>
 <tbody>
 <tr>
 <td>Nama Hotel</td>
 <td>:</td>
 <td>$kolom[nama_hotel]</td>
 </tr>
 <tr>
 <td>Tipe Hotel</td>
 <td>:</td>
 <td>$kolom[tipe_hotel]</td>
 </tr>
 <tr>
 <td>Alamat</td>
 <td>:</td>
 <td>$kolom[alamat_hotel]</td>
 </tr>
 <tr>
 <td>Telp. Hotel</td>
 <td>:</td>
 <td>0$kolom[telp_hotel]</td>
 </tr>
 <tr>
 <td>Website</td>
 <td>:</td>
 <td>$kolom[website]</td>
 </tr>
 </tbody>
 </table>
 <table><tr><td>Fasilitas:
 <ul>
 <li>$kolom[fas1]</li>
 <li>$kolom[fas2]</li>
 <li>$kolom[fas3]</li>
 <li>$kolom[fas4]</li>
 <li>$kolom[fas5]</li>
 <li>$kolom[fas6]</li>
 <li>$kolom[fas7]</li>
 <li>$kolom[fas8]</li>
 </ul></td></tr>
 <tr><td><a href=\"edithotel.php?id_hotel=$kolom[id_hotel]\"><img src='images/true.png'> Edit</td>
 <td><a href=\"hapushotel.php?id_hotel=$kolom[id_hotel]\"><img src='images/false.png'> Hapus</td></tr>
 </table><br>
 <hr width='540' color=#FF9900>
 <br/>";
}

if($halaman>=2){
 
 echo "<br>";
 echo "<a href=\"?halaman=".($halaman - 1)."\">Sebelumnya</a>";
}
echo " | ";

if($halaman < $jumlahHalaman){
 echo "<a href=\"?halaman=".($halaman + 1)."\">Berikutnya</a>";
}
?>