return multiple rows of data using XML_RPC

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
unomateo
Forum Newbie
Posts: 4
Joined: Sat Jul 01, 2006 1:36 am

return multiple rows of data using XML_RPC

Post by unomateo »

Am I doing this right?

I want to provide data from my database using PEAR::XML_RPC.
Is the output data in the right format? or is there a better way?

----------------
function phpGetLongLat($params) {
$mls_num = $params->getParam(0);

$query = "select MLSNUM, LONGITUDE, LATITUDE from PROPERTIES limit 2";
$result = mysql_query($query) or die ("SQL Error".mysql_error());
while ($row=mysql_fetch_assoc($result))
{
$A[$row['MLSNUM']] = new XML_RPC_Value(array("Longitude" => new XML_RPC_Value($row["LONGITUDE"], "string"),"Latitude" => new XML_RPC_Value($row["LATITUDE"], "string")), "struct");
//$array["MLSNUM"] = $A]
}
$value = new XML_RPC_Value($A, "struct");
// return response to client
return new XML_RPC_Response($value);

}
-----------------------

This function returns:

<methodResponse>
<params>
<param>
<value><struct>
<member><name>305949</name>
<value><struct>
<member><name>Longitude</name>
<value><string>-122.482452</string></value>
</member>
<member><name>Latitude</name>
<value><string>37.77883900</string></value>
</member>
</struct></value>
</member>
<member><name>308881</name>
<value><struct>
<member><name>Longitude</name>
<value><string>-122.477829</string></value>
</member>
<member><name>Latitude</name>
<value><string>37.77348300</string></value>
</member>
</struct></value>
</member>
</struct></value>
</param>
</params>
</methodResponse>
Post Reply