- Beranda
- Komunitas
- Tech
- Programmer Forum
[ASK][PHP] Form pencarian data menggunakan pagination class
TS
esbonbon
[ASK][PHP] Form pencarian data menggunakan pagination class
Spoiler for "source code":
[removed][removed]
<style>
.pagin {
padding: 10px 0;
font:bold 11px/30px arial, serif;
}
.pagin * {
padding: 2px 6px;
color:#0A7EC5;
margin: 2px;
border-radius:3px;
}
.pagin a {
border:solid 1px #8DC5E6;
text-decoration:none;
background:#F8FCFF;
padding:6px 7px 5px;
}
.pagin span, a:hover, .pagin a:active,.pagin span.current {
color:#FFFFFF;
background:-moz-linear-gradient(top,#B4F6FF 1px,#63D0FE 1px,#58B0E7);
}
.pagin span,.current{
padding:8px 7px 7px;
}
.content{
padding:10px;
font:bold 12px/30px gegoria,arial,serif;
border:1px dashed #0686A1;
border-radius:5px;
background:-moz-linear-gradient(top,#E2EEF0 1px,#CDE5EA 1px,#E2EEF0);
margin-bottom:10px;
text-align:left;
line-height:20px;
}
.outer_div{
margin:auto;
width:600px;
}
#loader{
position: absolute;
text-align: center;
top: 75px;
width: 100%;
display:none;
}
</style>
<?php
$db_hostname = 'localhost';
$db_username = 'root';
$db_password = '';
$db_database = 'sishelpdesk';
// Database Connection String
$con = mysql_connect($db_hostname,$db_username,$db_password);
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db($db_database, $con);
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8" />
<title></title>
</head>
<body>
<form name="form1" method="post" action="">
<input type="text" name="term" />
<input type="submit" value="Cari" class="btn btn-small btn-primary">
</form>
<?php
if (!empty($_REQUEST['cari'])) {
$cari = mysql_real_escape_string($_REQUEST['cari']);
/* Koneksi database*/
include 'pages/web/paging.php'; //include pagination file
//pagination variables
$hal = (isset($_REQUEST['hal']['cari']) && !empty($_REQUEST['hal']['cari']))?$_REQUEST['hal']['cari']:1;
$per_hal = 5; //berapa banyak blok
$adjacents = 5;
$offset = ($hal - 1) * $per_hal;
$reload="?cat=administrator&page=carisitelist";
//Cari berapa banyak jumlah data*/
$count_query = mysql_query("SELECT COUNT(siteid) as numrows, siteid, sitename, region, city, address, pm, cm, padlock, padlock2 FROM sitelist where sitename LIKE '%".$cari."%'");
if($count_query === FALSE) {
die(mysql_error());
}
$row = mysql_fetch_array($count_query);
$numrows = $row['numrows']; //dapatkan jumlah data
$total_hals = ceil($numrows/$per_hal);
//jalankan query menampilkan data per blok $offset dan $per_hal
$query = mysql_query("SELECT siteid, sitename, region, city, address, pm, cm, padlock, padlock2
FROM sitelist LIMIT $offset,$per_hal");
$r_query = mysql_query($count_query);
?>
<table width="100%" border="0" cellspacing="0" cellpadding="0" class="responsive table table-striped table-bordered">
<thead>
<tr>
<td colspan="2" align="right" class="no_sort"> </td>
</tr>
<tr>
<td class="no_sort"></td>
<td class="no_sort"></td>
</tr>
<tr>
<td class="no_sort">SiteID</td>
<td class="no_sort">Sitename</td>
<td class="no_sort">Region</td>
<td class="no_sort">City</td>
<td class="no_sort">Address</td>
<td class="no_sort">PM</td>
<td class="no_sort">CM</td>
<td class="no_sort">Padlock</td>
<td class="no_sort">Padlock2</td>
<td> </td>
</tr>
</thead>
<?php
while($result = mysql_fetch_array($query)){
?>
<tr >
<td><?php echo $result['siteid']; ?></td>
<td><?php echo $result['sitename']; ?></td>
<td><?php echo $result['region']; ?></td>
<td><?php echo $result['city']; ?></td>
<td><?php echo $result['address']; ?></td>
<td><?php echo $result['pm']; ?></td>
<td><?php echo $result['cm']; ?></td>
<td><?php echo $result['padlock']; ?></td>
<td><?php echo $result['padlock2']; ?></td>
<td><a href="?cat=administrator&page=sitelistedit&id=<?php echo sha1($result['siteid']); ?>">Edit</a> - <a href="?cat=administrator&page=sitelist&del=1&id=<?php echo sha1($result['siteid']); ?>">Hapus</a></td>
</tr>
<?php
}
?>
</table>
<?php
echo paginate($reload, $hal, $total_hals, $adjacents);
?>
<style>
.pagin {
padding: 10px 0;
font:bold 11px/30px arial, serif;
}
.pagin * {
padding: 2px 6px;
color:#0A7EC5;
margin: 2px;
border-radius:3px;
}
.pagin a {
border:solid 1px #8DC5E6;
text-decoration:none;
background:#F8FCFF;
padding:6px 7px 5px;
}
.pagin span, a:hover, .pagin a:active,.pagin span.current {
color:#FFFFFF;
background:-moz-linear-gradient(top,#B4F6FF 1px,#63D0FE 1px,#58B0E7);
}
.pagin span,.current{
padding:8px 7px 7px;
}
.content{
padding:10px;
font:bold 12px/30px gegoria,arial,serif;
border:1px dashed #0686A1;
border-radius:5px;
background:-moz-linear-gradient(top,#E2EEF0 1px,#CDE5EA 1px,#E2EEF0);
margin-bottom:10px;
text-align:left;
line-height:20px;
}
.outer_div{
margin:auto;
width:600px;
}
#loader{
position: absolute;
text-align: center;
top: 75px;
width: 100%;
display:none;
}
</style>
<?php
$db_hostname = 'localhost';
$db_username = 'root';
$db_password = '';
$db_database = 'sishelpdesk';
// Database Connection String
$con = mysql_connect($db_hostname,$db_username,$db_password);
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db($db_database, $con);
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8" />
<title></title>
</head>
<body>
<form name="form1" method="post" action="">
<input type="text" name="term" />
<input type="submit" value="Cari" class="btn btn-small btn-primary">
</form>
<?php
if (!empty($_REQUEST['cari'])) {
$cari = mysql_real_escape_string($_REQUEST['cari']);
/* Koneksi database*/
include 'pages/web/paging.php'; //include pagination file
//pagination variables
$hal = (isset($_REQUEST['hal']['cari']) && !empty($_REQUEST['hal']['cari']))?$_REQUEST['hal']['cari']:1;
$per_hal = 5; //berapa banyak blok
$adjacents = 5;
$offset = ($hal - 1) * $per_hal;
$reload="?cat=administrator&page=carisitelist";
//Cari berapa banyak jumlah data*/
$count_query = mysql_query("SELECT COUNT(siteid) as numrows, siteid, sitename, region, city, address, pm, cm, padlock, padlock2 FROM sitelist where sitename LIKE '%".$cari."%'");
if($count_query === FALSE) {
die(mysql_error());
}
$row = mysql_fetch_array($count_query);
$numrows = $row['numrows']; //dapatkan jumlah data
$total_hals = ceil($numrows/$per_hal);
//jalankan query menampilkan data per blok $offset dan $per_hal
$query = mysql_query("SELECT siteid, sitename, region, city, address, pm, cm, padlock, padlock2
FROM sitelist LIMIT $offset,$per_hal");
$r_query = mysql_query($count_query);
?>
<table width="100%" border="0" cellspacing="0" cellpadding="0" class="responsive table table-striped table-bordered">
<thead>
<tr>
<td colspan="2" align="right" class="no_sort"> </td>
</tr>
<tr>
<td class="no_sort"></td>
<td class="no_sort"></td>
</tr>
<tr>
<td class="no_sort">SiteID</td>
<td class="no_sort">Sitename</td>
<td class="no_sort">Region</td>
<td class="no_sort">City</td>
<td class="no_sort">Address</td>
<td class="no_sort">PM</td>
<td class="no_sort">CM</td>
<td class="no_sort">Padlock</td>
<td class="no_sort">Padlock2</td>
<td> </td>
</tr>
</thead>
<?php
while($result = mysql_fetch_array($query)){
?>
<tr >
<td><?php echo $result['siteid']; ?></td>
<td><?php echo $result['sitename']; ?></td>
<td><?php echo $result['region']; ?></td>
<td><?php echo $result['city']; ?></td>
<td><?php echo $result['address']; ?></td>
<td><?php echo $result['pm']; ?></td>
<td><?php echo $result['cm']; ?></td>
<td><?php echo $result['padlock']; ?></td>
<td><?php echo $result['padlock2']; ?></td>
<td><a href="?cat=administrator&page=sitelistedit&id=<?php echo sha1($result['siteid']); ?>">Edit</a> - <a href="?cat=administrator&page=sitelist&del=1&id=<?php echo sha1($result['siteid']); ?>">Hapus</a></td>
</tr>
<?php
}
?>
</table>
<?php
echo paginate($reload, $hal, $total_hals, $adjacents);
?>
masalahnya form cari gak berfungsi
Diubah oleh esbonbon 03-09-2014 14:20
0
755
Kutip
0
Balasan
Guest
Tulis komentar menarik atau mention replykgpt untuk ngobrol seru
Guest
Tulis komentar menarik atau mention replykgpt untuk ngobrol seru
Komunitas Pilihan