$value) {
$$key = $value;
}
reset($_GET);
foreach ($_POST as $key => $value) {
$$key = $value;
}
reset($_POST);
if ($_GET[‘Offset’]) {
$Offset = $_GET[‘Offset’];
} else if ($_POST[‘Offset’]) {
$Offset = $_POST[‘Offset’];
} else {
$Offset = 0;
}
if ($_GET[‘Limit’]) {
$Limit = $_GET[‘Limit’];
} else if ($_POST[‘Limit’]) {
$Limit = $_POST[‘Limit’];
} else {
$Limit = 12;
}
if ($_GET[‘Prop_Type_res0’]) {
$_GET[‘Prop_Type_res’][0] = $_GET[‘Prop_Type_res0’];
$_POST[‘Prop_Type_res’][0] = $_GET[‘Prop_Type_res0’];
$key = “Prop_Type_res[0]”;
$GetPass .= “$key=”.urlencode($_GET[‘Prop_Type_res0’]).”&”;
}
if ($_GET[‘Prop_Type_res’][0]) {
$_POST[‘Prop_Type_res’][0] = $_GET[‘Prop_Type_res’][0];
$key = “Prop_Type_res[0]”;
$GetPass .= “$key=”.urlencode($_GET[‘Prop_Type_res0’]).”&”;
}
if ($_GET[‘Prop_Type_res1’]) {
$_GET[‘Prop_Type_res’][1] = $_GET[‘Prop_Type_res1’];
$_POST[‘Prop_Type_res’][1] = $_GET[‘Prop_Type_res1’];
$key = “Prop_Type_res[1]”;
$GetPass .= “$key=”.urlencode($_GET[‘Prop_Type_res1’]).”&”;
}
if ($_GET[‘Prop_Type_res’][1]) {
$_POST[‘Prop_Type_res’][1] = $_GET[‘Prop_Type_res’][1];
$key = “Prop_Type_res[1]”;
$GetPass .= “$key=”.urlencode($_GET[‘Prop_Type_res1’]).”&”;
}
if ($_GET[‘Prop_Type_res2’]) {
$_GET[‘Prop_Type_res’][2] = $_GET[‘Prop_Type_res2’];
$_POST[‘Prop_Type_res’][2] = $_GET[‘Prop_Type_res2’];
$key = “Prop_Type_res[2]”;
$GetPass .= “$key=”.urlencode($_GET[‘Prop_Type_res2’]).”&”;
}
if ($_GET[‘Prop_Type_res’][2]) {
$_POST[‘Prop_Type_res’][2] = $_GET[‘Prop_Type_res’][2];
$key = “Prop_Type_res[2]”;
$GetPass .= “$key=”.urlencode($_GET[‘Prop_Type_res2’]).”&”;
}
if ($_GET[‘Prop_Type_comm0’]) {
$_GET[‘Prop_Type_comm’][0] = $_GET[‘Prop_Type_comm0’];
$_POST[‘Prop_Type_comm’][0] = $_GET[‘Prop_Type_comm0’];
$key = “Prop_Type_comm[0]”;
$GetPass .= “$key=”.urlencode($_GET[‘Prop_Type_comm0’]).”&”;
}
if ($_GET[‘Prop_Type_comm’][0]) {
$_POST[‘Prop_Type_comm’][0] = $_GET[‘Prop_Type_comm’][0];
$key = “Prop_Type_comm[0]”;
$GetPass .= “$key=”.urlencode($_GET[‘Prop_Type_comm0’]).”&”;
}
if ($_GET[‘Prop_Type_comm1’]) {
$_GET[‘Prop_Type_comm’][1] = $_GET[‘Prop_Type_comm1’];
$_POST[‘Prop_Type_comm’][1] = $_GET[‘Prop_Type_comm1’];
$key = “Prop_Type_comm[1]”;
$GetPass .= “$key=”.urlencode($_GET[‘Prop_Type_comm1’]).”&”;
}
if ($_GET[‘Prop_Type_comm’][1]) {
$_POST[‘Prop_Type_comm’][1] = $_GET[‘Prop_Type_comm’][1];
$key = “Prop_Type_comm[1]”;
$GetPass .= “$key=”.urlencode($_GET[‘Prop_Type_comm1’]).”&”;
}
if ($_GET[‘Prop_Type_land0’]) {
$_GET[‘Prop_Type_land’][0] = $_GET[‘Prop_Type_land0’];
$_POST[‘Prop_Type_land’][0] = $_GET[‘Prop_Type_land0’];
$key = “Prop_Type_land[0]”;
$GetPass .= “$key=”.urlencode($_GET[‘Prop_Type_land0’]).”&”;
}
if ($_GET[‘Prop_Type_land’][0]) {
$_POST[‘Prop_Type_land’][0] = $_GET[‘Prop_Type_land’][0];
$key = “Prop_Type_land[0]”;
$GetPass .= “$key=”.urlencode($_GET[‘Prop_Type_land0’]).”&”;
}
if ($_GET[‘Prop_Type_land1’]) {
$_GET[‘Prop_Type_land’][1] = $_GET[‘Prop_Type_land1’];
$_POST[‘Prop_Type_land’][1] = $_GET[‘Prop_Type_land1’];
$key = “Prop_Type_land[1]”;
$GetPass .= “$key=”.urlencode($_GET[‘Prop_Type_land1’]).”&”;
}
if ($_GET[‘Prop_Type_land’][1]) {
$_POST[‘Prop_Type_land’][1] = $_GET[‘Prop_Type_land’][1];
$key = “Prop_Type_land[1]”;
$GetPass .= “$key=”.urlencode($_GET[‘Prop_Type_land1’]).”&”;
}
reset($_POST[‘Prop_Type_res’]);
// cycle thru passed areas
if ($_GET[‘Area’]) {
foreach ($_GET[‘Area’] as $key => $value) {
$_POST[‘Area’][$key] = $value;
}
} else {
for($i=0;$i<=11;$i++) {
$thisArea = "Area".$i;
if ($_GET[$thisArea]) {
$_POST['Area'][$i] = $_GET[$thisArea];
$GetPass .= "Area[$i]=".urlencode($_GET[$thisArea])."&";
}
}
}
// cycle thru passed acres
if ($_GET['Acres']) {
$_POST['Acres'] = $_GET['Acres'];
$GetPass .= "Acres=".urlencode($_GET['Acres'])."&";
}
// cycle thru passed bdrms
if (isset($_GET['Bedrooms'])) {
foreach ($_GET['Bedrooms'] as $key => $value) {
$_POST[‘Bedrooms’][$key] = $value;
}
} else {
for($i=0;$i<=5;$i++) {
$thisBdrm = "Bedrooms".$i;
if ($_GET[$thisBdrm]) {
$_POST['Bedrooms'][$i] = $_GET[$thisBdrm];
$GetPass .= "Bedrooms[$i]=".urlencode($_GET[$thisBdrm])."&";
}
}
}
// cycle thru passed Fl_Baths
if ($_GET['Fl_Baths']) {
foreach ($_GET['Fl_Baths'] as $key => $value) {
$_POST[‘Fl_Baths’][$key] = $value;
}
} else {
for($i=0;$i<=2;$i++) {
$thisBtrm = "Fl_Baths".$i;
if ($_GET[$thisBtrm]) {
$_POST['Fl_Baths'][$i] = $_GET[$thisBtrm];
$GetPass .= "Fl_Baths[$i]=".urlencode($_GET[$thisBtrm])."&";
}
}
}
// cycle thru passed Ttl_Sqft
if ($_GET['TotalSqFt']) {
foreach ($_GET['TotalSqFt'] as $key => $value) {
$_POST[‘TotalSqFt’][$key] = $value;
}
} else {
for($i=0;$i<=4;$i++) {
$thisTtlsqft = "TotalSqFt".$i;
if ($_GET[$thisTtlsqft]) {
$_POST['TotalSqFt'][$i] = $_GET[$thisTtlsqft];
$GetPass .= "TotalSqFt[$i]=".urlencode($_GET[$thisTtlsqft])."&";
}
}
}
if ($_POST['Prop_Class']) {
$_GET['Prop_Class'] = $_POST['Prop_Class'];
}
// create the conditions for the query
// it's a search on property details
// default to all property classes if none are checked
if ((!$_POST['Prop_Type_res']) and (!$_POST['Prop_Type_comm']) and (!$_POST['Prop_Type_land']) and (!$_GET['Prop_Class'])) {
$Conditions .= "(Prop_Class = 'Residential' OR Prop_Class = 'Commercial' OR Prop_Class = 'Land' OR Prop_Class = 'Farmranch')";
} else {
$Conditions .= "(";
if ($_GET['Prop_Class']=="Residential") {
$Conditions .= "(Prop_Class = 'Residential'";
$Conditions .= ") OR ";
$GetPass .= "Prop_Class=Residential&";
}
if ($_POST['Prop_Type_comm'] || $_GET['Prop_Class']=="Commercial") {
$Conditions .= "(Prop_Class = 'Commercial'";
$Conditions .= ") OR ";
$GetPass .= "Prop_Class=Commercial&";
}
$landRanchFlag = 0;
if ($_POST['Prop_Type_land'] || $_GET['Prop_Class']=="Land") {
if ($_POST['Prop_Type_land']) {
$propTypeLndCond = "";
foreach ($_POST['Prop_Type_land'] as $key => $value) {
if ($value == “Ranch”) {
$landRanchFlag = 1;
$propTypeLndCond .= “Prop_Class = ‘Farmranch’ || “;
$GetPass .= “Prop_Type_land=Ranch&”;
}
}
if ($propTypeLndCond) {
$propTypeLndCond = substr($propTypeLndCond,0,-4);
$Conditions .= “($propTypeLndCond) OR “;
}
}
if (!$landRanchFlag) {
$Conditions .= “(Prop_Class = ‘Land'”;
$Conditions .= “) OR “;
$GetPass .= “Prop_Class=Land&”;
}
}
if ($_POST[‘Prop_Type_res’]) {
$propTypeResCond = “”;
foreach ($_POST[‘Prop_Type_res’] as $key => $value) {
$propTypeResCond .= “Prop_Type = ‘$value’ || “;
$GetPass .= “Prop_Type_res[$key]=$value&”;
if ($value == “Single Family”) {
$propTypeResCond .= “Prop_Type = ‘Single Family’ || Prop_Type = ‘Single Fam w Acc Dwelling’ || Prop_Type = ‘Stick Built’ || Prop_Type = ‘Modular’ || “;
}
if ($value == “Condo”) {
$propTypeResCond .= “Prop_Type = ‘Multi-Family’ || Prop_Type = ‘Townhouse’ || “;
}
}
if ($propTypeResCond) {
$propTypeResCond = substr($propTypeResCond,0,-4);
$Conditions .= “($propTypeResCond) OR “;
}
}
// for the property classes, trim the ‘ OR ‘
$Conditions = substr($Conditions, 0, strlen($Conditions)-4);
$Conditions .= “)”;
}
// then go on to formulate the rest of the query
if ($Asking_Price_from) $Conditions .= ” AND Asking_Price >= ‘$Asking_Price_from'”;
if ($Asking_Price_to) $Conditions .= ” AND Asking_Price <= '$Asking_Price_to'";
$areaStr = "";
$areaCnt = 0;
if ($_POST['Area']) {
foreach ($_POST['Area'] as $key => $value) {
if ($value) {
$areaCnt++;
$areaStr .= ” Area = ‘$value’ || “;
if ($value == “Crested Butte Rural”) $areaStr .= ” Area = ‘Mt. Crested Butte Rural’ || “;
$GetPass .= “Area[“.$areaCnt.”]=”.urlencode($value).”&”;
}
}
if ($areaStr) {
$areaStr = substr($areaStr,0,-4);
$Conditions .= ” AND ($areaStr)”;
}
}
// set areas if none are chosen
if (!$areaStr) {
$Conditions .= ” AND (Area = ‘Crested Butte’ || Area = ‘Crested Butte Rural’ || Area = ‘Mt. Crested Butte Rural’ || Area = ‘Mt. Crested Butte’ || Area = ‘Crested Butte South’ || Area = ‘Kebler Pass’ || Area = ‘Almont’ || Area = ‘Gunnison’ || Area = ‘Gunnison Rural’ || Area = ‘Ohio Creek Area’ || Area = ‘Powderhorn’)”;
}
$sqftConditions = “”;
if ($_POST[‘TotalSqFt’]) {
foreach ($_POST[‘TotalSqFt’] as $key => $value) {
if ($value == “5000+”) {
$sqftConditions .= “(TotalSqFt >= ‘5000’) || “;
} else {
$sqftBits = explode(“-“,$value);
$sqftConditions .= “(TotalSqFt >= ‘$sqftBits[0]’ && TotalSqFt <= '$sqftBits[1]') || ";
}
$GetPass .= "TotalSqFt[$key]=$value&";
}
$sqftConditions = substr($sqftConditions, 0, strlen($sqftConditions)-4);
if ($sqftConditions) $Conditions .= " AND ($sqftConditions)";
}
if ($Acres) {
// This works fine for non land properties
$GetPass .= "Acres=$Acres&";
$acreConditions .= "(Acres >= ‘$Acres’) || “;
}
$acreConditions = substr($acreConditions, 0, strlen($acreConditions)-4);
if ($acreConditions) $Conditions .= ” AND ($acreConditions)”;
$bdrmStr = “”;
if (isset($_POST[‘Bedrooms’])) {
foreach ($_POST[‘Bedrooms’] as $key => $value) {
if ($value == “Studio”) {
$bdrmStr .= ” Bedrooms = ‘0’ || “;
$GetPass .= “Bedrooms[1]=0&”;
}
if ($value == “1”) {
$bdrmStr .= ” Bedrooms = ‘1’ || “;
$GetPass .= “Bedrooms[2]=1&”;
}
if ($value == “2”) {
$bdrmStr .= “Bedrooms = ‘2’ || “;
$GetPass .= “Bedrooms[3]=2&”;
}
if ($value == “3”) {
$bdrmStr .= “Bedrooms = ‘3’ || “;
$GetPass .= “Bedrooms[4]=3&”;
}
if ($value == “4”) {
$bdrmStr .= “Bedrooms = ‘4’ || “;
$GetPass .= “Bedrooms[5]=4&”;
}
if ($value == “5”) {
$bdrmStr .= “Bedrooms = ‘5’ || “;
$GetPass .= “Bedrooms[6]=5&”;
}
}
if ($bdrmStr) {
$bdrmStr = substr($bdrmStr,0,-4);
$Conditions .= ” AND ($bdrmStr)”;
}
}
$btrmStr = “”;
if ($_POST[‘Fl_Baths’]) {
foreach ($_POST[‘Fl_Baths’] as $key => $value) {
if ($value == “2”) {
$btrmStr .= ” Fl_Baths = ‘2’ || “;
$GetPass .= “Fl_Baths[1]=2&”;
}
if ($value == “3”) {
$btrmStr .= ” Fl_Baths = ‘3’ || “;
$GetPass .= “Fl_Baths[2]=3&”;
}
if ($value == “4”) {
$btrmStr .= ” Fl_Baths = ‘4’ || “;
$GetPass .= “Fl_Baths[3]=4&”;
}
}
if ($btrmStr) {
$btrmStr = substr($btrmStr,0,-4);
$Conditions .= ” AND ($btrmStr)”;
}
}
if ($Prop_Type) $Conditions .= ” AND Prop_Type = ‘$Prop_Type'”;
// Array for displaying bedrooms numerically in limited area
$bedDisplayArray[‘Studio’] = “Studio”;
$bedDisplayArray[‘One’] = “1”;
$bedDisplayArray[‘Two’] = “2”;
$bedDisplayArray[‘Three’] = “3”;
$bedDisplayArray[‘Four’] = “4”;
$bedDisplayArray[‘Five’] = “5”;
$bedDisplayArray[‘Six’] = “6”;
$bedDisplayArray[‘Seven’] = “7”;
$bedDisplayArray[‘Eight’] = “8”;
$bedDisplayArray[‘Nine’] = “9”;
$bedDisplayArray[‘Ten Or More’] = “10+”;
if ($_POST[‘Mls_Num’]) {
$Conditions = “Mls_Num = ‘$_POST[Mls_Num]'”;
}
$db = mysqli_connect(“localhost”, “ramman”, “ippw4rm”, “mlsidx”);
//$Order_By = “Asking_Price DESC”; //For Testing
if (!$Order_By) $Order_By = “Asking_Price DESC”;
//$Limit = 12;
//if (!$Limit) $Limit = 12;
//if (!$Offset) $Offset = 0;
$sql = “SELECT
*
FROM Gunnison_listings_new
WHERE $Conditions
ORDER BY $Order_By
LIMIT $Offset, $Limit
“;
$result = mysqli_query($db,$sql);
echo ““;
$error_text = mysqli_error($db); if ($error_text) echo ““;
$sqlCount = “SELECT COUNT(*)
FROM Gunnison_listings_new
WHERE $Conditions
LIMIT 50
“;
$resultCount = mysqli_query($db,$sqlCount);
//echo “$sqlCount”;
if ($myrowCount = mysqli_fetch_row($resultCount)) $numListings = $myrowCount[0];
if ($numListings > 500) $numListings = 500;
if ($_GET[‘lastLimit’]) {
$LimitToUse = $_GET[‘lastLimit’];
} else {
$LimitToUse = $Limit;
}
$numpages = (INT)($numListings / $LimitToUse);
if ($numListings % $LimitToUse) $numpages++;
$pageNow = $Offset/$LimitToUse +1;
$nextPage = $pageNow + 1;
$lastPage = $pageNow – 1;
if ($_POST) {
while(list($key,$value)=each($_POST)) {
if (($value) and ($key != “Details_search”) and ($key != “Area”) and ($key != “Ttl_Sqft”) and ($key != “Number_Acres”) and ($key != “Prop_Class_res”) and ($key != “Prop_Class_land”) and ($key != “Prop_Class_comm”) and ($key != “Prop_Class”) and ($key != “Prop_type”) and ($key != “Prop_Type_res”) and ($key != “Bedrooms”) and ($key != “Fl_Baths”) and ($key != “Limit”) and ($key != “lastLimit”)) {
$GetPass .= “$key=”.stripslashes(urlencode($value)).”&”;
}
}
}
if ($_GET) {
while(list($key,$value)=each($_GET)) {
if (($value) and ($key != “Offset”) and ($key != “Area”) and ($key != “Ttl_Sqft”) and ($key != “Number_Acres”) and ($key != “Prop_Class_res”) and ($key != “Prop_Class_land”) and ($key != “Prop_Class_comm”) and ($key != “Prop_Class”) and ($key != “Prop_type”) and ($key != “Prop_Type_res”) and ($key != “Bedrooms”) and ($key != “Fl_Baths”) and ($key != “Limit”) and ($key != “lastLimit”)) {
$GetPass .= “$key=”.urlencode($value).”&”;
}
}
}
for($i=1;$i<=$numpages;$i++) {
$offpass = ($i-1) * $LimitToUse;
if ($i == $pageNow) {
$navText .= "$i “;
} else {
// check for last page
if ($i == $numpages) {
$nextLimit = (500-$offpass);
$lastLimit = $Limit;
} else {
$nextLimit = $LimitToUse;
}
$navText .= “$i “;
}
}
// echo “
$navText
“;
$offpassPrev = $Offset – $Limit;
$offpassNext = $Offset + $Limit;
if ($Offset >= $Limit) {
$navDisplaya .= ““;
} else {
$navDisplaya .= ““;
}
$navDisplay .= “ “;
if (($Offset+$Limit) >= $numListings) {
$navDisplayb .= ““;
} else {
$navDisplayb .= ““;
}
// echo “
$navDisplay
“;
$displayCount = 0;
$colCnt = 1;
while ($myrow = mysqli_fetch_array($result)) {
$displayCount++;
// strip non-alpha numeric chars
$addressProcessed = str_replace(” “,”-“,preg_replace(‘/[^a-zA-Z0-9\s]/’, ”, $myrow[‘Address’]));
$cityProcessed = str_replace(” “,”-“,preg_replace(‘/[^a-zA-Z0-9\s]/’, ”, $myrow[‘City’]));
$stateProcessed = str_replace(” “,”-“,preg_replace(‘/[^a-zA-Z0-9\s]/’, ”, $myrow[‘State’]));
// set details page link
$detailsPgLnk = strtolower($addressProcessed.”-“.$cityProcessed.”-“.$stateProcessed.”-“.$myrow[‘Mls_Num’].”.php”);
// look in custom file for a virtual tour for this property
if ($propTourArr[$myrow[‘Mls_Num’]]) $myrow[‘virtual_tour’] = $propTourArr[$myrow[‘Mls_Num’]];
while(list($key,$value)=each($myrow)){
if ($value && $key != “Remarks” && $key != “virtual_tour” && $key != “virtualTour” && $key != “propertyPageURL” && $key != “propertyPageLinkText” && $value != “SLO”) {
$myrow[$key] = ucwords(strtolower($value));
}
}
$priceShow = number_format($myrow[‘Asking_Price’]);
$imageSourcePath = “http://cren.interactiveproperties.com/images/listings/cren”.$myrow[‘Mls_Num’].”.jpg”;
//——————————————————————————
// check for images
$imgCode = “”;
$imgCheck = “”;
if ($myrow[‘imageLocations’]) {
$imgBits = explode(“|”,$myrow[‘imageLocations’]);
for($i=0;$i