- Beranda
- Programmer Forum
bantu tampilan pesanan e-commerce (PHP)
...
TS
baskoro.bayu
bantu tampilan pesanan e-commerce (PHP)
sesuai judul gan
di database jumlah pesanan ada 23 gan
tapi yg tampil di program saya cuma ada 10 gan
kenapa yah gan?
ini coding pesanan nya gan
mohon bantuannya
di database jumlah pesanan ada 23 gan
Spoiler for 23:
tapi yg tampil di program saya cuma ada 10 gan
Spoiler for 10:
kenapa yah gan?
ini coding pesanan nya gan
mohon bantuannya
Spoiler for CODING:
PHP Code:
<? session_start();
include "./include/conn.php";
if (session_is_registered('id'<img src="https://s.kaskus.id/images/smilies/sumbangan/13.gif" data-sceditor-emoticon=";)" border="0" alt="emoticon-Wink" title="Wink"/>)
{
?>
<html>
<head>
<title>Edit Artikel</title>
<table width="49%" border="0" cellpadding="0" cellspacing="0" bordercolor="#99CC99" align="center">
<tr>
<td width="2%" align="right"><img src="./img/kiri.jpg"></td>
<td width="96%" bgcolor="#73aa73" ><div align="center"><strong><font face="verdana" size="2" color="#FFFFFF">Pemesanan</font></strong></div></td>
<td width="2%"><img src="./img/kanan.jpg"></td>
</tr>
<tr>
<td background="./img/b-kiri.jpg"></td>
<td>
<table width="610" align="center">
<tr><td width="518">
<div align="center">
<p><a href="home.php?page=13" style="text-decoration:none" title="Masukan Produk Baru"></a></p>
<font color='#0066FF' face='verdana' size='2'><div align="center"><blink><? echo $_GET['status'] ?></blink></div>
</font></p>
</div>
<div align="center"><font face="Verdana, Arial, Helvetica, sans-serif" size="2">
<?
//untuk paging
$query=mysql_db_query($db,"select * from laporan ",$koneksi); //input
$get_pages=mysql_num_rows($query);
if ($get_pages>$entries) //proses
{
echo "Halaman : ";
$pages=1;
while($pages<=ceil($get_pages/$entries))
{
if ($pages!=1)
{
echo " | ";
}
?>
<a href="home.php?page=7&id=<? echo ($pages-1); ?> " style="text-decoration:none"><font color="#0066FF"><? echo $pages; ?></font></a>
<?
$pages++;
}
}else{
$pages=0;
}
?>
</font>
</p>
<?
//akhir paging
//proses halaman
$page=(int)$_GET['id'];
$offset=$page*$entries;
$result=mysql_db_query($db,"SELECT a.idlap, a.iduser, a.tgl, a.status, a.kode, b.pengiriman FROM laporan a, pemesanan b WHERE a.idlap = b.idlap ORDER BY a.tgl asc limit $offset,$entries",$koneksi); //output
$jumlah=mysql_num_rows($query);
if ($jumlah){
?>
</div><font face="verdana" size="2" color="#666666"><? echo "Tanggal Sekarang : ".$tanggal;?></font><br><br>
<table align="center" width="690" border="0">
<tr>
<td width="5%" bgcolor="#CCCCCC"><div align="center"><b>
<font color="#666666" size="2" face="Arial, Helvetica, sans-serif">NO</font></b></div>
</td>
<td width="21%" bgcolor="#CCCCCC"><div align="center"><b>
<font color="#666666" size="2" face="Arial, Helvetica, sans-serif">KODE PESANAN</font></b></div>
</td>
<td width="19%" bgcolor="#CCCCCC"><div align="center"><b>
<font color="#666666" size="2" face="Arial, Helvetica, sans-serif">PELANGGAN</font></b></div>
</td>
<td width="18%" bgcolor="#CCCCCC"><div align="center"><b><font color="#666666" size="2" face="Arial, Helvetica, sans-serif">TANGGAL</font></b>
</div> </td>
<td width="13%" bgcolor="#CCCCCC"><div align="center"><b><font color="#666666" size="2" face="Arial, Helvetica, sans-serif">STATUS</font></b></div>
</td>
<td width="13%" bgcolor="#CCCCCC"><div align="center"><b><font color="#666666" size="2" face="Arial, Helvetica, sans-serif">PENGIRIMAN</font></b></div>
</td>
<td width="24%" bgcolor="#CCCCCC"><div align="center"><b><font color="#666666" size="2" face="Arial, Helvetica, sans-serif">AKSI</font></b></div>
</td>
</tr>
<?
while ($row=mysql_fetch_array($result))
{
$idlap=$row['idlap'];
$iduser=$row['iduser'];
$tgl=$row['tgl'];
$status=$row['status'];
$pengiriman=$row['pengiriman'];
$kode=$row['kode'];
//translate id
$transbrg=mysql_db_query($db,"select * from daftar where id='$iduser'",$koneksi);
while ($row=mysql_fetch_array($transbrg)){
$nama=$row['nama'];
}
?>
<tr>
<td align="center">
<font face="verdana" size="1" color="#999999"><? echo $c=$c+1;?></font>
</td>
<td align="center">
<font face="verdana" size="1" color="#666666"><? echo $kode;?></font>
</td>
<td align="center">
<font face="verdana" size="1" color="#999999"><? echo $nama;?></font>
</td>
<td align="center">
<font face="verdana" size="1" color="#999999"><? echo $tgl;?></font>
</td>
<td align="center">
<font face="verdana" size="1" color="#333333"><? echo ucwords($status);?></font>
</td>
<td align="center">
<font face="verdana" size="1" color="#333333"><? echo ucwords($pengiriman);?></font>
</td>
<td align="center">
<a href="#" onClick="window.open('cetak-laporan.php?idlap=<? echo $idlap;?>&iduser=<? echo $iduser;?>','scrollwindow','top=200,left=350,width=575,height=500'<img src="https://s.kaskus.id/images/smilies/sumbangan/13.gif" data-sceditor-emoticon=";)" border="0" alt="emoticon-Wink" title="Wink"/>;" style="text-decoration:none" title="Info Situs"><img src="./img/print.png" border="0" title="Cetak Laporan"></a>
<a href="home.php?page=12&nama=<? echo $nama;?>&iduser=<? echo $iduser;?>">
<img src="./img/update.png" border="0" title="Ganti Status Pemesanan & pengiriman"></a>
<a href=warning.php?id=<? echo $idlap; ?>&type=pesanan&hal=home.php?page=7 style='text-decoration:none' title="hapus">
<img src="./img/hapus.png" border="0" title="Hapus">
</a>
</td>
</tr>
<tr>
<td colspan="7"><hr color="#CCCCCC"></td>
</tr>
<?
}
?>
</table>
<?
}else{
echo "<font color='#FF0000' face='verdana' size='2'><b>Belum ada data!!</b></font>";
}
?>
</td></tr>
</table>
</td>
<td background="./img/b-kanan.jpg"></td>
</tr>
<tr>
<td align="right"><img src="./img/kib.jpg"></td>
<td bgcolor="#73aa73" ><div align="center"><strong><font face="verdana" size="2" color="#FFFFFF">Jumlah Artikel : <b><? echo $jumlah; ?></font></strong></div></td>
<td><img src="./img/kab.jpg"></td>
</tr>
</table>
</table>
<p> </p>
<?
}else{
echo "<script> document.location.href='akses.php?go=session'; </script>";
}
?>
0
2.4K
Kutip
18
Balasan
Komentar yang asik ya
Mari bergabung, dapatkan informasi dan teman baru!
Programmer Forum
20.2KThread•5KAnggota
Urutkan
Terlama
Komentar yang asik ya