\n";
$dbname = 'flaidx_rets';
// $mlsconnfile = 'conn.php';
$mlsconnfile = $_SERVER['DOCUMENT_ROOT'].'/mysqliconnsuncoast.php');
// echo $_SERVER['DOCUMENT_ROOT'].'/flaidx/incsrets2014/'.$mlsconnfile;
// include $_SERVER['DOCUMENT_ROOT'].'/flaidx/incsrets2014/'.$mlsconnfile;
require_once( $mlsconnfile );
include $_SERVER['DOCUMENT_ROOT'].'/flaidx/wpincs/wpmlsfunctions.php';
$time = microtime(true) - $_SERVER["REQUEST_TIME_FLOAT"];
echo "Elapsed time to connect to database: $time seconds
\n";
echo "Now randomize some criteria to force a fresh database query:
\n";
$cities = array('Port Charlotte','Punta Gorda','Sarasota','Bradenton','Venice','Englewood','Rotonda','Deep Creek','Burnt Store','Nokomis','Osprey');
$rand_keys = array_rand($cities, 2);
$city = trim($cities[$rand_keys[0]]);
echo 'City: '.$city.'
';
$minprice = array(10000,20000,30000,40000);
$rand_keys = array_rand($minprice, 2);
$minprice = trim($minprice[$rand_keys[0]]);
echo 'Min price: '.$minprice.'
';
$maxprice = array(1000000,900000,1200000,850000);
$rand_keys = array_rand($maxprice, 2);
$maxprice = trim($maxprice[$rand_keys[0]]);
echo 'Max price: '.$maxprice.'
';
$minsqft = array(800,750,1000,1500);
$rand_keys = array_rand($minsqft, 2);
$minsqft = trim($minsqft[$rand_keys[0]]);
echo 'Min SqFt: '.$minsqft.'
';
$minyrbuilt = array(1970,1980,1992,2001);
$rand_keys = array_rand($minyrbuilt, 2);
$minyrbuilt = trim($minyrbuilt[$rand_keys[0]]);
echo 'Earliest yr built: '.$minyrbuilt.'
';
$maxyrbuilt = array(2012,2014,2015,2009);
$rand_keys = array_rand($maxyrbuilt, 2);
$maxyrbuilt = trim($maxyrbuilt[$rand_keys[0]]);
echo 'Latest yr built: '.$maxyrbuilt.'
';
echo '
';
// AND ( CountyOrParish = 'Charlotte' OR CountyOrParish = 'Manatee' OR CountyOrParish = 'Sarasota' )
$tablename = 'Listings';
// $tablename = 'ListingsSold';
$myquery = "SELECT * , DATE_FORMAT(ListingContractDate, '%Y') as ListYear FROM flaidx_rets.`$tablename` WHERE 1=1
AND ( PropertyStyle = 'Single Family Home'
AND PropertyType = 'Residential' )
AND SpecialSaleProvision NOT IN ('Short Sale','REO / Bank Owned')
AND ( CountyOrParish IN ( 'Charlotte' , 'Manatee' , 'Sarasota' ) )
AND ( StreetCity LIKE '%$city%' OR SWSubdivCommunityName LIKE '%$city%' OR LegalSubdivisionName LIKE '%$city%' OR ComplexCommunityNameNCCB LIKE '%$city%' )
AND ( ListPrice >= $minprice )
AND ( ListPrice <= $maxprice )
AND ( SqFtHeated >= $minsqft )
AND ( SqFtHeated <= 9500 )
AND ( BedsTotal >= 2 )
AND ( BathsFull >= 1 )
AND ( YearBuilt >= $minyrbuilt )
AND ( YearBuilt <= $maxyrbuilt )
AND ( GarageCarport LIKE '%2 Car Garage%' OR GarageCarport LIKE '%2+ Car Garage%' )
AND ( Pool = 'Community,Private' OR Pool = 'None,Private' OR Pool = 'Private' OR Pool = 'Private,Community' )
AND ( WaterFrontageYN = 1 )
AND PropertyType = 'Residential'
AND PropertyStyle != 'Dock-Rackominium' ORDER BY ListPrice ASC LIMIT 0, 100 ";
echo 'QUERY:
';
// echo nl2br($myquery);
echo '
';
$query = mysqli_query($dbcmls,$myquery) or die('Bad myquery: '.mysqli_error());
$time2 = microtime(true) - $time;
$time = microtime(true) - $_SERVER["REQUEST_TIME_FLOAT"];
echo '
Selected '.mysqli_num_rows($query).' listings from db - total elapsed time: '.$time.' seconds
';
echo 'Now loop through the results and print the MLS numbers to the screen:
';
if ( $query && mysqli_num_rows($query) > 0 ) {
$i = 1;
while ($row = mysqli_fetch_assoc($query)) {
$MLSNumber = $row['MLSNumber'];
echo ''.$i.''.' - '.$row['MLSNumber'].' ';
$i++;
}
}
$time = microtime(true) - $_SERVER["REQUEST_TIME_FLOAT"];
echo '
Total elapsed time from request until server has sent complete page: '.$time.' seconds
';
// echo time();
$t=time();
// echo($t . "
");
echo 'Current time: '.(date("Y-m-d G:i:s",$t));
?>