Viewing file:  standard_3_1_xml.php (3.82 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
$information = '<?xml version="1.0" encoding="windows-874"?>';
//Standard 3-1
$information .= "\n<Standard_3_1>";
//teacher
$information .= "\n<teachers>";
$dsn_name = "staff";
$username ="";
$password ="";
$connect= odbc_connect($dsn_name, $username, $password) or die("µÔ´µèÍ DSN äÁèä´é");
$sql = "SELECT *,TEmployee.id as tempid FROM TEmployee,TWorkStatus,TPosScale WHERE (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;
while($row = odbc_fetch_array($execute))
{
$num1++;
$id=$row["tempid"];
$name=$row["fname"];
$surname=$row["lname"];
$information .= "\n<teacher>";
$information .= "\n<teacher_id>";
$information .= "$id";
$information .= "\n</teacher_id>";
$information .= "\n<teacher_fname>";
$information .= "$name";
$information .= "\n</teacher_fname>";
$information .= "\n<teacher_lname>";
$information .= "$surname";
$information .= "\n</teacher_lname>";
$information .= "\n</teacher>";
}
$information .= "\n</teachers>";
$information .= "\n<num_teachers>";
$information .= "$num1";
$information .= "\n</num_teachers>";
//project
$information .= "\n<projects>";
$dsn_name = "project";
$username ="";
$password ="";
$connect= odbc_connect($dsn_name, $username, $password) or die("µÔ´µèÍ DSN äÁèä´é");
//selece_database_project
$sql = "SELECT TProject.id, TProject.NameT ,TProject.NameE ,TProject.Type_id, TProject.TypeSub_id FROM TProject, TTypeProject, TTypeProjectSub WHERE (TProject.Type_id=TTypeProject.id) and (TProject.TypeSub_id=TTypeProjectSub.id)and (TProject.Type_id='1') and (TProject.TypeSub_id='01') ";
$execute = odbc_exec($connect, $sql) or die ("àÍç¡«Ô¤ÔÇÊì¤ÓÊÑè§äÁèä´é");
$i=1;
$num1=0;
while($row = odbc_fetch_array($execute))
{
$TProject_id=$row['id'];
$TProject_NameT=$row["NameT"];
$TProject_NameE=$row["NameE"];
$TProject_Type_id=$row["Type_id"];
$TProject_TypeSub_id=$row["TypeSub_id"];
//selece_database_TTypeProject
$sql2 = "SELECT * FROM TTypeProject WHERE (id='$TProject_Type_id')";
$execute2 = odbc_exec($connect, $sql2) or die ("àÍç¡«Ô¤ÔÇÊì¤ÓÊÑè§äÁèä´é");
while($row2 = odbc_fetch_array($execute2))
{
$TTypeProject_id=$row2["id"];
$TTypeProject_name=$row2["name"];
}
//selece_database_TTypeProjectSub
$sql3 = "SELECT * FROM TTypeProjectSub WHERE (id='$TProject_TypeSub_id')";
//$sql = "SELECT * FROM TProject";
$execute3 = odbc_exec($connect, $sql3) or die ("àÍç¡«Ô¤ÔÇÊì¤ÓÊÑè§äÁèä´é");
while($row3 = odbc_fetch_array($execute3))
{
$TTypeProjectSub_id=$row3["id"];
$TTypeProjectSub_name=$row3["name"];
}
$num1++;
$information .= "\n<project>";
$information .= "\n<project_id>";
$information .= "$TProject_id";
$information .= "\n</project_id>";
$information .= "\n<project_tname>";
$information .= "$TProject_NameT";
$information .= "\n</project_tname>";
$information .= "\n<project_ename>";
$information .= "$TProject_NameE";
$information .= "\n</project_ename>";
$information .= "\n<project_type_id>";
$information .= "$TProject_Type_id";
$information .= "\n</project_type_id>";
$information .= "\n<project_type_name>";
$information .= "$TTypeProject_name";
$information .= "\n</project_type_name>";
$information .= "\n<project_typesub_id>";
$information .= "$TProject_TypeSub_id";
$information .= "\n</project_typesub_id>";
$information .= "\n<project_typesub_name>";
$information .= "$TTypeProjectSub_name";
$information .= "\n</project_typesub_name>";
$information .= "\n</project>";
}
//end_selece_database_project
$information .= "\n</projects>";
//project
$information .= "\n<num_projects>";
$information .= "$num1";
$information .= "\n</num_projects>";
$information .= "\n</Standard_3_1>";
//end _ Standard 3-1
echo "$information";
?>
|