Viewing file: TrainingDetail.php (7.6 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php
include("../../include/FunctionDB.php");
ConnectDB();
$sql = "Select * From personal_tb as t,training_tb as r Where t.Teacher_code = r.Teacher_code and r.Training_code='$Training_code'";
//$sql = "Select * From researchtb Where Research_code=$Research_code";
$result = mysql_query($sql) or die(" Error").mysql_error();
$rs = mysql_fetch_array($result)
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>Training Detail</title>
<meta http-equiv="Content-Type" content="text/html; charset=windows-874">
<link rel="stylesheet" href="../css/cart3.css" type="text/css">
</head>
<body bgcolor="#F2FCED" topmargin="0" marginwidth="0" marginheight="0">
<p> </p>
<table width="80%" border="0" align="center" cellpadding="0" cellspacing="1" style="background-color:#eeeeee; border:1px solid gray"size="12">
<!--DWLayoutTable-->
<tr>
<td colspan="3" bgcolor="#D2F49F"> <div align="center"><font color="#006633" size="4" face="Tahoma"><strong>แสดงรายละเอียด</strong></font></div></td>
</tr>
<tr>
<td height="20" nowrap bordercolor="#D8D2A9" bgcolor="#FFFFFF"> <div align="center"><strong><font color="#003366" size="2" face="Tahoma">ปี
พ.ศ</font></strong></div></td>
<td width="20" nowrap bordercolor="#DDF8D1" bgcolor="#FFFFFF"><!--DWLayoutEmptyCell--> </td>
<td nowrap bordercolor="#DDF8D1" bgcolor="#FFFFFF"><strong><font color="#000000" size="2" face="Tahoma">
<?php
echo"$rs[Year_std]";
?>
</font></strong></td>
</tr>
<tr>
<td height="20" nowrap bordercolor="#D8D2A9" bgcolor="#FFFFFF"> <div align="center"><strong><font color="#003366" size="2" face="Tahoma">ชื่อผู้อบรม/ดูงาน</font></strong></div></td>
<td nowrap bordercolor="#DDF8D1" bgcolor="#FFFFFF"><!--DWLayoutEmptyCell--> </td>
<td nowrap bordercolor="#DDF8D1" bgcolor="#FFFFFF"> <strong><font color="#000000" size="2" face="Tahoma">
<?php
echo"$rs[First_name]";
?>
<?php
echo"$rs[Teacher_name]";
?>
<?php
echo"$rs[Teacher_lastname]";
?>
</font></strong></td>
</tr>
<tr>
<td width="305" height="20" nowrap bordercolor="#D8D2A9" bgcolor="#FFFFFF">
<div align="center"><strong><font color="#003366" size="2" face="Tahoma">เรื่อง</font></strong></div></td>
<td nowrap bordercolor="#DDF8D1" bgcolor="#FFFFFF"><!--DWLayoutEmptyCell--> </td>
<td nowrap bordercolor="#DDF8D1" bgcolor="#FFFFFF"><font color="#000000" size="2" face="Tahoma"><? echo $rs[Training_name] ?></font></td>
</tr>
<tr>
<td height="20" nowrap bordercolor="#D8D2A9" bgcolor="#FFFFFF"> <div align="center"><strong><font color="#003366" size="2" face="Tahoma">ประเภท</font></strong></div></td>
<td nowrap bordercolor="#DDF8D1" bgcolor="#FFFFFF"><!--DWLayoutEmptyCell--> </td>
<td width="471" nowrap bordercolor="#DDF8D1" bgcolor="#FFFFFF"> <font color="#336600" size="2" face="Tahoma">
<?php
$Training_type = $rs[Training_type];
$sql = "Select * From training_type_tb WHERE Training_type='$Training_type'";
$res = mysql_query($sql);
$row = mysql_fetch_array($res);
echo "$row[Detail]";
?>
</font><font color="#000000" size="2" face="Tahoma"> <? echo $rs[Level]?></font></td>
</tr>
<tr>
<td height="20" nowrap bordercolor="#D8D2A9" bgcolor="#FFFFFF"> <div align="center"><strong><font color="#003366" size="2" face="Tahoma">สาขาวิชา</font></strong></div></td>
<td nowrap bordercolor="#DDF8D1" bgcolor="#FFFFFF"><!--DWLayoutEmptyCell--> </td>
<td width="471" nowrap bgcolor="#FFFFFF"> <font color="#000000" size="2" face="Tahoma">
<? echo $rs[Major]?> </font></td>
</tr>
<tr>
<td height="20" nowrap bordercolor="#D8D2A9" bgcolor="#FFFFFF"> <div align="center"><strong><font color="#003366" size="2" face="Tahoma">วันที่ีเริ่ม-วันที่สิ้นสุด</font></strong></div></td>
<td nowrap bordercolor="#DDF8D1" bgcolor="#FFFFFF"><!--DWLayoutEmptyCell--> </td>
<td width="471" nowrap bordercolor="#DDF8D1" bgcolor="#FFFFFF"><font color="#003366" size="2" face="Tahoma">
<?php
$sday = $rs[Date_start];
$yearthai = explode("-",$sday);
$day = intval($yearthai[2]);
$month = intval($yearthai[1]);
$year = intval($yearthai[0]);
//////////////////
// $yearthai = $day ;
// $month = TxtThaiMonth($month);
echo"$day"."/"."$month"."/"."$year";
?>
</font><font color="#000000" size="2" face="Tahoma">
<font color="#003366">ถึง </font></font><font color="#003366" size="2" face="Tahoma">
<?php
$fday = $rs[Date_finish];
$yearthai = explode("-",$fday);
$day = intval($yearthai[2]);
$month = intval($yearthai[1]);
$year = intval($yearthai[0]);
//////////////////
// $yearthai = $day ;
// $month = TxtThaiMonth($month);
echo"$day"."/"."$month"."/"."$year";
?>
</font></td>
</tr>
<tr>
<td height="20" nowrap bgcolor="#FFFFFF"> <div align="center"><strong><font color="#003366" size="2" face="Tahoma">CNEU
</font></strong></div></td>
<td nowrap bordercolor="#DDF8D1" bgcolor="#FFFFFF"><!--DWLayoutEmptyCell--> </td>
<td nowrap bordercolor="#DDF8D1" bgcolor="#FFFFFF"><font color="#000000" size="2" face="Tahoma"><? echo $rs[CNEU] ?></font></td>
</tr>
<tr>
<td height="20" nowrap bordercolor="#D8D2A9" bgcolor="#FFFFFF"> <div align="center"><strong><font color="#003366" size="2" face="Tahoma">
จำนวนชั่ัวโมง</font></strong></div></td>
<td nowrap bordercolor="#DDF8D1" bgcolor="#FFFFFF"><!--DWLayoutEmptyCell--> </td>
<td nowrap bordercolor="#DDF8D1" bgcolor="#FFFFFF"><font color="#000000" size="2" face="Tahoma"><? echo $rs[Total_hour] ?></font></td>
</tr>
<tr>
<td height="20" nowrap bordercolor="#D8D2A9" bgcolor="#FFFFFF"> <div align="center"><strong><font color="#003366" size="2" face="Tahoma">เงินสนับสนุน</font>
</strong></div></td>
<td nowrap bordercolor="#DDF8D1" bgcolor="#FFFFFF"><!--DWLayoutEmptyCell--> </td>
<td nowrap bordercolor="#DDF8D1" bgcolor="#FFFFFF"><font color="#000000" size="2" face="Tahoma"><? echo $rs[Fund] ?></font></td>
</tr>
<tr>
<td height="20" nowrap bordercolor="#D8D2A9" bgcolor="#FFFFFF"> <div align="center"><strong><font color="#003366" size="2" face="Tahoma">แหล่งเงินสนับสนุน</font></strong></div></td>
<td nowrap bordercolor="#DDF8D1" bgcolor="#FFFFFF"><!--DWLayoutEmptyCell--> </td>
<td nowrap bgcolor="#FFFFFF"><font color="#000000" size="2" face="Tahoma"><? echo $rs[Fund_resource] ?></font></td>
</tr>
<tr>
<td height="20" nowrap bordercolor="#D8D2A9" bgcolor="#FFFFFF"> <div align="center"><strong><font color="#003366" size="2" face="Tahoma">หน่วยงานที่จัด</font></strong></div></td>
<td nowrap bgcolor="#FFFFFF"><!--DWLayoutEmptyCell--> </td>
<td nowrap bgcolor="#FFFFFF"><font color="#000000" size="2" face="Tahoma"><? echo $rs[Organiz] ?></font></td>
</tr>
<tr>
<td height="20" nowrap bordercolor="#D8D2A9" bgcolor="#FFFFFF"> <div align="center"><strong><font color="#003366" size="2" face="Tahoma">การประยุกต์นำไปใช้งาน</font></strong></div></td>
<td nowrap bgcolor="#FFFFFF"><!--DWLayoutEmptyCell--> </td>
<td nowrap bgcolor="#FFFFFF"><font color="#000000" size="2" face="Tahoma"><? echo $rs[Apply] ?></font></td>
</tr>
<tr>
<td height="20" colspan="3" bgcolor="#D2F49F"> <div align="center"> </div></td>
</tr>
</table>
<p> </p>
</body>
</html>
|