Viewing file: standard_3_2_xml.php (1.81 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
';
$information .= "\n";
//Standard 3-1
$information .= "\n";
//project
$information .= "\n";
$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";
$execute = odbc_exec($connect, $sql) or die ("àÍç¡«Ô¤ÔÇÊì¤ÓÊÑè§äÁèä´é");
$i=1;
$num1=0;
$TEmployee_id_check="";
while($row = odbc_fetch_array($execute))
{
$TEmployee_id=$row['Id'];
$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";
$information .= "\n";
$information .= "$TEmployee_id";
$information .= "\n";
$information .= "\n";
$information .= "$TEmployee_fname";
$information .= "\n";
$information .= "\n";
$information .= "$TEmployee_lname";
$information .= "\n";
$information .= "\n";
$information .= "$TFileCommittee_order_no";
$information .= "\n";
$information .= "\n";
$information .= "$TFileCommittee_ttile";
$information .= "\n";
$information .= "\n";
}
//end_selece_database_project
$information .= "\n";
//project
$information .= "\n";
$information .= "$num1";
$information .= "\n";
$information .= "\n";
//end _ Standard 3-1
$information .= "\n";
echo "$information";
?>
bool(false)
|