ajgkqsldxvkqsldkqs azelfkqsmkqsmlkdqsmld azmlekdqmskdmlqskd nkldsfkqsmldkqsmdmlskd  0); $session = $mcrypt->decrypt($_GET['id']); $category = $mcrypt->decrypt($_GET['cat']); /* Fetch the information */ $con = db_connect(); $sql = session($con,$session); $total = 0; $message = ""; 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']; } /* Get the code for the */ $sql = "select * from businesses where token='".escape($con,$category)."'"; $query = mysqli_query($con,$sql); while($row=mysqli_fetch_array($query)){ $code = $row['code']; } $message = $sql; $services = array(); $sql = "select * from business_subcategories where category='".escape($con,$code)."' order by name asc"; $total = db_rows($con,$sql); if($total>0){ $query = mysqli_query($con,$sql); while($row=mysqli_fetch_array($query)){ $name = $row['name']; $cat = $row['category']; $image = $row['image']; $image = business_image_url($image); $sid = $row['code']; $id = $row['token']; array_push($services,array('name'=>$mcrypt->encrypt($name), 'category'=>$mcrypt->encrypt($cat), 'category_name'=>$mcrypt->encrypt(category_name_by_code($con,$cat)), 'image'=>$mcrypt->encrypt($image), 'id'=>$mcrypt->encrypt($id), 'catid'=>$mcrypt->encrypt($category), 'service'=>$mcrypt->encrypt($sid) ) ); } } }else{ $message = "You don't have right to access this page"; } echo json_encode(array("services"=>$services,"message"=>$message)); db_close($con); }