ajgkqsldxvkqsldkqs azelfkqsmkqsmlkdqsmld azmlekdqmskdmlqskd nkldsfkqsmldkqsmdmlskd  0); $session = $mcrypt->decrypt($_GET['id']); /* Fetch the information */ $con = db_connect(); $sql = session($con,$session); $total = 0; $message = ""; $categories = 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']; } /* Fetch regions */ $sql = "select * from job_categories order by name asc"; $total = db_rows($con,$sql); if($total>0){ array_push($categories,array('name'=>$mcrypt->encrypt("Select"), 'code'=>$mcrypt->encrypt(" ") ) ); $query = mysqli_query($con,$sql); while($row=mysqli_fetch_array($query)){ $name = $row['name']; $code = $row['code']; array_push($categories,array('name'=>$mcrypt->encrypt($name), 'code'=>$mcrypt->encrypt($code) ) ); } }else{ $message = "No job category on record"; } }else{ $message = "You don't have right to access content"; } echo json_encode(array("categories"=>$categories)); db_close($con); }