| S/N |
Card Id |
Date |
Surname |
Othernames |
Age |
Service |
Status |
'$year' ";
$param = array();
$param['worker_id'] = getCookie("userid");
if(isset($_POST['search']))
{
$searchtext = $_POST['search'];
$status = $_POST['status'];
$age = $_POST['age'];
$datefrom = $_POST['datefrom'];
$dateto = $_POST['dateto'];
if(strlen(trim($searchtext)) > 0)
{
$sql .= " AND (`surname` LIKE :surname OR `firstname` LIKE :firstname OR `othernames` LIKE :othernames OR `email` LIKE :email OR `phone` LIKE :phone OR `state` LIKE :state OR `occupation` LIKE :occupation)";
$param[":surname"] = "%$searchtext%";
$param[":othernames"] = "%$searchtext%";
$param[":firstname"] = "%$searchtext%";
$param[":email"] = "%$searchtext%";
$param[":phone"] = "%$searchtext%";
$param[":state"] = "%$searchtext%";
$param[":occupation"] = "%$searchtext%";
}
if(strlen(trim($status)) > 0)
{
$sql .= " AND (`status` = :status)";
$param[":status"] = $status;
}
if(strlen(trim($age)) > 0)
{
$sql .= " AND (`age` = :age)";
$param[":age"] = $age;
}
if(strlen(trim($datefrom)) > 0)
{
$sql .= " AND (`carddate` >= :datefrom)";
$param[":datefrom"] = $datefrom;
}
if(strlen(trim($dateto)) > 0)
{
$sql .= " AND (`carddate` <= :dateto)";
$param[":dateto"] = $dateto;
}
}
else if(isset($_GET['status']) && $_GET['status'] != "")
{
$sql .= " AND (`status` = :status)";
$param[":status"] = $_GET['status'];
}
$myrec = $mycon->prepare($sql);
$myrec->execute($param);
$pos = 0;
while($row = $myrec->fetch(PDO::FETCH_ASSOC))
{
?>
|
|
|
|
|
|
|
|
|