HOST,'user'=>DBUSER,'password'=>DBPASS,'database'=>DBNAME)); $siteDataObj = new SiteData($dbObj); $stateDataArr = getStateArr($dbObj); $breedsdDataArr = getBreedsArr($dbObj); $sideMenuHTML = ""; if(!isset($_GET['page']))$_GET['page'] = 1; // determine page request type if(trim($_SERVER['QUERY_STRING'])==""){ // show state list of breeders with count $breedersArr = array(); $html .= "

Hunting Dog breeders by state

"; $query = "SELECT COUNT(breeders.id) as breederCount, state.stateName, countries.country FROM state LEFT JOIN breeders ON (state.id = breeders.state AND breeders.active = 1), countries WHERE state.country = countries.id GROUP BY state.id ORDER BY state.stateName"; $dbObj->performQuery($query); while($row = $dbObj->fetchRow()){ $breedersArr[$row['country']][] = $row; } $html .="
"; $pageTitle = "Hunting Dog Breeders"; $metaDescription = "Find gun dog breeders by State or by hunting dog breeds. Bird dog puppy for sale classified ads include started and finished dogs for sale."; $metaKeywords = "gun dogs, hunting dogs, dog breeders, trainers, bird dog, kennel, puppy for sale, started, finished, male, female, puppies, sporting breeds, USA and Canada"; // record hit //$dbObj->performQuery("INSERT INTO traffic SET mark = NOW(), referringIP = '{$_SERVER['REMOTE_ADDR']}', type = 'incoming', pageType='breeder'"); } else if(isset($_GET['breederName']) && isset($_GET['stateID'])){ // show breeder data $query = "SELECT breeders.id, breeders.name, breeders.linkName, breeders.services, breeders.address, breeders.zip, breeders.city, breeders.phone, breeders.secPhone, breeders.contact, breeders.writeup, breeders.businessYrs, breeders.breeds, breeders.dateModified, breeders.logo, breeders.imgExt, breeders.expires, breeders.email, breeders.website, state.stateName, count(classifieds.id) as classifiedsCount FROM breeders LEFT JOIN classifieds ON classifieds.ownerID = breeders.id AND classifieds.expires >= NOW(), state WHERE breeders.state = state.id AND breeders.linkName LIKE '".linkFormat::stripDashes($_GET['breederName'])."' AND breeders.active = 1 AND state.stateName LIKE '".LinkFormat::stripDashes($_GET['stateID'])."' GROUP BY breeders.id"; $dbObj->performQuery($query); if($row = $dbObj->fetchRow()){ $html = ""; $services = ""; if(strtotime($row['expires'])>strtotime("now")){ $paid=1; $dataContainerClass = "dataContainer2"; } else { $dataContainerClass = "dataContainer"; } if(trim($row['logo']!="" && trim($row['imgExt']!=""))){ if($row['imgExt']==".png"){ } else { $html.= "
siteURL."/logoImages/".$row['id'].$row['imgExt']."\" alt=\"".$row['name']."\" class=\"breederLogo\"/>
"; } } $breederID = $row['id']; if(trim($row['writeup'])!=""){ $html .= "
About ".$row['name']."
"; $html .= "
".preg_replace("~ ~"," ",$row['writeup'])."
"; } $thisBreedsArr = getBreedNames($row['breeds'],$breedsdDataArr); $html .= "
Hunting Dog Breeds Raised
"; $html .= "
".implode(", ",$thisBreedsArr)."
"; $sideMenuHTML .= '
Search by Breed
'; foreach($thisBreedsArr as $value){ $sideMenuHTML.="
$value
"; } $sideMenuHTML.="Search Breeders by ".LinkFormat::stripDashes($_GET['stateID']).""; $sideMenuHTML.=" "; if(trim($row['services'])!=""){ $services = str_replace(",",", ",$row['services']); $html .= "
Additional Services
"; $html .= "
$services
"; } $html .= "
Breeder Contact Info
"; $html .= "
".$row['contact']."
"; if(trim($row['address'])!="")$html .= $row['address']."
"; if(trim($row['city'])!="")$html .= $row['city'].", "; $html .= $row['stateName']; if(trim($row['zip'])!="")$html .= " ".$row['zip']; $html .="
"; if($row['businessYrs']>0){ $html .= "
Breeding quality gun dogs for over {$row['businessYrs']} years.
"; } if(trim($row['phone'])!="") $html .= "
".$row['phone']."
"; if(trim($row['secPhone'])!="") $html .= "
".$row['secPhone']."
"; if(trim($row['email'])!="") $html .= "mobileSiteURL}/contactBreeder{$breederID}.html\" class=\"email link\" > Send Email to {$row['name']}"; if(trim($row['website'])!="") $html .= " Click here to visit {$row['name']} website"; $html .= "
"; if($row['classifiedsCount']>0){ $html .= "
Puppies for sale
\n
"; $query = "SELECT title,id FROM classifieds WHERE classifieds.ownerID = $breederID AND expires >= NOW() ORDER BY dateAdded DESC"; $dbObj->performQuery($query); while($cRow = $dbObj->fetchRow()){ $html.="mobileSiteURL."/classifieds/".$cRow['id'].".html\" class=\"breederSMLink link\"> ".$cRow['title'] .""; } $html .= "
"; } // get pedigrees $query = "SELECT title, id FROM pedigrees WHERE owner = ".$row['id']." AND showOnBreedPage = 1 ORDER BY title"; $dbObj->performQuery($query); $pedigreeArr = array(); while($pRow = $dbObj->fetchRow()){ $pedigreeArr[] = "mobileSiteURL}/pedigree{$pRow['id']}.html\">{$pRow['title']}"; } if(count($pedigreeArr)>0){ $html .= "
Our Pedigrees
"; $html .= "
"; $html .= implode("
",$pedigreeArr); $html .= "

"; } // get testimonials $testInitLimit = 10; $query = "SELECT count(id) as totalReviews FROM reviews WHERE ownerID = {$row['id']} AND active = 1 "; $dbObj->performQuery($query); if($revCount = $dbObj->fetchRow()){ $totalReviews = $revCount['totalReviews']; } else { $totalReviews = 0; } $query = "SELECT name, dateCreated, rating, comment FROM reviews WHERE ownerID = ".$row['id']." AND (active = 1 OR ip = '".$_SERVER['REMOTE_ADDR']."') ORDER BY dateCreated DESC LIMIT $testInitLimit"; $dbObj->performQuery($query); $reviewArr =array(); while($rRow = $dbObj->fetchRow()){ $reviewArr[] = "
Submitted by: ".$rRow['name']." on ".formatDate($rRow['dateCreated'])."
".nl2br($rRow['comment']); } $html .= "
Testimonials ($totalReviews)"; $html .= ($totalReviews>$testInitLimit)?' You are viewing the 10 most recent - Click here for more reviews':""; $html .= "
"; $html .= "
"; if(count($reviewArr)>0){ $html .= "
".implode("
",$reviewArr)."
"; } else { $html .= "No testimonials for this breeder"; } $html.= ($totalReviews>$testInitLimit)?' More Reviews for '.$row['name'].'':""; $html .= "mobileSiteURL."/testimonials.html?breederID=".$row['id']."\" class=\"link\"> Submit your testimonial"; $html .= "
"; $pageTitle = "{$row['name']} - {$row['stateName']} ".implode(", ",$thisBreedsArr)." Breeders"; $metaDescription = showFirst($row['writeup'],255); $metaKeywords = showFirst($row['name'],255).", ".$row['stateName']." gun dog breeder, ".implode(", ",$thisBreedsArr).", puppy for sale, litter, started, finished, stud, breed, puppies, dogs".((trim($services)!="")?" ,$services":""); // record hit $dbObj->performQuery("INSERT INTO traffic SET mark = NOW(), referringIP = '{$_SERVER['REMOTE_ADDR']}', breederID= {$row['id']}, type = 'incoming', pageType='breeder'"); } else { //$html = showImproperRequest(); //$pageTitle = "Error"; $query = "SELECT stateName FROM state WHERE stateName LIKE '".LinkFormat::stripDashes($_GET['stateID'])."'"; $dbObj->performQuery($query); if($row = $dbObj->fetchRow()){ header ("HTTP/1.0 404 Not Found"); $pageTitle = LinkFormat::stripDashes($_GET['breederName'])." is not listed on our site"; $html = "To view other breeders in {$row['stateName']} click here"; /// show breed list $breedLinksArr = getBreedCountList($dbObj); $html .= "
View breeders by gun dog breed
"; $html .= tableResults($breedLinksArr,1,100,""); } else { showImproperRequest(); exit(); } } } else if(isset($_GET['breeds'])){ // show breeders by breeds. $html = ""; $query = "SELECT breeds,description, id FROM breeds WHERE breeds LIKE '".LinkFormat::stripDashes($_GET['breeds'],SQLREADY)."'"; $dbObj->performQuery($query); if($row = $dbObj->fetchRow()){ $breed = $row['breeds']; $breedID = $row['id']; } else { showImproperRequest(); exit(); } $query = "SELECT breeders.name, breeders.linkName, breeders.services, breeders.city, breeders.breeds, breeders.dateModified, breeders.id, state.stateName, breeds.id as breedIdent, breeders.expires, COUNT(reviews.id) as reviewCount FROM breeders LEFT JOIN reviews ON reviews.ownerID = breeders.id AND reviews.active = 1, state, breeds WHERE breeders.state = state.id AND breeders.active = 1 AND breeds.id = $breedID AND breeders.breeds REGEXP CONCAT('(,|^)',breeds.id,'(,|$)') GROUP BY breeders.id ORDER BY IF(breeders.expires >=NOW(),0,1), reviewCount DESC, breeders.businessYrs DESC"; $pg=&new Pager($dbObj,$query,50); $resArr = $pg->displayRecords($_GET['page'],"$siteDataObj->mobileSiteURL/breeders-by-breed/{$_GET['breeds']}/breeders"); if(count($resArr['results'])>0){ $html = ""; $thisPageAd = getCategoryAd($dbObj,$breedID,'ads_by_cat'); if($thisPageAd!=""){ $html .= $thisPageAd; } else { $html .= getAdsense(); } $a = 0; $breederDataArr = array(); foreach($resArr['results'] as $row){ $breederDataArr[] = $row; } foreach($breederDataArr as $row){ //if($a == 25) $html .= getAdsense(); $thisBreedsArr = getBreedNames($row['breeds'],$breedsdDataArr); $html .= formatListing($row, $a, $siteDataObj, $thisBreedsArr, $dbObj); $stateName = $row['stateName']; $a++; } if($a>5) $html .= ""; } else { $html .= "

About the ".$breed."
".$row['description']."


"; $html .= "

Sorry, we do not have any listings for this gun dog breed

"; $html .= "

mobileSiteURL.$_SERVER['PHP_SELF']."\">Click here to do another search.

"; } $pageTitle = "$breed Puppies For Sale by $breed Breeders, Trainers and Kennels"; $metaDescription = "Find $breed puppies for sale from gun dog breeders who raise $breed puppies and offer started $breed dogs, finished dogs and $breed puppies for sale."; $metaKeywords = "$breed puppies, $breed breeders, $breed puppy for sale, $breed dogs, Female, Male, Puppies, Breeders, Kennels, Started, Finished, stud, pups"; // record hit //$dbObj->performQuery("INSERT INTO traffic SET mark = NOW(), referringIP = '{$_SERVER['REMOTE_ADDR']}', breedID = (SELECT id FROM breeds WHERE breeds LIKE '".Linkformat::stripDashes($_GET['breeds'])."'), type = 'incoming', pageType='breeder'"); } else if(isset($_GET['stateID'])){ // Breeders by State // assumes only state has been set $stateID = LinkFormat::stripDashes($_GET['stateID']); $query = "SELECT breeders.name,breeders.linkName,breeders.services,breeders.city, breeders.breeds, breeders.dateModified, breeders.id, state.stateName,state.abbv, breeders.expires, COUNT(reviews.id) as reviewCount FROM breeders LEFT JOIN reviews ON reviews.ownerID = breeders.id, state WHERE breeders.state = state.id AND breeders.active = 1 AND state.stateName LIKE '$stateID' GROUP BY breeders.id ORDER BY IF(breeders.expires >=NOW(),0,1), reviewCount DESC, breeders.businessYrs DESC"; $pg=&new Pager($dbObj,$query,50); $resArr = $pg->displayRecords($_GET['page'],"$siteDataObj->mobileSiteURL/breeders-{$_GET['stateID']}/breeders"); //$stateClassifiedLink = "View puppies for sale in $stateID by $stateID gun dog breeders."; if(count($resArr['results'])>0){ $html = ""; $html .= getAdsense(); $a = 0; $breederDataArr = array(); foreach($resArr['results'] as $row){ $breederDataArr[] = $row; } foreach($breederDataArr as $row){ //if($a == 25) $html .= getAdsense(); $thisBreedsArr = getBreedNames($row['breeds'],$breedsdDataArr); $stateName = "{$row['stateName']}"; $html .= formatListing($row, $a, $siteDataObj, $thisBreedsArr, $dbObj); $a++; } if($a>5) $html .= ""; } else { $query = "SELECT stateName, abbv FROM state WHERE stateName LIKE '$stateID'"; $dbObj->performQuery($query); if($row = $dbObj->fetchRow()){ $stateName = "{$row['abbv']} – {$row['stateName']}"; $html .= "

Sorry, we don't have any listings for Gun Dog Breeders in this state.

"; $html .= "

mobileSiteURL.$_SERVER['PHP_SELF']."\">Click here to do another search.

"; } else { showImproperRequest(); exit(); } } $pageTitle = "Hunting Dog Puppies in $stateName and $stateName Bird Dog Breeders"; $metaDescription = "Find hunting dog breeders in $stateName with bird dog puppies for sale as well as started and finished bird hunting dogs raised and trained in $stateName."; $metaKeywords = "$stateName hunting dog breeders, bird dogs, hunting, puppy for sale, $stateName dog kennels, breeder, kennel, puppies, female, male, pup"; // record hit //$dbObj->performQuery("INSERT INTO traffic SET mark = NOW(), referringIP = '{$_SERVER['REMOTE_ADDR']}', stateID = (SELECT id FROM state WHERE stateName LIKE '$stateID'), type = 'incoming', pageType='breeder'"); } else if(isset($_GET['allBreeders'])){ // All breeders by alpha $resultsPerPage = 50; $query = "SELECT breeders.name,breeders.linkName,breeders.city,breeders.breeds,breeders.dateModified, breeders.expires, breeders.id, state.stateName, count(classifieds.id) as classifiedsCount FROM state, breeders LEFT JOIN classifieds ON (breeders.id = classifieds.ownerID AND classifieds.expires >= NOW()) WHERE breeders.active = 1 AND breeders.state = state.id GROUP BY breeders.id ORDER BY IF(breeders.expires >=NOW(),0,1), breeders.name"; $pg=&new Pager($dbObj,$query,$resultsPerPage); $resArr = $pg->displayRecords($_GET['page'],"allBreeders"); $a = 0; if(count($resArr['results'])>0){ $html = ""; $html .= getAdsense(); $breederDataArr = array(); foreach($resArr['results'] as $row){ $breederDataArr[] = $row; } foreach($breederDataArr as $row){ //if($a == 25) $html .= getAdsense(); $thisBreedsArr = getBreedNames($row['breeds'],$breedsdDataArr); $html .= formatListing($row, $a, $siteDataObj, $thisBreedsArr, $dbObj); $stateName = $row['stateName']; $a++; } if($a>5) $html .= ""; } $pageTitle = "All Gun Dog Breeders in USA and Canada"; $metaDescription = "Find gun dog breeders in USA and Canada with bird dog puppies for sale as well as started dogs, finished dogs and training for hunting dogs and sporting breeds."; $metaKeywords = "gun dog, hunting dog breeder, bird dogs, USA dog breeders, Canada puppy for sale, kennel, hunting, bird, started, finished dogs, training, pup, pointer, retriever, setter "; $metaSEO = ""; } else if(isset($_GET['canadaBreeders'])){ // Canada breeders by alpha $resultsPerPage = 50; $html = ""; $query = "SELECT COUNT(breeders.id) as breederCount, state.stateName, countries.country FROM state LEFT JOIN breeders ON (state.id = breeders.state AND breeders.active = 1), countries WHERE state.country = countries.id AND breeders.country = 2 GROUP BY state.id ORDER BY state.stateName"; $dbObj->performQuery($query); while($row = $dbObj->fetchRow()){ $breedersArr[$row['country']][] = $row; } $itemArr = array(); $optionArr = array(); foreach($breedersArr as $key => $value){ if(is_array($value) && count($value)>0){ foreach($value as $stateBreederData){ $itemArr[] = "mobileSiteURL."/breeders-".LinkFormat::addDashes($stateBreederData['stateName'],lcase)."/\">{$stateBreederData['stateName']}". (($stateBreederData['breederCount']>0)?" (".$stateBreederData['breederCount'].")":""); $optionArr[] = ""; } } $html .="
"; } $query = "SELECT breeders.name,breeders.linkName,breeders.city,breeders.breeds,breeders.dateModified, breeders.expires, breeders.id, state.stateName, count(classifieds.id) as classifiedsCount FROM state, breeders LEFT JOIN classifieds ON (breeders.id = classifieds.ownerID AND classifieds.expires >= NOW()) WHERE breeders.active = 1 AND breeders.state = state.id AND breeders.country = 2 GROUP BY breeders.id ORDER BY IF(breeders.expires >=NOW(),0,1), breeders.name"; $pg=&new Pager($dbObj,$query,$resultsPerPage); $resArr = $pg->displayRecords($_GET['page'],"bird-dog-breeders-in-canada"); $a = 0; if(count($resArr['results'])>0){ $html .= ""; $html .= getAdsense(); $breederDataArr = array(); foreach($resArr['results'] as $row){ $breederDataArr[] = $row; } foreach($breederDataArr as $row){ //if($a == 25) $html .= getAdsense(); $thisBreedsArr = getBreedNames($row['breeds'],$breedsdDataArr); $html .= formatListing($row, $a, $siteDataObj, $thisBreedsArr, $dbObj); $stateName = $row['stateName']; $a++; } if($a>5) $html .= ""; } $pageTitle = "Bird Dog Breeders in Canada"; $metaDescription = "Find bird dog breeders in Canada with bird dog puppies for sale as well as started dogs, finished dogs and training for hunting dogs and sporting breeds."; $metaKeywords = "bird dog, canada hunting dog breeder, bird dogs for sale, canadian dog breeders, Canada puppy for sale, kennel, hunting, bird, started, finished dogs, training, pup, pointer, retriever, setter "; $metaSEO = ""; } else { showImproperRequest(); exit(); } function formatListing(&$row, &$a, &$siteDataObj, &$thisBreedsArr, &$dbObj){ $colorArr = array("eeeeee","ffffff"); $html = ""; $style = "background: #".$colorArr[($a%2)]; $html .= "
"; if(strtotime("now") < strtotime($row['expires'])){ $html .= "\"Double"; } //$html.= strtotime($row['expires'])."-".strtotime("now"); $html .= "mobileSiteURL."/breeders-".LinkFormat::addDashes($row['stateName'],lcase)."/".LinkFormat::addDashes($row['linkName'],lcase).".html\" class=\"breederLink\">".$row['name'].""; $html .= " ".$row['city']." - ".$row['stateName']."
"; $dbObj->performQuery("SELECT COUNT(*) as cCount FROM classifieds WHERE ownerID = {$row['id']} AND expires >= NOW()"); if($row = $dbObj->fetchRow()){ if($row['cCount'] >0){ $html .= "We currently have an active classified
"; } } if(count($thisBreedsArr)>0) $html .= "Hunting Dog Breeds Raised: ".implode(", ",$thisBreedsArr).""; $html .= "
"; return $html; } function getBreedNames($breeds,&$breedsdDataArr){ $thisBreedsArr = array(); $dbBreeds = explode(",",$breeds); if(count($dbBreeds)>0){ foreach($dbBreeds as $value){ if($value!=0){ $thisBreedsArr[] = $breedsdDataArr[$value]; } } } return $thisBreedsArr; } function getCategoryAd(&$dbObj,$breedID,$table){ $html = ''; $query = "SELECT * FROM $table WHERE category = $breedID AND end > DATE_SUB(NOW(),INTERVAL 1 DAY) AND start <= NOW() "; $dbObj->performQuery($query); if($row = $dbObj->fetchRow()){ $html = "

\"\"/

"; } return $html; } ?> <?= $pageTitle ?> - <?= $siteDataObj -> siteName?>

$stateClassifiedLink"; ?>
Want to list your puppies for sale? Post a classified today!