prepare("SELECT * FROM soil_records WHERE id = ? AND rand = ?"); $stmt->execute([$record_id, $rand_id]); $row = $stmt->fetch(PDO::FETCH_ASSOC); if (!$row) { die('Soil record not found'); } // Extract data $client = htmlspecialchars($row['client_name'] ?? '', ENT_QUOTES, 'UTF-8'); $address = htmlspecialchars($row['site_address'] ?? '', ENT_QUOTES, 'UTF-8'); $state = htmlspecialchars($row['state_postcode'] ?? '', ENT_QUOTES, 'UTF-8'); $email = htmlspecialchars($row['email'] ?? '', ENT_QUOTES, 'UTF-8'); $labNo = htmlspecialchars($row['lab_no'] ?? '', ENT_QUOTES, 'UTF-8'); $sampleDate = htmlspecialchars($row['date_sampled'] ?? '', ENT_QUOTES, 'UTF-8'); $sample = htmlspecialchars($row['site_id'] ?? '', ENT_QUOTES, 'UTF-8'); $crop = htmlspecialchars($row['sample_id'] ?? '', ENT_QUOTES, 'UTF-8'); } catch (PDOException $e) { error_log("Database error in soil-analysis.php: " . $e->getMessage()); die('Database error occurred'); } $today = date('jS F Y'); $pageTitle = 'Soil Analysis Results - ' . $client; ?> <?php echo $pageTitle; ?> | Crop Management Platform
"; if ($client === "") { echo "Crop Monitor"; } else { echo "Crop Monitor"; } //echo ""; //Client Test Description if ($client === "") { echo ""; } else { echo "Crop Monitor"; } echo "
"; echo "
"; ?>
DATE: SAMPLE ID:
CLIENT: DATE SAMPLED:
ADDRESS: LAB NUMBER:
CROP:
Soil Analysis Summary
Total kilograms per hectare of each element needed to balance soil in this test
Overview
Ideal Soil Balancing Program for One Season of a FIVE YEAR Plan
Microbe Program

Any recommendations provided by Cropmonitor are advice only, We are not paid consultants and we are not covered to accept responsibiliy for any of our suggestions. As no control can be exercised over storage, handling, mixing application or use, or weather, plant or soil conditions before, during or after application (all of which may affect the preformance of our program), no responsibility for, or liability for any failure in performance, losses, damage or injuries consequential or otherwise, arisiing form such storage mixng application or use will be accepted under any circumstances whatsoever. The buyer assumes all responsibility for the use of any of our products.

[[!logoHeader]]
[[!soilAnalysisClient]]
[[!soilAnalysisReportButton]]
ANALYSIS RESULTS
[[!soilAnalysisCalcs? &element=cec &sbl=`` &nutrient=`CEC` &min=`` &max=`` &text=`` &recV=`n` &decimal=`2` &graph=lightorangeGraph]] [[!soilAnalysisCalcs? &element=tec &sbl=`` &nutrient=`TEC` &min=`` &max=`soil_type` &text=`` &recV=`max` &rec_text=`c` &decimal=`2` &graph=lightorangeGraph]] [[!soilAnalysisCalcs? &element=ph_h2o &sbl=`` &nutrient=`pH-level (H20)` &type=`pH` &min=`` &max=`` &text=`` &recV=`ph` &decimal=`1` &graph=lightorangeGraph]] [[!soilAnalysisCalcs? &element=ph_cacl2 &sbl=`` &nutrient=`pH-level (CaCl2)` &type=`pH` &min=`` &max=`` &text=`` &recV=`n` &decimal=`1` &graph=lightorangeGraph]] [[!soilAnalysisCalcs? &element=ec &sbl=`` &nutrient=`Conductivity (EC)` &type=`mS/cm` &min=`` &max=`` &text=`` &decimal=`2` &graph=lightorangeGraph]] [[!soilAnalysisCalcs? &element=ocarbon &sbl=`` &nutrient=`Organic Carbon` &type=`%` &min=`` &max=`` &text=`` &decimal=`1` &graph=lightorangeGraph]] [[!soilAnalysisCalcs? &element=omatter &sbl=`` &nutrient=`Organic Matter` &type=`%` &min=`` &max=`` &text=`` &decimal=`1` &graph=lightorangeGraph]] [[!soilAnalysisCalcs? &element=`NO3_N` &sbl=`NO3-N` &nutrient=`Nitrate Nitrogen` &min=`10` &max=`20` &type=ppm &text=`c` &rec_text=`r` &decimal=`0` &graph=lightgreenGraph]] [[!soilAnalysisCalcs? &element=`NH3_N` &sbl=`NH3-N` &nutrient=`Ammonium Nitrogen` &min=`` &max=`` &min=`` &max=`` &type=ppm &text=`c` &rec_text=`r` &decimal=`0` &graph=lightgreenGraph]] [[!soilAnalysisCalcs? &element=`p_colwell` &sbl=`P` &nutrient=`Phosphate (colwell)` &min=`` &max=`` &type=ppm &text=`c` &rec_text=`r` &decimal=`0` &graph=lightgreenGraph]] [[!soilAnalysisCalcs? &element=`BS_ca_ppm` &sbl=`Ca` &nutrient=`Calcium` &min=`ca_ppm_min` &max=`ca_ppm_max` &type=`ppm` &text=`c` &rec_text=`r` &recV=`max` &decimal=`0` &graph=lightgreenGraph]] [[!soilAnalysisCalcs? &element=`BS_mg_ppm` &sbl=`Mg` &nutrient=`Magnesium` &min=`mg_ppm_min` &max=`mg_ppm_max` &type=`ppm` &text=`c` &rec_text=`r` &recV=`max` &decimal=`0` &graph=lightgreenGraph]] [[!soilAnalysisCalcs? &element=`BS_k_ppm` &sbl=`K` &nutrient=`Potassium` &min=`k_ppm_min` &max=`k_ppm_max` &type=`ppm` &text=`c` &rec_text=`r` &recV=`max` &decimal=`0` &graph=lightgreenGraph]] [[!soilAnalysisCalcs? &element=`BS_na_ppm` &sbl=`Na` &nutrient=`Sodium` &min=`na_ppm_min` &max=`na_ppm_max` &type=`ppm` &text=`c` &rec_text=`r` &recV=`max` &decimal=`0` &graph=lightgreenGraph]] [[!soilAnalysisCalcs? &element=s_morgan &sbl=`S` &nutrient=`Sulfur` &min=`` &max=`` &type=ppm &text=`c` &rec_text=`r` &decimal=`2` &graph=lightredGraph]] [[!soilAnalysisCalcs? &element=b_cacl2 &sbl=`B` &nutrient=`Boron` &min=`` &max=`` &type=ppm &text=`c` &rec_text=`r` &decimal=`2` &graph=lightredGraph]] [[!soilAnalysisCalcs? &element=mn_dtpa &sbl=`Mn` &nutrient=`Manganese` &min=`` &max=`` &type=ppm &text=`c` &rec_text=`r` &decimal=`2` &graph=lightredGraph]] [[!soilAnalysisCalcs? &element=cu_dtpa &sbl=`Cu` &nutrient=`Copper` &min=`` &max=`` &type=ppm &text=`c` &rec_text=`r` &decimal=`2` &graph=lightredGraph]] [[!soilAnalysisCalcs? &element=zn_dtpa &sbl=`Zn` &nutrient=`Zinc` &min=`` &max=`` &type=ppm &text=`c` &rec_text=`r` &decimal=`2` &graph=lightredGraph]] [[!soilAnalysisCalcs? &element=fe_dtpa &sbl=`Ir` &nutrient=`Iron` &min=`` &max=`` &type=ppm &text=`c` &rec_text=`r` &decimal=`2` &graph=lightredGraph]] [[!soilAnalysisCalcs? &element=al &sbl=`Al` &nutrient=`Aluminium` &min=`` &max=`` &type=ppm &text=`c` &rec_text=`r` &decimal=`2` &graph=lightredGraph]] [[!soilAnalysisCalcs? &element=sl_cacl2 &sbl=`Si` &nutrient=`Silicon` &min=`` &max=`` &type=ppm &text=`c` &rec_text=`r` &decimal=`2` &graph=lightredGraph]] [[!soilAnalysisCalcs? &element=`BS_ca2` &sbl=`Ca` &nutrient=`Calcium` &min=`cabs_min` &max=`cabs_max` &type=`%` &text=`c` &rec_text=`r` &recV=`max` &decimal=`2` &graph=lightpurpleGraph]] [[!soilAnalysisCalcs? &element=`BS_mg2` &sbl=`Mg` &nutrient=`Magnesium` &min=`mgbs_min` &max=`mgbs_max` &type=`%` &text=`c` &rec_text=`r` &recV=`max` &decimal=`2` &graph=lightpurpleGraph]] [[!soilAnalysisCalcs? &element=`BS_k` &sbl=`K` &nutrient=`Potassium` &min=`kbs_min` &max=`kbs_max` &type=`%` &text=`c` &rec_text=`r` &recV=`max` &decimal=`2` &graph=lightpurpleGraph]] [[!soilAnalysisCalcs? &element=`BS_na` &sbl=`Na` &nutrient=`Sodium` &min=`nabs_min` &max=`nabs_max` &type=`%` &text=`c` &rec_text=`r` &recV=`max` &decimal=`2` &graph=lightpurpleGraph]] [[!soilAnalysisCalcs? &element=`BS_ob` &sbl=`` &nutrient=`Other Bases` &min=`` &max=`ob_rec` &type=`%` &text=`c` &rec_text=`r` &recV=`max` &decimal=`2` &graph=lightpurpleGraph]] [[!soilAnalysisCalcs? &element=`BS_h` &sbl=`` &nutrient=`Hydrogen` &min=`` &max=`h_rec` &type=`%` &text=`c` &rec_text=`r` &recV=`max` &decimal=`2` &graph=lightpurpleGraph]] [[!soilAnalysisCalcs? &element=s_morgan &sbl=`Ca` &nutrient=`Calcium` &min=`` &max=`` &type=`%` &text=`c` &rec_text=`r` &decimal=`0` &graph=lightgreyGraph]] [[!soilAnalysisCalcs? &element=b_cacl2 &sbl=`Mg` &nutrient=`Magnesium` &min=`` &max=`` &type=`%` &text=`c` &rec_text=`r` &decimal=`0` &graph=lightgreyGraph]] [[!soilAnalysisCalcs? &element=mn_dtpa &sbl=`K` &nutrient=`Potassium` &min=`` &max=`` &type=`%` &text=`c` &rec_text=`r` &decimal=`0` &graph=lightgreyGraph]] [[!soilAnalysisCalcs? &element=s_morgan &sbl=`Ca` &nutrient=`Calcium` &min=`` &max=`` &type=`%` &text=`c` &rec_text=`r` &decimal=`0` &graph=lightgreyGraph]] [[!soilAnalysisRatio? &element=ca_mehlick3 &elementTwo=mg_mehlick3 &sbl=`` &rec=`ca_mg_ratio` &nutrient=`Ca:Mg Ratio` &min=`` &max=`` &text=`y` &rec_text=`r` &decimal=`1` &graph=lightblueGraph]] [[!soilAnalysisCalcs? &element=NH3_N &sbl=`` &nutrient=`Total Nitrogen` &type=`%` &min=`` &max=`` &text=`c` &rec_text=`r` &decimal=`1` &graph=lightblueGraph]] [[!soilAnalysisCalcs? &element=ocarbon &sbl=`` &nutrient=`Total Carbon` &type=`%` &min=`` &max=`` &text=`c` &rec_text=`r` &decimal=`1` &graph=lightblueGraph]] [[!soilAnalysisRatio? &element=ocarbon &elementTwo=NO3_N &sbl=`` &rec=`c_n_ratio` &nutrient=`C:N Ratio `&type=`:1` &min=`` &max=`` &text=`y` &rec_text=`r` &decimal=`1` &graph=lightblueGraph]]
ELEMENT STATUS
DESIRED FOUND LIGHT MEDIUM HEAVY
DEFICIT IDEAL HIGH
MAJOR ELEMENTS
TRACE ELEMENTS
BASE SATURATION
SOLUBLE MORGAN 2 EXTRACT
ADDITIONAL DATA LOW IDEAL EXCELLENT
RATIOS
© 2008-[[!date?format=year]] Cropmonitor