Viewing file: ResearchDetail.php (14.72 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php
include("../../include/FunctionDB.php");
include("../../include/Function.php");
ConnectDB();
$sql = "Select * From personal_tb as t,research_tb as r Where t.Teacher_code = r.Teacher_code and r.Research_code='$Research_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>Research 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="#FFFFFF">
<table width="95%" border="0" align="center" cellpadding="0" cellspacing="1" bordercolor="#999999" bgcolor="#E8E1C8"style="background-color:#eeeeee; border:1px solid gray"size="12">
<form action="FrmEditPersonal.php" method="$_POST">
<!--DWLayoutTable-->
<tr bgcolor="#FFCC99">
<td colspan="3" bgcolor="#0066CC"><img src="../../Image/Ponallogo.jpg" width="550" height="71"></td>
</tr>
<tr bgcolor="#FFCC99">
<td colspan="3"> <div align="center"><font color="#000000" size="4" face="Tahoma"><strong>แสดงรายละเอียดงานวิจัย</strong></font></div></td>
</tr>
<tr bgcolor="#FFEFDF">
<td width="267" height="20" nowrap bordercolor="#D8D2A9">
<div align="center"><strong><font color="#003366" size="2" face="Tahoma">ชื่องานวิจัย</font></strong></div></td>
<td nowrap bgcolor="#F7F7F7"><!--DWLayoutEmptyCell--> </td>
<td nowrap bgcolor="#F7F7F7"><strong><font color="#000000" size="2" face="Tahoma"><? echo $rs[Research_name] ?></font></strong></td>
</tr>
<tr bgcolor="#FFEFDF">
<td height="20" nowrap bordercolor="#D8D2A9">
<div align="center"><strong><font color="#003366" size="2" face="Tahoma">ประเภทงานวิจัย</font></strong></div></td>
<td nowrap bgcolor="#F7F7F7"><!--DWLayoutEmptyCell--> </td>
<td nowrap bgcolor="#F7F7F7"><font color="#000000" size="2" face="Tahoma"><? echo $rs[Research_type] ?></font></td>
</tr>
<tr bgcolor="#FFEFDF">
<td height="20" nowrap bordercolor="#D8D2A9">
<div align="center"><strong><font color="#003366" size="2" face="Tahoma">ลักษณะผลงานวิจัย</font></strong></div></td>
<td nowrap bgcolor="#F7F7F7"><!--DWLayoutEmptyCell--> </td>
<td nowrap bgcolor="#F7F7F7"><font color="#000000" size="2" face="Tahoma"><? echo $rs[Research_char] ?></font></td>
</tr>
<tr bgcolor="#FFEFDF">
<td height="20" nowrap bordercolor="#D8D2A9">
<div align="center"><strong><font color="#003366" size="2" face="Tahoma">สาขาวิชา</font></strong></div></td>
<td width="11" nowrap bgcolor="#F7F7F7"><!--DWLayoutEmptyCell--> </td>
<td width="653" nowrap bgcolor="#F7F7F7"> <font color="#000000" size="2" face="Tahoma">
<? echo $rs[Branch] ?> </font></td>
</tr>
<tr bgcolor="#FFEFDF">
<td height="20" nowrap bordercolor="#D8D2A9">
<div align="center"><strong><font color="#003366" size="2" face="Tahoma">ชื่อผู้วิจัย</font></strong></div></td>
<td width="11" nowrap bgcolor="#F7F7F7"><!--DWLayoutEmptyCell--> </td>
<td width="653" nowrap bgcolor="#F7F7F7"> <font color="#000000" size="2" face="Tahoma">
<strong>
<?php
echo"$rs[First_name]";
?>
<?php
echo"$rs[Teacher_name]";
?>
<?php
echo"$rs[Teacher_lastname]";
?>
</strong> </font></td>
</tr>
<tr bgcolor="#FFEFDF">
<td height="20" nowrap bordercolor="#D8D2A9">
<div align="center"><strong><font color="#003366" size="2" face="Tahoma">ปีที่เริ่มทำ</font></strong></div></td>
<td nowrap bgcolor="#F7F7F7"><!--DWLayoutEmptyCell--> </td>
<td nowrap bgcolor="#F7F7F7">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr bgcolor="#FFEFDF">
<td width="30%" bgcolor="#F7F7F7">
<div align="center"><font color="#003366" size="2" face="Tahoma">
<?php
$sday = $rs[Year_start];
$yearthai = explode("-",$sday);
$day = intval($yearthai[2]);
$month = intval($yearthai[1]);
$year = intval($yearthai[0]);
//////////////////
// $yearthai = $day ;
$m = getThaiSubMonth($month);
echo"$day"." "."$m"." "."$year";
?>
</font></div></td>
<td width="30%">
<div align="center"><font color="#000000" size="2" face="Tahoma"><strong>ปีที่แล้วเสร็จ</strong></font></div></td>
<td width="30%" bgcolor="#F7F7F7">
<div align="center"><font color="#003366" size="2" face="Tahoma">
<?php
$sday = $rs[Year_finish];
$yearthai = explode("-",$sday);
$day = intval($yearthai[2]);
$month = intval($yearthai[1]);
$year = intval($yearthai[0]);
//////////////////
// $yearthai = $day ;
$m = getThaiSubMonth($month);
echo"$day"." "."$m"." "."$year";
?>
</font></div></td>
</tr>
</table></td>
</tr>
<tr bgcolor="#FFEFDF">
<td height="20" nowrap bordercolor="#D8D2A9">
<div align="center"><strong><font color="#003366" size="2" face="Tahoma">ตำแหน่งการวิจัย</font></strong></div></td>
<td width="11" nowrap bgcolor="#F7F7F7"><!--DWLayoutEmptyCell--> </td>
<td width="653" nowrap bgcolor="#F7F7F7"> <font color="#000000" size="2" face="Tahoma">
<? echo $rs[R_position]?> </font></td>
</tr>
<tr bgcolor="#FFEFDF">
<td height="20" nowrap bordercolor="#D8D2A9">
<div align="center"><strong><font color="#003366" size="2" face="Tahoma">ผู้ร่วมวิจัย
1</font></strong></div></td>
<td width="11" nowrap bgcolor="#F7F7F7"><!--DWLayoutEmptyCell--> </td>
<td width="653" nowrap bgcolor="#F7F7F7"> <font color="#000000" size="2" face="Tahoma">
<?php
$name1 = $rs[name1] ;
$sql11 = "Select First_name,Teacher_name,Teacher_lastname From personal_tb Where Teacher_code='$name1'";
$result11 = mysql_query($sql11);
$rs11 = mysql_fetch_array($result11);
echo"$rs11[First_name] $rs11[Teacher_name] $rs11[Teacher_lastname]";
?>
</font></td>
</tr>
<tr bgcolor="#FFEFDF">
<td height="20" nowrap bordercolor="#D8D2A9">
<div align="center"><strong><font color="#003366" size="2" face="Tahoma">ผู้ร่วมวิจัย
2</font></strong></div></td>
<td width="11" nowrap bgcolor="#F7F7F7"><!--DWLayoutEmptyCell--> </td>
<td width="653" nowrap bgcolor="#F7F7F7"> <font color="#000000" size="2" face="Tahoma">
<?php
$name2 = $rs[name2] ;
$sql11 = "Select First_name,Teacher_name,Teacher_lastname From personal_tb Where Teacher_code='$name2'";
$result11 = mysql_query($sql11);
$rs11 = mysql_fetch_array($result11);
echo"$rs11[First_name] $rs11[Teacher_name] $rs11[Teacher_lastname]";
?>
</font></td>
</tr>
<tr bgcolor="#FFEFDF">
<td height="20" nowrap bordercolor="#D8D2A9">
<div align="center"><strong><font color="#003366" size="2" face="Tahoma">ผู้ร่วมวิจัย
3</font></strong></div></td>
<td width="11" nowrap bgcolor="#F7F7F7"><!--DWLayoutEmptyCell--> </td>
<td width="653" nowrap bgcolor="#F7F7F7"> <font color="#000000" size="2" face="Tahoma">
<?php
$name3 = $rs[name3] ;
$sql11 = "Select First_name,Teacher_name,Teacher_lastname From personal_tb Where Teacher_code='$name3'";
$result11 = mysql_query($sql11);
$rs11 = mysql_fetch_array($result11);
echo"$rs11[First_name] $rs11[Teacher_name] $rs11[Teacher_lastname]";
?>
</font></td>
</tr>
<tr bgcolor="#FFEFDF">
<td height="20" nowrap bordercolor="#D8D2A9">
<div align="center"><strong><font color="#003366" size="2" face="Tahoma">ผู้ร่วมวิจัย
4</font></strong></div></td>
<td width="11" nowrap bgcolor="#F7F7F7"><!--DWLayoutEmptyCell--> </td>
<td width="653" nowrap bgcolor="#F7F7F7"> <font color="#000000" size="2" face="Tahoma">
<?php
$name4 = $rs[name4] ;
$sql11 = "Select First_name,Teacher_name,Teacher_lastname From personal_tb Where Teacher_code='$name4'";
$result11 = mysql_query($sql11);
$rs11 = mysql_fetch_array($result11);
echo"$rs11[First_name] $rs11[Teacher_name] $rs11[Teacher_lastname]";
?>
</font></td>
</tr>
<tr bgcolor="#FFEFDF">
<td height="20" nowrap bordercolor="#D8D2A9">
<div align="center"><strong><font color="#003366" size="2" face="Tahoma">ผู้ร่วมวิจัย
5</font></strong></div></td>
<td width="11" nowrap bgcolor="#F7F7F7"><!--DWLayoutEmptyCell--> </td>
<td width="653" nowrap bgcolor="#F7F7F7"><font color="#000000" size="2" face="Tahoma">
<?php
$name5 = $rs[name5] ;
$sql11 = "Select First_name,Teacher_name,Teacher_lastname From personal_tb Where Teacher_code='$name5'";
$result11 = mysql_query($sql11);
$rs11 = mysql_fetch_array($result11);
echo"$rs11[First_name] $rs11[Teacher_name] $rs11[Teacher_lastname]";
?>
</font></td>
</tr>
<tr bgcolor="#FFEFDF">
<td height="20" nowrap bordercolor="#D8D2A9">
<div align="center"><strong><font color="#003366" size="2" face="Tahoma">ผู้ร่วมวิจัย
6</font></strong></div></td>
<td nowrap bgcolor="#F7F7F7"><!--DWLayoutEmptyCell--> </td>
<td nowrap bgcolor="#F7F7F7"><font color="#000000" size="2" face="Tahoma">
<?php
$name6 = $rs[name6] ;
$sql11 = "Select First_name,Teacher_name,Teacher_lastname From personal_tb Where Teacher_code='$name6'";
$result11 = mysql_query($sql11);
$rs11 = mysql_fetch_array($result11);
echo"$rs11[First_name] $rs11[Teacher_name] $rs11[Teacher_lastname]";
?>
</font></td>
</tr>
<tr bgcolor="#FFEFDF">
<td height="20" nowrap bordercolor="#D8D2A9">
<div align="center"><strong><font color="#003366" size="2" face="Tahoma">ผู้ร่วมวิจัย
7 </font></strong></div></td>
<td nowrap bgcolor="#F7F7F7"><!--DWLayoutEmptyCell--> </td>
<td nowrap bgcolor="#F7F7F7"><font color="#000000" size="2" face="Tahoma">
<?php
$name7 = $rs[name7] ;
$sql11 = "Select First_name,Teacher_name,Teacher_lastname From personal_tb Where Teacher_code='$name7'";
$result11 = mysql_query($sql11);
$rs11 = mysql_fetch_array($result11);
echo"$rs11[First_name] $rs11[Teacher_name] $rs11[Teacher_lastname]";
?>
</font></td>
</tr>
<tr bgcolor="#FFEFDF">
<td height="20" nowrap bordercolor="#D8D2A9">
<div align="center"><strong><font color="#003366" size="2" face="Tahoma">ผู้ร่วมวิจัย
8 </font></strong></div></td>
<td nowrap bgcolor="#F7F7F7"><!--DWLayoutEmptyCell--> </td>
<td nowrap bgcolor="#F7F7F7"><font color="#000000" size="2" face="Tahoma">
<?php
$name8 = $rs[name8] ;
$sql11 = "Select First_name,Teacher_name,Teacher_lastname From personal_tb Where Teacher_code='$name8'";
$result11 = mysql_query($sql11);
$rs11 = mysql_fetch_array($result11);
echo"$rs11[First_name] $rs11[Teacher_name] $rs11[Teacher_lastname]";
?>
</font></td>
</tr>
<tr bgcolor="#FFEFDF">
<td height="20" nowrap bordercolor="#D8D2A9">
<div align="center"><strong><font color="#003366" size="2" face="Tahoma">เงินทุน</font></strong></div></td>
<td nowrap bgcolor="#F7F7F7"><!--DWLayoutEmptyCell--> </td>
<td nowrap bgcolor="#F7F7F7"> <font color="#000000" size="2" face="Tahoma"><? echo $rs[Fund] ?> </font><font color="#003366" size="2" face="Tahoma">บาท</font></td>
</tr>
<tr bgcolor="#FFEFDF">
<td height="20" nowrap bordercolor="#D8D2A9">
<div align="center"><strong><font color="#003366" size="2" face="Tahoma">แหล่งเงินทุน</font></strong></div></td>
<td nowrap bgcolor="#F7F7F7"><!--DWLayoutEmptyCell--> </td>
<td nowrap bgcolor="#F7F7F7"><font color="#000000" size="2" face="Tahoma"><? echo $rs[Fund_resource] ?> <font color="#003366">จาก</font> <? echo $rs[Resource_des] ?></font></td>
</tr>
<tr bgcolor="#FFEFDF">
<td height="20" nowrap bordercolor="#D8D2A9">
<div align="center"><strong><font color="#003366" size="2" face="Tahoma">การเผยแพร่</font></strong></div></td>
<td nowrap bgcolor="#F7F7F7"><!--DWLayoutEmptyCell--> </td>
<td nowrap bgcolor="#F7F7F7"><font color="#000000" size="2" face="Tahoma"><? echo $rs[Propagate] ?></font><font color="#003366" size="2" face="Tahoma">
</font><font color="#000000" size="2" face="Tahoma"><? echo $rs[Propagate_des] ?></font><font color="#003366" size="2" face="Tahoma">
</font></td>
</tr>
<tr bgcolor="#FFEFDF">
<td height="20" nowrap bordercolor="#D8D2A9">
<div align="center"><strong><font color="#003366" size="2" face="Tahoma">ลักษณะการเผยแพร่</font></strong></div></td>
<td nowrap bgcolor="#F7F7F7"><!--DWLayoutEmptyCell--> </td>
<td nowrap bgcolor="#F7F7F7"><font color="#000000" size="2" face="Tahoma"><? echo $rs[Prop_type] ?></font></td>
</tr>
<tr bgcolor="#FFEFDF">
<td height="20" nowrap bordercolor="#D8D2A9">
<div align="center"><strong><font color="#003366" size="2" face="Tahoma">การนำไปใช้</font></strong></div></td>
<td nowrap bgcolor="#F7F7F7"><!--DWLayoutEmptyCell--> </td>
<td nowrap bgcolor="#F7F7F7"><font color="#000000" size="2" face="Tahoma"><? echo $rs[Apply1] ?>
,<? echo $rs[Apply2] ?> ,<? echo $rs[Apply3] ?> </font></td>
</tr>
<tr bgcolor="#FFEFDF">
<td height="20" nowrap bordercolor="#D8D2A9"> </td>
<td nowrap bgcolor="#F7F7F7"><!--DWLayoutEmptyCell--> </td>
<td nowrap bgcolor="#F7F7F7"><font color="#000000" size="2" face="Tahoma"><? echo $rs[Apply4] ?>
<? echo $rs[Apply_des] ?> </font></td>
</tr>
<tr bgcolor="#FFEFDF">
<td height="20" nowrap bordercolor="#D8D2A9">
<div align="center"><strong><font color="#003366" size="2" face="Tahoma">ปีที่เผยแพร่</font></strong></div></td>
<td nowrap bgcolor="#F7F7F7"><!--DWLayoutEmptyCell--> </td>
<td nowrap bgcolor="#F7F7F7"><font color="#000000" size="2" face="Tahoma"><? echo $rs[Year_prop] ?></font></td>
</tr>
<tr bgcolor="#FFCC99">
<td height="26" colspan="3"> </td>
</tr>
</form>
</table>
<p> </p>
</body>
</html>
|