}
//to get total row count
$res =$connection->query("SELECT staffno FROM staff_tab WHERE status=1");
$pat= ($connection->affected_rows);