<html>
  <head>
 
 </head>
  <body>
<p><font size="3" color="#3866A3" face="verdana">

<?php

$user="user";  
$host="127.0.0.1";  
$password="password";  
$database = "SensiHome";
$cxn = mysqli_connect($host,$user,$password,$database)         
	or die("geen verbinding mogelijk"); 
	
?>

<?php
$q_toeren_select = "SELECT DatumTijd, KwH FROM ElectMeterMeter ORDER BY DatumTijd DESC LIMIT 1"; 
	$result2 = mysqli_query($cxn,$q_toeren_select)	
	or die ("Couldn’t execute query."); 
	
	
	$rij=array(); 
			while ($rij=mysqli_fetch_array($result2)) {
			
				$tijd=$rij[DatumTijd];
				
				$ActGeb=$rij[KwH];
				
				
			
			
			echo $tijd ;
			echo " <br>";
			echo "Actueel verbruik : ";
			echo "<br>";
			echo "<font size = 600pt>";
			echo $ActGeb;
			echo " Wh";
			echo "</font>";
            }

?>
<?php

$totverb = "SELECT SUM(toer) AS toer_som FROM ElectMeterMeter WHERE DATE(DatumTijd) = CURDATE()";
$result3 = mysqli_query($cxn,$totverb)	
	or die ("Couldn’t execute query."); 
	
	$rij2=array(); 
			while ($rij2=mysqli_fetch_array($result3)) {
			
				
				
				$toeren_som=$rij2[toer_som];
				$toeren_som = ($toeren_som/375*1000);
				
				
			echo "<br>";
			echo "Dagverbruik : ";
			echo round($toeren_som) ;
			echo "Wh";

            }

$cxn->close();

?>


  </body>
</html>
