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)
//)
//{
?>
Centre : Beaufort Keningau
KK North KK South
Kota Marudu Ranau
Labuan ALL
| No
|
Centre
|
District
|
RoadName
|
Date
|
FromLoc
|
ToLoc
|
Type
|
Side
|
Length(m)
|
Remark
|
$sql = "select * From r07 WHERE centre='ranau' 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";
$Nom = $offset + 1;
$rs = mysql_query($sql) or die(mysql_error());
if ($rs)
{
while ($rw = mysql_fetch_object($rs))
{
$centre=$rw->centre;
$district=$rw->district;
$road=$rw->road;
$date=$rw->date;
$fromloc=$rw->fromloc;
$toloc=$rw->toloc;
$type=$rw->type;
$side=$rw->side;
$length=$rw->length;
$remark=$rw->remark;
//$PurchaseDate=$rw->PurchaseDate;
//$centre=$rw->centre;
//$company=$rw->company;
?>
| echo $Nom; ?> |
echo $centre; ?> |
echo $district; ?> |
echo $road; ?> |
echo $date; ?> |
echo $fromloc; ?> |
echo $toloc; ?> |
echo $type; ?> |
echo $side; ?> |
echo $length; ?> |
echo $remark; ?> |
$Nom++;
}
}
else
{
?>
| RECORD |
Empty |
}
?>
|
$query = "select count(r7id) as numrows from r07 WHERE centre='Ranau'";
$result = mysql_query($query) or die("Error, query failed");
$row = mysql_fetch_array($result, MYSQL_ASSOC);
$numrows = $row['numrows'];
$maxPage = ceil($numrows/$rowsPerPage);
$self = $_SERVER['PHP_SELF'];
if($pageNum > 1)
{
$page = $pageNum - 1;
$prev = " [Prev] ";
$first = " [First Page] ";
}
else
{
$prev = ' ';
$first = ' ';
}
if($pageNum < $maxPage)
{
$page = $pageNum + 1;
$next = " [Next] ";
$last = " [Last Page] ";
}
else
{
$next = ' ';
$last = ' ';
}
//echo $first . $prev . $nav . $next . $last;
echo $first . $prev .
" Showing page $pageNum of $maxPage pages " . $next . $last;
?>
|
|