bantu tampilan laporan e-commerce (PHP)

Beranda

...

Programmer Forum
bantu tampilan laporan e-commerce (PHP)

baskoro.bayu

26-09-2012 14:38

bantu tampilan laporan e-commerce (PHP)

sesuai judul gan ane dah bikin laporan tapi kekurangan nya seperti di gambar gan
mohon bantuannya
bantu tampilan laporan e-commerce (PHP)

ini skrip nya

Spoiler for coding:

<? session_start();
\tinclude "./include/conn.php";
if (session_is_registered('id' emoticon-Wink

)
{
?>

\t<html>
\t<head>
\t<title>Edit Artikel</title>
\t<table width="49%" border="0" cellpadding="0" cellspacing="0" bordercolor="#99CC99" align="center">
\t<tr>
\t\t<td width="2%" align="right"><img src="./img/kiri.jpg"></td>
\t\t<td width="96%" bgcolor="#73aa73" ><div align="center"><strong><font face="verdana" size="2" color="#FFFFFF">Pemesanan</font></strong></div></td>
\t\t<td width="2%"><img src="./img/kanan.jpg"></td>
\t</tr>
\t
\t<tr>
\t\t<td background="./img/b-kiri.jpg"></td>
\t\t<td>
\t\t\t<table width="600" align="center">
\t\t\t\t <tr><td width="518">
\t\t\t\t
\t\t\t\t
\t\t\t\t
\t\t\t\t
\t\t\t\t <div align="center">
\t\t\t\t <p><a href="home.php?page=13" style="text-decoration:none" title="Masukan Produk Baru"></a></p>
\t\t\t\t <font color='#0066FF' face='verdana' size='2'><div align="center"><blink><? echo $_GET['status'] ?></blink></div>
\t\t\t </font></p>
\t\t\t\t </div>
\t\t\t\t <div align="center"><font face="Verdana, Arial, Helvetica, sans-serif" size="2">
\t\t\t <?
\t\t\t\t//untuk paging
\t\t\t\t$query=mysql_db_query($db,"select * from laporan ",$koneksi); //input
\t\t\t\t$get_pages=mysql_num_rows($query);
\t\t\t\t
\t\t\t\tif ($get_pages>$entries) //proses
\t\t\t\t{
\t\t\t\t\techo "Halaman : ";
\t\t\t\t\t$pages=1;
\t\t\t\t\twhile($pages<=ceil($get_pages/$entries))
\t\t\t\t\t{
\t\t\t\t\t\tif ($pages!=1)
\t\t\t\t\t\t{
\t\t\t\t\t\t\techo " | ";
\t\t\t\t\t\t}
\t\t\t\t\t?>
\t\t\t\t\t\t\t<a href="home.php?page=7&id=<? echo ($pages-1); ?> " style="text-decoration:none"><font color="#0066FF"><? echo $pages; ?></font></a>
\t\t\t\t\t\t <?
\t\t\t\t\t\t\t$pages++;
\t\t\t\t\t}
\t\t\t\t}else{
\t\t\t\t\t$pages=0;
\t\t\t\t}
\t\t\t\t?>
\t\t\t\t\t\t </font>
\t\t\t\t\t </p>
\t\t\t\t\t\t
\t\t\t\t\t\t <?
\t\t\t\t//akhir paging
\t\t\t\t
\t\t\t\t
\t\t\t\t//proses halaman
\t\t\t\t$page=(int)$_GET['id'];
\t\t\t\t$offset=$page*$entries;
\t\t\t\t$result=mysql_db_query($db,"select * from laporan order by tgl asc limit $offset,$entries",$koneksi); //output
\t\t\t\t$jumlah=mysql_num_rows($query);
\t\t\t\t\t
\t\t\t\t
\t\t\t\tif ($jumlah){
\t\t\t\t\t?>
\t\t\t\t </div><font face="verdana" size="2" color="#666666"><? echo "Tanggal Sekarang : ".$tanggal;?></font><br><br>
\t\t\t\t\t <table align="center" width="690" border="0">
\t\t\t\t<tr>
\t\t\t\t <td width="5%" bgcolor="#CCCCCC"><div align="center"><b>
\t\t\t\t <font color="#666666" size="2" face="Arial, Helvetica, sans-serif">NO</font></b></div>
\t\t\t\t </td>
\t\t\t\t <td width="21%" bgcolor="#CCCCCC"><div align="center"><b>
\t\t\t\t <font color="#666666" size="2" face="Arial, Helvetica, sans-serif">KODE PESANAN</font></b></div>
\t\t\t\t </td>
\t\t\t\t <td width="19%" bgcolor="#CCCCCC"><div align="center"><b>
\t\t\t\t <font color="#666666" size="2" face="Arial, Helvetica, sans-serif">PELANGGAN</font></b></div>
\t\t\t\t </td>
\t\t\t\t <td width="20%" bgcolor="#CCCCCC"><div align="center"><b><font color="#666666" size="2" face="Arial, Helvetica, sans-serif">TANGGAL</font></b>
\t\t\t\t </div> </td>
\t\t\t\t <td width="13%" bgcolor="#CCCCCC"><div align="center"><b><font color="#666666" size="2" face="Arial, Helvetica, sans-serif">STATUS</font></b></div>
\t\t\t\t </td>
<td width="13%" bgcolor="#CCCCCC"><div align="center"><b><font color="#666666" size="2" face="Arial, Helvetica, sans-serif">PENGIRIMAN</font></b></div>
\t\t\t\t </td>
\t\t\t\t <td width="24%" bgcolor="#CCCCCC"><div align="center"><b><font color="#666666" size="2" face="Arial, Helvetica, sans-serif">AKSI</font></b></div>
\t\t\t\t </td>
\t\t\t\t</tr>
\t\t\t\t\t<?
\t\t\t\t\t
\t\t\t\t\twhile ($row=mysql_fetch_array($result))
\t\t\t\t\t{
\t\t\t\t\t
\t\t\t\t\t\t\t$idlap=$row['idlap'];
\t\t\t\t\t\t\t$iduser=$row['iduser'];
\t\t\t\t\t\t\t$tgl=$row['tgl'];
\t\t\t\t\t\t\t$status=$row['status'];
\t\t\t\t\t\t\t$pengiriman=$row['pengiriman'];
\t\t\t\t\t\t\t$kode=$row['kode'];
\t\t\t\t\t\t\t
\t\t\t\t\t\t\t
\t\t\t\t\t\t\t
\t\t\t\t\t\t\t
\t\t\t\t\t\t\t//translate id
\t\t\t\t\t\t\t$transbrg=mysql_db_query($db,"select * from daftar where id='$iduser'",$koneksi);
\t\t\t\t\t\t\twhile ($row=mysql_fetch_array($transbrg)){
\t\t\t\t\t\t\t\t$nama=$row['nama'];
\t\t\t\t\t\t\t}
\t\t\t\t\t\t\t
\t\t\t\t\t\t\t
\t\t\t\t\t\t\t
\t\t\t\t\t?>
\t\t\t\t\t<tr>
\t\t\t\t\t\t<td align="center">
\t\t\t\t\t\t\t<font face="verdana" size="1" color="#999999"><? echo $c=$c+1;?></font>
\t\t\t\t\t\t</td>
\t\t\t\t\t\t
\t\t\t\t\t\t<td align="center">
\t\t\t\t\t\t\t<font face="verdana" size="1" color="#666666"><? echo $kode;?></font>
\t\t\t\t\t\t</td>
\t\t\t\t\t\t
\t\t\t\t\t\t<td align="center">
\t\t\t\t\t\t\t<font face="verdana" size="1" color="#999999"><? echo $nama;?></font>
\t\t\t\t\t\t</td>
\t\t\t\t\t\t
\t\t\t\t\t\t<td align="center">
\t\t\t\t\t\t\t<font face="verdana" size="1" color="#999999"><? echo $tgl;?></font>
\t\t\t\t\t\t</td>
\t\t\t\t\t\t
\t\t\t\t\t\t<td align="center">
\t\t\t\t\t\t\t<font face="verdana" size="1" color="#333333"><? echo ucwords($status);?></font>
\t\t\t\t\t\t</td>

<td align="center">
\t\t\t\t\t\t\t<font face="verdana" size="1" color="#333333"><? echo ucwords($pengiriman);?></font>
\t\t\t\t\t\t</td>
\t\t\t\t\t\t
\t\t\t\t\t\t<td align="center">
\t\t\t\t\t\t\t<a href="#" onClick="window.open('cetak-laporan.php?idlap=<? echo $idlap;?>&iduser=<? echo $iduser;?>','scrollwindow','top=200,left=350,width=575,height=500' emoticon-Wink

;" style="text-decoration:none" title="Info Situs"><img src="./img/print.png" border="0" title="Cetak Laporan"></a>
\t\t\t\t\t\t\t
\t\t\t\t\t\t\t<a href="home.php?page=12&nama=<? echo $nama;?>&iduser=<? echo $iduser;?>">
\t\t\t\t\t\t\t<img src="./img/update.png" border="0" title="Ganti Status Pemesanan & pengiriman"></a>
\t\t\t\t\t\t\t
\t\t\t\t\t\t\t<a href=warning.php?id=<? echo $idlap; ?>&type=pesanan&hal=home.php?page=7 style='text-decoration:none' title="hapus">
\t\t\t\t\t\t\t<img src="./img/hapus.png" border="0" title="Hapus">
\t\t\t\t\t\t\t</a>
\t\t\t\t\t\t</td>
\t\t\t\t\t\t
\t\t\t\t\t</tr>
\t\t\t\t\t
\t\t\t\t\t<tr>
\t\t\t\t\t\t<td colspan="6"><hr color="#CCCCCC"></td>
\t\t\t\t\t</tr>
\t\t\t\t\t<?
\t\t\t\t\t}
\t\t\t\t\t?>
\t\t\t\t </table>
\t\t\t\t\t<?
\t\t\t\t
\t\t\t\t}else{
\t\t\t\t\techo "<font color='#FF0000' face='verdana' size='2'><b>Belum ada data!!</b></font>";
\t\t\t\t}
\t\t\t\t?>
\t\t\t\t
\t\t\t\t
\t\t\t\t\t\t
\t\t\t\t</td></tr>
\t\t </table>
\t\t</td>
\t\t<td background="./img/b-kanan.jpg"></td>
\t</tr>
\t<tr>
\t\t<td align="right"><img src="./img/kib.jpg"></td>
\t\t<td bgcolor="#73aa73" ><div align="center"><strong><font face="verdana" size="2" color="#FFFFFF">Jumlah Artikel : <b><? echo $jumlah; ?></font></strong></div></td>
\t\t<td><img src="./img/kab.jpg"></td>
\t</tr>

\t</table>

</table>

<p> </p>
<?\t
}else{
\techo "<script> document.location.href='akses.php?go=session'; </script>";
}
?>

1.1K

Kutip

Balasan

Komentar yang asik ya

Mari bergabung, dapatkan informasi dan teman baru!

Programmer Forum

20.2KThread•5KAnggota

Urutkan

Terlama

Komentar yang asik ya