soil-report-ai/test-analysis.php

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

$sql = null;
$con = mysqli_connect("localhost", "cropmonitor", "brvnCcaEYxlPCS3", "cropmonitor");

//set todays date
$date = date("Y-m-d H:i:s");

//Get figures
$email = "ben@tazz.com.au";
$client_name = "Benjamin Harris";
$site_address = "24 Alfred Street";
$state_postcode = "";
$analysis_type = "Soil Test";  //for future types of Soil Analysis
$lab_no = "NT2698/3";
$batch_no = "3";
$sample_id = "Sample 3";
$site_id = "";
$crop_type = "Grape";
$soil_type = "sandy";  //need to fix form to say soil_type not analysis_type
$date_sampled = "2018/11/22";
$tec = "50.2";
$cec = "45.4";
$texture = "Clay Loam";
$gravel = "";
$colour = "Black";
$NO3_N = "2.6";
$NH3_N = "5.3";
$p_mehlick = "36";
$p_bray2 = "0";
$p_morgan = "4.1";
$k_morgan = "154";
$ca_morgan = "4174";
$mg_morgan = "1347";
$na_morgan = "0";
$ch_h2o = "62";
$ocarbon = "3.95";
$omatter = ($ocarbon * 2.7);
$fe = "0";
$ec = "0.097";
$ph_cacl2 = "";
$ph_h2o = "6.4";
$paramag = "6000";
$s_morgan = "";
$b_cacl2 = "1.24";
$mn_dtpa = "40";
$zn_dtpa = "9.5";
$fe_dtpa = "156";
$cu_dtpa = "7.6";
$al = "0";
$sl_cacl2 = "0";
$m_dtpa = "0";
$co_dtpa = "0";
$se = "0";
$ca_mehlick3 = "30.28";
$mg_mehlick3 = "14.01";
$k_mehlick3 = "0.76";
$na_mehlick3 = "0.38";
$al_mehlick3 = "0.24";

$c_total = "4.5";
$n_total = ($NO3_N + $NH3_N);
$c_nRatio = ($c_total / $n_total);
$ca_mgRatio = ($ca_mehlick3 / $mg_mehlick3);

//$rand = substr(md5(microtime()),rand(0,26),5);
$rand = mt_rand(10000, 99999);


// PH lookup table (ph*10 rounded to single decimal point for easy lookup)
$phrange = array(
    30 => [75.0, 11.4],
    31 => [74.0, 11.2],
    32 => [73.0, 11.0],
    33 => [72.0, 10.8],
    34 => [71.0, 10.6],
    35 => [70.0, 10.4],
    36 => [69.0, 10.2],
    37 => [68.0, 10.0],
    38 => [67.0, 9.8],
    39 => [66.0, 9.6],
    40 => [65.0, 9.4],
    41 => [63.0, 9.2],
    42 => [61.0, 9.0],
    43 => [59.0, 8.8],
    44 => [57.0, 8.6],
    45 => [55.0, 8.4],
    46 => [53.0, 8.2],
    47 => [51.0, 8.0],
    48 => [49.0, 7.8],
    49 => [47.0, 7.6],
    50 => [45.0, 7.4],
    51 => [42.0, 7.2],
    52 => [39.0, 7.0],
    53 => [36.0, 6.8],
    54 => [33.0, 6.6],
    55 => [30.0, 6.4],
    56 => [27.0, 6.2],
    57 => [24.0, 6.0],
    58 => [21.0, 5.8],
    59 => [18.0, 5.6],
    60 => [15.0, 5.4],
    61 => [13.5, 5.3],
    62 => [12.0, 5.2],
    63 => [10.5, 5.1],
    64 => [9.0, 5.0],
    65 => [7.5, 4.9],
    66 => [6.0, 4.8],
    67 => [4.5, 4.7],
    68 => [3.0, 4.6],
    69 => [1.5, 4.5],
    70 => [0.0, 4.4],
    71 => [0.0, 4.3],
    72 => [0.0, 4.2],
    73 => [0.0, 4.1],
    74 => [0.0, 4.0],
    75 => [0.0, 3.9],
    76 => [0.0, 3.8],
    77 => [0.0, 3.7],
    78 => [0.0, 3.6],
    79 => [0.0, 3.5],
    80 => [0.0, 3.4],
    81 => [0.0, 3.3],
    82 => [0.0, 3.2],
    83 => [0.0, 3.1],
    84 => [0.0, 3.0],
    85 => [0.0, 2.9],
    86 => [0.0, 2.8],
    87 => [0.0, 2.7],
    88 => [0.0, 2.6],
    89 => [0.0, 2.5],
    90 => [0.0, 2.4],
    91 => [0.0, 2.3],
    92 => [0.0, 2.2],
    93 => [0.0, 2.1],
    94 => [0.0, 2.0],
    95 => [0.0, 1.9],
    96 => [0.0, 1.8],
    97 => [0.0, 1.7],
    98 => [0.0, 1.6],
    99 => [0.0, 1.5],
    100 => [0.0, 1.4],
);



/* ********* START ********* */
/* ********* ADD BASE SATURATION CALCULATION HERE ********* */

// ***
//  calculating hydrogen and otherbases
// ***

$ph = $ph_h2o;      // $ph_h2o from above
$aluminium = $al;   // VERIFY: assuming $al is aluminium

// round the ph value to single decimal point    
$ph_lookup = round($ph, 1); 

// lookup H and Other Bases
$hydrogen = $phrange[($ph_lookup * 10)][0];
$other_Bases = $phrange[($ph_lookup * 10)][1];

// CAUTION: $otherbases & other_Bases are too similar variable names, prone to error
$otherbases = $other_Bases;

// CAUTION: $otherbases & $otherBases can be different variables depending on aluminum levels.
if ( $aluminium < 0 ) {
    $otherbases = 0;
}

// INTEGRATE: in the spreadsheet at this point the macro sets the value of hydrogen into a cell
// there is no comparable variable here...  don't know if the cell gets used again...

// *** the hydrogen value that is entered into the cell is the final Hydrogen value, which is then just written to the database ***

$hbs = $hydrogen;

//
//  obresult
//


$obresult = 0;  // INTEGRATE: starting at zero per spreadsheet, double check that this is intended

if ( $otherbases > 0 ) {
    while ( ($obresult * 100 / $tec) <= $otherbases ) {
        $obresult += 0.001;
        $tempNo = $obresult;
        $tempNo1 = $otherbases;
        $tempNo2 = $hydrogen;
        // CAUTION: storing value in Calc:E16
        $obresult_offset_1_0_cell = $tempNo * $tempNo2 / $tempNo1;
    }
    $obresult -= 0.001;
    if ( $obresult_offset_1_0_cell != 0 ){
        $obresult_offset_1_0_cell -= 0.001;
    }
}
else {

    // ERROR: VALUE OF CELL Calc:E16 IS BEING READ PRIOR TO ASSIGNMENT!! 
    // THIS COULD BE USING LEFT OVER DATA FROM PREVIOUS RUNS! THE CURRENT VALUE IS 0.
    $obresult_offset_1_0_cell = 0; // INTEGRATE: NEEDS VALUE ASSIGNED

    while( ($obresult_offset_1_0_cell * 100 / $tec) <= $hydrogen ) {
        $obresult_offset_1_0_cell += 0.001;
    }
    $obresult_offset_1_0_cell -= 0.001;
}


//
// Calculating Ca Mg K Na levels based on temp
//
// *** I think that the tecTemp needs to be a sum of $tec and $obresult_offset_1_0_cell and $obresult ***
// *** As far as I can see on the spreadsheet the TEC in CALC:B16 is "CEC + obresult + CALC:E16"
//$tecTemp = $obresult_offset_1_0_cell;    
$tecTemp = $cec + $obresult + $obresult_offset_1_0_cell;
$tec = $tecTemp;

// CAUTION: for $tecTemp values below 1 and above 100000 this will not work

if ( ( 1.0 < $tecTemp  ) && ( $tecTemp >= 3.0 ) ) {
    $cabs = $CABS = 0;
    $cabsmax = $CABSMAX = 60.00;
    $mgbs = $MGBS = 0;
    $mgbsmax = $MGBSMAX = 20.00;
    $kbs = $KBS = 5.00;
    $kbsmax = $KBSMAX = 7.00; 
    $nabs = $NABS = 0.50;
    $nabsmax = $NABSMAX = 1.50; 
}
elseif ( ( 3.0 < $tecTemp  ) && ( $tecTemp >= 5.0 ) ) {
    $cabs = $CABS = 0;
    $cabsmax = $CABSMAX = 62.00;
    $mgbs = $MGBS = 0;
    $mgbsmax = $MGBSMAX = 18.00;
    $kbs = $KBS = 5.00;
    $kbsmax = $KBSMAX = 7.00; 
    $nabs = $NABS = 0.50;
    $nabsmax = $NABSMAX = 1.50; 
}
elseif ( ( 5.0 < $tecTemp  ) && ( $tecTemp >= 7.0 ) ) {
    $cabs = $CABS = 0;
    $cabsmax = $CABSMAX = 64.00;
    $mgbs = $MGBS = 0;
    $mgbsmax = $MGBSMAX = 16.00;
    $kbs = $KBS = 4.00;
    $kbsmax = $KBSMAX = 7.00; 
    $nabs = $NABS = 0.50;
    $nabsmax = $NABSMAX = 1.50; 
}
elseif ( ( 7.0 < $tecTemp  ) && ( $tecTemp >= 9.0 ) ) {
    $cabs = $CABS = 0;
    $cabsmax = $CABSMAX = 65.00;
    $mgbs = $MGBS = 0;
    $mgbsmax = $MGBSMAX = 15.00;
    $kbs = $KBS = 4.00;
    $kbsmax = $KBSMAX = 7.00; 
    $nabs = $NABS = 0.50;
    $nabsmax = $NABSMAX = 1.50; 
}
elseif ( ( 9.0 < $tecTemp  ) && ( $tecTemp >= 11.0 ) ) {
    $cabs = $CABS = 0;
    $cabsmax = $CABSMAX = 67.00;
    $mgbs = $MGBS = 0;
    $mgbsmax = $MGBSMAX = 13.00;
    $kbs = $KBS = 4.00;
    $kbsmax = $KBSMAX = 7.00; 
    $nabs = $NABS = 0.50;
    $nabsmax = $NABSMAX = 1.50; 
}
elseif ( ( 11.0 < $tecTemp  ) && ( $tecTemp >= 30.0 ) ) {
    $cabs = $CABS = 0;
    $cabsmax = $CABSMAX = 68.00;
    $mgbs = $MGBS = 0;
    $mgbsmax = $MGBSMAX = 12.00;
    $kbs = $KBS = 4.00;
    $kbsmax = $KBSMAX = 7.00; 
    $nabs = $NABS = 0.50;
    $nabsmax = $NABSMAX = 1.50; 
}
elseif ( ( 30.0 < $tecTemp  ) && ( $tecTemp >= 100000.0 ) ) {
    $cabs = $CABS = 0;
    $cabsmax = $CABSMAX = 70.00;
    $mgbs = $MGBS = 0;
    $mgbsmax = $MGBSMAX = 10.00;
    $kbs = $KBS = 3.00;
    $kbsmax = $KBSMAX = 6.00; 
    $nabs = $NABS = 0.50;
    $nabsmax = $NABSMAX = 1.50; 
}

// *** CALCULATED TEC MIN / MAX LEVELS
$cabs_min = $cabs;
$cabs_max = $cabsmax;
$mgbs_min = $mgbs;
$mgbs_max = $mgbsmax;
$kbs_min = $kbs;
$kbs_max = $kbsmax;
$nabs_min = $nabs;
$nabs_max = $nabsmax;
$albs_min = "0";
$albs_max = "0.5";

// *** CALCULATED TEC LEVELS
$cabs_tec = $ca_mehlick3 * $tec * 100;
$mgbs_tec = $mg_mehlick3 * $tec * 100;
$kbs_tec = $k_mehlick3 * $tec * 100;
$nabs_tec = $na_mehlick3 * $tec * 100;
$albs_tec = $al_mehlick3 * $tec * 100;

// *** CALCULATED PPM FROM MEQ
$BS_ca_ppm =  $ca_mehlick3 * 200;
$BS_mg_ppm =  $mg_mehlick3 * 120;
$BS_k_ppm =  $k_mehlick3 * 390;
$BS_na_ppm =  $na_mehlick3 * 230;
$BS_al_ppm =  $al_mehlick3 * 90;


/* ********* ADD BASE SATURATION CALCULATION HERE ********* */
/* ********* END ********* */

/*
NOTES:
will need to add rows in mysql to save data that has been calculated above.


*/

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

$sql = mysqli_query($con, "INSERT into `soil_records`
            (
                date,
                email,
                client_name,
                site_address,
                state_postcode,
                analysis_type,
                lab_no,
                batch_no,
                sample_id,
                site_id,
                crop_type,
                soil_type,
                date_sampled,
                tec,
                cec,
                texture,
                gravel,
                colour,
                NO3_N,
                NH3_N,
                p_mehlick,
                p_bray2,
                p_morgan,
                k_morgan,
                ca_morgan,
                mg_morgan,
                na_morgan,
                ch_h2o,
                ocarbon,
                omatter,
                fe,
                ec,
                ph_cacl2,
                ph_h2o,
                paramag,
                s_morgan,
                b_cacl2,
                mn_dtpa,
                zn_dtpa,
                fe_dtpa,
                cu_dtpa,
                al,
                sl_cacl2,
                m_dtpa,
                co_dtpa,
                se,

                ca_mehlick3,
				BS_ca_ppm,
                mg_mehlick3,
				BS_mg_ppm,
                k_mehlick3,
				BS_k_ppm,
                na_mehlick3,
				BS_na_ppm,
                al_mehlick3,
				BS_al_ppm,
				BS_ca2,
				BS_mg2,
				BS_k,
				BS_na,
				BS_al3,
				BS_h,

				cabs_min,
				cabs_max,
				mgbs_min,
				mgbs_max,
				kbs_min,
				kbs_max,
				nabs_min,
				nabs_max,
				albs_min,
				albs_max,

				ca_mg_ratio,

                rand
            ) VALUES (
                '" . $date . "',
                '" . $email . "',
                '" . $client_name . "',
                '" . $site_address . "',
                '" . $state_postcode . "',
                '" . $analysis_type . "',
                '" . $lab_no . "',
                '" . $batch_no . "',
                '" . $sample_id . "',
                '" . $site_id . "',
                '" . $crop_type . "',
                '" . $soil_type . "',
                '" . $date_sampled . "',
                '" . $tec . "',
                '" . $cec . "',
                IF('" . $texture . "'='',NULL,'" . $texture . "'),
                IF('" . $gravel . "'='',NULL,'" . $gravel . "'),
                IF('" . $colour . "'='',NULL,'" . $colour . "'),
                '" . $NO3_N . "',
                '" . $NH3_N . "',
                '" . $p_mehlick . "',
                '" . $p_bray2 . "',
                '" . $p_morgan . "',
                '" . $k_morgan . "',
                '" . $ca_morgan . "',
                '" . $mg_morgan . "',
                '" . $na_morgan . "',
                '" . $ch_h2o . "',
                '" . $ocarbon . "',
                '" . $omatter . "',
                '" . $fe . "',
                '" . $ec . "',
                '" . $ph_cacl2 . "',
                '" . $ph_h2o . "',
                IF('" . $paramag . "'='',NULL,'" . $paramag . "'),
                '" . $s_morgan . "',
                '" . $b_cacl2 . "',
                '" . $mn_dtpa . "',
                '" . $zn_dtpa . "',
                '" . $fe_dtpa . "',
                '" . $cu_dtpa . "',
                '" . $al . "',
                '" . $sl_cacl2 . "',
                '" . $m_dtpa . "',
                '" . $co_dtpa . "',
                '" . $se . "',

                '" . $ca_mehlick3 . "',
				'" . $BS_ca_ppm . "',
                '" . $mg_mehlick3 . "',
				'" . $BS_mg_ppm . "',
                '" . $k_mehlick3 . "',
				'" . $BS_k_ppm . "',
                '" . $na_mehlick3 . "',
				'" . $BS_na_ppm . "',
                '" . $al_mehlick3 . "',	
				'" . $BS_al_ppm . "',

				'" . $cabs_tec . "',
				'" . $mgbs_tec . "',
				'" . $kbs_tec . "',
				'" . $nabs_tec . "',
				'" . $aluminium . "',
				'" . $hbs . "',

				'" . $cabs_min . "',
				'" . $cabs_max . "',
				'" . $mgbs_min . "',
				'" . $mgbs_max . "',
				'" . $kbs_min . "',
				'" . $kbs_max . "',
				'" . $nabs_min . "',
				'" . $nabs_max . "',
				'" . $albs_min . "',
				'" . $albs_max . "',

				'" . $ca_mgRatio . "',

                '" . $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 = '[[~32]]?rand=" . $rand . "&cid=" . $sample_id . "&rid=" . $insert_id . "&stid=" .$crop_type . "';</script>";
    } else {
    die(mysqli_error($con)); // TODO: better error handling
    //echo "User Profile incorrect";
}
*/
?>

<table style="width:50%">
    <tr>
        <th style="width:25%">Element</th>
        <th style="width:75%">Results</th> 
    </tr>

    <tr>
        <td> Date </td>
        <td> <?php echo $date; ?> </td>
    </tr>

    <tr>
        <td> Email </td>
        <td> <?php echo $email; ?> </td>
    </tr>
    <tr>
        <td> Client </td>
        <td> <?php echo $client_name; ?> </td>
    </tr>
    <tr>
        <td> Address </td>
        <td> <?php echo $site_address; ?> </td>
    </tr>
    <tr>
        <td> State </td>
        <td> <?php echo $state_postcode; ?> </td>
    </tr>
    <tr>
        <td> Analysis </td>
        <td> <?php echo $analysis_type; ?> </td>
    </tr>
    <tr>
        <td> Lab # </td>
        <td> <?php echo $lab_no; ?> </td>
    </tr>
    <tr>
        <td> Batch </td>
        <td> <?php echo $batch_no; ?> </td>
    </tr>
    <tr>
        <td> Sample ID </td>
        <td> <?php echo $sample_id; ?> </td>
    </tr>
    <tr>
        <td> Site ID </td>
        <td> <?php echo $site_id; ?> </td>
    </tr>
    <tr>
        <td> Crop Type </td> 
        <td> <?php echo $crop_type; ?> </td>
    </tr>
    <tr>
        <td> Soil Type </td> 
        <td> <?php echo $soil_type; ?> </td>
    </tr>
    <tr>
        <td> Date Sampled </td> 
        <td> <?php echo $date_sampled; ?> </td>
    </tr>

    <tr>
        <td> TEC </td> 
        <td> <?php echo $tecTemp; ?> </td>
    </tr>
    <tr>
        <td> CEC </td> 
        <td> <?php echo $cec; ?> </td>
    </tr>
    <tr>
        <td> Texture </td> 
        <td> <?php echo $texture; ?> </td>
    </tr>
    <tr>
        <td> Gravel </td> 
        <td> <?php echo $gravel; ?> </td>
    </tr>
    <tr>
        <td> Colour </td> 
        <td> <?php echo $colour; ?> </td>
    </tr>
    <tr>
        <td> N03_Nitrogen </td> 
        <td> <?php echo $NO3_N; ?> </td>
    </tr>
    <tr>
        <td> NH3_Nitrogen </td> 
        <td> <?php echo $NH3_N; ?> </td>
    </tr>
    <tr>
        <td> P Mehlick </td> 
        <td> <?php echo $p_mehlick; ?> </td>
    </tr>
    <tr>
        <td> P Bray2</td> 
        <td> <?php echo $p_bray2; ?> </td>
    </tr>
    <tr>
        <td> P Morgan</td> 
        <td> <?php echo $p_morgan; ?> </td>
    </tr>
    <tr>
        <td> K Morgan</td> 
        <td> <?php echo $k_morgan; ?> </td>
    </tr>
    <tr>
        <td> Ca Morgan</td> 
        <td> <?php echo $ca_morgan; ?> </td>
    </tr>
    <tr>
        <td> Mg Morgan</td> 
        <td> <?php echo $mg_morgan; ?> </td>
    </tr>
    <tr>
        <td> Na Morgan</td> 
        <td> <?php echo $na_morgan; ?> </td>
    </tr>
    <tr>
        <td> Chloride</td> 
        <td> <?php echo $ch_h2o; ?> </td>
    </tr>
    <tr>
        <td> Organic Carbon</td> 
        <td> <?php echo $ocarbon; ?> </td>
    </tr>
    <tr>
        <td> Organic Matter</td> 
        <td> <?php echo $omatter; ?> </td>
    </tr>
    <tr>
        <td> Iron</td> 
        <td> <?php echo $fe; ?> </td>
    </tr>
    <tr>
        <td> EC</td> 
        <td> <?php echo $ec; ?> </td>
    </tr>
    <tr>
        <td> ph cacl2</td> 
        <td> <?php echo $ph_cacl2; ?> </td>
    </tr>
    <tr>
        <td> ph h2o</td> 
        <td> <?php echo $ph_h2o; ?> </td>
    </tr>
    <tr>
        <td> Parameg</td> 
        <td> <?php echo $paramag; ?> </td>
    </tr>

    <tr>
        <td> Sulphur</td> 
        <td> <?php echo $s_morgan; ?> </td>
    </tr>
    <tr>
        <td> Boron</td> 
        <td> <?php echo $b_cacl2; ?> </td>
    </tr>
    <tr>
        <td> Mananese</td> 
        <td> <?php echo $mn_dtpa; ?> </td>
    </tr>
    <tr>
        <td> Zinc</td> 
        <td> <?php echo $zn_dtpa; ?> </td>
    </tr>
    <tr>
        <td> Iron</td> 
        <td> <?php echo $fe_dtpa; ?> </td>
    </tr>
    <tr>
        <td> Copper</td> 
        <td> <?php echo $cu_dtpa; ?> </td>
    </tr>
    <tr>
        <td> Aluminium</td> 
        <td> <?php echo $al; ?> </td>
    </tr>
    <tr>
        <td> Silicoln</td> 
        <td> <?php echo $sl_cacl2; ?> </td>
    </tr>
    <tr>
        <td> Moly</td> 
        <td> <?php echo $m_dtpa; ?> </td>
    </tr>
    <tr>
        <td> Colbalt</td> 
        <td> <?php echo $co_dtpa; ?> </td>
    </tr>
    <tr>
        <td> Selenium</td> 
        <td> <?php echo $se; ?> </td>
    </tr>

    <tr>
        <td> Ca</td> 
        <td> <?php echo $ca_mehlick3; ?> </td>
    </tr>
    <tr>
        <td> Ca ppm</td> 
        <td> <?php echo $BS_ca_ppm; ?> </td>
    </tr>
    <tr>
        <td> Mg</td> 
        <td> <?php echo $mg_mehlick3; ?> </td>
    </tr>
    <tr>
        <td> Mg ppm</td> 
        <td> <?php echo $BS_mg_ppm; ?> </td>
    </tr>
    <tr>
        <td> K</td> 
        <td> <?php echo $k_mehlick3; ?> </td>
    </tr>
    <tr>
        <td> K ppm</td> 
        <td> <?php echo $BS_k_ppm; ?> </td>
    </tr>
    <tr>
        <td> Na</td> 
        <td> <?php echo $na_mehlick3; ?> </td>
    </tr>
    <tr>
        <td> Na ppm</td> 
        <td> <?php echo $BS_na_ppm; ?> </td>
    </tr>
    <tr>
        <td> Al</td> 
        <td> <?php echo $al_mehlick3; ?> </td>
    </tr>
    <tr>
        <td> Al ppm</td> 
        <td> <?php echo $BS_al_ppm; ?> </td>
    </tr>

    <tr>
        <td> CA</td> 
        <td> <?php echo $cabs_tec; ?> </td>
    </tr>
    <tr>
        <td> MG</td> 
        <td> <?php echo $mgbs_tec; ?> </td>
    </tr>
    <tr>
        <td> K</td> 
        <td> <?php echo $kbs_tec; ?> </td>
    </tr>
    <tr>
        <td> NA</td> 
        <td> <?php echo $nabs_tec; ?> </td>
    </tr>
    <tr>
        <td> AL</td> 
        <td> <?php echo $aluminium; ?> </td>
    </tr>
    <tr>
        <td> H</td> 
        <td> <?php echo $hbs; ?> </td></tr>

    <tr>
        <td> CA_min</td>
        <td> <?php echo $cabs_min; ?> </td>
    </tr>
    <tr>
        <td> CA_max</td> 
        <td> <?php echo $cabs_max; ?> </td>
    </tr>
    <tr>
        <td> MG_min</td> 
        <td> <?php echo $mgbs_min; ?> </td>
    </tr>
    <tr>
        <td> MG_max</td> 
        <td> <?php echo $mgbs_max; ?> </td>
    </tr>
    <tr>
        <td> K_min</td> 
        <td> <?php echo $kbs_min; ?> </td>
    </tr>
    <tr>
        <td> K_max</td> 
        <td> <?php echo $kbs_max; ?> </td>
    </tr>
    <tr>
        <td> NA_min</td> 
        <td> <?php echo $nabs_min; ?> </td>
    </tr>
    <tr>
        <td> NA_max</td> 
        <td> <?php echo $nabs_max; ?> </td>
    </tr>
    <tr>
        <td> AL_min</td> 
        <td> <?php echo $albs_min; ?> </td>
    </tr>
    <tr>
        <td> AL_max</td> 
        <td> <?php echo $albs_max; ?> </td>
    </tr>

    <tr>
        <td> Rand #</td> 
        <td> <?php echo $rand; ?> </td>
    </tr>
</table>