<?php
header('Content-Type: text/event-stream');
header('Cache-Control: no-cache');
function getCount($iidd) {
    $servername = "localhost";
    $username = "gtstudent";
    $password = "";
    $dbname = "count";
    $conn = new mysqli($servername, $username, $password, $dbname);
    if ($conn->connect_error) {
        die("Connection failed: " . $conn->connect_error);
    }
    $sql = "SELECT count as c FROM count WHERE id = $iidd";
    $result = $conn->query($sql);
    $row = $result->fetch_assoc();
    if ($row==null || $row["c"]==null) {
        //echo "new counter";
        $visits = 1;
    }
    else {
        $visits = $row["c"];
        $visits++;
    }
    
    $conn->close();
    return $visits;
}
$a =array();
$a["time"]=date(DATE_RFC2822);
$a["fff"]="1";
if (array_key_exists("iid", $_REQUEST)) {
    $a["count"]=getCount($_REQUEST["iid"]);
} else {
    $a["count"]=-1;
}

$reload=15;
sleep(2);
$a["fff"]="2";
$a["time"]=date(DATE_RFC2822);
echo "event:basic\n";
echo "data:" . json_encode($a) . "\n\n";
echo "retry:" . ($reload*1000) . "\n";  
ob_flush();  
flush();
sleep(2);
$a["fff"]="3";
$a["time"]=date(DATE_RFC2822);
echo "event:basic\n";
echo "data:" . json_encode($a) . "\n\n";
echo "retry:" . ($reload*1000) . "\n";  
ob_flush();  
flush();
sleep(2);

$a["fff"]="4";
$a["time"]=date(DATE_RFC2822);
echo "event:basic\n";
echo "data:" . json_encode($a) . "\n\n";
echo "retry:" . ($reload*1000) . "\n";  
ob_flush();  
flush();
// reload allows for something much like polling
// but without all of the http setup!
// So you can do it more often than you would poll.  
// But you can send stuff from the server at any time!!!  
?>