<?php


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

$information .= "\n<Projects_of_outservice>";
//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</Projects_of_outservice>";


echo "$information";


?>