getdetails.php

<?php
session_start();
include 'inc/checker.php';
include 'inc/config.php';

$pollid=$_GET['pollid'];
$userid=$_GET['userid'];

if($_SESSION['polllog']==true && $userid && $userid==$_SESSION['polluserid'])
{
  echo "[";
   if($pollid)
   {
   	   $query=$db->query("SELECT * FROM ".$subscript."polls WHERE pollid='$pollid'");

   	   if($db->numrows($query)>0){
   	   	 
         $result=$db->fetch($query);
     	   
         // First printing the main details : 

         $totalvotes=$db->numrows($db->query("SELECT * FROM ".$subscript."pollvotes WHERE pollid='$pollid'"));
     	   
     	   echo "{";
     	   echo '"title":"'.$result['title']."\",";
     	   echo '"options":'.$result['options'].",";
         echo '"totalvotes":'.$totalvotes.",";
         echo '"date_created":"'.$result['date_created'].'",';
         echo '"last_updated":"'.$result['updated'].'"';
     	   echo "},";

     	   // Now the voting results.

         $query1=$db->query("SELECT * FROM ".$subscript."pollvotes WHERE userid='$userid' AND pollid='$pollid'");

         if($db->numrows($query1)!=0){
            $vote=$db->fetch($query1);
            echo "{\"uservote\":".$vote['voteindex']."}";
         }
         else{
          echo "{\"uservote\":-1}";
         }
     }
   }
  echo "]";
}else{
  echo "Unauthorised.";
}
?>