Geek Answers Handbook

Why does the search query not show the result in PHRETS?

I use this php script to get the result from a simple search query registered here

And I downloaded this excel property metadata file here

$rets_login_url = "http://sef.rets.interealty.com/Login.asmx/Login";
$rets_username = "xxxxxxxx";
$rets_password = "xxxxxxxx";
$rets_user_agent = "PHRETS/1.0";
$rets_user_agent_password = "xxxxxxx";

//////////////////////////////

// start rets connection
$rets = new phRETS;
// Uncomment and change the following if you're connecting
// to a server that supports a version other than RETS 1.5

$rets->AddHeader("RETS-Version", "RETS/1.5");

$rets->AddHeader("User-Agent", $rets_user_agent);

echo "+ Connecting to {$rets_login_url} as {$rets_username}<br>\n";
$connect = $rets->Connect($rets_login_url, $rets_username, $rets_password, $rets_user_agent_password);

// check for errors
if ($connect) {
        echo "  + Connected<br>\n";
}
else {
        echo "  + Not connected:<br>\n";
        print_r($rets->Error());
        exit;
}

$search = $rets->SearchQuery("Property","ResidentialProperty","(ListDate=1990-01-01+)");
while ($listing = $rets->FetchRow($search)) {
   echo "Address: {$listing['StreetNumber']} {$listing['StreetName']}, ";
   echo "{$listing['City']}, ";
   echo "{$listing['State']} {$listing['ZipCode']} listed for ";
   echo "\$".number_format($listing['ListPrice'])."\n";
}


$rets->FreeResult($search);

echo "+ Disconnecting<br>\n";
$rets->Disconnect();

when I run this script, it shows that the result is connected and then disabled. But no result was found. I tried many things suggested on some issues, for which the result was not shown, but nothing works for me. Where am I mistaken?

Information about my RETS server is here:

RETS server: SEF RETS system RETS system identifier: SEFRETS Login URL: http://sef.rets.interealty.com:80/Login.asmx/Login RETS Version: 1.5 Server software: Microsoft-IIS / 6.0

, $rets_modtimestamp_field = "LIST_87";

, . , RETS.

+4
2

SearchQuery.

- ListDate. excel, , "ListDate" B . RETS (. ). " " = > 1 ' SearchQuery:

$search = $rets- > SearchQuery ( "", "ResidentialProperty", "(ListDate = 1990-01-01 +)", array ( "StandardNames" = > 1));

, , , , SearchQuery . GetMetadataClasses PHRETS. retsmd.com, URL-, RETS Server.

$rets_modtimestamp_field - , , .

7.4.7 RETS 1.7.2 http://www.reso.org/assets/RETS/Specifications/rets_1_7_2.pdf,

" , ( 7.7). , ... ( "0" ) , , , SystemNames, . "

+2

, ListStatus, . ListStatus:

  • A = Active-Available
  • B = - LA
  • C =
  • CS =
  • PS = /
  • Q =
  • T = .
  • W = Withdrawn
  • X =

, - :

$query ="(922=MIAMI),(246=A)";

, :

$query ="(City=MIAMI),(ListingStatus=A)";

:

$search = $rets->SearchQuery("Property", $class, $query, array("StandardNames" => 1, 'Limit' => 10, ));

. , .

+1

More articles:


All Articles