if ($pPermalink && $parksQuery) {
$result = mysqli_query($db, $parksQuery) or die("Couldn't execute query.");
while ($row = mysqli_fetch_array($result)) {
$parkID = $row["id"];
$parkName = $row["name"];
$parkPermalink = $row["permalink"];
$parkCategory = $row["category"];
$parkAddress = $row["address"];
$parkCity = $row["city"];
$parkState = $row["state"];
$parkZip = $row["zip"];
$parkMapAddress = str_replace(" ","+",$parkAddress.", ".$parkCity.", IA");
$parkIntro = $row["intro"];
$parkDescription = $row["description"];
$parkMessage = $row["message"];
$parkAmenities = $row["tags"];
if ($parkAmenities) {
$parkAmenities = str_replace("Archery Range"," Archery Range",$parkAmenities);
$parkAmenities = str_replace("Biking"," Biking",$parkAmenities);
$parkAmenities = str_replace("Birding"," Bird",$parkAmenities);
$parkAmenities = str_replace("Boating"," Boating",$parkAmenities);
$parkAmenities = str_replace("Camping"," Camping",$parkAmenities);
$parkAmenities = str_replace("Canoeing"," Canoeing",$parkAmenities);
$parkAmenities = str_replace("Cross Country Skiing"," Cross Country Skiing",$parkAmenities);
$parkAmenities = str_replace("Disc Golf"," Disc Golf",$parkAmenities);
$parkAmenities = str_replace("Dog Training"," Dog Training",$parkAmenities);
$parkAmenities = str_replace("Fishing"," Fishing",$parkAmenities);
$parkAmenities = str_replace("Geocaching"," Geocaching",$parkAmenities);
$parkAmenities = str_replace("Hiking"," Hiking",$parkAmenities);
$parkAmenities = str_replace("Horseback Riding"," Horseback Riding",$parkAmenities);
$parkAmenities = str_replace("Hunting"," Hunting",$parkAmenities);
$parkAmenities = str_replace("Nature Study"," Nature Study",$parkAmenities);
$parkAmenities = str_replace("Picnicking"," Picnicking",$parkAmenities);
$parkAmenities = str_replace("Playgrounds"," Playgrounds",$parkAmenities);
$parkAmenities = str_replace("Sledding"," Sledding",$parkAmenities);
$parkAmenities = str_replace("Snowmobile"," Snowmobile",$parkAmenities);
$parkAmenities = str_replace("Sport Courts"," Sport Courts",$parkAmenities);
$parkAmenities = str_replace("Swimming"," Swimming",$parkAmenities);
$parkAmenities = str_replace("Trapping"," Trapping",$parkAmenities);
$parkAmenities = str_replace("Walking"," Walking",$parkAmenities);
$parkDisplayAmenities = "
";
$parkDisplayAmenities .= str_replace(", ","
",$parkAmenities);
$parkDisplayAmenities .= "
";
}
$featuredPhoto = $row["featuredPhoto"];
$featuredPhotoSm = str_replace(".jpg","_sm.jpg",$featuredPhoto);
$featuredPhotoMed = str_replace(".jpg","_med.jpg",$featuredPhoto);
$parkImagePosition = $row["imagePosition"];
if (!$parkImagePosition) {
$parkImagePosition = "center center";
}
$parkOpen = $row["parkOpen"];
if ($parkOpen == "00:00:00") { $displayParkOpen = ""; }
elseif ($parkOpen == "00:02:00") { $displayParkOpen = "Sunrise"; }
else {
$displayParkOpen = date("g:ia",strtotime($parkOpen));
$displayParkOpen = str_replace("am"," a.m.",$displayParkOpen);
$displayParkOpen = str_replace("pm"," p.m.",$displayParkOpen);
}
$parkClose = $row["parkClose"];
if ($parkClose == "00:00:00") { $displayParkClose = ""; }
elseif ($parkClose == "00:02:00") { $displayParkClose = "Sunset"; }
else {
$displayParkClose = date("g:ia",strtotime($parkClose));
$displayParkClose = str_replace("am"," a.m.",$displayParkClose);
$displayParkClose = str_replace("pm"," p.m.",$displayParkClose);
}
$parkReservation = $row["facebook"];
$parkBrochure = $row["brochureURL"];
# For Map Display Only
$parkLatitude = $row["latitude"];
$parkLongitude = $row["longitude"];
# Unused
$parkPhone = $row["phone"];
$parkDirections = $row["directions"];
$pageName = $parkName;
$displayTitle = $parkName;
$metaTitle = $displayTitle . " - Conservation - Muscatine County, Iowa";
$pageIntroduction = $parkIntro;
$pageContent = $parkDescription;
$pageContent = createButtons($pageContent);
$sectionParent = "Parks & Wildlife Areas";
$sectionParentURL = "/conservation/parks/";
$contentName = $pageName;
# Find Gallery Photos
$galleryQuery = "SELECT * FROM `parkGalleries` WHERE `clientID` = '$clientID' AND `parkID`='$parkID' ORDER BY `priority` ASC, `name` ASC";
$result = mysqli_query($db, $galleryQuery) or die("Couldn't execute query.");
$gC = 1;
while ($row = mysqli_fetch_array($result)) {
$parkGalleryID[$gC] = $row["id"];
$parkGalleryParkID[$gC] = $row["parkID"];
$parkGalleryParkName[$gC] = $fName[$parkGalleryParkID[$gC]];
$parkGalleryName[$gC] = $row["name"];
$parkGalleryDescription[$gC] = $row["description"];
$parkGalleryCredit[$gC] = $row["credit"];
$parkGallerySrc[$gC] = $row["src"];
$parkGallerySrcMed[$gC] = str_replace(".jpg","_med.jpg",$parkGallerySrc[$gC]);
$parkGalleryPriority[$gC] = $row["priority"];
$gC++;
}
if ($parkHeaderPhoto) {
$defaultPageHeader = "parks/" . $parkHeaderPhoto;
$defaultPageHeaderPosition = $parkImagePosition;
}
}
}
?>
Upcoming Holiday Closure Schedule
- Memorial Day (May 25, 2026)
- Independence Day (July 3, 2026)
- Labor Day (September 7, 2026)
- Veterans' Day (November 11, 2026)
- Thanksgiving (November 26, 2026)
- Day after Thanksgiving (November 27, 2026)
- Christmas Eve (December 24, 2026)
- Christmas (December 25, 2026)