ajgkqsldxvkqsldkqs azelfkqsmkqsmlkdqsmld azmlekdqmskdmlqskd nkldsfkqsmldkqsmdmlskd decrypt($_GET['id']); $code = $mcrypt->decrypt($_GET['job']); /* Fetch the information */ $con = db_connect(); $sql = session($con,$session); $total = 0; $message = ""; $candidates = array(); 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']; $latitude = $row['latitude']; $longitude = $row['longitude']; } $sql = job_candidates($con,$latitude,$longitude,$code); if(db_rows($con,$sql)>0){ $query = mysqli_query($con,$sql); while($row=mysqli_fetch_array($query)){ $name = $row['name']; $pic = $row['picture']; if(empty($pic)){ $pic = "default.jpg"; } $pic = pic_url($pic); $phone = $row['phone']; $profile = $row['profile']; $cv = cv_url($row['cv']); $id = $row['id']; array_push($candidates,array("name"=>$mcrypt->encrypt($name), "pic"=>$mcrypt->encrypt($pic),"phone"=>$mcrypt->encrypt($phone), "profile"=>$mcrypt->encrypt($profile), "cv"=>$mcrypt->encrypt($cv), "userid"=>$mcrypt->encrypt($id))); } }else{ $message = "No candidate on record."; } }else{ $message = "You have no right to this content"; } echo json_encode(array("candidates"=>$candidates,"message"=>$mcrypt->encrypt($message),"sql"=>$sql)); db_close($con); } ?>