<?php

ini_set('display_errors', 1);
error_reporting(~0);

//require("meterconfig.php");

$serverName = "localhost";
$username = "root";
$password = "";
$dbname = "uhm_electromagnetic";

$conn = mysqli_connect($serverName,$username,$password,$dbname);
//$sql = "SELECT * FROM meter_no WHERE meter_code =  '".$_GET['p']."' ";
$sql = "SELECT device_master.customer_type, SUM(electro_count.flow) AS `SUM(flow)`, device_master.dma,
        DATE_FORMAT(date, '%Y') AS Years, device_master.watermeter_size FROM device_master
        INNER JOIN electro_count ON device_master.device_no = electro_count.device_no
        GROUP BY device_master.customer_type, device_master.dma, DATE_FORMAT(date, '%Y'), device_master.watermeter_size";
	$query = mysqli_query($conn,$sql);
	if (!$query) {
		printf("Error: %s\n", $conn->error);
		exit();
	}
	$resultArray = array();
	while($result = mysqli_fetch_array($query,MYSQLI_ASSOC))
	{
		array_push($resultArray,$result);
	}
	mysqli_close($conn);

	echo json_encode($resultArray);



?>