crop-monitor/core/cache/includes/elements/modsnippet/134.include.cache.php

<?php
error_reporting(E_ALL);
	ini_set('display_errors', 1);
	
    header('Content-Type: application/json');
    
    $client_id = ""; // Client ID
    $client_serial = $_GET['client_serial']; //serial number of clients device
    $date_start = $_GET['date_start']; //start date of graph
    $date_end = $_GET['date_end']; // end date of graph
    
    if ( isset($_GET['client_serial']) ) {
        $sensor_filter = " `sensor_id` = '". $client_serial ."' AND ";
    } else {
        $sensor_filter = " ";
    }
    
    //Database connection
    $con = mysqli_connect("localhost", "root", "R3M0T31", "cropmonitor");
    
    // Check connection
    if (mysqli_connect_errno()) {
        echo "Failed to connect to MySQL: " . mysqli_connect_error();
    }
    
    $sqlQuery = "SELECT `id`, `sensor_id`, `DATEUTC` AS `cur_date`, `value` FROM `field_sensors` WHERE ". $sensor_filter ." (`DATEUTC` BETWEEN '" . $date_start . "' AND '" . $date_end . "') ORDER BY `DATEUTC`";
    // 
    
    $result = mysqli_query($con,$sqlQuery);
    
    $data = array();
    foreach ($result as $row) {
    	$data[] = $row;
    }
    
    mysqli_close($con);
    
    echo json_encode($data);
return;