benjamin.harris
/
soil-report-ai


			
							1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283
							<!doctype html>
<html lang="en">
	<head>
		<title>[[*longtitle]] | [[++site_name]]</title>
		<base href="[[!++site_url]]" >
		<meta charset="[[++modx_charset]]" >
		<meta name="viewport" content="width=device-width, initial-scale=1, shrink-to-fit=no" >
		<meta http-equiv="Content-Type" content="text/html; charset=utf-8" >
		<meta name="keywords" content="[[*introtext]]" >
		<meta name="description" content="[[*description]]" >

		[[!Profile]]

		[[$dash-header]]
		
		
		<link rel='stylesheet' type='text/css' href="/client-assets/css/dashboard.css" />
		<script src="https://unpkg.com/gijgo@1.9.11/js/gijgo.min.js" type="text/javascript"></script>
		<link href="https://unpkg.com/gijgo@1.9.11/css/gijgo.min.css" rel="stylesheet" type="text/css" />
		<script src="client-assets/js/skycons.js"></script>
    
        <link rel="stylesheet" href="client-assets/home/css/graphing.css" media="screen">
        <link rel="stylesheet" href="client-assets/home/css/alux.min.css" media="screen">

    </head>
	
<?php
$result    = null;

$record_id = (isset($_GET["rid"])) ? $_GET["rid"] : ""; // record number
$rand_id = (isset($_GET["rand"])) ? $_GET["rand"] : "";

//Database connection
//$con = mysqli_connect("localhost", "root", "R3M0T31", "cropmonitor");
$con = mysqli_connect("localhost", "cropmonitor", "brvnCcaEYxlPCS3", "cropmonitor");


// Check connection
if (mysqli_connect_errno()) {
    echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

// Get results from database 
$result = mysqli_query($con, "SELECT BS_ca2, BS_mg2, BS_k, BS_na, BS_ob, BS_h FROM `soil_records` WHERE soil_records.id=" . $record_id ." AND soil_records.rand=". $rand_id ." ");

if ($result === FALSE) {
    die(mysqli_error($con)); // TODO: better error handling
    echo "User Profile incorrect";
} else {
    
    $data = array();
    
    for ($x = 0; $x < mysqli_num_rows($result); $x++) {
        $data[] = mysqli_fetch_assoc($result);
    }
    
    echo json_encode($data);     
    
    mysqli_close($con);
}
?>

<!-- jQuery first, then Popper.js, then Bootstrap JS -->
<script type="text/javascript" src="https://code.jquery.com/ui/1.12.1/jquery-ui.min.js" integrity="sha256-VazP97ZCwtekAsvgPBSUwPFKdrwD3unUfSGVYrahUqU=" crossorigin="anonymous"></script>
<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.3/umd/popper.min.js" integrity="sha384-ZMP7rVo3mIykV+2+9J3UJ46jBk0WLaUAdn689aCwoqbBJiSnjAK/l8WvCWPIPm49" crossorigin="anonymous"></script>
<script type="text/javascript" src="https://stackpath.bootstrapcdn.com/bootstrap/4.1.3/js/bootstrap.min.js" integrity="sha384-ChfqqxuZUCnJSK3+MXmPNIyE6ZbWh2IMqE241rYiqJxyMiZ6OW/JmZQ5stwEULTy" crossorigin="anonymous"></script>	

<script type="text/javascript">
    addEventListener("load", function() { 
        setTimeout(hideURLbar, 0);
    }, false);
    function hideURLbar(){ 
        window.scrollTo(0,1);
    }
</script>

<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.bundle.min.js" integrity="sha384-xrRywqdh3PHs8keKZN+8zzc5TX0GRTLCcmivcbNJWm2rs5C8PRhcEn3czEjhAO9o" crossorigin="anonymous"></script>

<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery-easing/1.4.1/jquery.easing.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/magnific-popup.js/1.1.0/jquery.magnific-popup.js"></script>

</html>