prepare("select * from payroll where staff_id = '$username'") ; $chk->execute(); if($chk->rowcount() > 0) { $msg = "This Staff Record has been added before try another" ; } if(empty($msg)) { if($user->paylist($username,$pos,$bs,$ha,$ta,$wa,$ma,$oa,$gs)) { $msg = "Record Added Succefully" ; } } } ?> Admin Panel

PAYMENT SYSTEMS

prepare("select * from payroll") ; $gtcat->execute() ; $count = 0 ; while($row = $gtcat->fetch(pdo::FETCH_ASSOC)) { $count++ ; echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; echo "" ; ?> " ; } ?>
SN STAFF ID DESIGNATION BASIC SALARY GROSS SALARY ACTIONS
".$count."".$row['staff_id']."".$row['designation']."".$row['Basic_Salary']."".$row['Gross_salary']."EDITH|DELETE