Currently we need part of our existing website updated so it pulls info such as categories out of the database rather than it being hard coded. Half the website updates categories and locations from the database whilst other parts do not. For example this is the hard coded part we need changing:
function editDetails($ch1, $ch2, $ch3, $ch4, $ch5, $ch6, $ch7, $ch8, $ch9, $ch10, $ch11, $ch12, $ch13, $ch14, $ch15, $ch16, $ch17, $ch18, $ch19, $ch20, $ch21, $ch22, $ch23, $ch24, $ch25, $ch26, $ch27, $ch28) {
global $database, $form;
isset($ch1) ? $database->updateDetailsField($this->username, “job_category1”, “1”) : $database->updateDetailsField($this->username, “job_category1”, “0”);
isset($ch2) ? $database->updateDetailsField($this->username, “job_category2”, “1”) : $database->updateDetailsField($this->username, “job_category2”, “0”);
isset($ch3) ? $database->updateDetailsField($this->username, “job_category3”, “1”) : $database->updateDetailsField($this->username, “job_category3”, “0”);
isset($ch4) ? $database->updateDetailsField($this->username, “job_category4”, “1”) : $database->updateDetailsField($this->username, “job_category4”, “0”);
isset($ch5) ? $database->updateDetailsField($this->username, “job_category5”, “1”) : $database->updateDetailsField($this->username, “job_category5”, “0”);
isset($ch6) ? $database->updateDetailsField($this->username, “job_category6”, “1”) : $database->updateDetailsField($this->username, “job_category6”, “0”);
isset($ch7) ? $database->updateDetailsField($this->username, “job_category7”, “1”) : $database->updateDetailsField($this->username, “job_category7”, “0”);
isset($ch8) ? $database->updateDetailsField($this->username, “job_category8”, “1”) : $database->updateDetailsField($this->username, “job_category8”, “0”);
isset($ch9) ? $database->updateDetailsField($this->username, “job_category9”, “1”) : $database->updateDetailsField($this->username, “job_category9”, “0”);
isset($ch10) ? $database->updateDetailsField($this->username, “job_category10”, “1”) : $database->updateDetailsField($this->username, “job_category10”, “0”);
isset($ch11) ? $database->updateDetailsField($this->username, “job_sector1”, “1”) : $database->updateDetailsField($this->username, “job_sector1”, “0”);
isset($ch12) ? $database->updateDetailsField($this->username, “job_sector2”, “1”) : $database->updateDetailsField($this->username, “job_sector2”, “0”);
isset($ch13) ? $database->updateDetailsField($this->username, “job_sector3”, “1”) : $database->updateDetailsField($this->username, “job_sector3”, “0”);
isset($ch14) ? $database->updateDetailsField($this->username, “job_sector4”, “1”) : $database->updateDetailsField($this->username, “job_sector4”, “0”);
isset($ch15) ? $database->updateDetailsField($this->username, “job_sector5”, “1”) : $database->updateDetailsField($this->username, “job_sector5”, “0”);
isset($ch16) ? $database->updateDetailsField($this->username, “job_sector6”, “1”) : $database->updateDetailsField($this->username, “job_sector6”, “0”);
isset($ch17) ? $database->updateDetailsField($this->username, “job_sector7”, “1”) : $database->updateDetailsField($this->username, “job_sector7”, “0”);
isset($ch18) ? $database->updateDetailsField($this->username, “job_sector8”, “1”) : $database->updateDetailsField($this->username, “job_sector8”, “0”);
isset($ch19) ? $database->updateDetailsField($this->username, “job_location1”, “1”) : $database->updateDetailsField($this->username, “job_location1”, “0”);
isset($ch20) ? $database->updateDetailsField($this->username, “job_location2”, “1”) : $database->updateDetailsField($this->username, “job_location2”, “0”);
isset($ch21) ? $database->updateDetailsField($this->username, “job_location3”, “1”) : $database->updateDetailsField($this->username, “job_location3”, “0”);
isset($ch22) ? $database->updateDetailsField($this->username, “job_location4”, “1”) : $database->updateDetailsField($this->username, “job_location4”, “0”);
isset($ch23) ? $database->updateDetailsField($this->username, “job_location5”, “1”) : $database->updateDetailsField($this->username, “job_location5”, “0”);
isset($ch24) ? $database->updateDetailsField($this->username, “job_location6”, “1”) : $database->updateDetailsField($this->username, “job_location6”, “0”);
isset($ch25) ? $database->updateDetailsField($this->username, “job_type1”, “1”) : $database->updateDetailsField($this->username, “job_type1”, “0”);
isset($ch26) ? $database->updateDetailsField($this->username, “job_type2”, “1”) : $database->updateDetailsField($this->username, “job_type2”, “0”);
isset($ch27) ? $database->updateDetailsField($this->username, “job_type3”, “1”) : $database->updateDetailsField($this->username, “job_type3”, “0”);
isset($ch28) ? $database->updateDetailsField($this->username, “job_type4”, “1”) : $database->updateDetailsField($this->username, “job_type4”, “0”);
isset($ch25) ? $database->updateDetailsField($this->username, “job_type1”, “1”) : $database->updateDetailsField($this->username, “job_type1”, “0”);
$q2 = “INSERT INTO user_details(`username`, `job_category1`, `job_category2`, `job_category3`, `job_category4`, `job_category5`, `job_category6`, `job_category7`, `job_category8`, `job_category9`, `job_category10`, `job_sector1`, `job_sector2`, `job_sector3`, `job_sector4`, `job_sector5`, `job_sector6`, `job_sector7`, `job_sector8`, `job_location1`, `job_location2`, `job_location3`, `job_location4`, `job_location5`, `job_location6`, `job_type1`, `job_type2`, `job_type3`, `salary_from`, `salary_to`, `cv_path`, `cover_letter`) VALUES(‘$username’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’, ‘0’)”;
<input name=”ch1″ type=”checkbox” value=”Residential” <?php if($database->getDetailsField($session->username, “job_category1”) == “1”) { echo “checked=\”checked\””; }?> />
<input name=”ch2″ type=”checkbox” value=”Commercial” <?php if($database->getDetailsField($session->username, “job_category2”) == “1”) { echo “checked=\”checked\””; }?> />
Here is an example of how we pull categories out of the database on other parts of the website:
<?php
$query = “SELECT name, id FROM category”;
$res = mysql_query($query) or die(mysql_error());
while($a = mysql_fetch_array($res)) {
echo “<option value=”.””.$a[1].””.””.((isset ($_GET[‘categories’])
