Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $connection = mysql_connect('localhost',"sernec","sernec");
- if(!$connection){ die('Not connected : '.mysql_error()); }
- $db_selected = mysql_select_db("SERNEC",$connection);
- if(!$db_selected){ die('Cant use db: '.mysql_error()); }
- if (isset($_GET["state"])) {
- $state_name = $_GET["state"];
- // echo $_GET['state_name'];
- }
- else
- echo "didn't get it";
- if (isset($_GET["county"])) {
- $county_name = $_GET["county"];
- // echo $_GET['county_name'];
- }
- else
- echo "didn't get it";
- if (isset($_GET["genus"])) {
- $genus = $_GET["genus"];
- //echo $_GET['state_name'];
- }
- else
- echo "didn't get it";
- echo "\"state_name\"" . ",". "\"county_name\"". "," . "\"fips\"" . "," . "\"count\"" . "," . "\"entries\"" . "," . "\"category\"" . ",";
- for($i=1;$i<=85;$i++)
- {
- echo "\"lat$i\"". ",". "\"lng$i\"".",";
- }
- echo "\n";
- if(!$_GET["genus"]){
- $query = "SELECT * FROM SECountiesEntries s, Tennessee t WHERE s.fips=t.Fips and t.State='".$state_name."' and t.County='".$county_name."'";
- }
- else
- {
- $query = "SELECT * FROM SECountiesEntries s, Tennessee t WHERE s.fips=t.Fips and t.State='".$state_name."' and t.County='".$county_name."' and t.Genus='".$genus."'";
- }
- $result = mysql_query($query);
- if(!$result){
- die('Invalid query: ' .mysql_error());
- }
- while($row = mysql_fetch_row($result))
- {
- for($i=0;$i<=6;$i++)
- {
- echo $row[$i]. ",";
- }
- echo "\n";
- }
- mysql_close($connection);
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement