/home/mip/public_html_/old_mip/home/sqloption.php
<?php
require_once("../func-select.php");
$db = db_connect();
$what = isset($_GET['what']) ? $_GET['what'] : '';
switch ($what) {
case 'jobview':
$job = getdata_one("*","web_jobs","webjob_id",$id);
$arrayjob = array(
'position_id' => getname($job['position_id'],"positions","position_id"),
'country_id' => getname($job['country_id'],"country","country_id"),
'principal_id' => getname($job['principal_id'],"principals","principal_id"),
'gender' => ($job['gender']) ? $job['gender'] : 'Male or Female',
'min_age' => ($job['min_age']) ? $job['min_age'] : '',
'max_age' => ($job['max_age']) ? ' - '.$job['max_age'] : '',
'education' => ($job['min_reqmt']) ? $job['min_reqmt'] : 'Any',
'exp' => ($job['yrs_exp']) ? $job['yrs_exp'] : 'No Exp',
'jobdetail' => $job['job_details'],
'webjob_id' => $job['webjob_id'],
'showit' => $job['showit'],
'alias' => $job['alias']
);
echo json_encode($arrayjob);
break;
case 'newsview':
$news = getdata_one("*","web_announcements","id",$id);
$arrnews = array(
'title' => $news['title'],
'posting_date' => dateformat($news['posting_date']),
'announcement' => str_replace('<kbd>', '', $news['announcement'])
);
echo json_encode($arrnews);
break;
case 'loadPosition':
$position = getdata("select * from positions where category_id='".$category_id."' and category_id!='0' order by name");
echo json_encode($position);
break;
case 'education':
$education = getdata_one("*","web_education","id",$id);
$arraueducation = array(
'education' => $education['education'],
'from_date' => $education['from_date'],
'to_date' => $education['to_date'],
'school' => $education['school'],
'course' => $education['course'],
'id' => $education['id']
);
echo json_encode($arraueducation);
break;
case 'employment':
$employment = getdata_one("*","web_employment","id",$id);
$arremployment = array(
'company' => $employment['company'],
'address' => $employment['address'],
'position' => $employment['position'],
'from_date' => ($employment['from_date']!='0000-00-00') ? date('m/Y', strtotime($employment['from_date'])) : '',
'to_date' => ($employment['to_date']!='0000-00-00') ? date('m/Y', strtotime($employment['to_date'])) : '',
'job_desc' => $employment['job_desc'],
'reason_for_leaving' => $employment['reason_for_leaving'],
'id' => $employment['id']
);
echo json_encode($arremployment);
break;
case 'training':
$training = getdata_one("*","web_training","training_id",$id);
$arrtraining = array(
'title' => $training['title'],
'center' => $training['center'],
'date' => ($training['date']!='0000-00-00') ? date('m/d/Y', strtotime($training['date'])) : '',
'remarks' => $training['remarks'],
'id' => $training['training_id']
);
echo json_encode($arrtraining);
break;
case 'document':
$document = getdata_one("*","web_doc_library","id",$id);
$arrdocument = array(
'doc_name' => $document['doc_name'],
'type_id' => $document['type_id'],
'doc_file' => $document['doc_file'],
'applicant_id' => $document['applicant_id'],
'id' => $document['id']
);
echo json_encode($arrdocument);
break;
}