public function updateCandidateProfile($userID, $updatefiles) { $avaiFields = array("firstname", "lastname", "CandidateProfileID", "tagline", "overview", "minimumsalary", "maximumsalary", "CandidateSkillID", "SkillID", "keywords", "servicedescription"); $api = new PR_Api_Core_CandidateClass(); $listskill = $updatefiles["SkillID"]; //echo("tetst:");print_r($listskill);die(); // update table user $updateFields = array('firstname' => $updatefiles["firstname"], 'lastname' => $updatefiles["lastname"]); $criteria = "UserID = '{$userID}'"; PR_Database::update('user', $updateFields, $criteria); //update table candidate $candidateInfo = $api->getCandidateInfo($userID); if (count($candidateInfo) == 0) { return 0; } $candidateProfileID = $candidateInfo['CandidateProfileID']; $updateFields1 = array('tagline' => $updatefiles["tagline"], 'overview' => $updatefiles["overview"], 'minimumsalary' => $updatefiles["minimumsalary"], 'maximumsalary' => $updatefiles["maximumsalary"], 'keywords' => $updatefiles["keywords"], 'servicedescription' => $updatefiles["servicedescription"]); $criteria1 = "CandidateProfileID = '{$candidateProfileID}'"; PR_Database::update('candidate_profile', $updateFields1, $criteria1); $db = PR_Database::getInstance(); $select = $db->select(); $select->from('candidate_skill', array('*')); $select->where("CandidateProfileID = '{$candidateProfileID}'"); $records = PR_Database::fetchAll($select); if (empty($records) && count($records) > 0) { return -1; } $CandidateSkillID = $records[0]['CandidateProfileID']; $skillIDs = array(); foreach ($listskill as $Skills) { $skillIDs[] = $Skills["SkillID"]; } // echo("tetst:");print_r($skillIDs);die(); $api->saveCandidateSkills($userID, $CandidateSkillID, $skillIDs); }