session_start();
ob_start();
//$_SESSION['last_reload'] = time();
//include "../user/timeout.php";
include "../../database/member.php";
mysql_connect("$host", "$username", "$password")or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");
//$rowsPerPage = 30;
//$pageNum = 1;
//if(isset($_GET['page']))
//{
// $pageNum = $_GET['page'];
// }
// $offset = ($pageNum -1)*$rowsPerPage;
//$pagelevel1 = 1;
//$pagelevelP1 = 'P1';
//$pagelevelW1 = 'W1';
//$pagelevel2 = 2;
//$pagelevel3 = 3;
//$pagelevel4 = 4;
//$pagelevel5 = 5;
//$pagelevelS = 'S';
//$pagelevelCM = 'CM';
//$pagelevelAC = 'AC';
?>
Periodic
//if (
//($_SESSION['mylevel'] == $pagelevel1)
//||
//($_SESSION['mylevel'] == $pagelevelP1)
//||
//($_SESSION['mylevel'] == $pagelevelW1)
//||
//($_SESSION['mylevel'] == $pagelevel2)
//||
//($_SESSION['mylevel'] == $pagelevel3)
//||
//($_SESSION['mylevel'] == $pagelevel4)
//||
//($_SESSION['mylevel'] == $pagelevel5)
//||
//($_SESSION['mylevel'] == $pagelevelS)
//||
//($_SESSION['mylevel'] == $pagelevelCM)
//||
//($_SESSION['mylevel'] == $pagelevelAC)
//)
//{
?>
No
District
Type
Route
Road Name
FromLoc
ToLoc
Desc
AK.No.
Amount(RM)
StartDate
CompleteDate
Status(%)
if(isset($_GET['s']))
{
$s=$_GET['s'];
}
//$district = $_POST['district'];
//$type = $_POST['type'];
//$route = $_POST['route'];
//$road = $_POST['road'];
//$fromkm = $_POST['fromkm'];
//$tokm = $_POST['tokm'];
//$start = $_POST['start'];
//$complete = $_POST['complete'];
//$query = "select * from page where";
//$string = $_GET['ordertype'];
//if(!empty($string)){
// $query.=" ordertype like '%$string%' and ";
//}
//$string2 = $_GET['shirt'];
//if(!empty($string2)){
// $query.=" shirt like '%$string2%' and ";
//}
$query = "select * from pw where";
$string1 = $_GET['district'];
if(!empty($string1)){
$query.=" district like '%$string1%' and ";
}
$string2 = $_GET['type'];
if(!empty($string2)){
$query.=" type like '%$string2%' and ";
}
$string3 = $_GET['route'];
if(!empty($string3)){
$query.=" route like '%$string3%' and ";
}
$string4 = $_GET['road'];
if(!empty($string4)){
$query.=" road like '%$string4%' and ";
}
$string5 = $_GET['fromkm'];
if(!empty($string5)){
$query.=" fromkm like '$string5%' and ";
}
$string6 = $_GET['tokm'];
if(!empty($string6)){
$query.=" tokm like '$string6%' and ";
}
$string7 = $_GET['start'];
if(!empty($string7)){
$query.=" start like '%$string7%' and ";
}
$string8 = $_GET['complete'];
if(!empty($string8)){
$query.=" complete like '%$string8%' and ";
}
$query = substr($query, 0, -4);
$limit=30;
$numresults=mysql_query($query) or die(mysql_error());
$numrows=mysql_num_rows($numresults);
if (empty($s)) {
$s=0;
}
$query .= " limit $s,$limit";
$result = mysql_query($query) or die("Couldn't execute query");
echo "Results";
$count = 1 + $s ;
//$sql.=" LIMIT $offset, $rowsPerPage";
//$No = $offset + 1;
//$rs = mysql_query($sql) or die(mysql_error());
//if ($rs)
//$sql = "select * From pw LIMIT $offset, $rowsPerPage";
//$sql = "Select id, DateRequested, RequestedBy, ApprovedBy, centre From overtime";
//$sql = "Select count(prRef) as countPrRef, prRef, count(prOrderDate) as countprOrderDate, prProcessStatus, prOrderDate, prPRFNo, prPreUserID, prReqUserID, prReqDate, prVerUserID, prVerDate, prAppUserID, prAppUserID2 From pr Group By prRef Order By prOrderDate DESC, prPRFNo, prPreDate DESC ";
//$sql = "Select * From pr";
//$No = $offset + 1;
$No = $s + 1;
//$rs = mysql_query($sql) or die(mysql_error());
//$num_rows = mysql_num_rows($rs);
//if ($rs)
//{
while ($rw = mysql_fetch_object($result))
{
$pwid=$rw->pwid;
$district=$rw->district;
$type=$rw->type;
$route=$rw->route;
$road=$rw->road;
$fromkm=$rw->fromkm;
$tokm=$rw->tokm;
$desc=$rw->desc;
$ak=$rw->ak;
$amount=$rw->amount;
$start=$rw->start;
$complete=$rw->complete;
$status=$rw->status;
//$PurchaseDate=$rw->PurchaseDate;
//$centre=$rw->centre;
//$company=$rw->company;
?>
echo $No; ?>
echo $district; ?>
echo $type; ?>
echo $route; ?>
echo $road; ?>
echo $fromkm; ?>
echo $tokm; ?>
echo $desc; ?>
echo $ak; ?>
echo $amount; ?>
echo $start; ?>
echo $complete; ?>
echo $status; ?>
$No++;
$count++;
}
$currPage = (($s/$limit) + 1);
?>
if ($s>=1) { // bypass PREV link if s is 0
$prevs=($s-$limit);
print " <<
Prev   ";
}
// calculate number of pages needing links
$pages=intval($numrows/$limit);
// $pages now contains int of pages needed unless there is a remainder from division
if ($numrows%$limit) {
// has remainder so add one page
$pages++;
}
// check to see if last page
if (!((($s+$limit)/$limit)==$pages) && $pages!=1) {
// not last page so give NEXT link
$news=$s+$limit;
echo " Next>> ";
}
$a = $s + ($limit) ;
if ($a > $numrows) { $a = $numrows ; }
$b = $s + 1 ;
echo "Showing results $a of $numrows
";
//}
//else
//{
// $html = "
// RECORD
// Empty ";
//echo $html;
//}
?>