crop-monitor/core/cache/scripts/elements/modsnippet/134.cache.php

<?php  return '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;
';