Skip to content
Permalink
2dd0c734a3
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/wells-list.php

Go to file
 
 
Cannot retrieve contributors at this time
134 lines (117 sloc) 4.45 KB
Raw Blame
<!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/well-card.css">
<link rel="stylesheet" href="css/map-desktop.css">
<link rel="stylesheet" href="css/desktop.css">
<script src="js/vendor/modernizr-2.8.3.min.js"></script>
<?php
require 'cred.php';
$mysqli = new mysqli("localhost", $username, $password, $database);
/* check connection */
if ($mysqli->connect_errno) {
printf("Connect failed: %s\n", $mysqli->connect_error);
exit();
}
if (isset($_GET['lat']) && isset($_GET['long'])) {
$lat = (float)$_GET['lat'];
$lat2 = (float)$_GET['lat'] + 1;
$lat1 = (float)$_GET['lat'] - 1;
$long = (float)$_GET['long'];
$long2 = (float)$_GET['long'] + 1;
$long1 = (float)$_GET['long'] - 1;
$query = "SELECT
Well_Longitude,
Well_Longitude,
CONCAT(Well_Street_Number, ' ', Well_Street_Name) AS 'WellAddress', Well_Town, Permit_Number
FROM well_completion_report
WHERE (Well_Latitude BETWEEN $lat1 AND $lat2) AND (Well_Longitude BETWEEN $long1 AND $long2)
ORDER BY (((Well_Longitude-$long)*(Well_Longitude-$long)) + ((Well_Latitude-$lat)*(Well_Latitude-$lat))) ASC
LIMIT 30
";
} else {
echo "
<script type='text/javascript'>
if (navigator.geolocation) {
navigator.geolocation.getCurrentPosition(function (position) {
var lat = position.coords.latitude;
var long = position.coords.longitude;
location.href = 'http://wellreportapp.uconn.edu/wells-list.php?lat=' + lat + '&long=' + long;
});
}
</script>
";
}
//$query = "SELECT CONCAT(Well_Street_Number, ' ', Well_Street_Name) AS 'WellAddress', Well_Town, Permit_Number FROM well_completion_report LIMIT 10";
?>
</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">
<div class="main-bttns">
<h1>Nearby Wells</h1>
<a href="search.php"> <img src="img/search.svg" alt="menu"> </a>
</div>
</nav>
<main class="list">
<h1 class="title">Nearby Wells</h1>
<?php
if ($result = $mysqli->query($query)) {
/* fetch associative array */
while ($row = $result->fetch_assoc()) {
echo'
<a href="details.php?Well_ID='.$row["Permit_Number"].'">
<div class="well-card clearfix">
<div class="well-img"></div>
<div>
<h2>'.$row["WellAddress"].'</h2>
<h2>'.$row["Well_Town"].'</h2>
<p>Permit Number: '.$row["Permit_Number"].'</p>
</div>
</div>
</a>';
}
/* free result set */
$result->free();
}
?> </main>
<nav class="bottom-nav">
<a href="map.php"><img src="img/map.svg" alt="menu" /></a>
<a href="wells-list.php"><img src="img/list.svg" alt="menu" /></a>
</nav>
<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>