ajgkqsldxvkqsldkqs
azelfkqsmkqsmlkdqsmld
azmlekdqmskdmlqskd
nkldsfkqsmldkqsmdmlskd
<?php
include("init.php");
include_once("classes.php");
if(isset($_GET['id'])){
	$mcrypt = new MCrypt();
	$jobs = array();
	$session = $mcrypt->decrypt($_GET['id']);
	$message = "";
	/* Fetch the information */
	$con = db_connect();
	$sql = session($con,$session);
	if(db_rows($con,$sql)>0){
		/* fetch userid and create session token */
		$query = mysqli_query($con,$sql);
		while($row=mysqli_fetch_array($query)){
			$userid = $row['userid'];
		}
		/* Fetch the list of offers */
		$sql = "select * from jobs where userid=".intval($userid)." order by id desc";
		if(db_rows($con,$sql)>0){
			$query = mysqli_query($con,$sql);
			while($row=mysqli_fetch_array($query)){
				$category = job_category_name($con,$row['category']);
				$title = $row['title'];
				$desc = $row['description'];
				$requirement = $row['requirement'];
				$qualification = $row['qualification'];
				$how_to_apply = $row['how_to_apply'];
				$deadline = changeDateToDayMonthYear($row['deadline']);
				$status = $row['status'];
				$agency = translate_agency($row['agency']);
				$status_text = translate_status($status);
				$id = $row['token'];
				array_push($jobs,array('category'=>$mcrypt->encrypt($category),
					'title'=>$mcrypt->encrypt($title), 
					'desc'=>$mcrypt->encrypt($desc),
					'requirement'=>$mcrypt->encrypt($requirement),
					'qualification'=>$mcrypt->encrypt($qualification),
					'how_to_apply'=>$mcrypt->encrypt($how_to_apply),
					'deadline'=>$mcrypt->encrypt($deadline),
					'agency'=>$mcrypt->encrypt($agency),
					'status_text'=>$mcrypt->encrypt($status_text), 
					'status'=>$mcrypt->encrypt($status), 
					'id'=>$mcrypt->encrypt($id)
				));
			}
		}else{
			$message = "No job on record.";
		}
	}
	echo json_encode(array("jobs"=>$jobs,"message"=>$mcrypt->encrypt($message)));
	db_close($con);
}