addwell.php

<?php 
require 'cred.php';
$mysqli = new mysqli("localhost", $username, $password, $database);

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']));  

    
    $Insert_Query = "INSERT INTO well_pending (
    Permit_Number,
    Registration_Number,
    State_Well_No,
    Other_No,
    Owner_First_Name,
    Owner_Last_Name) 
    VALUES (
    '$PermitNumber',
    '$RegistrantNumber',
    '$StateWellNumber',
    '$OtherNumber',
    '$OwnerFirstName',
    '$OwnerLastName')";
    
    
    $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($Insert_Query);
    
}
?>
<!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="addwell.php" 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>
                <input name="well-completion-date" >
            </li>
            
            <li>
                <label for="report-completion-date">Date of report</label>
                <input name="report-completion-date">
            </li>

            <li>
                <label for="permit-number">Permit number</label>
                <input type="number" min="1" name="permit-number" class="long-num">
            </li>

            <li>
                <label for="registrant-number">Registrant number</label>
                <input type="text" min="1" name="registrant-number" class="long-num">
            </li>

            <li>
                <label for="state-well-number">State well number</label>
                <input type="number" min="1" name="state-well-number" class="long-num">
            </li>

            <li>
                <label for="other-number">Other number</label>
                <input type="number" min="1" 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 type="text" name="first-name">
            </li>
            
            <li><label for="last-name">Owner Last Name</label>
            <input type="text" name="last-name">
            </li>

            <li>
                <label for="address">Address</label>
                <input 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 type="text" name="well-street-number">
            </li>
            
            <li>
                <label for="address">Well Street Name</label>
                <input type="text" name="well-street-address">
            </li>

            <li>
                <label for="town">Town</label>
                <input type="text" name="town">
            </li>

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

            <li>
                <label for="lot-number">Lot number</label>
                <input type="number" min="1" 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 type="text" name="gps-coordinates-latitude">
                <label for="gps-coordinates">Longitude</label>
                <input type="text" name="gps-coordinates-longitude">
                
            </li>

            <li>
                <label for="relative-location">Location relative to three permanent landmarks</label>
                <textarea 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) {
				        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) {
				        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 type="number" min="1" name="length" step="any"> feet
            </li>
            <li>
                <label for="diameter">Diameter</label>
                <input type="number" min="1" name="casing-diameter" step="any"> inches
            </li>

            <li>
                <label for="weight">Weight per foot</label>
                <input type="number" min="1" step="any" name="weight" step="any"> lbs/feet
            </li>

            <li>
                <input type="radio" name="threaded-vs-welded" value="Threaded"> Threaded
                <input type="radio" name="threaded-vs-welded" value="Welded"> Welded
            </li>

            <li>
                <label for="drive-shoe">Drive shoe</label>
                <input type="radio" name="drive-shoe" value="1"> yes
                <input type="radio" name="drive-shoe" value="0"> no
            </li>

            <li>
                <label for="casing-grouting">Was casing grouted</label>
                <input type="radio" name="casing-grouting" value="1"> yes
                <input 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 value="Bailed">Bailed</option>
                    <option value="COMPRESSED AIR">Compressed Air</option>
                    <option value="Cable Percussion">Pumped</option>
                </select>
            </li>
            <li>
                <label for="yield-hours">Test duration</label>
                <input type="number" min="1" name="yield-hours" step="any"> hours
            </li>

            <li>
                <label for="yield-gpm">Yield</label>
                <input type="number" min="1" name="yield-gpm" step="any"> gallons per minute
            </li>
            
            <li>
                <label for="yield-test-notes">Yield test notes</label>
                <textarea 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 type="number" min="1" name="water-from-surface" step="any"> feet
            </li>

            <li>
                <label for="water-level-during-yield-test">During yield test</label>
                <input type="number" min="1" name="water-level-during-yield-test" step="any"> feet
            </li>

            <li>
                <label for="depth-of-well">Depth of complete well</label>
                <input type="number" min="1" 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 type="text" name="make">
            </li>

            <li>
                <label for="length-open-to-aquifier">Length open to aquifier</label>
                <input type="number" min="1" name="length-open-to-aquifier" step="any"> feet
            </li>

            <li>
                <label for="slot-size">Slot size</label>
                <input type="number" min="1" name="slot-size" step="any">
            </li>

            <li>
                <label for="diameter">Diameter</label>
                <input type="number" min="1" name="screen-diameter" step="any"> inches
            </li>

            <li>
                <label for="gravel">Gravel</label>
                <input type="radio" name="gravel" value="Packed"> Packed
                <input type="radio" name="gravel" value="Unpacked"> Unpacked
            </li>

            <li>
                <label for="diameter-including-gravel-pack">Diameter including gravel pack</label>
                <input type="number" min="1" name="diameter-including-gravel-pack" step="any"> inches
            </li>

            <li>
                <label for="gravel-size">Gravel size</label>
                <input type="number" min="1" name="gravel-size" step="any"> inches
            </li>

            <li>
                <label for="gravel-pack-location">Gravel pack location</label>
                <input type="number" min="1" name="gravel-pack-location-from" step="any"> feet
                <br>to<br>
                <input type="number" min="1" 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 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>