setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); $db->setAttribute(PDO::ATTR_DEFAULT_FETCH_MODE, PDO::FETCH_ASSOC); } catch(PDOException $e) { return 'Connection failed : '.$e->getMessage(); } // Get Watershed selections $sql_watershed_selections = $db->prepare("SELECT DISTINCT tblAUsStreamMiles.area FROM tblAUsStreamMiles WHERE tblAUsStreamMiles.area NOT LIKE '%County' "); try { $sql_watershed_selections->execute(); } catch (Exception $e) { die("Watershed selections query failed: " . $e->getMessage()); } $watershed_selections = $sql_watershed_selections->fetchAll(); // fetch counties $sql_county_selections = $db->prepare("SELECT DISTINCT tblAUsStreamMiles.area FROM tblAUsStreamMiles WHERE tblAUsStreamMiles.area LIKE '%county' "); try { $sql_county_selections->execute(); } catch (Exception $e) { die("County selections query failed: " . $e->getMessage()); } $county_selections = $sql_county_selections->fetchAll(); // Get years for stream miles data $sql_stream_miles_year = $db->prepare("SELECT DISTINCT tblAUsStreamMiles.ir_year FROM tblAUsStreamMiles "); try { $sql_stream_miles_year->execute(); } catch (Exception $e) { die("Years Query failed: ".$e->getMessage()); } $stream_miles_years_array = $sql_stream_miles_year->fetchAll(); $output = <<

Select year: HTML; foreach ($watershed_selections as $watershed) { $watershed_area = $watershed['area']; $output .= <<$watershed_area HTML; } $output .= <<

Select year: HTML; foreach ($county_selections as $county) { $county_area = $county['area']; $output .= <<$county_area HTML; } $output .= <<

HTML; return $output; }