Software: Apache/2.2.3 (CentOS). PHP/5.1.6 

uname -a: Linux mx-ll-110-164-51-230.static.3bb.co.th 2.6.18-194.el5PAE #1 SMP Fri Apr 2 15:37:44
EDT 2010 i686 

uid=48(apache) gid=48(apache) groups=48(apache) 

Safe-mode: OFF (not secure)

/var/www/html/ws_standard_on_mis/   drwxr-xr-x
Free 52.82 GB of 127.8 GB (41.33%)
                            Encoder    Tools    Proc.    FTP brute    Sec.    SQL    PHP-code    Update    Feedback    Self remove    Logout    

Viewing file:     xml_asset_permanent.php.bak (2.49 KB)      -rw-r--r--

<?php
$information = '<?xml version="1.0" encoding="windows-874"?>';
//asset_permanent
$information .= "\n<asset_permanent>";

//asset_permanent
$information .= "\n<assets>";
$dsn_name = "asset";
$username =""; 
$password =""; 
$connect= odbc_connect($dsn_name, $username, $password) or die("µФґµиН DSN дБидґй"); 
//selece_database_asset

$sql = "SELECT TBase_budget.id as a, TBase.name, TBase.bye_year, TBase.pirce, TBase_budget.budgetyear ,TBase_budget.amount , TBase.TTypecate_id , TTypeCatagory.id FROM TBase, TBase_budget, TTypeCatagory WHERE (TBase.id = TBase_budget.id) and (TBase.TTypecate_id = TTypeCatagory.id) and ( (TBase.TTypecate_id = '100') or (TBase.TTypecate_id = '101') )and  (TBase_budget.budgetyear = 2550)";
    $num1=0;
	$sum ="";
	$sum100 = "";
	$sum101 = "";
    $sum102 = "";
	$execute = odbc_exec($connect, $sql) or die ("аНзЎ«Ф¤ФЗКм¤УКСи§дБидґй $sql");
	while($row = odbc_fetch_array($execute))
	{
$TBase_id=$row['a'];
$TBase_name=$row["name"];
$TBase_bye_year=$row["bye_year"];
$TBase_pirce=$row["pirce"];
$TBase_amount=$row["amount"];
$TTypecate_id=$row["TTypecate_id"];

$num1++;
$information .= "\n<asset>";

	$information .= "\n<asset_id>";
		$information .= "$TBase_id";
	$information .= "\n</asset_id>";

	$information .= "\n<asset_name>";
		$information .= "$TBase_name";
	$information .= "\n</asset_name>";

	$information .= "\n<asset_bye_year>";
		$information .= "$TBase_bye_year";
	$information .= "\n</asset_bye_year>";

	$information .= "\n<asset_pirce>";
		$information .= "$TBase_pirce";
	$information .= "\n</asset_pirce>";

	$information .= "\n<amount>";
		$information .= "$TBase_amount";
	$information .= "\n</amount>";

    $information .= "\n<Typecate>";
		$information .= "$TTypecate_id";
	$information .= "\n</Typecate>";

$information .= "\n</asset>";

if ($TTypecate_id == '100') {
	$sum100 = $sum100 + $TBase_amount;
}

if ($TTypecate_id == '101') {
	$sum101 = $sum101 + $TBase_amount;
}

if ($TTypecate_id == '102') {
	$sum102 = $sum102 + $TBase_amount;
}
$sum=$sum100+$sum101+$sum101;
}
$information .= "\n</assets>";
	

//sum_asset_permanent
	$information .= "\n<base_sum>";
		$information .= "$sum100";
	$information .= "\n</base_sum>";

	$information .= "\n<build_sum>";
		$information .= "$sum101";
	$information .= "\n</build_sum>";

	$information .= "\n<asset_sum>";
		$information .= "$sum102";
	$information .= "\n</asset_sum>";

		$information .= "\n<sum>";
		$information .= "$sum";
	$information .= "\n</sum>";

$information .= "\n</asset_permanent>";

echo "$information";


?>