Viewing file: xml_committees_of_teacher.php (2.18 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?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";
?>
|