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
centre
Ref. No.
Received by
Date received
Mode
Source
Report by
Phone
Event
Road Name
Location (CH)
Duty Person
Status
Complete date
if(isset($_GET['s']))
{
$s=$_GET['s'];
}
$query = "select * from comp where";
$string1 = $_GET['centre'];
if(!empty($string1)){
$query.=" centre like '%$string1%' and ";
}
$string2 = $_GET['report_no'];
if(!empty($string2)){
$query.=" report_no like '%$string2%' and ";
}
$string3 = $_GET['received_by'];
if(!empty($string3)){
$query.=" received_by like '%$string3%' and ";
}
$string4 = $_GET['date'];
if(!empty($string4)){
$query.=" date like '%$string4%' and ";
}
$string5 = $_GET['mode'];
if(!empty($string5)){
$query.=" mode like '%$string5%' and ";
}
$string6 = $_GET['source'];
if(!empty($string6)){
$query.=" source like '%$string6%' and ";
}
$string7 = $_GET['s_name'];
if(!empty($string7)){
$query.=" s_name like '%$string7%' and ";
}
$string8 = $_GET['event'];
if(!empty($string7)){
$query.=" event like '%$string7%' and ";
}
$string9 = $_GET['road'];
if(!empty($string7)){
$query.=" road like '%$string7%' and ";
}
$string10 = $_GET['location'];
if(!empty($string7)){
$query.=" location like '$string7%' and ";
}
$string11 = $_GET['complete'];
if(!empty($string7)){
$query.=" complete like '%$string7%' 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))
{
$compid=$rw->compid;
$centre=$rw->centre;
$report_no=$rw->report_no;
$received_by=$rw->received_by;
$date=$rw->date;
$mode=$rw->mode;
$source=$rw->source;
$s_name=$rw->s_name;
$s_phone=$rw->s_phone;
$event=$rw->event;
$road=$rw->road;
$location=$rw->location;
$duty_Person=$rw->duty_Person;
$status=$rw->status;
$complete=$rw->complete;
//$PurchaseDate=$rw->PurchaseDate;
//$centre=$rw->centre;
//$company=$rw->company;
?>
echo $No; ?>
echo $centre; ?>
echo $report_no; ?>
echo $received_by; ?>
echo $date; ?>
echo $mode; ?>
echo $source; ?>
echo $s_name; ?>
echo $s_phone; ?>
echo $event; ?>
echo $road; ?>
echo $location; ?>
echo $duty_Person; ?>
echo $status; ?>
echo $complete; ?>
$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;
//}
?>