Untitled

 <?php include "libchart/classes/libchart.php";
?>

<!DOCTYPE html>
<html>
<head>
	<title>Volby 2016</title>
	<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
	<link rel="stylesheet" href="style.css" />
</head>

<body>


<table>
		<tr>
			<td style='width: 30%;'><img class = 'newappIcon' src='images/newapp-icon.png'>
			</td>
			<td>
				<h1 id = "message"><?php echo "Volby 2016"; ?>
</h1>

			</td>
		</tr>
	</table>

	 <h1>volby</h1>

    <input type="button" onclick="window.open('db.php');" class="btn" value="Create table"></input>
	<input type="button" onclick="window.open('info.php');" class="btn" value="View PHP info"></input>

<?php


if(!$_ENV["VCAP_SERVICES"]){ //local dev
    $mysql_server_name = "127.0.0.1:3306";
    $mysql_username = "root";
    $mysql_password = "";
    $mysql_database = "test";
} else { //running in Bluemix
    $vcap_services = json_decode($_ENV["VCAP_SERVICES" ]);
    if($vcap_services->{'mysql-5.5'}){ //if "mysql" db service is bound to this application
        $db = $vcap_services->{'mysql-5.5'}[0]->credentials;
    }
    else if($vcap_services->{'cleardb'}){ //if cleardb mysql db service is bound to this application
        $db = $vcap_services->{'cleardb'}[0]->credentials;
    }
    else {
        echo "Error: No suitable MySQL database bound to the application. <br>";
        die();
    }
    $mysql_database = $db->name;
    $mysql_port=$db->port;
    $mysql_server_name =$db->hostname . ':' . $db->port;
    $mysql_username = $db->username;
    $mysql_password = $db->password;
}
//echo "Debug: " . $mysql_server_name . " " .  $mysql_username . " " .  $mysql_password . "\n";
$mysqli = new mysqli($mysql_server_name, $mysql_username, $mysql_password, $mysql_database);

if ($mysqli->connect_errno) {
    echo "Failed to connect to MySQL: (" . $mysqli->connect_errno . ") " . $mysqli->connect_error;
    die();
}

//insert
mysql_select_db($mysql_database,$mysqli);

$strsq0 = "INSERT INTO ACCESS_HISTORY ( BROWSER, IP_ADDRESS) VALUES
('" . $_SERVER['HTTP_USER_AGENT'] . "', '" . $_SERVER['REMOTE_ADDR'] . "');";
$result0 = mysql_query ( $strsq0 );
if ($result0) {
    echo "insert success!";
} else {
    echo "Cannot insert into the data table; check whether the table is created, or the database is active.";
}
$strsql = "select * from ACCESS_HISTORY ORDER BY ID DESC limit 100";

$result = mysql_db_query ( $mysql_database, $strsql, $con );
//end of insert
$mysqli_result=mysqli_query($mysqli,"select id,strany,hlasy,hlasy2 from volby")or die(mysqli_error()); ;
$hlasy;
echo "<table border='1'>";
echo "<tr> <th>id</th> <th>strany</th> <th>hlasy</th><th>hlasy 2. kolo</th> </tr>";
// keeps getting the next row until there are no more to get
$a=0;$b=0;$i=0;$hlasy;$hlasy2;$points;$points2;
while($gear = mysqli_fetch_array( $mysqli_result )) {

// Print out the contents of each row into a table
    echo "<tr><td>";
    echo $gear['id'];
    echo "</td><td>";
    echo $gear['strany'];
    echo "</td><td>";
    echo $gear['hlasy'];
    echo "</td><td>";
    echo $gear['hlasy2'];
    echo "</td></tr>";

    if($gear['hlasy']>=5){
        $a=1;
        $hlasy[$i]= $gear['strany'];
        $points[$i]=new Point( $gear['strany'],$gear['hlasy']);
    }
    if($gear['hlasy2']>=5){
        $hlasy2[$i]= $gear['strany'];
        $points2[$i]=new Point( $gear['strany'],$gear['hlasy2']);
        $b=1;
    }
    $i++;

}
echo "</table>";
mysqli_close($mysqli);
echo "1.kolo:";
foreach ($hlasy as $hlas):
echo $hlas.",";

endforeach;
echo "<br>";
echo "2.kolo:";
foreach ($hlasy2 as $hlas):
echo $hlas.",";

endforeach;
echo "<br>";
$chart = new PieChart();
    if ($a==0){$points[0]=new Point( 0,0);}
    $dataSet = new XYDataSet();
    foreach ($points as $point):
    $dataSet->addPoint($point);
    endforeach;
    $chart->setDataSet($dataSet);

    $chart->setTitle("postupujuci do parlamentu");
    $chart->render("demo3.png");
    if ($b==0){$points2[0]=new Point( 0,0);}
    $dataSet = new XYDataSet();
    foreach ($points2 as $point):
    $dataSet->addPoint($point);
    endforeach;
    $chart->setDataSet($dataSet);

    $chart->setTitle("postupujuci do parlamentu 2.kolo");
    $chart->render("demo2kolo.png");


?>
<div>
<img alt="Pie chart"  src="demo3.png" style="border: 1px solid gray;"/>
<img alt="Pie chart"  src="demo2kolo.png" style="border: 1px solid gray;"/>
</div>
</body>
</html>