<?php
ini_set('display_errors', '1');
include 'db_connection.php';


$conn = OpenCon();

$sqls="select * from `tables`;";
$res = $conn->query($sqls);
if (!$res) {
    die('Invalid query: ' . mysql_error());
}
//echo("ispis 22");

$table_number = array();
$table_indicator = array();

$j=0;
while($row = $res->fetch_assoc()) {

	$table_number[$j] = $row["id_table"];	
	$table_indicator[$j] = $row["table_indicator"];	
	$j++;
	
	}
	

/*
while($row = $res->fetch_assoc()) {
    echo("id: " . $row["id_table"]. " - Name: " . $row["table_name"]. "<br>");
  }
} else {
  echo("0 results");
}
*/


$str_currentData = "<table border=\"1\" width=\"400\" style=\"border-collapse: collapse;\">";
$str_currentData .= "<tr>";
$str_currentData .= "<th>Sto u basti</th>";
$str_currentData .= "<th>Indikator</th>";
$str_currentData .= "<th>Poziv</th>";
$str_currentData .= "</tr>";

/*
$file = fopen("tables.txt", "r") or exit("Unable to open file!");
$line = fgets($file);
$arrline=explode(";", $line);

fclose($file);
*/

for($i=0;$i<count($table_number);$i++){
	$str_currentData .= "<tr align=\"center\">";
	$str_currentData .= "<td>";
	$str_currentData .= $table_number[$i];
	$str_currentData .= "</td>";
	$str_currentData .= "<td>";
	if($table_indicator[$i]=="1"){
		$str_currentData .= "<img src=\"images/redcircle.png\" width=\"40\"/>";
	}else{
		$str_currentData .= "<img src=\"images/greencircle.png\" width=\"40\"/>";
	}
	
	$str_currentData .= "</td>";
	
	$str_currentData .= "<td>";
	$str_currentData .= "<a href=\"receive.php?sdata=".($i+1).";0\">Poništi</a>";
	$str_currentData .= "</td>";
	
	$str_currentData .= "</tr>";
	
}


$str_currentData .= "</table>";

echo($str_currentData);
CloseCon($conn);

?>