prepare("select * from genpin where (pins =:pn)") ;
$cke->bindparam(":pn",$pin) ;
$cke->execute() ;
if($cke->rowcount() == 1)
{
?>
prepare("select * from genpin where (regno =:rg)") ;
$cker->bindparam(":rg",$rg) ;
$cker->execute() ;
if($cker->rowcount() == 1)
{
?>
prepare("insert into genpin(regno,enno,pins,admin) values(:a,:b,:c,:d)") ;
$insert->bindparam(":a",$rg) ;
$insert->bindparam(":b",$eno) ;
$insert->bindparam(":c",$pin) ;
$insert->bindparam(":d",$aduser) ;
if($insert->execute())
{
?>
prepare("SELECT COUNT(*) FROM genpin" . $search_condition);
foreach ($search_params as $key => &$val) {
$count_query->bindParam($key, $val);
}
$count_query->execute();
$total_records = $count_query->fetchColumn();
$total_pages = ceil($total_records / $records_per_page);
// Get records for current page
if($_SESSION['lv'] == 'MAJOR ADMIN')
{
$query = $DBcon->prepare("SELECT * FROM genpin" . $search_condition . " ORDER BY sn DESC LIMIT :offset, :records_per_page");
foreach ($search_params as $key => &$val) {
$query->bindParam($key, $val);
}
$query->bindParam(':offset', $offset, PDO::PARAM_INT);
$query->bindParam(':records_per_page', $records_per_page, PDO::PARAM_INT);
$query->execute();
$records = $query->fetchAll(PDO::FETCH_ASSOC);
}
// Get records for current page
if($_SESSION['lv'] == 'MINOR ADMIN')
{
$query = $DBcon->prepare("SELECT * FROM genpin where admin =:um" . $search_condition . " ORDER BY sn DESC LIMIT :offset, :records_per_page");
foreach ($search_params as $key => &$val) {
$query->bindParam($key, $val);
}
$query->bindParam(':offset', $offset, PDO::PARAM_INT);
$query->bindParam(':records_per_page', $records_per_page, PDO::PARAM_INT);
$query->bindParam(':um',$aduser);
$query->execute();
$records = $query->fetchAll(PDO::FETCH_ASSOC);
}
?>
Admin