- Beranda
- Komunitas
- Tech
- Programmer Forum
[ask]Ane buat report berdasarkan filter by tanggal kok error ya,,, Error dimana?
TS
Julian111
[ask]Ane buat report berdasarkan filter by tanggal kok error ya,,, Error dimana?
Ane lagi disuruh buat report filter by tanggal dengan koding, report2.php:
Dan report.php:
Tapi kok error ya? Error di mana ya...
Ane masih newbie nih di programming web. mohon bantuannya
Code:
<html>
<head><title>Report berdasarkan periode</title></head>
<body>
<?php
include "koneksi.php";
?>
<center><h1>Report by Periode</h1></center>
</br>
<center>Filter by Periode:
<form name="report" action="report.php" method="post">
<table>
<tr>
<td>Tanggal Awal</td>
<td><input type="text" size="20" name="tgl_awal" title="dd-mm-yyyy" /><a ><img name="popcal" align="absmiddle" src="calender/calbtn.gif" width="34" height="22" border="0" alt=""></td></tr></td>
</tr>
<tr>
<td>Tanggal Akhir</td>
<td><input type="text" size="20" name="tgl_akhir" title="dd-mm-yyyy" /><a ><img name="popcal" align="absmiddle" src="calender/calbtn.gif" width="34" height="22" border="0" alt=""></td></tr></td>
</tr>
<tr>
<td><input type="submit" value="cari"/></td>
</tr>
</table>
</form>
</center>
<iframe width=174 height=189 name="gToday:normal:calender/normal.js" id="gToday:normal:calender/normal.js" src="calender/ipopeng.htm" scrolling="no" frameborder="0" style="visibility:visible; forbidden999; position:absolute; top:-500px; left:-500px;">
</iframe>
</body>
</html>
Dan report.php:
Code:
<html>
<head><title>Report berdasarkan periode</title></head>
<body>
<?php
include "koneksi.php";
?>
<table border="1" align="center" cellspacing="0">
<tr align="center">
<td bgcolor="D5FF95">Tanggal</td>
<td bgcolor="D5FF95">Id jemaah</td>
<td bgcolor="D5FF95">Nominal</td>
<td bgcolor="D5FF95">Keterangan</td>
</tr>
<?php
$query="SELECT * FROM cicilan_umroh WHERE Tgl_transfer >='" . $_post['tgl_awal'] . "' AND Tgl_transfer >='" . $_post['tgl_akhir'] . "'";
$hasil= mysql_query($query,$koneksi)or die("Gagal melakukan query");
while ($buff=mysql_fetch_array($hasil)){
?>
<tr>
<td><?php echo $buff['Tgl_transfer'];?></td>
<td><?php echo $buff['Id_jemaah'];?></td>
<td><?php echo $buff['Nominal_transfer'];?></td>
<td><?php echo $buff['Keterangan'];?></td>
</tr>
<?php
}
mysql_close($koneksi);
?>
</table>
</body>
</html>
Tapi kok error ya? Error di mana ya...
Ane masih newbie nih di programming web. mohon bantuannya
0
1.3K
11
Guest
Tulis komentar menarik atau mention replykgpt untuk ngobrol seru
Urutan
Terbaru
Terlama
Guest
Tulis komentar menarik atau mention replykgpt untuk ngobrol seru
Komunitas Pilihan