Monday, June 8, 2015

Get data from Database php Code-User details from

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