'; echo '

Jobs Management System

'; // Get actions to be performed $edit = $_POST['edit']; //user wants to edit job with $id $delete = $_POST['delete']; //user wants to permanently delete job with $id $add = $_POST['add']; //user wants to add new job, so present an empty form $addpost = $_POST['addpost']; //append new record user has added $editpost = $_POST['editpost']; //update existing job $id with new values // NOTE: FOLLOWING ITEMS ARE GET, not POST $sortby = $_GET['sortby']; //column heading to sort by when listing jobs //Get data values $id =$_POST['id']; $dateposted =$_POST['dateposted']; $datemodified =$_POST['datemodified']; $position =trim($_POST['position']); $city =trim($_POST['city']); $state =trim($_POST['state']); $country =trim($_POST['country']); $salary =trim($_POST['salary']); $contactname =trim($_POST['contactname']); $email =trim($_POST['email']); $contactphone =trim($_POST['contactphone']); $description =stripslashes(trim($_POST['description'])); $requirements =stripslashes(trim($_POST['requirements'])); $hidden =$_POST['hidden']; // Arrays $states_arr = array('Alabama', 'Alaska', 'Arizona', 'Arkansas', 'California', 'Colorado', 'Connecticut', 'Delaware', 'District of Columbia', 'Florida', 'Georgia', 'Hawaii', 'Idaho', 'Illinois', 'Indiana', 'Iowa', 'Kansas', 'Kentucky', 'Louisiana', 'Maine', 'Montana', 'Nebraska', 'Nevada', 'New Hampshire', 'New Jersey', 'New Mexico', 'New York', 'North Carolina', 'North Dakota', 'Ohio', 'Oklahoma', 'Oregon', 'Maryland', 'Massachusetts', 'Michigan', 'Minnesota', 'Mississippi', 'Missouri', 'Pennsylvania', 'Rhode Island', 'South Carolina', 'South Dakota', 'Tennessee', 'Texas', 'Utah', 'Vermont', 'Virginia', 'Washington', 'West Virginia', 'Wisconsin', 'Wyoming'); $country_arr = array('United States','Canada','Afghanistan','Albania','Algeria','Andorra','Angola','Antigua & Deps','Argentina','Armenia','Australia','Austria','Azerbaijan','Bahamas','Bahrain','Bangladesh','Barbados','Belarus','Belgium','Belize','Benin','Bhutan','Bolivia','Bosnia Herzegovina','Botswana','Brazil','Brunei','Bulgaria','Burkina','Burundi','Cambodia','Cameroon','Canada','Cape Verdi','Central African Rep','Chad','Chile','China','Columbia','Comoros','Congo','Congo {Democratic Rep}','Costa Rica','Croatia','Cuba','Cyprus','Czech Republic','Denmark','Djibouti','Dominica','Dominican Republic','East Timor','Ecuador','Egypt','El Salvador','Equatorial Guinea','Eritrea','Estonia','Ethiopia','Fiji','Finland','France','Gabon','Gambia','Georgia','Germany','Ghana','Greece','Greneda','Guatemala','Guinea','Guinea-Bissau','Guyana','Haiti','Honduras','Hungary','Iceland','India','Indonesia','Iran','Iraq','Ireland {Republic}','Israel','Italy','Ivory Coast','Jamaica','Japan','Jordan','Kazakhstan','Kenya','Kiribati','Korea North','Korea South','Kuwait','Kyrgyzstan','Laos','Latvia','Lebanon','Lesotho','Liberia','Libya','Liechtenstein','Lithuania','Luxembourg','Macedonia','Madagascar','Malawi','Malaysia','Maldives','Mali','Malta','Marshall Islands','Mauritania','Mauritius','Mexico','Micronesia','Moldova','Monaco','Mongolia','Morocco','Mozambique','Myanmar','{Burma}','Namibia','Narau','Nepal','Netherlands','New Zealand','Nicaragua','Niger','Nigeria','Norway','Oman','Pakistan','Palau','Panama','Papua New Guinea','Paraguay','Peru','Philippines','Poland','Portugal','Qatar','Romania','Russian Federation','Rwanda','St Kitts & Nevis','St Lucia','St Vincent & Grenadines','San Marino','Sao Tome & Principe','Saudi Arabia','Senegal','Seychelles','Sierra Leone','Singapore','Slovakia','Slovenia','Solomon Islands','Somalia','South Africa','Spain','Sri Lanka','Sudan','Suriname','Swaziland','Sweden','Switzerland','Syria','Taiwan','Tajikstan','Tanzania','Thailand','Togo','Tonga','Trinidad & Tobago','Tunisia','Turkey','Turkmenistan','Tuvalu','Uganda','Ukraine','United Arab Emirates','United Kingdom','Uruguay','Uzbekistan','Vanuatu','Vatican City','Venezuela','Vietnam','Western Samoa','Yemen','Yugoslavia','Zambia','Zimbabwe' ); // Choose what action to perform if (!empty($delete)) { // HANDLE DELETE FROM DATABASE $sql = "DELETE From Sheet1 where id = '" . $id . "'"; $result = @mysql_query( $sql); if (!$result) {exit('

Error performing query: ' . mysql_error() . '

');} echo '

The job has been deleted.

'; echo ''; } elseif (!empty($addpost) ) { // ADD NEW JOB INTO DATABASE $sql = 'INSERT INTO jobs(dateposted,datemodified,position,city,state,country,salary,contactname,email,contactphone,description,requirements,hidden) '; // Date Posted $sql .= " VALUES ('" . date("Y-m-d") . "',"; // Date Modified $sql .= 'NULL,'; // Position $sql .= "'" . mysql_real_escape_string ($position) . "',"; //City $sql .= "'" . mysql_real_escape_string ($city) . "',"; // State $sql .= "'" . mysql_real_escape_string ($state) . "',"; //Country $sql .= "'" . mysql_real_escape_string ($country) . "',"; // Salary $sql .= "'" . mysql_real_escape_string ($salary) . "',"; // Contact Name $sql .= "'" . mysql_real_escape_string ($contactname) . "',"; // email $sql .= "'" . mysql_real_escape_string ($email) . "',"; // Contact Phone $sql .= "'" . mysql_real_escape_string ($contactphone) . "',"; // Description $sql .= "'" . mysql_real_escape_string ($description) . "',"; // Requirements $sql .= "'" . mysql_real_escape_string ($requirements) . "',"; // Hidden $sql .= "'No')"; $result = @mysql_query( $sql); if (!$result) {exit('

Error performing query: ' . mysql_error() . '

');} echo '

' . $position . '
has been added.

'; echo ''; } elseif (!empty($editpost) ) { // EDIT EXISTING JOB IN DATABASE // data fields "id","dateposted","datemodified","position","city","state","country","salary","contactname","email","contactphone","description","requirements","hidden" $sql = 'UPADATE sheet1 SET '; // Date Posted $sql .= " dateposted = '" . $dateposted . "',"; // Date Modified $sql .= " datemodified = '" . date("Y-m-d") . "',"; // Position $sql .= " position = '" . mysql_real_escape_string ($position) . "',"; //City $sql .= " city = '" . mysql_real_escape_string ($city) . "',"; // State $sql .= " state = '" . mysql_real_escape_string ($state) . "',"; //Country $sql .= " country = '" . mysql_real_escape_string ($country) . "',"; // Salary $sql .= " salary = '" . mysql_real_escape_string ($salary) . "',"; // Contact Name $sql .= " contactname = '" . mysql_real_escape_string ($contactname) . "',"; // email $sql .= " email = '" . mysql_real_escape_string ($email) . "',"; // Contact Phone $sql .= " contactphone = '" . mysql_real_escape_string ($contactphone) . "',"; // Description $sql .= " description = '" . mysql_real_escape_string ($description) . "',"; // Requirements $sql .= " requirements = '" . mysql_real_escape_string ($requirements) . "',"; // Hidden $sql .= " hidden = '" . $hidden . "'"; $sql .= " WHERE id = " . $id ; $result = @mysql_query( $sql); if (!$result) {exit('

Error performing query: ' . mysql_error() . '

');} echo '

' . $position . '
has been updated.

'; echo ''; } elseif ((!empty($add)) || (!empty($edit)) ) { if (empty($add)) { $temp = 'Edit Existing Job'; $sql = "SELECT * From jobs WHERE id = " . $id; $result = @mysql_query( $sql); if (!$result) {exit('

Error performing query: ' . mysql_error() . '

');} while ($row = mysql_fetch_array($result)) { $dateposted =$row['dateposted']; if (!is_null($dateposted)) { $dateposted = date('Y-m-d', strtotime($dateposted)); } $datemodified =$row['datemodified']; if (!is_null($datemodified)) { $datemodified = date('Y-m-d', strtotime($datemodified)); } $position =$row['position']; $city =$row['city']; $state =$row['state']; $country =$row['country']; $salary =$row['salary']; $contactname =$row['contactname']; $email =$row['email']; $contactphone =$row['contactphone']; $description =$row['description']; $requirements =$row['requirements']; $hidden =$row['hidden']; } } else { $temp = 'Add New Job'; } // DISPLAY ADD NEW JOB FORM or Edit existing Jobs echo '

' . $temp . '

'; echo '

'; echo ''; // ID Hidden echo ''; echo ''; echo ''; // Position echo ''; // City echo ''; //State echo ''; // Country echo ''; // Salary echo ''; // Contact echo ''; // email echo ''; // Contact phone echo ''; // Job Description echo ''; // Job Requirements echo ''; // Hidden echo '

Position
City
State
Country
Salary
Contact
email
Contact Phone
Job Description	' . $description . '
Job Requirements	' . $requirements . '
Hidden		'; if (!empty($edit)) { $temp = 'Edit Existing Job'; echo ''; echo ''; } else { echo ''; echo ''; } echo ' Cancel '; echo '

'; } else { // DISPLAY THE LIST OF JOBS $sql = 'SELECT * From jobs ORDER BY '; if (empty($sortby)) { $sql .= 'dateposted'; } else { switch ($sortby) { case "position" : $sql .= 'position'; break; case "dateposted" : $sql .= 'dateposted, position'; break; case "datemodified" : $sql .= 'datemodified, position'; break; case "hidden" : $sql .= 'hidden, position'; break; } } echo ''; echo ''; echo ''; echo ''; $result = @mysql_query( $sql); if (!$result) {exit('

Error performing query: ' . mysql_error() . '

');} while ($row = mysql_fetch_array($result)) { $id = $row['id']; $dateposted =$row['dateposted']; if (!is_null($dateposted)) { $dateposted = date('Y-m-d', strtotime($dateposted)); } $datemodified =$row['datemodified']; if (!is_null($datemodified)) { $datemodified = date('Y-m-d', strtotime($datemodified)); } $position =$row['position']; $city =$row['city']; $state =$row['state']; $country =$row['country']; $salary =$row['salary']; $contactname =$row['contactname']; $email =$row['email']; $contactphone =$row['contactphone']; $description =$row['description']; $requirements =$row['requirements']; $hidden =$row['hidden']; echo ''; // Show action Buttons echo ''; } echo '

Position	Date Posted	Date Modified	Hidden	Action
' . $position . '	' . $dateposted . '	' . $datemodified . '	' . $hidden . '	'; echo ' '; echo ''; $confirmtext = 'Are you sure you want to delete job ' . $position .'?\nThis action can not be reversed.'; echo ' '; echo '
				'; echo ' '; echo ''; echo ' '; echo '

'; } ?>

Jobs Management System

The job has been deleted.

' . $position . ' has been added.

' . $position . ' has been updated.

' . $temp . '

' . $position . '
has been added.

' . $position . '
has been updated.