include_once "accesscontrol.php"; /*$q1 = "select plan, JS_number, JP_number from job_employer_info where ename = \"$ename\" "; $r1 = mysql_query($q1) or die(mysql_error()); $a1 = mysql_fetch_array($r1); */ //$a11 = $a1[JP_number]; if(isset($submit) && $submit == 'Post this job') { $q2 = "select * from job_employer_info where ename = \"$ename\" "; $r2 = mysql_query($q2) or die(mysql_error()); $a2 = mysql_fetch_array($r2); if (is_array($JobCategory)) { $JobStr = implode("," , $JobCategory); } $qc = "select job_id from job_post order by job_id desc"; $rc = mysql_query($qc) or die(mysql_error()); $ac = mysql_fetch_array($rc); $job_id = $ac[0] + 1; $position = strip_tags($position); $description = strip_tags($description); $EXday = date('d', mktime(0,0,0,0, date("d") + $_POST["exdays1"], 0)); $EXmonth = date('m', mktime(0,0,0, date("m"), date("d") + $_POST["exdays1"], 0)); $EXyear = date('Y', mktime(0,0,0,date("m") ,date("d") + $_POST["exdays1"], date("Y"))); $q3 = "insert into job_post set job_id = \"$job_id\", ename = \"$ename\", CompanyCountry = \"$a2[CompanyCountry]\", CompanyState = \"$a2[CompanyState]\", Company = \"$a2[CompanyName]\", position = \"$position\", JobCategory = \"$JobStr\", description = \"$description\", j_target = \"$j_target\", salary = \"$salary\", s_period = \"$s_period\", EXmonth = \"$EXmonth\", EXday = \"$EXday\", EXyear = \"$EXyear\" "; $r3 = mysql_query($q3) or die(mysql_error()); //$a11 = $a11 - 1; //$q4 = "update job_employer_info set JP_number = \"$a11\" where ename = \"$ename\" "; //$r4 = mysql_query($q4) or die(mysql_error()); $to = $a2['CompanyEmail']; $subject = "Your Job post at $url"; $message = "This is an automate sent copy of your Job post.\n\n Details:\n Job ID# $job_id \n Position: $position \n Category: $JobStr \n Description: $description \n Target: $j_target \n Salary: $salary/$s_period \n Expire date: $EXmonth/$EXday/$EXyear\n\n\n To edit or delete this job, click here: $url/employers/DeleteJob.php "; $from = "From: $site_name <$aset[ContactEmail]>"; mail($to, $subject, $message, $from); echo "
To post a job, use the form below: |
|
| Position: | |
| Job Category:
|
|
| Description: | |
| Target: | |
| Salary: | |
| This offer expire after: | days. |
| |
|