<?php  return 'error_reporting(E_ALL);
ini_set(\'display_errors\', 1);

if(isset($_POST[\'PlantcsvForm\'])) {
    
    $sql = null;
    $con = mysqli_connect("localhost", "root", "R3M0T31", "cropmonitor");
    
    //set todays date
    $date = date("Y-m-d H:i:s");
    
    //Get figures
    $email = (isset($_POST["email"])) ? $_POST["email"] : "";
    $client_name = (isset($_POST["name"])) ? $_POST["name"] : "";
    $site_address = (isset($_POST["site_address"])) ? $_POST["site_address"] : "";
    $state_postcode = (isset($_POST["state_postcode"])) ? $_POST["state_postcode"] : "";
    $analysis_type = (isset($_POST["analysis_type"])) ? $_POST["analysis_type"] : "";
    $lab_no = (isset($_POST["lab_no"])) ? $_POST["lab_no"] : "";
    $batch_no = (isset($_POST["batch_no"])) ? $_POST["batch_no"] : "";
    $date_sampled = (isset($_POST["date_sampled"])) ? $_POST["date_sampled"] : "";
    $sample_id = (isset($_POST["sample_id"])) ? $_POST["sample_id"] : "";
    $site_id = (isset($_POST["site_id"])) ? $_POST["site_id"] : "";
    $crop_type = (isset($_POST["crop_type"])) ? $_POST["crop_type"] : "";
    $n = (isset($_POST["n"])) ? $_POST["n"] : "";
    $p = (isset($_POST["p"])) ? $_POST["p"] : "";
    $k = (isset($_POST["k"])) ? $_POST["k"] : "";
    $s = (isset($_POST["s"])) ? $_POST["s"] : "";
    $mg = (isset($_POST["mg"])) ? $_POST["mg"] : "";
    $ca = (isset($_POST["ca"])) ? $_POST["ca"] : "";
    $na = (isset($_POST["na"])) ? $_POST["na"] : "";
    $fe = (isset($_POST["fe"])) ? $_POST["fe"] : "";
    $mn = (isset($_POST["mn"])) ? $_POST["mn"] : "";
    $zn = (isset($_POST["zn"])) ? $_POST["zn"] : "";
    $cu = (isset($_POST["cu"])) ? $_POST["cu"] : "";
    $b = (isset($_POST["b"])) ? $_POST["b"] : "";
    $m = (isset($_POST["m"])) ? $_POST["m"] : "";
    $co = (isset($_POST["co"])) ? $_POST["co"] : "";
    $se = (isset($_POST["se"])) ? $_POST["se"] : "";
    $ch = (isset($_POST["cl"])) ? $_POST["cl"] : "";
    //$rand = substr(md5(microtime()),rand(0,26),5);
    $rand = mt_rand(10000, 99999);
    
    // Check connection
    	if (mysqli_connect_errno())
    		{
    		echo "Failed to connect to MySQL: " . mysqli_connect_error();
    		}
    		
    $sql = mysqli_query($con, "INSERT into `plant_records`
                (
                    date,
                    email,
                    client_name,
                    site_address,
                    state_postcode,
                    analysis_type,
                    lab_no,
                    batch_no,
                    date_sampled,
                    sample_id,
                    site_id,
                    crop_type,
                    n,
                    p,
                    k,
                    s,
                    mg,
                    ca,
                    na,
                    fe,
                    mn,
                    zn,
                    cu,
                    b,
                    m,
                    co,
                    se,
                    cl,
                    rand
                ) VALUES (
                    \'" . $date . "\',
                    \'" . $email . "\',
                    \'" . $client_name . "\',
                    \'" . $site_address . "\',
                    \'" . $state_postcode . "\',
                    \'" . $analysis_type . "\',
                    \'" . $lab_no . "\',
                    \'" . $batch_no . "\',
                    \'" . $date_sampled . "\',
                    \'" . $sample_id . "\',
                    \'" . $site_id . "\',
                    \'" . $crop_type . "\',
                    \'" . $n . "\',
                    \'" . $p . "\',
                    \'" . $k . "\',
                    \'" . $s . "\',
                    \'" . $mg . "\',
                    \'" . $ca . "\',
                    \'" . $na . "\',
                    \'" . $fe . "\',
                    \'" . $mn . "\',
                    \'" . $zn . "\',
                    \'" . $cu . "\',
                    \'" . $b . "\',
                    IF(\'" . $m . "\'=\'\',NULL,\'" . $m . "\'),
                    IF(\'" . $co . "\'=\'\',NULL,\'" . $co . "\'),
                    IF(\'" . $se . "\'=\'\',NULL,\'" . $se . "\'),
                    IF(\'" . $cl . "\'=\'\',NULL,\'" . $cl . "\'),
                    \'" . $rand . "\'
                )" );
    $insert_id = mysqli_insert_id($con);
                
    if ($sql === TRUE)
    	{
    	//echo "success"; //CHECKING
    	// forward to results page if successfully inserts to database
    	echo "<script>location.href = \'[[~26]]?rand=" . $rand . "&cid=" . $sample_id . "&rid=" . $insert_id . "&stid=" .$crop_type . "\',\'_blank\';</script>";
        } else {
        die(mysqli_error($con)); // TODO: better error handling
        //echo "User Profile incorrect";
    }
}
return;
';