form.php

<?php 
require 'cred.php';
$mysqli = new mysqli("localhost", $username, $password, $database);
if (isset($_GET['Well_ID'])) {
	$Well_ID = $_GET['Well_ID'];
}
elseif (isset($_POST['Well_ID'])) {
	$Well_ID = $_POST['Well_ID'];
}
else {
    $Well_ID = "0";
}


if($_SERVER['REQUEST_METHOD']=='POST') {
//    $Permit_Number = $mysqli->real_escape_string(trim($_POST['well-completion-date']));
//    $Permit_Number = $mysqli->real_escape_string(trim($_POST['report-completion-date']));
    $PermitNumber = $mysqli->real_escape_string(trim($_POST['permit-number']));
    $RegistrantNumber = $mysqli->real_escape_string(trim($_POST['registrant-number']));
    $StateWellNumber = $mysqli->real_escape_string(trim($_POST['state-well-number']));
    $OtherNumber = $mysqli->real_escape_string(trim($_POST['other-number']));
    $OwnerFirstName = $mysqli->real_escape_string(trim($_POST['first-name']));
    $OwnerLastName = $mysqli->real_escape_string(trim($_POST['last-name']));
    $WellStreetNumber = $mysqli->real_escape_string(trim($_POST['well-street-number']));
    $WellStreetName = $mysqli->real_escape_string(trim($_POST['well-street-address']));
    $OwnerAddress = $mysqli->real_escape_string(trim($_POST['owner-address']));
    $WellTown = $mysqli->real_escape_string(trim($_POST['town']));
    $WellZip = $mysqli->real_escape_string(trim($_POST['zip-code']));
    $WellLotNumber = $mysqli->real_escape_string(trim($_POST['lot-number']));
    $WellLatitude = $mysqli->real_escape_string(trim($_POST['gps-coordinates-latitude']));
    $WellLongitude = $mysqli->real_escape_string(trim($_POST['gps-coordinate-longitude']));
    $RelativeLocation = $mysqli->real_escape_string(trim($_POST['relative-location']));
    $ProposedUse = $mysqli->real_escape_string(trim($_POST['use']));
//    $OtherUse = $mysqli->real_escape_string(trim($_POST['other-use-case']));
    $DrillingEquipment = $mysqli->real_escape_string(trim($_POST['drilling-equipment']));
//    $OtherEquipment = $mysqli->real_escape_string(trim($_POST['other-equipment']));
    $CasingLength = $mysqli->real_escape_string(trim($_POST['length']));
    $CasingDiameter = $mysqli->real_escape_string(trim($_POST['casing-diameter']));
    $CasingWeight = $mysqli->real_escape_string(trim($_POST['weight']));
    $CasingJoint = $mysqli->real_escape_string(trim($_POST['threaded-vs-welded']));
    $DriveShoe = $mysqli->real_escape_string(trim($_POST['drive-shoe']));
    $CasingGrouting = $mysqli->real_escape_string(trim($_POST['casing-grouting']));
    $YieldType = $mysqli->real_escape_string(trim($_POST['method']));
    $YieldHours = $mysqli->real_escape_string(trim($_POST['yield-hours']));
    $YieldGPM = $mysqli->real_escape_string(trim($_POST['yield-gpm']));
    $YieldNotes = $mysqli->real_escape_string(trim($_POST['yield-test-notes']));
    $WaterDepth = $mysqli->real_escape_string(trim($_POST['water-from-surface']));
    $YieldWaterLevel = $mysqli->real_escape_string(trim($_POST['water-level-during-yield-test']));
    $WellDepth = $mysqli->real_escape_string(trim($_POST['depth-of-well']));
    $ScreenMake = $mysqli->real_escape_string(trim($_POST['make']));
    $OpenScreenLength = $mysqli->real_escape_string(trim($_POST['length-open-to-aquifier']));
    $ScreenSlotSize = $mysqli->real_escape_string(trim($_POST['slot-size']));
    $ScreenDiameter = $mysqli->real_escape_string(trim($_POST['screen-diameter']));
    $Gravel = $mysqli->real_escape_string(trim($_POST['gravel']));
    $DiameterIncludingGravel = $mysqli->real_escape_string(trim($_POST['diameter-including-gravel-pack']));
    $GravelSize = $mysqli->real_escape_string(trim($_POST['gravel-size']));
    $DepthToTop = $mysqli->real_escape_string(trim($_POST['gravel-pack-location-from']));
    $DepthToBottom = $mysqli->real_escape_string(trim($_POST['gravel-pack-location-to']));
    $Comment = $mysqli->real_escape_string(trim($_POST['notes']));  
    
//    if (empty($errors)) { //If no errors in error array
    
    if ($_GET['Admin'] == 1) {
        $form_update = "UPDATE well_pending
    SET
    Registration_Number = '$RegistrantNumber', 
    State_Well_No = '$StateWellNumber', 
    Other_No = '$OtherNumber',
    Owner_First_Name = '$OwnerFirstName',
    Owner_Last_Name = '$OwnerLastName',
    Owner_Address = '$OwnerAddress',
    Well_Street_Number = $WellStreetNumber,
    Well_Street_Name = '$WellStreetName',
    Well_Town = '$WellTown', 
    Well_Zip = '$WellZip',
    Well_Lot_Number = '$WellLotNumber',
    Well_Latitude = '$WellLatitude', 
    Well_Longitude = '$WellLongitude',
    Relative_Location = '$RelativeLocation', 
    Proposed_Use = '$ProposedUse', 
    Drilling_Equipment = '$DrillingEquipment', 
    Casing_Length_Feet = '$CasingLength',
    Casing_Diameter_Inches = '$CasingDiameter',
    Casing_Weight_Per_Foot_Pounds = '$CasingWeight',
    Casing_Joint_Type = '$CasingJoint',
    Drive_Shoe = '$DriveShoe',
    Grouted = '$CasingGrouting',
    Yield_Test_Type = '$YieldType',
    Yield_Test_Hours = '$YieldHours',
    Yield_GPM = '$YieldGPM',
    Yield_Test_Notes = '$YieldNotes',
    Static_Water_Level_Feet = '$WaterDepth',
    Yield_Test_Water_Level_Feet = '$YieldWaterLevel',
    Well_Depth_Feet = '$WellDepth',
    Screen_Make = '$ScreenMake',
    Open_Screen_Length_Feet = '$OpenScreenLength',
    Screen_Slot_Size = '$ScreenSlotSize',
    Screen_Diameter_Inches = '$ScreenDiameter',
    Gravel_Packed = '$Gravel',
    Well_Diameter_Inches = '$DiameterIncludingGravel',
    Gravel_Size_Inches = '$GravelSize',
    comment = '$Comment',
    Depth_To_Top_Of_Gravel_Pack = '$DepthToTop', 
    Depth_To_Bottom_Of_Gravel_Pack = '$DepthToBottom'
    WHERE Permit_Number = $Well_ID
    LIMIT 1";
    }
    else {
    $form_update = "UPDATE well_completion_report
    SET
    Registration_Number = '$RegistrantNumber', 
    State_Well_No = '$StateWellNumber', 
    Other_No = '$OtherNumber',
    Owner_First_Name = '$OwnerFirstName',
    Owner_Last_Name = '$OwnerLastName',
    Owner_Address = '$OwnerAddress',
    Well_Street_Number = $WellStreetNumber,
    Well_Street_Name = '$WellStreetName',
    Well_Town = '$WellTown', 
    Well_Zip = '$WellZip',
    Well_Lot_Number = '$WellLotNumber',
    Well_Latitude = '$WellLatitude', 
    Well_Longitude = '$WellLongitude',
    Relative_Location = '$RelativeLocation', 
    Proposed_Use = '$ProposedUse', 
    Drilling_Equipment = '$DrillingEquipment', 
    Casing_Length_Feet = '$CasingLength',
    Casing_Diameter_Inches = '$CasingDiameter',
    Casing_Weight_Per_Foot_Pounds = '$CasingWeight',
    Casing_Joint_Type = '$CasingJoint',
    Drive_Shoe = '$DriveShoe',
    Grouted = '$CasingGrouting',
    Yield_Test_Type = '$YieldType',
    Yield_Test_Hours = '$YieldHours',
    Yield_GPM = '$YieldGPM',
    Yield_Test_Notes = '$YieldNotes',
    Static_Water_Level_Feet = '$WaterDepth',
    Yield_Test_Water_Level_Feet = '$YieldWaterLevel',
    Well_Depth_Feet = '$WellDepth',
    Screen_Make = '$ScreenMake',
    Open_Screen_Length_Feet = '$OpenScreenLength',
    Screen_Slot_Size = '$ScreenSlotSize',
    Screen_Diameter_Inches = '$ScreenDiameter',
    Gravel_Packed = '$Gravel',
    Well_Diameter_Inches = '$DiameterIncludingGravel',
    Gravel_Size_Inches = '$GravelSize',
    comment = '$Comment',
    Depth_To_Top_Of_Gravel_Pack = '$DepthToTop', 
    Depth_To_Bottom_Of_Gravel_Pack = '$DepthToBottom'
    WHERE Permit_Number = $Well_ID
    LIMIT 1";
    }
    $r_update = $mysqli->query($form_update);
    
}

if ($_GET['Admin'] == 1) {
    $query = "SELECT 
    Date_Well_Completed, 
    Date_of_Report, 
    Registration_Number, 
    State_Well_No, 
    Other_No, 
    Owner_First_Name,
    Owner_Last_Name,
    Owner_Address,
    Well_Street_Number,
    Well_Street_Name,
    Well_Town, 
    Well_Lot_Number,
    Well_Latitude, 
    Well_Longitude,
    Relative_Location, 
    Proposed_Use, 
    Drilling_Equipment, 
    Casing_Length_Feet,
    Casing_Diameter_Inches,
    Casing_Weight_per_Foot_Pounds,
    Casing_Joint_Type,
    Drive_Shoe,
    Grouted,
    Yield_Test_Type,
    Yield_Test_Hours,
    Yield_GPM,
    Yield_Test_Notes,
    Static_Water_Level_Feet,
    Yield_Test_Water_Level_Feet,
    Well_Depth_Feet,
    Screen_Make,
    Open_Screen_Length_Feet,
    Screen_Slot_Size,
    Screen_Diameter_Inches,
    Gravel_Packed,
    Well_Diameter_Inches,
    Gravel_Size_Inches,
    comment,
    Depth_To_Top_Of_Gravel_Pack, 
    Depth_To_Bottom_Of_Gravel_Pack
    FROM well_pending
    WHERE Permit_Number = $Well_ID";
    $Admin = 1;
}
else {
    $query = "SELECT 
    Date_Well_Completed, 
    Date_of_Report, 
    Registration_Number, 
    State_Well_No, 
    Other_No, 
    Owner_First_Name,
    Owner_Last_Name,
    Owner_Address,
    Well_Street_Number,
    Well_Street_Name,
    Well_Town, 
    Well_Lot_Number,
    Well_Latitude, 
    Well_Longitude,
    Relative_Location, 
    Proposed_Use, 
    Drilling_Equipment, 
    Casing_Length_Feet,
    Casing_Diameter_Inches,
    Casing_Weight_per_Foot_Pounds,
    Casing_Joint_Type,
    Drive_Shoe,
    Grouted,
    Yield_Test_Type,
    Yield_Test_Hours,
    Yield_GPM,
    Yield_Test_Notes,
    Static_Water_Level_Feet,
    Yield_Test_Water_Level_Feet,
    Well_Depth_Feet,
    Screen_Make,
    Open_Screen_Length_Feet,
    Screen_Slot_Size,
    Screen_Diameter_Inches,
    Gravel_Packed,
    Well_Diameter_Inches,
    Gravel_Size_Inches,
    comment,
    Depth_To_Top_Of_Gravel_Pack, 
    Depth_To_Bottom_Of_Gravel_Pack
    FROM well_completion_report
    WHERE Permit_Number = $Well_ID";
    $Admin = 0;
}

if ($result = $mysqli->query($query)) {
    $row = $result->fetch_assoc();
    foreach ($row as &$value) {
        if ($value == ""){
            $value == "Not Specified";
        }
    }
}
?>
<!doctype html>
<html class="no-js" lang="">

<head>
    <meta charset="utf-8">
    <meta http-equiv="x-ua-compatible" content="ie=edge">
    <title></title>
    <meta name="description" content="">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <link rel="apple-touch-icon" href="apple-touch-icon.png">
    <!-- Place favicon.ico in the root directory -->
    <link rel="stylesheet" href="css/normalize.css">
    <link rel="stylesheet" href="css/main.css">
    <link rel="stylesheet" href="css/desktop.css">
    <script src="js/vendor/modernizr-2.8.3.min.js"></script>
</head>

<body>

    <nav class="top-nav form">
        <a href="map.php">Cancel</a>
    </nav>
    
    <?php
    echo'<form id="add-well" role="form" action="form.php?Admin='.$Admin.'&Well_ID='.$Well_ID.'" method="post">';
    ?>
		<div class="group">
        <label for="well-picture">
            <img id="well-pic" src="img/add-img-icon.png"/>
        </label>
        <input type="file" id="well-picture" accept="image/*" onchange="readURL(this);">
        </div>
		<div class="group">
        <ul class="inputs" id="report-metadata">
            <li>
                <label for="well-completion-date">Date Well Completed</label>
                <?php
                $W_Completion_Date = date("m/d/Y", strtotime($row['Date_Well_Completed']));
                echo'<input name="well-completion-date" value="'.$W_Completion_Date.'" readonly>';  
                ?>
            </li>
            
            <li>
                <label for="report-completion-date">Date of Report</label>
                <?php
                $R_Completion_Date = date("m/d/Y", strtotime($row['Date_of_Report']));
                echo'<input name="report-completion-date" value="'.$W_Completion_Date.'" readonly>';  
                ?>
            </li>

            <li>
                <label for="permit-number">Permit Number</label>
                <?php
                echo'<input type="number" min="0" name="permit-number" class="long-num" value="'.$Well_ID.'" readonly>';
                ?>
            </li>

            <li>
                <label for="registrant-number">Registrant Number</label>
                <input value="<?php
                echo $row['Registration_Number'];?>
                              " type="text" min="0" name="registrant-number" class="long-num">
            </li>

            <li>
                <label for="state-well-number">State Well Number</label>
                <input value="<?php echo $row['State_Well_No'];?>" type="number" min="0" name="state-well-number" class="long-num">
            </li>

            <li>
                <label for="other-number">Other Number</label>
                <input value="<?php echo $row['Other_No'];?>" type="number" min="0" name="other-number" class="long-num">
            </li>
        </ul>
		</div>
		<div class="group">

        <h2>Owner Info</h2>
        <ul class="inputs" name="owner-info">
            <li><label for="first-name">Owner First Name</label>
            <input value="<?php echo $row['Owner_First_Name'];?>" type="text" name="first-name">
            </li>
            
            <li><label for="last-name">Owner Last Name</label>
            <input value="<?php echo $row['Owner_Last_Name'];?>" type="text" name="last-name">
            </li>

            <li>
                <label for="address">Address</label>
                <input value="<?php echo $row['Owner_Address'];?>" type="text" name="owner-address">
            </li>

        </ul>
		</div>
		<div class="group">
        <h2>Well location</h2>
        <ul class="inputs" name="owner-info">

            <li>
                <label for="address">Well Street Number</label>
                <input value="<?php echo $row['Well_Street_Number'];?>" type="text" name="well-street-number">
            </li>
            
            <li>
                <label for="address">Well Street Name</label>
                <input value="<?php echo $row['Well_Street_Name'];?>" type="text" name="well-street-address">
            </li>

            <li>
                <label for="town">Town</label>
                <input value="<?php echo $row['Well_Town'];?>" type="text" name="town">
            </li>

            <li>
                <label for="zip-code">Zip Code</label>
                <input value="" type="number" min="0" name="zip-code" class="med-num">
            </li>

            <li>
                <label for="lot-number">Lot Number</label>
                <input value="<?php
                    //Should add ternary operator for nulls and blanks
                    echo $row['Well_Lot_Number'];
                    ?>" type="number" min="0" name="lot-number" class="med-num" step="any">
            </li>

            <li name="get-gps-local">
                <label for="gps-coordinates">GPS Coordinates 
                    <img onclick="getLocation()" alt="get location" src="img/gps-black.svg">
                </label>
                <p name="demo"></p>
                <label for="gps-coordinates">Latitude</label>
                <input value="<?php
                //Should add ternary operator for nulls and blanks
                //Rounding the latitude to 6 decimal places for neatness
                $RoundLat = round($row['Well_Latitude'], 6);
                echo $RoundLat;
                ?>" type="text" name="gps-coordinates-latitude">
                <label for="gps-coordinates">Longitude</label>
                <input value="<?php
                //Should add ternary operator for nulls and blanks
                //Rounding the longitude to 6 decimal places for neatness
                $RoundLong = round($row['Well_Longitude'], 6);
                echo $RoundLong;
                ?>" type="text" name="gps-coordinates-longitude">
                
            </li>

            <li>
                <label for="relative-location">Location relative to three permanent landmarks</label>
                <textarea value="<?php
                    //Should add ternary operator for nulls and blanks
                    echo $row['Relative_Location'];
                    ?>" name="relative-location"></textarea>
            </li>

            <li>
                <label for="use">Use</label>
                <?php
                $ProposedArray = array('DOMESTIC','BUSINESS ESTABLISHMENT','FARM','TEST WELL','PUBLIC SUPPLY','INDUSTRIAL','AIR CONDITIONING','OTHER');
                echo'<select name="use">';
				    foreach ($ProposedArray as $value) {
				    //sticky form implementation for drop down, set selected to previous user input
									if ($row['Proposed_Use'] == $value) {
										echo '<option value="' . $value . '" selected="selected">' . $value . '</option>';
									} else {
										echo '<option value="' . $value . '">' . $value . '</option>';
									}
								}
                echo '</select>';
                ?>
                <input value="" type="text" name="other-use-case" class="other">
            </li>

            <li>
                <label for="drilling-equipment">Drilling equipment</label>
                <?php
                $DrillingEquipArray = array('ROTARY','COMPRESSED AIR PERCUSSION','CABLE PERCUSSION','OTHER');
                echo'<select name="drilling-equipment">';
				    foreach ($DrillingEquipArray as $value) {
				    //sticky form implementation for drop down, set selected to previous user input
									if ($row['Proposed_Use'] == $value) {
										echo '<option value="' . $value . '" selected="selected">' . $value . '</option>';
									} else {
										echo '<option value="' . $value . '">' . $value . '</option>';
									}
								}
                echo '</select>';
                ?>
                <input value="" type="text" name="other-equipment" class="other">
            </li>

        </ul>
		</div>
		<div class="group">
        <h2>Casing Details</h2>
        <ul class="inputs" name="casing-details">
            <li>
                <label for="length">Length</label>
                <input value="<?php
                    //Should add ternary operator for nulls and blanks
                    echo $row['Casing_Length_Feet'];
                    ?>" type="number" min="0" name="length" step="any"> feet
            </li>
            <li>
                <label for="diameter">Diameter</label>
                <input value="<?php
                    //Should add ternary operator for nulls and blanks
                    echo round($row['Casing_Diameter_Inches'], 5);
                    ?>" type="number" min="0" name="casing-diameter" step="any"> inches
            </li>

            <li>
                <label for="weight">Weight per foot</label>
                <input value="<?php
                    //Should add ternary operator for nulls and blanks
                    echo $row['Casing_Weight_per_Foot_Pounds'];
                    ?>" type="number" min="0" step="any" name="weight" step="any"> lbs/feet
            </li>

            <li>
                <input <?php if ($row['Casing_Joint_Type'] == 'THREADED'){echo 'checked="checked"';} ?> type="radio" name="threaded-vs-welded" value="Threaded"> Threaded
                <input <?php if ($row['Casing_Joint_Type'] == 'WELDED'){echo 'checked="checked"';} ?> value="" type="radio" name="threaded-vs-welded" value="Welded"> Welded
            </li>

            <li>
                <label for="drive-shoe">Drive Shoe?</label>
                <input <?php if ($row['Drive_Shoe'] == '1'){echo 'checked="checked"';} ?> value="" type="radio" name="drive-shoe" value="1"> Yes
                <input <?php if ($row['Drive_Shoe'] == '0'){echo 'checked="checked"';} ?> value="" type="radio" name="drive-shoe" value="0"> No
            </li>

            <li>
                <label for="casing-grouting">Was Casing Grouted?</label>
                <input <?php if ($row['Grouted'] == '1'){echo 'checked="checked"';} ?> type="radio" name="casing-grouting" value="1"> Yes
                <input <?php if ($row['Grouted'] == '0'){echo 'checked="checked"';} ?> type="radio" name="casing-grouting" value="0"> No
            </li>
        </ul>
		</div>
		<div class="group">
        <h2>Yield Test</h2>
        <ul class="inputs" name="yield-test">
            <li>
                <label for="method">Method</label>
                <select name="method">
                    <option <?php if ($row['Yield_Test_Type'] == 'BAILED'){echo 'selected="selected"';} ?> value="Bailed">Bailed</option>
                    <option <?php if ($row['Yield_Test_Type'] == 'COMPRESSED AIR'){echo 'selected="selected"';} ?>  value="COMPRESSED AIR">Compressed Air</option>
                    <option <?php if ($row['Yield_Test_Type'] == 'CABLE PERCUSSION'){echo 'selected="selected"';} ?>  value="Cable Percussion">Pumped</option>
                </select>
            </li>
            <li>
                <label for="yield-hours">Test Duration</label>
                <input value="<?php
                    //Should add ternary operator for nulls and blanks
                    
                    echo $row['Yield_Test_Hours'];
                    ?>" type="number" min="0" name="yield-hours" step="any"> Hours
            </li>

            <li>
                <label for="yield-gpm">Yield</label>
                <input value="<?php
                    //Should add ternary operator for nulls and blanks
                    
                    echo $row['Yield_GPM'];
                    ?>" type="number" min="0" name="yield-gpm" step="any"> Gallons Per Minute
            </li>
            
            <li>
                <label for="yield-test-notes">Yield Test Notes</label>
                <textarea value="<?php
                    //Should add ternary operator for nulls and blanks
                    
                    echo $row['Yield_Test_Notes'];
                    ?>" name="yield-test-notes"></textarea>
            </li>

        </ul>
		</div>
		<div class="group">
        <h2>Water Level</h2>
        <ul class="inputs" name="yield-test">
            <li>
                <label for="water-from-surface">From Land Surface</label>
                <input value="<?php
                    //Should add ternary operator for nulls and blanks
                    
                    echo $row['Static_Water_Level_Feet'];
                    ?>" type="number" min="0" name="water-from-surface" step="any"> Feet
            </li>

            <li>
                <label for="water-level-during-yield-test">During Yield Test</label>
                <input value="<?php
                    //Should add ternary operator for nulls and blanks
                    
                    echo $row['Yield_Test_Water_Level_Feet'];
                    ?>" type="number" min="0" name="water-level-during-yield-test" step="any"> Feet
            </li>

            <li>
                <label for="depth-of-well">Depth of Complete Well</label>
                <input value="<?php
                    //Should add ternary operator for nulls and blanks
                    
                    echo $row['Well_Depth_Feet'];
                    ?>" type="number" min="0" name="depth-of-well" step="any"> Feet
            </li>

        </ul>
		</div>
		<div class="group">
        <h2>Screen Details</h2>
        <ul class="inputs" name="screen-details">
            <li>
                <label for="make">Make</label>
                <input value="<?php
                    //Should add ternary operator for nulls and blanks
                    
                    echo $row['Screen_Make'];
                    ?>" type="text" name="make">
            </li>

            <li>
                <label for="length-open-to-aquifier">Length Open to Aquifier</label>
                <input value="<?php
                    //Should add ternary operator for nulls and blanks
                    
                    echo $row['Open_Screen_Length_Feet'];
                    ?>" type="number" min="0" name="length-open-to-aquifier" step="any"> Feet
            </li>

            <li>
                <label for="slot-size">Slot Size</label>
                <input value="<?php
                    //Should add ternary operator for nulls and blanks
                    
                    echo $row['Screen_Slot_Size'];
                    ?>" type="number" min="0" name="slot-size" step="any">
            </li>

            <li>
                <label for="diameter">Diameter</label>
                <input value="<?php
                    //Should add ternary operator for nulls and blanks
                    
                    echo $row['Screen_Diameter_Inches'];
                    ?>" type="number" min="0" name="screen-diameter" step="any"> Inches
            </li>

            <li>
                <label for="gravel">Gravel</label>
                <input <?php if ($row['Gravel_Packed'] == '1'){echo 'checked="checked"';} ?> type="radio" name="gravel" value="Packed"> Packed
                <input <?php if ($row['Gravel_Packed'] == '0'){echo 'checked="checked"';} ?> type="radio" name="gravel" value="Unpacked"> Unpacked
            </li>

            <li>
                <label for="diameter-including-gravel-pack">Diameter (Including Gravel Pack)</label>
                <input value="<?php
                    //Should add ternary operator for nulls and blanks
                    
                    echo $row['Well_Diameter_Inches'];
                    ?>" type="number" min="0" name="diameter-including-gravel-pack" step="any"> Inches
            </li>

            <li>
                <label for="gravel-size">Gravel Size</label>
                <input value="<?php
                    //Should add ternary operator for nulls and blanks
                    
                    echo $row['Gravel_Size_Inches'];
                    ?>" type="number" min="0" name="gravel-size" step="any"> Inches
            </li>

            <li>
                <label for="gravel-pack-location">Gravel Pack Location</label>
                <input value="<?php
                //Should add ternary operator for nulls and blanks
                echo $row['Depth_To_Top_Of_Gravel_Pack'];
                ?>" type="number" min="0" name="gravel-pack-location-from" step="any"> Feet
                <br>to<br>
                <input value="<?php
                //Should add ternary operator for nulls and blanks
                echo $row['Depth_To_Bottom_Of_Gravel_Pack'];
                ?>" type="number" min="0" name="gravel-pack-location-to" step="any"> Feet
            </li>

        </ul>
		</div>
		<div class="group">
        <h2>Other Notes</h2>
        <ul class="inputs" name="notes">

            <li>
                <textarea value="<?php
                    //Should add ternary operator for nulls and blanks
                    
                    echo $row['comment'];
                    ?>" name="notes"></textarea>
            </li>

        </ul>

        <input type="submit" value="Submit">
		</div>
    </form>


    <script src="https://code.jquery.com/jquery-1.12.0.min.js"></script>
    <script>
        window.jQuery || document.write('<script src="js/vendor/jquery-1.12.0.min.js"><\/script>')
    </script>
    <script src="js/plugins.js"></script>
    <script src="js/main.js"></script>
    <!-- Google Analytics: change UA-XXXXX-X to be your site's name. -->
    <script>
        (function (b, o, i, l, e, r) {
            b.GoogleAnalyticsObject = l;
            b[l] || (b[l] = function () {
                (b[l].q = b[l].q || []).push(arguments)
            });
            b[l].l = +new Date;
            e = o.createElement(i);
            r = o.getElementsByTagName(i)[0];
            e.src = 'https://www.google-analytics.com/analytics.js';
            r.parentNode.insertBefore(e, r)
        }(window, document, 'script', 'ga'));
        ga('create', 'UA-XXXXX-X', 'auto');
        ga('send', 'pageview');
    </script>
</body>

</html>