if($id=='getdata')
{
echo "<?xml version=\"1.0\" encoding=\"utf-8\"?>\n";
$ResponseXML = "<XMLgetuser>";
$userid = $_GET['userid'];
$sql = "SELECT username,
email,
intUserNo,
strTitle,
strFirst,
strLast,
strDesignation,
strNic,
strGender,
dtmDate,
strAdd1,
strAdd2,
strAdd3,
intTele
from user WHERE id='$userid'
";
$result = $db->RunQuery($sql);
while($row=mysql_fetch_array($result))
{
$ResponseXML .= "<intUserNo><![CDATA[" . $row["intUserNo"] . "]]> </intUserNo>\n";
$ResponseXML .= "<username><![CDATA[" . $row["username"] . "]]></username>\n";
$ResponseXML .= "<strTitle><![CDATA[" . $row["strTitle"] . "]]></strTitle>\n";
$ResponseXML .= "<strFirst><![CDATA[" . $row["strFirst"] . "]]></strFirst>\n";
$ResponseXML .= "<strLast><![CDATA[" . $row["strLast"] . "]]></strLast>\n";
$ResponseXML .= "<strDesignation><![CDATA[" . $row["strDesignation"] . "]]></strDesignation>\n";
$ResponseXML .= "<strNic><![CDATA[" . $row["strNic"] . "]]></strNic>\n";
$ResponseXML .= "<strGender><![CDATA[" . $row["strGender"] . "]]></strGender>\n";
$ResponseXML .= "<dtmDate><![CDATA[" . $row["dtmDate"] . "]]></dtmDate>\n";
$ResponseXML .= "<email><![CDATA[" . $row["email"] . "]]></email>\n";
$ResponseXML .= "<strAdd1><![CDATA[" . $row["strAdd1"] . "]]></strAdd1>\n";
$ResponseXML .= "<strAdd2><![CDATA[" . $row["strAdd2"] . "]]></strAdd2>\n";
$ResponseXML .= "<strAdd3><![CDATA[" . $row["strAdd3"] . "]]></strAdd3>\n";
$ResponseXML .= "<intTele><![CDATA[" . $row["intTele"] . "]]></intTele>\n";
}
$ResponseXML .= "</XMLgetuser>";
echo $ResponseXML;
}
No comments:
Post a Comment