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.63 GB of 127.8 GB (41.18%)
                            Encoder    Tools    Proc.    FTP brute    Sec.    SQL    PHP-code    Update    Feedback    Self remove    Logout    

Viewing file:     xml_committees_of_teacher.php (2.18 KB)      -rw-r--r--

<?php
$information = '<?xml version="1.0" encoding="windows-874"?>';

//project
$information .= "\n<Committees_of_teacher>";

$information .= "\n<committees>";
$dsn_name = "staff";
$username =""; 
$password =""; 
$connect= odbc_connect($dsn_name, $username, $password) or die("µФґµиН DSN дБидґй"); 
//selece_database_project
//$sql = "SELECT * FROM TFileCommittee, TEmployee WHERE  TFileCommittee.TEmp_id=TEmployee.Id";
//$sql = "SELECT * FROM TProject";
$sql = "SELECT *,TEmployee.id as tempid FROM TFileCommittee, TEmployee,TWorkStatus,TPosScale WHERE  TFileCommittee.TEmp_id=TEmployee.Id and (TEmployee.work_status=TWorkStatus.id) and (TEmployee.Id=TPosScale.TEmp_id) and (TWorkStatus.id = '0')  and (TEmployee.id like '01%') and (TPosScale.TDep_id = '0702')";
$execute = odbc_exec($connect, $sql) or die ("аНзЎ«Ф¤ФЗКм¤УКСи§дБидґй");

$i=1;
$num1=0;
$num2=0;
$TEmployee_id_check="";
while($row = odbc_fetch_array($execute))
{
		$num2++;

$TEmployee_id=$row['tempid'];
$TEmployee_fname=$row["fname"];
$TEmployee_lname=$row["lname"];
$TFileCommittee_order_no=$row["order_no"];
$TFileCommittee_ttile=$row["TTitle"];
if($TEmployee_id!=$TEmployee_id_check)
	{
		$num1++;
	}
$TEmployee_id_check=$TEmployee_id;




$information .= "\n<committee>";

	$information .= "\n<temp_id>";
		$information .= "$TEmployee_id";
	$information .= "\n</temp_id>";

	$information .= "\n<temp_fname>";
		$information .= "$TEmployee_fname";
	$information .= "\n</temp_fname>";

	$information .= "\n<temp_lname>";
		$information .= "$TEmployee_lname";
	$information .= "\n</temp_lname>";

	$information .= "\n<order_no>";
		$information .= "$TFileCommittee_order_no";
	$information .= "\n</order_no>";

	$information .= "\n<t_title>";
		$information .= "$TFileCommittee_ttile";
	$information .= "\n</t_title>";



$information .= "\n</committee>";
}
//end_selece_database_project


$information .= "\n</committees>";
//end_committee

$information .= "\n<num_teacher_committees>";
	$information .= "$num1";
$information .= "\n</num_teacher_committees>";

$information .= "\n<num_committees_of_teacher>";
	$information .= "$num2";
$information .= "\n</num_committees_of_teacher>";

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


echo "$information";


?>