|
Server : Apache/2.2.2 (Fedora) System : Linux App1.pathumtani.go.th 2.6.20-1.2320.fc5smp #1 SMP Tue Jun 12 19:40:16 EDT 2007 i686 User : apache ( 48) PHP Version : 5.2.9 Disable Function : NONE Directory : /var/www/html/pathumthani_vc/report/sar/ |
Upload File : |
<?
header("content-type:text/xml;charset=utf-8;");
//----------------------------------
function utf($str){
return iconv('TIS-620','UTF-8',$str);
}
//----------------------------------
echo "<?xml version=\"1.0\" encoding=\"UTF-8\" ?>";
require("../../inc/conndb_nonsession.inc.php");
/*
$connect = new MysqlConnect();
$connect->host = $host;
$connect->username = $username;
$connect->password = $password;
$connect->connect($dbname);
*/
$sql = "SELECT
`accordgroup`.`accgroupid`,
`accordgroup`.`accgroupname`,
`accordgroup`.`accicon`,
`accordgroup`.`acctype`
FROM
`accordgroup`
ORDER BY `accordgroup`.`accgroupid` asc
";
$result = mysql_query($sql);
$nm = mysql_num_rows($result);
//echo $nm;
while ($garr = mysql_fetch_array($result)){
$isql = "SELECT
`accorditem`.`accgroupid`,
`accorditem`.`accitemid`,
`accorditem`.`accitemname`,
`accorditem`.`accitemicon`,
`accorditem`.`accitemlink`,
`accorditem`.`accitemwindow`,
`accorditem`.`accitemparam`
FROM
`accorditem`
WHERE
`accorditem`.`accgroupid` = ".$garr['accgroupid']." ORDER BY `accorditem`.`accgroupid`,
`accorditem`.`accitemid`
";
echo "<data accgroupid='".$garr['accgroupid']."' accgroupname='".utf($garr['accgroupname'])."' >\n";
$iresult = mysql_query($isql);
while ($iarr = mysql_fetch_array($iresult)){
echo "<node accitemid='".$iarr['accitemid']."' accitemname='".utf($iarr['accitemname'])."' accitemicon='".$iarr['accitemicon']."' accitemlink='".$iarr['accitemlink']."' accitemwindow='".$iarr['accitemwindow']."' accitemparam='".$iarr['accitemparam']."'/>\n";
}
echo "</data>\n";
}
?>