Skip to content
Permalink
6da1d98946
Switch branches/tags

Name already in use

A tag already exists with the provided branch name. Many Git commands accept both tag and branch names, so creating this branch may cause unexpected behavior. Are you sure you want to create this branch?

Wello/Wello/www/details.php

Go to file
 
 
Cannot retrieve contributors at this time
134 lines (123 sloc) 3.89 KB
Raw Blame
<?php require 'cred.php';
$mysqli = new mysqli("localhost", $username, $password, $database);
if ( (isset($_GET['Well_ID']))) {
$Well_ID = $_GET['Well_ID'];
}
else if ( (isset($_POST['Well_ID']))) {
$Well_ID = $_POST['Well_ID'];
}
else {
$Well_ID = "0";
}
$query = "SELECT
well_pics,
Date_Well_Completed,
Date_of_Report,
Registration_Number,
State_Well_No,
Other_No,
CONCAT(Owner_First_Name, ' ', Owner_Last_Name) AS 'Owner_Name',
Owner_Address,
CONCAT(Well_Street_Number, ' ', Well_Street_Name) AS 'WellAddress',
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";
if ($result = $mysqli->query($query)) {
$row = $result->fetch_assoc();
}
foreach ($row as $key => $value) {
if (is_null($value)) {
$row[$key] = "-";
} elseif ($value == ""){
$row[$key] = "-";
} elseif ($value == "1"){
$row[$key] = "yes";
} elseif ($value == "0"){
$row[$key] = "no";
}
}
?>
<!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>
<!--[if lt IE 8]>
<p class="browserupgrade">You are using an <strong>outdated</strong> browser. Please <a href="http://browsehappy.com/">upgrade your browser</a> to improve your experience.</p>
<![endif]-->
<!-- Add your site or application content here -->
<nav class="top-nav">
<a href="map.php"><img alt="back" src="img/back.svg" ></a> <h1>Details</h1>
<?php
echo'<a href="form.php?Well_ID='.$Well_ID.'"><img alt="edit" src="img/edit.svg" ></a>';
?>
</nav>
<main class="details">
<?php
include 'details-content.php';
?>
<main class="details">
<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 ID. -->
<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>