TS
Mr.r4mtn
help me
assalamualaikum gan and sis....
ane punya trable nih ...
untuk pencarian data dua periode digabungkan dengan pagging menggunakan php....
<?php include("koneksi.php");
$tablename="tb_suratmasuk";
$baselink=$_SERVER['PHP_SELF'];
// jumlah data perhalaman
$rowsPerPage = 2;
//nilai pertama
$pageNum = 1;
if(!empty($_GET['page']))
{
$pageNum = $_GET['page'];
}
$offset = ($pageNum - 1) * $rowsPerPage;
// query database
$query = "SELECT * FROM $tablename ORDER by nomor asc LIMIT $offset, $rowsPerPage";
$result = mysql_query($query) or die('Error, query failed. ' . mysql_error());
$min_tanggal=mysql_fetch_array(mysql_query("select min(tanggal_terima) as min_tanggal from $tablename"));
$max_tanggal=mysql_fetch_array(mysql_query("select max(tanggal_terima) as max_tanggal from $tablename"));
?>
<form action="" method="post" name="postform">
<table width="435" border="0">
<tr>
<td>Tanggal Awal</td>
<td colspan="2"><input type="text" name="tanggal_awal" size="15" value="<?php echo $min_tanggal['min_tanggal'];?>"/>
<a ><img src="calender/calender.jpeg" alt="" name="popcal" width="34" height="29" border="0" align="absmiddle" id="popcal" /></a>
</td>
</tr>
<tr>
<td>Tanggal Akhir</td>
<td colspan="2"><input type="text" name="tanggal_akhir" size="15" value="<?php echo $max_tanggal['max_tanggal'];?>"/>
<a ><img src="calender/calender.jpeg" alt="" name="popcal" width="34" height="29" border="0" align="absmiddle" id="popcal" /></a>
</td>
</tr>
<tr>
<td><input type="submit" value="Tampilkan Data" name="cari"></td>
<td colspan="2"> </td>
</tr>
</table>
</form>
<p>
<?php
//di proses jika sudah klik tombol cari
if(isset($_POST['cari'])){
//menangkap nilai form
$tanggal_awal=$_POST['tanggal_awal'];
$tanggal_akhir=$_POST['tanggal_akhir'];
if(empty($tanggal_awal) and empty($tanggal_akhir)){
//jika tidak menginput apa2
$query=mysql_query("select nomor, DATE_FORMAT(tanggal_terima, '%d-%m-%Y') as tanggal_terima, asal_surat, nomor_surat, lampiran_surat, DATE_FORMAT(tanggal_surat, '%d-%m-%Y') as tanggal_surat, surat_untuk, perihal, surat_upload from tb_suratmasuk");
}else{
$query=mysql_query("select nomor, DATE_FORMAT(tanggal_terima, '%d-%m-%Y') as tanggal_terima, asal_surat, nomor_surat, lampiran_surat, DATE_FORMAT(tanggal_surat, '%d-%m-%Y') as tanggal_surat, surat_untuk, perihal, surat_upload from tb_suratmasuk");
}
?>
<h2 align="center">Data Surat Masuk</h2>
<form name="FLaporan" method="GET" action="delete_banyak.php">
<table width="100%" border="1" align="center" cellpadding="2" cellspacing="0">
<tr bgcolor="#999999">
<td align="center"> </td>
<td align="center" width="30px">No. Urut</td>
<td align="center" width="100px">Nomor Surat</td>
<td align="center" width="100px">Tanggal Surat</td>
<td align="center" >Asal Surat</td>
<td align="center" >Perihal</td>
<td align="center" >Kepada</td>
<td align="center" width="100px">Tanggal Terima</td>
<td align="center" >Lampiran</td>
<td align="center" >Upload</td>
<td align="center" width="50px">Koreksi</td>
<td align="center" width="50px">Hapus</td>
</tr>
<?php
//untuk penomoran data
//menampilkan data
while($row=mysql_fetch_array($query)){
?>
<tr>
<td align="center"><input type="checkbox" name="item[]" id="item[]" value="<?php echo $row['nomor']?>" /></td>
<td align="center" width="30px"><?php echo $row['nomor']?></td>
<td align="center"><?php echo $row['nomor_surat']?></td>
<td align="center" width="100px "><?php echo $row['tanggal_surat']?></td>
<td><?php echo $row['asal_surat']?></td>
<td><?php echo $row['perihal']?></td>
<td><?php echo $row['surat_untuk']?></td>
<td align="center" width="100px "><?php echo $row['tanggal_terima']?></td>
<td><?php echo $row['lampiran_surat']?></td>
<td align="center"><a href="#" target="fenetreA"><img src="<?php echo $row['surat_upload']?>" alt="<?php echo $row['nomor']?>" width="30"></a></td>
<td align="center"><a href="edit_surat.php?nomor=<?php echo $row['nomor']?>">Koreksi</a></td>
<td align="center"><a href="hapus_data.php?nomor=<?php echo $row['nomor']?>">Hapus</a></td>
</tr>
<?php }?>
</table>
<br/>
<input name="btnHapus" type="submit" value="Delete">
<?php
$query = "SELECT COUNT(nomor) AS numrows FROM $tablename";
$result = mysql_query($query) or die('Error, query failed. ' . mysql_error());
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$numrows = $row['numrows'];
$maxPage = ceil($numrows/$rowsPerPage);
$nextLink = ' ';
if($maxPage >1)
{
$self = $_SERVER['PHP_SELF'];
$nextLink = array();
for($page = 1; $page <= $maxPage; $page++)
{
$nextLink[] = "<a >$page</a>";
}
$nextLink = "<br/>" . implode(' ', $nextLink);
}
echo '<div id="navpage">'.$nextLink.'</div>';
mysql_free_result($result);
}
?>
</form>
<br/>
ane punya trable nih ...
untuk pencarian data dua periode digabungkan dengan pagging menggunakan php....
Spoiler for photo:
Spoiler for php:
<?php include("koneksi.php");
$tablename="tb_suratmasuk";
$baselink=$_SERVER['PHP_SELF'];
// jumlah data perhalaman
$rowsPerPage = 2;
//nilai pertama
$pageNum = 1;
if(!empty($_GET['page']))
{
$pageNum = $_GET['page'];
}
$offset = ($pageNum - 1) * $rowsPerPage;
// query database
$query = "SELECT * FROM $tablename ORDER by nomor asc LIMIT $offset, $rowsPerPage";
$result = mysql_query($query) or die('Error, query failed. ' . mysql_error());
$min_tanggal=mysql_fetch_array(mysql_query("select min(tanggal_terima) as min_tanggal from $tablename"));
$max_tanggal=mysql_fetch_array(mysql_query("select max(tanggal_terima) as max_tanggal from $tablename"));
?>
<form action="" method="post" name="postform">
<table width="435" border="0">
<tr>
<td>Tanggal Awal</td>
<td colspan="2"><input type="text" name="tanggal_awal" size="15" value="<?php echo $min_tanggal['min_tanggal'];?>"/>
<a ><img src="calender/calender.jpeg" alt="" name="popcal" width="34" height="29" border="0" align="absmiddle" id="popcal" /></a>
</td>
</tr>
<tr>
<td>Tanggal Akhir</td>
<td colspan="2"><input type="text" name="tanggal_akhir" size="15" value="<?php echo $max_tanggal['max_tanggal'];?>"/>
<a ><img src="calender/calender.jpeg" alt="" name="popcal" width="34" height="29" border="0" align="absmiddle" id="popcal" /></a>
</td>
</tr>
<tr>
<td><input type="submit" value="Tampilkan Data" name="cari"></td>
<td colspan="2"> </td>
</tr>
</table>
</form>
<p>
<?php
//di proses jika sudah klik tombol cari
if(isset($_POST['cari'])){
//menangkap nilai form
$tanggal_awal=$_POST['tanggal_awal'];
$tanggal_akhir=$_POST['tanggal_akhir'];
if(empty($tanggal_awal) and empty($tanggal_akhir)){
//jika tidak menginput apa2
$query=mysql_query("select nomor, DATE_FORMAT(tanggal_terima, '%d-%m-%Y') as tanggal_terima, asal_surat, nomor_surat, lampiran_surat, DATE_FORMAT(tanggal_surat, '%d-%m-%Y') as tanggal_surat, surat_untuk, perihal, surat_upload from tb_suratmasuk");
}else{
$query=mysql_query("select nomor, DATE_FORMAT(tanggal_terima, '%d-%m-%Y') as tanggal_terima, asal_surat, nomor_surat, lampiran_surat, DATE_FORMAT(tanggal_surat, '%d-%m-%Y') as tanggal_surat, surat_untuk, perihal, surat_upload from tb_suratmasuk");
}
?>
<h2 align="center">Data Surat Masuk</h2>
<form name="FLaporan" method="GET" action="delete_banyak.php">
<table width="100%" border="1" align="center" cellpadding="2" cellspacing="0">
<tr bgcolor="#999999">
<td align="center"> </td>
<td align="center" width="30px">No. Urut</td>
<td align="center" width="100px">Nomor Surat</td>
<td align="center" width="100px">Tanggal Surat</td>
<td align="center" >Asal Surat</td>
<td align="center" >Perihal</td>
<td align="center" >Kepada</td>
<td align="center" width="100px">Tanggal Terima</td>
<td align="center" >Lampiran</td>
<td align="center" >Upload</td>
<td align="center" width="50px">Koreksi</td>
<td align="center" width="50px">Hapus</td>
</tr>
<?php
//untuk penomoran data
//menampilkan data
while($row=mysql_fetch_array($query)){
?>
<tr>
<td align="center"><input type="checkbox" name="item[]" id="item[]" value="<?php echo $row['nomor']?>" /></td>
<td align="center" width="30px"><?php echo $row['nomor']?></td>
<td align="center"><?php echo $row['nomor_surat']?></td>
<td align="center" width="100px "><?php echo $row['tanggal_surat']?></td>
<td><?php echo $row['asal_surat']?></td>
<td><?php echo $row['perihal']?></td>
<td><?php echo $row['surat_untuk']?></td>
<td align="center" width="100px "><?php echo $row['tanggal_terima']?></td>
<td><?php echo $row['lampiran_surat']?></td>
<td align="center"><a href="#" target="fenetreA"><img src="<?php echo $row['surat_upload']?>" alt="<?php echo $row['nomor']?>" width="30"></a></td>
<td align="center"><a href="edit_surat.php?nomor=<?php echo $row['nomor']?>">Koreksi</a></td>
<td align="center"><a href="hapus_data.php?nomor=<?php echo $row['nomor']?>">Hapus</a></td>
</tr>
<?php }?>
</table>
<br/>
<input name="btnHapus" type="submit" value="Delete">
<?php
$query = "SELECT COUNT(nomor) AS numrows FROM $tablename";
$result = mysql_query($query) or die('Error, query failed. ' . mysql_error());
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$numrows = $row['numrows'];
$maxPage = ceil($numrows/$rowsPerPage);
$nextLink = ' ';
if($maxPage >1)
{
$self = $_SERVER['PHP_SELF'];
$nextLink = array();
for($page = 1; $page <= $maxPage; $page++)
{
$nextLink[] = "<a >$page</a>";
}
$nextLink = "<br/>" . implode(' ', $nextLink);
}
echo '<div id="navpage">'.$nextLink.'</div>';
mysql_free_result($result);
}
?>
</form>
<br/>
Diubah oleh Mr.r4mtn 08-12-2014 19:26
0
985
Kutip
1
Balasan
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