<style>
tr:nth-child(even){background-color:rgb(90,120,190);
color: yellow
}
table{
width:100%;
padding:40px;
color: rgb(90,20,40);
}
</style>
<?php
include 'koneksi.php';
$batas = 3;
$hal = @$_GET['hal'];
if(empty($hal)){
$posisi = 0;
$hal =1;
}else{
$posisi = ($hal-1)*$batas;
}
$sql = "SELECT*FROM produk LIMIT $posisi,$batas";
$query = mysqli_query($conn,$sql) or die('salah');
?>
<h3> Data Mobil PT Harits Teguh</h3>
<table border='1px' style='border-collapse:collapse;' cellpadding='3px'>
<tr>
<th >No</th> <th >Kode Produk</th>
<th >Nama Produk</th> <th >Kategori</th> <th >Harga</th>
<th >Stok</th> <th >Tgl Masuk</th> <th >Gambar</th>
</tr>
<?php
$no = $posisi+1;
while($row = mysqli_fetch_array($query)){
$no++;
?>
<tr>
<td> <?php echo $no;?></td>
<td> <?php echo $row[0];?></td>
<td> <?php echo $row[2];?></td>
<td> <?php echo $row[3];?></td>
<td> <?php echo $row[5];?></td>
<td> <?php echo $row[6];?></td>
<td> <?php echo $row[8];?></td>
<td> <?php echo '<img width="70px" height="50px" src=foto_produk/'.$row[9].'>' ;?></td>
</tr>
<?php } ?>
</table>
<div style="float:left; margin-top:10px">
<?php
$jmlData = mysqli_num_rows(mysqli_query($conn,"SELECT*FROM produk"));
echo "Jumlah Data barang :".$jmlData;
?>
</div>
<div style="margin-top:10px; float:right">
<?php
$jml_hal = ceil($jmlData/$batas);
for($i=1; $i<=$jml_hal; $i++){
if($i != $hal){
echo '<a href="?page=mobil&hal='.$i.'"><button style="border:1px solid #000; background-color:#fff; padding:4px 10px">'.$i.'</button></a>';
}else{
echo '<button style="border:1px solid #000; background-color:rgb(85,90,180);color:red; padding:4px 10px;">'.$i.'</button>';
}
}
?>
</div>
4/
5
Oleh
Ris Koding
