- Beranda
- 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
Mari bergabung, dapatkan informasi dan teman baru!
Programmer Forum
20.2KThread•4.3KAnggota
Guest
Tulis komentar menarik atau mention replykgpt untuk ngobrol seru