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);
}
