我连接到RETS服务器,我可以使用PHrets库中的函数,如GetMetadataResources,GetMetadataClasses,以及每个类中的所有字段来获取所有元数据,但我无法使用SearchQuery从该服务器获取数据,我尝试了所有方法,但没有运气。
<pre>
/* Initialize Object */
require("PHRets_CREA.php");
require("credentials.php");
$rets = new PHRets();
$connect=$rets->Connect($RETSURL, $RETSUsername, $RETSPassword);
/* Connect */
/* Query Server */
if ($connect) {
echo "Connected";
$resources = $rets->GetMetadataResources();
foreach ($resources as $resource) {
echo "+ Resource {$resource['ResourceID']}\n";
$classes = $rets->GetMetadataClasses($resource['ResourceID']);
foreach ($classes as $class) {
echo " + Class {$class['ClassName']} described as " . $class['Description'] . "\n";
$rets_metadata = $rets->GetMetadata($resource['ResourceID'],$class['ClassName']);
foreach ($rets_metadata as $field) {
echo " + Field: {$field['SystemName']} ({$field['DataType']})\n";
}
}
}
/*
$search = $rets->SearchQuery("Property","RE_1","(L_ListingDate=2010-03-02-2010-03-03)");
while ($listing = $rets->FetchRow($search)) {
echo $listing['L_ListingID'];
}*/
$search = $rets->SearchQuery("Property","ResidentialProperty","(ListDate=1990-01-01+)",
array( "Count" => 1, "Format" => "COMPACT", "Limit" => "2", "Offset" => "2",
"RestrictedIndicator" => "****", "StandardNames" => 1 )
);
echo "data";
print_r($search);
while ($listing = $rets->FetchRow($search))
echo "{$listing['L_City']}";exit;
}
$rets->FreeResult($search);
}</pre>
Thanks发布于 2015-12-06 04:06:33
首先确保你的资源和类名是正确的。使用http://retsmd.com进行验证。资源通常是"Property“,但是检查你当前拥有的"ResidentialProperty”的类名。它可能是您在上述代码中使用的"RE_1“。
接下来,修改您的SearchQuery。也许可以在选项数组中使用较少的参数,并尝试删除StandardNames并使用默认的系统名称。
如下所示:
$search = $rets->SearchQuery("Property","RE_1","(L_ListingDate=1990-01-01+)", array("Limit" => "10"));发布于 2015-12-22 21:16:12
请尝试这个,我们得到了这个的所有活动属性。
$search = $rets->SearchQuery("Property","1","(135=1990-01-01+),(246=A)");
https://stackoverflow.com/questions/34103693
复制相似问题