Online PHP editor | refs for HZeev

<h3>Data Barang Beli</h3> </br> <a href="?p=BeliInput" ><?php BtnHijau("Tambah Barang");?></a> </table> <table> <tr align="center"> <td width="20" height="33"><strong>No</strong></td> <td width="67"><strong>No Nota</strong></td> <td width="55"><strong>Tanggal Beli</strong></td> <td width="30"><strong>Supplier</strong></td> <td width="48"><strong>Kode Barang</strong></td> <td width="57"><strong>Nama Barang</strong></td> <td width="57"><strong>Jumlah</strong></td> <td width="57"><strong>Harga</strong></td> <td width="56"><strong>Aksi</strong></td> </tr> <?php //mulai paging $sql = mysql_query("SELECT * FROM beli"); $nr = mysql_num_rows($sql); if (isset($_GET['pn'])) { $pn = preg_replace('#[^0-9]#i', '', $_GET['pn']); } else { $pn = 1; } $show=15; $halaman=new paging(); $pages=$halaman->itemspage("$_SERVER[PHP_SELF]?p=Beli",$show,$nr,$pn); $limit="LIMIT $pages[j], $show"; $sql2 = mysql_query("SELECT nota,tgl_b,nama_s,beli.kd_brg as kode,master.nama_brg as nama,jml_b,hrg_b from beli,supplier,master WHERE master.kd_brg=beli.kd_brg and supplier.kd_supp=beli.kd_supp ORDER BY tgl_b DESC $limit"); //batas paging atas while($r =mysql_fetch_array($sql2)) { $no++; ?> <tr> <td align="center"><?php echo $no; ?></td> <td><?php echo $r[nota]; ?></td> <td><?php echo $r[tgl_b]; ?></td> <td><?php echo $r[nama_s]; ?></td> <td><?php echo $r[kode]; ?></td> <td><?php echo $r[nama]; ?></td> <td><?php echo $r[jml_b]; ?></td> <td><?php echo $r[hrg_b]; ?></td> <td width="56" align="center"><a href="?p=BeliEdit&id=<?php echo $r[kd_supp] ?>"><img src='images/edit.png' title='Edit'></a> | <a href="?p=BeliEdit&s=del&id=<?php echo $r[kd_supp]; ?>" onclick="return ConfirmDelete()"><img src="images/delete.png" width="16" height="16" /></a></td> </tr> <?php } ?> </table><br /> <?php halamanbawah("$nr","$pages[disp]"); ?>