0
<link href="gradient.css" rel="stylesheet" type="text/css">
<?php
//mysql_connect("localhost","root","");
//mysql_select_db("pintar");
include "includes/koneksi.php";

//echo "<table align=center><tr><th>No</th><th>Nama</th><th>Alamat</th></tr>";


// Langkah 1: Tentukan batas,cek halaman & posisi data
$batas   = 3;
$halaman = $_GET['halaman'];
if(empty($halaman)){
	$posisi  = 0;
	$halaman = 1;
}
else{
	$posisi = ($halaman-1) * $batas;
}

//Langkah 2: Sesuaikan perintah SQL
echo "<table>";

  $tampil = "select * from produk order by id_produk desc LIMIT $posisi,$batas";
  $hasil  = mysql_query($tampil);
  $sql=mysql_query("select * from produk order by id_produk desc LIMIT $posisi,$batas");
  $no = $posisi+1;
  
  while ($r=mysql_fetch_array($sql)){
    $harga     = number_format($r['harga'],0,",",".");
    $deskripsi = nl2br($r['deskripsi']); // membuat paragraf 
    $isi       = substr($deskripsi,0,220); // ambil sebanyak 220 karakter
    $isi       = substr($deskripsi,0,strrpos($isi," ")); // potong per spasi kalimat

	$no++;
    echo "<tr><td><img src='foto_produk/small_$r[gambar]' align=left hspace=20 border=0></td><td><b>$r[nama_produk]</b> <br /><br />
          $isi ... <a href=#>Selengkapnya</a></td></tr>
          <tr><td>Rp. <b>$harga</b> </td><td><a href=aksi.php?module=keranjang&act=tambah&id=$r[id_produk]><img src='images/beli.jpg' border=0></a></td></tr>
          <tr><td colspan=2><hr /></td></tr>";
  }
echo "</table>";

/*
$tampil = "SELECT * FROM anggota LIMIT $posisi,$batas";
$hasil  = mysql_query($tampil);

$no = $posisi+1;
while($r=mysql_fetch_array($hasil)){
  echo "<tr><td>$no</td><td>$r[nama]</td><td>$r[alamat]</td></tr>";
  $no++;
}
echo "</table><br>";
*/

//Langkah 3: Hitung total data dan halaman 
$tampil2 = mysql_query("SELECT * FROM produk ORDER BY id_produk desc");
$jmldata = mysql_num_rows($tampil2);
$jmlhal  = ceil($jmldata/$batas);


echo "<div class=paging>";
// Link ke halaman sebelumnya (previous)
if($halaman > 1){
	$prev=$halaman-1;
	echo "<span class=prevnext><a href=$_SERVER[PHP_SELF]?halaman=$prev>« Prev</a></span> ";
}
else{ 
	echo "<span class=disabled>« Prev</span> ";
}

// Tampilkan link halaman 1,2,3 ...
for($i=1;$i<=$jmlhal;$i++)
if ($i != $halaman){
	echo " <a href=$_SERVER[PHP_SELF]?halaman=$i>$i</a> ";
}
else{
	echo " <span class=current>$i</span> ";
}

// Link kehalaman berikutnya (Next)
if($halaman < $jmlhal){
	$next=$halaman+1;
	echo "<span class=prevnext><a href=$_SERVER[PHP_SELF]?halaman=$next>Next »</a></span>";
}
else{ 
	echo "<span class=disabled>Next »</span>";
}
echo "</div>";
echo "<p align=center>Total anggota : <b>$jmldata</b> orang</p>";
?>

Notice: Undefined index: halaman in C:\xampp\htdocs\php_template2\tampil_produk.php on line 12

line 12: $halaman = $_GET;

How to define halaman ? (translate: page) this coding is for paging.

3
Contributors
2
Replies
4
Views
5 Years
Discussion Span
Last Post by Purnomo_1
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.