session_start(); ob_start(); //$_SESSION['last_reload'] = time(); //include "../../road/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 = 10; $pageNum = 1; if(isset($_GET['page'])) { $pageNum = $_GET['page']; } $offset = ($pageNum -1)*$rowsPerPage; //$zoneSabah='SPB'; //$zoneLabuan='LLB'; ?>
|
|||||||||||||
| New Arahan Kerja |
|||||||||||||
| AK. No | Project Name | Type | Route No | Location | Date start | Date Complete | Amount | Status | Option | ||||
| echo $ak; ?> | echo $projectName; ?> | echo $type; ?> | echo $route; ?> | echo $fromkm; ?> | echo $start; ?> | echo $complete; ?> | echo number_format($amount, 2, '.', ','); ?> | if($status=='01') { $s='Apply(mohon)'; } if($status=='02') { $s='Active(aktif)'; } if($status=='03') { $s='Complete(selesai)'; } if($status=='04') { $s='Cancel(batal)'; } if($status=='05') { $s='Postponed(tangguh)'; } if($status=='06') { $s='Pass(lulus)'; } if($status=='07') { $s='Fail(tak lulus)'; } ?>echo $s; ?> | Edit Delete |
||||
| RECORD | Empty | } ?>||||||||||||
| $query = "select count(route) as numrows from pw WHERE zone='SPB'"; $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; ?> |