Post a Job – The JobShop

[insert_php]
//db connect
// Create database connection
// Web
$connection = mysql_connect(“localhost”, “ceasuser_dbadmin”, “L3@rn!ng”);
If (!$connection) {
die(“Database connection failed: ” . mysql_error());
}
// Select database to use
//Web
$db_select = mysql_select_db(“ceasuser_ceasdata”,$connection);
If (!$db_select) {
die(“Database selection failed: ” . mysql_error());
}
//end dbconnect

If ($_POST[“Mode”] == “Insert”) {
$errors = array();
$required_fields = array(‘Position’, ‘JobCategory’, ‘Company’, ‘Contact’, ‘Phone’);
ForEach($required_fields as $fieldname) {
If (!isset($_POST[$fieldname]) || empty($_POST[$fieldname])) {
$errors[] = $fieldname;}
}
If (!empty($errors)){
echo ”

Please review the following required fields:
“;
ForEach($errors as $error) {
echo ” – ” . $error . ”
“;
}
echo “

“;
}
ElseIf (empty($errors)) {
//******NOTE: There is a bracket to uncomment near the end of the PHP code that ends this ElseIf
//form data valid, add to db
$Position = mysql_real_escape_string($_POST[“Position”]);
//echo $Position;
$Category = mysql_real_escape_string($_POST[“JobCategory”]);
$StartDate = mysql_real_escape_string($_POST[“StartDate”]);
//$MySqlStartDate = MySqlDate($StartDate);
$PostedDate = Date(“Ymd”);
$Wage = mysql_real_escape_string($_POST[“Wage”]);
//$WageComment = mysql_real_escape_string($_POST[“WageComment”]);
$Hours = mysql_real_escape_string($_POST[“Hours”]);
$Duties = mysql_real_escape_string($_POST[“Duties”]);
$Requirements = mysql_real_escape_string($_POST[“Requirements”]);
$Company = mysql_real_escape_string($_POST[“Company”]);
$Contact = mysql_real_escape_string($_POST[“Contact”]);
$Phone = mysql_real_escape_string($_POST[“Phone”]);
If (!empty($Phone)){
$CheckBoxDisplayPhone = $_POST[“CheckBoxDisplayPhone”];
}
$Fax = mysql_real_escape_string($_POST[“Fax”]);
$Email = mysql_real_escape_string($_POST[“Email”]);
$Address = mysql_real_escape_string($_POST[“Address”]);
$Notes = mysql_real_escape_string($_POST[“Notes”]);
$CheckBoxPhone = $_POST[“CheckBoxPhone”];
$CheckBoxFax = $_POST[“CheckBoxFax”];
$CheckBoxEmail = $_POST[“CheckBoxEmail”];
$CheckBoxInPerson = $_POST[“CheckBoxInPerson”];
$CheckBoxMail = $_POST[“CheckBoxMail”];
$CheckBoxDisplayCompany = $_POST[“CheckBoxDisplayCompany”];
$CheckBoxDisplayPhone = $_POST[“CheckBoxDisplayPhone”];
$sql = “INSERT INTO jobbank (Position, Category, StartDate, PostedDate, Wage, Hours, Duties, Requirements, Company, Contact, Phone, Fax, Email, Address, Notes, ApplyByPhone, ApplyByFax, ApplyByEmail, ApplyInPerson, ApplyByMail, DisplayCompany, DisplayPhone) VALUES (‘$Position ‘, ‘$Category’, ‘$StartDate’, ‘$PostedDate’, ‘$Wage’, ‘$Hours’, ‘$Duties’, ‘$Requirements’, ‘$Company’, ‘$Contact’, ‘$Phone’, ‘$Fax’, ‘$Email’, ‘$Address’, ‘$Notes’, ‘$CheckBoxPhone’, ‘$CheckBoxFax’, ‘$CheckBoxEmail’, ‘$CheckBoxInPerson’, ‘$CheckBoxMail’, ‘$CheckBoxDisplayCompany’, ‘$CheckBoxDisplayPhone’)”;
mysql_query($sql, $connection);
echo “Thanks for your job post!

Jobs will not be available to view on the Job Board until they have been approved. During the work week this should take less than 24 hours. If you are reading this message you do NOT need to click the Post button again!

“;
echo “

“;
echo “Create Job Listing

This is a local job bank. Only jobs in the Comox Valley and surrounding area, camp jobs or jobs with a high enough salary to justify a commute will be accepted. Postings must be business related. Jobs from private individuals will not be posted. We do not post jobs where payment is based on piecework.

Apply By:
Phone
Fax
Email
In Person
Mail – Check all that apply

Settings:
Display Company?

Hiring and concerned about the cost of training a new employee?
“;
echo “Wanting to ensure the training is thorough?

“;
echo “

The Wage Subsidy program could help your business.

The Wage Subsidy program subsidizes the wages of a new employee to offset the cost of training. Currently the subsidy is up to 50% of the hourly rate of pay for up to 24 weeks.

“;
echo “The Wage Subsidy Program:
“;
echo “

helps employers to provide quality on-the-job training to new employees

“;
echo “

supports Job Seekers to learn while they earn.

“;
echo “

Contracts can usually be signed within a week and every effort is made to keep paperwork to a minimum.

“;
echo “Check to see if your business meets the basic qualifications for the program:
“;
echo “Training and supervision will be available>
“;
echo “The position is 35 hrs a week
“;
echo “Applicant has not worked for you before and is not a relative or close family member
“;
echo “This is a permanent position
“;
echo “Hiring will not replace an existing employee who is on lay-off from this position
“;
echo “Your company is registered and has been in business for at least one year

If you answered yes to the questions above, please call Andrea Gilfillan at 250-334-3119 for further details.

“;
echo “ Important Wage subsidy agreements MUST be in place before a new employee starts work!