Viewing file: standard_3_4_xml.php (4.23 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_4>";
//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)) { $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>";
//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 as a, TProject.NameT ,TProject.NameE ,TProject.Type_id, TProject.TypeSub_id, TProject.budget3 , TProject.budget4, TProject.budget2 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['a']; $TProject_NameT=$row["NameT"]; $TProject_NameE=$row["NameE"]; $TProject_Type_id=$row["Type_id"]; $TProject_TypeSub_id=$row["TypeSub_id"];
$TProject_budget2=$row['budget2']; $TProject_budget3=$row['budget3']; $TProject_budget4=$row['budget4'];
//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<budget3>"; $information .= "$TProject_budget3"; $information .= "\n</budget3>";
$information .= "\n<budget4>"; $information .= "$TProject_budget4"; $information .= "\n</budget4>";
$information .= "\n</project>";
$TProject_budget2_sum=$TProject_budget2_sum+$TProject_budget2; $TProject_budget3_sum=$TProject_budget3_sum+$TProject_budget3; $TProject_budget4_sum=$TProject_budget4_sum+$TProject_budget4;
} //end_selece_database_project
$information .= "\n</projects>"; //project $information .= "\n<budget2_sum>"; $information .= "$TProject_budget2_sum"; $information .= "\n</budget2_sum>";
$information .= "\n<budget3_sum>"; $information .= "$TProject_budget3_sum"; $information .= "\n</budget3_sum>";
$information .= "\n<budget4_sum>"; $information .= "$TProject_budget4_sum"; $information .= "\n</budget4_sum>";
$information .= "\n</Standard_3_4>"; echo "$information";
?>
|