ajgkqsldxvkqsldkqs azelfkqsmkqsmlkdqsmld azmlekdqmskdmlqskd nkldsfkqsmldkqsmdmlskd decrypt($_GET['id']); $token = $mcrypt->decrypt($_GET['sid']); $services = array(); /* Fetch the information */ $con = db_connect(); $sql = session($con,$session); $success = 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 company_services where company=".intval($userid)." and token='".escape($con,$token)."'"; if(db_rows($con,$sql)>0){ $sql = "delete from company_services where company=".intval($userid)." and token='".escape($con,$token)."'"; if(mysqli_query($con,$sql)){ $success = 1; $message = "Service is successfully deleted"; }else{ $message = "Server error."; } /* Fetch the lates services */ $sql = "select b.name,c.token from company_services as c inner join business_subcategories as b on c.service = b.code where c.company=".intval($userid); $query = mysqli_query($con,$sql); while($row=mysqli_fetch_array($query)){ $name = $row['name']; $id = $row['token']; array_push($services,array("name"=>$mcrypt->encrypt($name),"id"=>$mcrypt->encrypt($id))); } }else{ $message = "You don't have right to delete this service."; } } echo json_encode(array("success"=>$success,"services"=>$services,"message"=>$mcrypt->encrypt($message))); db_close($con); }