Viewing file: ManDetail.php (9.09 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php
include("../include/FunctionDB.php");
include("../include/Function.php");
ConnectDB();
$sql = "Select * From manament_tb Where code='$code'";
$result = mysql_query($sql) or die(" Error").mysql_error();
$rs = mysql_fetch_array($result)
?>
<html>
<head>
<title>ўйНБЩЕЎТГбЁй§«иНБєУГШ§</title>
<link href="./source/style.css" rel="stylesheet" type="text/css">
<meta http-equiv="Content-Type" content="text/html; charset=windows-874" />
<style type="text/css">
<!--
.style1 {
color: #000000;
font-weight: bold;
font-size: 14px;
}
.style2 {font-size: 14px}
.style2 {font-family: Tahoma}
-->
</style>
</head>
<table width="741" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="741" ><form id="form1" name="form1" method="post" action=""><fieldset>
<table width="98%" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#eeeeee" style="border:0px solid gray"size="12">
<tr bgcolor="#6699CC">
<td height="10" colspan="4" bgcolor="#FFFFFF" align="center"></td>
</tr>
<tr bgcolor="#6699CC">
<td height="26" colspan="4" bgcolor="#F8F8F8" align="center"><span class="style1"><font face="Tahoma">бКґ§ГТВЕРаНХВґ</font></span></td>
</tr>
<tr bgcolor="#EEEEEE">
<td width="170" height="20" bordercolor="#D8D2A9" bgcolor="#FFFFFF"><font size="2" face="Tahoma">ЗС№·ХибЁй§«иНБ</font></td>
<td nowrap bordercolor="#DDF8D1" bgcolor="#FFFFFF"></td>
<td nowrap bordercolor="#DDF8D1" bgcolor="#FFFFFF"><strong><font color="#000000" size="2" face="Tahoma"> </font><font color="#003366" size="2" face="Tahoma">
<?php
$sday = $rs[Date_buy];
$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></strong></td>
<td width="147" rowspan="16" valign="top" nowrap bordercolor="#DDF8D1" bgcolor="#FFFFFF" align="center"><br>
<?php
echo"<center>";
echo"<img src=\"$rs[Img1]\" width=\"200\" height=\"150\" >";
echo"</center>";
?></td>
</tr>
<tr bgcolor="#EEEEEE">
<td height="20" bordercolor="#D8D2A9" bgcolor="#FFFFFF"><font size="2" face="Tahoma">ЄЧиННШ»ЎГім/ВХиЛйН</font></td>
<td nowrap bordercolor="#DDF8D1" bgcolor="#FFFFFF"></td>
<td nowrap bordercolor="#DDF8D1" bgcolor="#FFFFFF"><strong><font color="#000000" size="2" face="Tahoma">
<?php
echo"$rs[Acc_name]";
?></font></strong></td>
</tr>
<tr bgcolor="#EEEEEE">
<td height="20" nowrap bordercolor="#D8D2A9" bgcolor="#FFFFFF"><font size="2" face="Tahoma">Є№ФґўН§НШ»ЎГім</font></td>
<td bordercolor="#DDF8D1" bgcolor="#FFFFFF"> </td>
<td bordercolor="#DDF8D1" bgcolor="#FFFFFF"><font color="#000000" size="2" face="Tahoma"> <? echo $rs[Status] ?></font></td>
</tr>
<tr bgcolor="#EEEEEE">
<td height="20" bordercolor="#D8D2A9" bgcolor="#FFFFFF"><font size="2" face="Tahoma">ГТВЎТГ</font></td>
<td bordercolor="#DDF8D1" bgcolor="#FFFFFF"> </td>
<td bgcolor="#FFFFFF" ><font color="#000000" size="2" face="Tahoma"> <? echo nl2br($rs[Acc_code])?></font></td>
</tr>
<tr bgcolor="#EEEEEE">
<td height="20" bordercolor="#D8D2A9" bgcolor="#FFFFFF"><font size="2" face="Tahoma">К¶Т№·ХиНШ»ЎГім</font></td>
<td bordercolor="#DDF8D1" bgcolor="#FFFFFF"> </td>
<td bgcolor="#FFFFFF" ><font color="#000000" size="2" face="Tahoma"><? echo nl2br($rs[Store])?></font></td>
</tr>
<tr bgcolor="#EEEEEE">
<td height="20" bordercolor="#D8D2A9" bgcolor="#FFFFFF"><font size="2" face="Tahoma">»ГРЗСµФЎТГ«иНБ</font></td>
<td width="10" bordercolor="#DDF8D1" bgcolor="#FFFFFF"> </td>
<td width="397" bgcolor="#FFFFFF" ><font color="#000000" size="2" face="Tahoma"> <? echo nl2br($rs[Fix_History])?></font></td>
</tr>
<tr bgcolor="#EEEEEE">
<td height="20" bordercolor="#D8D2A9" bgcolor="#FFFFFF"><font size="2" face="Tahoma">КТаЛµШНТЎТГ</font></td>
<td width="10" bordercolor="#DDF8D1" bgcolor="#FFFFFF"> </td>
<td width="397" bordercolor="#DDF8D1" bgcolor="#FFFFFF"><font color="#000000" size="2" face="Tahoma"> <? echo $rs[Contact]?></font></td>
</tr>
<tr bgcolor="#EEEEEE">
<td height="20" bgcolor="#FFFFFF" ><font size="2" face="Tahoma">ЗС№·Хи«иНБаКГзЁ</font></td>
<td bordercolor="#DDF8D1" bgcolor="#FFFFFF"> </td>
<td bordercolor="#DDF8D1" bgcolor="#FFFFFF"><font color="#003366" size="2" face="Tahoma">
<?php
$sday = $rs[Date_year];
$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></td>
</tr>
<tr bgcolor="#EEEEEE">
<td height="20" bordercolor="#D8D2A9" bgcolor="#FFFFFF"><font size="2" face="Tahoma">ГТ¤Т</font></td>
<td bordercolor="#DDF8D1" bgcolor="#FFFFFF"> </td>
<td bordercolor="#DDF8D1" bgcolor="#FFFFFF"><font color="#993333" size="2" face="Tahoma"> <? echo number_format($rs['Price'],2,'.',','); ?></font><font color="#000000" size="2" face="Tahoma"> єТ·</font></td>
</tr>
<tr bgcolor="#EEEEEE">
<td height="20" bordercolor="#D8D2A9" bgcolor="#FFFFFF"><font size="2" face="Tahoma">§є»ГРБТіЎТГ«иНБб«Б</font></td>
<td bordercolor="#DDF8D1" bgcolor="#FFFFFF"> </td>
<td bordercolor="#DDF8D1" bgcolor="#FFFFFF"><font color="#000000" size="2" face="Tahoma"> <? echo $rs[Fix_budget] ?> єТ·</font></td>
</tr>
<tr bgcolor="#EEEEEE">
<td height="20" nowrap bordercolor="#D8D2A9" bgcolor="#FFFFFF"><font size="2" face="Tahoma">К¶Т№РЎТГгЄй§Т№</font></td>
<td bordercolor="#DDF8D1" bgcolor="#FFFFFF"> </td>
<td bordercolor="#DDF8D1" bgcolor="#FFFFFF"><font color="#000000" size="2" face="Tahoma"> <? echo $rs[Status_1] ?></font></td>
</tr>
<tr bgcolor="#EEEEEE">
<td height="20" bordercolor="#D8D2A9" bgcolor="#FFFFFF"><font size="2" face="Tahoma">К¶ФµФЎТГгЄй§Т№</font></td>
<td bordercolor="#DDF8D1" bgcolor="#FFFFFF"> </td>
<td bgcolor="#FFFFFF" ><font color="#000000" size="2" face="Tahoma"> <? echo $rs[Statistic] ?></font></td>
</tr>
<tr bgcolor="#EEEEEE">
<td height="20" nowrap bordercolor="#D8D2A9" bgcolor="#FFFFFF"><font size="2" face="Tahoma">єС№·ЦЎ«иЗВЁУ</font></td>
<td bgcolor="#FFFFFF" > </td>
<td bgcolor="#FFFFFF" ><font color="#000000" size="2" face="Tahoma"> <? echo nl2br($rs[Description]) ?></font></td>
</tr>
<tr bgcolor="#EEEEEE">
<td height="20" bordercolor="#D8D2A9" bgcolor="#FFFFFF"><font size="2" face="Tahoma">№СЎИЦЎЙТјЩйбЁй§</font></td>
<td nowrap bordercolor="#DDF8D1" bgcolor="#FFFFFF"></td>
<td nowrap bordercolor="#DDF8D1" bgcolor="#FFFFFF"><font color="#000000" size="2" face="Tahoma">
<?php
$Student_id = $rs[Student_id];
$sql2= "Select * From student_tb Where Student_id='$Student_id' ";
$result2 = mysql_query($sql2) or die("Error Select".mysql_query());
$rs2 = mysql_fetch_array($result2);
echo"$rs2[Name] $rs2[Lastname]";
?></font></td>
</tr>
<tr bgcolor="#EEEEEE">
<td height="20" bordercolor="#D8D2A9" bgcolor="#FFFFFF"><font size="2" face="Tahoma">НТЁТГВм·ХиГСєјФґЄНє</font></td>
<td bordercolor="#DDF8D1" bgcolor="#FFFFFF"> </td>
<td bordercolor="#DDF8D1" bgcolor="#FFFFFF"><font color="#000000" size="2" face="Tahoma">
<?php
$Teacher_code = $rs["Teacher_code"];
$sql = "Select * From personal_tb Where Teacher_code='$Teacher_code'";
$result1 = mysql_query($sql) or die("Error".mysql_error());
$rss = mysql_fetch_array($result1);
echo "$rss[Teacher_name] $rss[Teacher_lastname]";
?>
</font></td>
</tr>
<tr bgcolor="#EEEEEE">
<td height="29" nowrap bordercolor="#D8D2A9" bgcolor="#FFFFFF"><font size="2" face="Tahoma">єС№·ЦЎ«иЗВЁУ</font></td>
<td bgcolor="#FFFFFF" > </td>
<td bgcolor="#FFFFFF" ><font color="#000000" size="2" face="Tahoma"> <? echo nl2br($rs[Description]) ?></font></td>
</tr>
</table>
</fieldset>
<div align="center">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="10"></td>
</tr>
</table>
<input type="button" name="Close" value="»ФґЛ№йТµиТ§" onClick="window.close()" onMouseOver="this.style.cursor='hand'" />
</div>
</form>
</tr>
</table>
</body>
</html>
|