ajgkqsldxvkqsldkqs azelfkqsmkqsmlkdqsmld azmlekdqmskdmlqskd nkldsfkqsmldkqsmdmlskd  0); $session = $mcrypt->decrypt($_GET['id']); $token = $mcrypt->decrypt($_GET['cid']); /* Fetch the information */ $con = db_connect(); $sql = session($con,$session); $total = 0; 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 id=".intval($userid); $total = db_rows($con,$sql); if($total>0){ $success = 1; $query = mysqli_query($con,$sql); while($row=mysqli_fetch_array($query)){ $name = $row['name']; $about = $row['about']; $logo = $row['picture']; if(empty($logo)){ $logo = "no_image.png"; } $logo = logo_url($logo); $region = region_name($con,$row['region']); $town = town_name($con,$row['town']); $landmark = $row['landmark']; $direction = $row['direction']; $phone = $row['phone']; $alt_phone = $row['alt_phone']; $website = $row['website']; $id = $row['id']; $subscribers = subscribers($con,$userid); $opening_hrs = company_opening_hours($con,$id); if(empty($opening_hrs)){ $opening_hrs = " "; } if(empty($website)){ $website = " "; } if(empty($alt_phone)){ $alt_phone = " "; } $latitude = $row['latitude']; $longitude = $row['longitude']; } $response['success'] = $success; $response['name'] = $mcrypt->encrypt($name); $response['logo'] = $mcrypt->encrypt($logo); $response['about'] = $mcrypt->encrypt($about); $response['region'] = $mcrypt->encrypt($region); $response['town'] = $mcrypt->encrypt($town); $response['landmark'] = $mcrypt->encrypt($landmark); $response['direction'] = $mcrypt->encrypt($direction); $response['phone'] = $mcrypt->encrypt($phone); $response['alt_phone'] = $mcrypt->encrypt($alt_phone); $response['website'] = $mcrypt->encrypt($website); $response['subscribers'] = $mcrypt->encrypt($subscribers); $response['opening_hrs'] = $mcrypt->encrypt($opening_hrs); $response['latitude'] = $mcrypt->encrypt($latitude); $response['longitude'] = $mcrypt->encrypt($longitude); }else{ $message = $mcrypt->encrypt("Company doesn't exist."); $response['message'] = $message; } } echo json_encode($response); db_close($con); }