function check($username, $password) { $q = "select * from er_login where username='******'and password='******'"; $ob = new dbase(); $res = $ob->execute($q); if (mysqli_num_rows($res) > 0) { $r = mysqli_fetch_array($res); $_SESSION['userid'] = $r['login_id']; if ($r['type'] == 1) { echo '<script>window.location="Admin/AdminHome.php";</script>'; //header("location:../Admin/AdminHome.php"); } if ($r['type'] == 2) { echo '<script>window.location="Company/CompanyHome.php";</script>'; //header("location:../Company/CompanyHome.php"); } if ($r['type'] == 3) { echo '<script>window.location="seeker/SeekerHome.php";</script>'; //header("location:../seeker/SeekerHome.php"); } //return $n=1; } else { $_SESSION['error'] = "Invalid Username or Password"; echo '<script>window.location="index.php";</script>'; } }
function select_qualification() { $qry = "select * from er_education"; $ob = new dbase(); return $ob->execute($qry); }
function update_seeker($full_name, $mobile_number, $experience, $skill, $education, $master_education, $certification, $id) { echo $qry = "update er_seeker set full_name='{$full_name}', mobile_number={$mobile_number},`experience`='{$experience}',`skill`='{$skill}', `education`='{$education}',`master_education`={$master_education},`certification`='{$certification}' where login_id={$id}"; $ob = new dbase(); $ob->execute($qry); }
function update_company($first_name, $last_name, $designation, $contact_no, $company_id) { echo $q = "update er_company set first_name='{$first_name}',last_name='{$last_name}',designation='{$designation}',contact_number='{$contact_no}' where login_id={$company_id}"; $ob = new dbase(); return $ob->execute($q); }
function applycheck($user_id, $vacancy_id) { $qry = "select * from er_applay where vacancy_id={$vacancy_id} and user_id={$user_id} "; $ob = new dbase(); $res = $ob->execute($qry); if ($res) { return 1; } else { return 0; } }
function delete_location($id) { $qry = "delete from er_location where id={$id}"; $ob = new dbase(); return $ob->execute($qry); }