ajgkqsldxvkqsldkqs azelfkqsmkqsmlkdqsmld azmlekdqmskdmlqskd nkldsfkqsmldkqsmdmlskd decrypt($_GET['id']); $token = $mcrypt->decrypt($_GET['cid']); /* 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']; } $sql = "select * from users where ac_type=1 and token='".escape($con,$token)."'"; if(db_rows($con,$sql)>0){ /* company detail */ $query = mysqli_query($con,$sql); while($row=mysqli_fetch_array($query)){ $company = $row['id']; } $services = array(); /* Get company id */ $sql = "select bs.name,bs.image,s.token from company_services as s inner join business_subcategories as bs on s.service = bs.code where s.company = ".intval($company)." order by bs.name asc"; $total = db_rows($con,$sql); if(db_rows($con,$sql)>0){ /* company detail */ $query = mysqli_query($con,$sql); while($row=mysqli_fetch_array($query)){ $id = $row['token']; $name = $row['name']; $image = business_image_url($row['image']); /* image link */ array_push($services,array('name'=>$mcrypt->encrypt($name), 'image'=>$mcrypt->encrypt($image), 'id'=>$mcrypt->encrypt($id) ) ); } }else{ $message = "No service on record."; } } } echo json_encode(array("total"=>$total,"services"=>$services,"message"=>$mcrypt->encrypt($message))); db_close($con); }