Viewing file:  listing_functions_bak.php (3.73 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?
/************************************************************
make array for each new visit
***************************************************************/
function makeListingsArray(){
global $dataStr, $properties;
//get makras data
$domain = "www.makrasrealestate.com";
$username = "makras";
$password = "agne0sri";
$database = "makras";
$db = mysql_connect("$domain", "$username", "$password");
mysql_select_db($database ,$db);
$query = "SELECT ID from listings WHERE active = 'yes' ORDER BY year desc, month desc";
$index_data = mysql_query($query, $db);
$rows = mysql_num_rows($index_data);
$database = "makras";
for ($i = 0; $i < $rows; $i++){
$ID = mysql_result($index_data, $i, 'ID');
$dataStr .= "$database-$ID,";
}
mysql_close($db);
if ($rows < 10){ //go to SFM database if there are less than 10 listings in makras db
//get SFM data
$dataStr .= file_get_contents('http://sfmkt.com/makras/getdata.php');
}
$dataStr = substr($dataStr, 0, -1); //get rid of the trailing comma
}
}//end function
/**************************************************************
GET INDEX DATA
***************************************************************/
function getIndexRecord($current, $dataStr){
global $index_data, $database, $arrayCount;
$dataArray = explode(",", $dataStr);//split data array into entries like sfm-3 or makras-5
$arrayCount = count($dataArray);
for ($i = 0; $i < $arrayCount; $i++){//split array elements into component parts:sfm, 3
$values = explode ("-", $dataArray[$i]);
$dataArray[$i] = array($values[0], $values[1]);
}
if ($dataArray[$current][0] == "makras"){ //the current database
$domain = "www.makrasrealestate.com";
$username = "makras";
$password = "agne0sri";
$database = "makras";
}
else if ($dataArray[$current][0] == "sfm"){
$domain = "www.sfmkt.com";
$username = "sfmkt1";
$password = "qih422v2";
$database = "sfmkt1";
}
$ID = $dataArray[$current][1];
$query = "SELECT ID, title, thumb, intro, price FROM listings WHERE ID = $ID";
$db = mysql_connect("$domain", "$username", "$password");
mysql_select_db($database ,$db);
$index_data = mysql_query($query, $db);
$ID = mysql_result($index_data, 0, 'ID');
$test = mysql_num_rows($index_data);
}//end of function
/**************************************************************
detail detail detail detail detail detail detail detail
GET DETAIL DATA
detail detail detail detail detail detail detail detail
***************************************************************/
function getDetailRecord($current, $dataStr){
global $detail_data, $database, $arrayCount;
$dataArray = explode(",", $dataStr);//split data array into entries like sfm-3 or makras-5
$arrayCount = count($dataArray);
for ($i = 0; $i < $arrayCount; $i++){//split array elements into component parts:sfm, 3
$values = explode ("-", $dataArray[$i]);
$dataArray[$i] = array($values[0], $values[1]);
}
if ($dataArray[$current][0] == "makras"){ //the current database
$domain = "www.makrasrealestate.com";
$username = "makras";
$password = "agne0sri";
$database = "makras";
}
else if ($dataArray[$current][0] == "sfm"){
$domain = "www.sfmkt.com";
$username = "sfmkt1";
$password = "qih422v2";
$database = "sfmkt1";
}
$ID = $dataArray[$current][1];
$query = "SELECT * FROM listings WHERE ID = $ID";
$db = mysql_connect("$domain", "$username", "$password");
mysql_select_db($database ,$db);
$detail_data = mysql_query($query, $db);
$ID = mysql_result($detail_data, 0, 'ID');
$test = mysql_num_rows($detail_data);
}//end of function
?>
|