<?php
require_once('dbconfig.php');
 
if($_SESSION){
   $user_id = $_SESSION['UserID'];
  
   $resultData = array();

   $WebSitesList = $db->prepare("SELECT * FROM WebSites WHERE UserID=:user_id");
   $WebSitesList->execute(array(":user_id"=>$user_id));
   while($userRow=$WebSitesList->fetch(PDO::FETCH_ASSOC)){
         $resultData[] = array(
                     $userRow['idsite'],
                     $userRow['main_url'],
                     $userRow['Index'],
                     $userRow['GlobalRank'].'/'.$userRow['CountryRank'],
                     $userRow['Dom']."/".$userRow['Trust'].'/'.$userRow['PA'].'/'.$userRow['DA'],
                     $userRow['ShareCount']."/".$userRow['LikeCount'].'/'.$userRow['CommentCount'],
                     $userRow['Plus'],
                     $userRow['Switter'],
                     $userRow['Winterest'],
                     $userRow['Wkontak'],
                     $userRow['Linked']
                     );
                             
   }

   $newData = array("aaData" => $resultData);

  echo json_encode($newData);

}
?>