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.
Name
Work Scope
Contact Person
Licence
if(isset($_GET['s']))
{
$s=$_GET['s'];
}
$query = "select * from scon where";
$string1 = $_GET['name'];
if(!empty($string1)){
$query.=" name like '%$string1%' and ";
}
$string2 = $_GET['scope'];
if(!empty($string2)){
$query.=" scope like '%$string2%' 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))
{
$sconid=$rw->sconid;
$name=$rw->name;
$scope=$rw->scope;
$centre=$rw->centre;
$licence=$rw->licence;
?>
echo $No; ?>
echo $name; ?>
echo $scope; ?>
echo $centre; ?>
echo $licence; ?>
$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;
//}
?>