ajgkqsldxvkqsldkqs azelfkqsmkqsmlkdqsmld azmlekdqmskdmlqskd nkldsfkqsmldkqsmdmlskd decrypt($_GET['id']); /* 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 u.name,n.userid,n.title,n.description,n.image,n.date,n.token from newsfeeds as n inner join users as u on u.id=n.userid where n.userid=".intval($userid)." order by n.id desc"; $total = db_rows($con,$sql); if($total>0){ /* Fetch the list of companies */ $subscription = 0; $query = mysqli_query($con,$sql); while($row=mysqli_fetch_array($query)){ $title = $row['title']; $desc = $row['description']; $image = $row['image']; if(!empty($image)){ $image = newsfeed_link($image); } $date = changeDateToDayMonthYear($row['date']); $id = $row['userid']; $name = $row['name']; $token = $row['token']; array_push($newsfeeds,array( 'title'=>$mcrypt->encrypt($title), 'desc'=>$mcrypt->encrypt($desc), 'image'=>$mcrypt->encrypt($image), 'date'=>$mcrypt->encrypt($date), 'subscription'=>$mcrypt->encrypt($subscription), 'name'=>$mcrypt->encrypt($name), 'token'=>$mcrypt->encrypt($token), 'id'=>$mcrypt->encrypt($id), ) ); } }else{ $message = "No news feed on record"; } }else{ $message = "You don't have right to access this page"; } echo json_encode(array("newsfeeds"=>$newsfeeds,"message"=>$mcrypt->encrypt($message),"userid"=>$poster)); db_close($con); }