Post a Job
[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 “
Hiring and concerned about the cost of training a new employee? “; echo “Wanting to ensure the training is thorough? “; |
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 “
echo “ “; “; “; |
Contracts can usually be signed within a week and every effort is made to keep paperwork to a minimum. “; |
If you answered yes to the questions above, please call Andrea Gilfillan at 250-334-3119 for further details. “; |
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.