| Server IP : 172.67.187.206 / Your IP : 172.71.28.155 Web Server : Apache/2.4.25 (Win32) OpenSSL/1.0.2j PHP/5.6.30 System : Windows NT WIN-ECQAAA40806 6.2 build 9200 (Windows Server 2012 Standard Edition) i586 User : SYSTEM ( 0) PHP Version : 5.6.30 Disable Function : NONE MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /Inetpub/www/myoffice/2565/modules/tkk7/ |
Upload File : |
<?
CheckUser($_SESSION['user_user'], $_SESSION['user_pwd']);
?>
<TABLE cellSpacing=0 cellPadding=0 width=100% height="500"border=0>
<TBODY>
<TR>
<TD vAlign=top>
<?
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$res[user] = $db->select_query("SELECT * FROM ".TB_user." WHERE username='".$_SESSION['user_user']."' ");
$arr[user] = $db->fetch($res[user]);
$res[usersch] = $db->select_query("SELECT * FROM ".TB_usersch." WHERE id='".$arr[user][sangkad]."' ");
$arr[usersch] = $db->fetch($res[usersch]);
?>
<img src="images/back.png" align="absmiddle" > <B>หนังสือราชการเข้าใหม่ของ<? echo $arr[usersch][name];?></B>
<TABLE width="100%" align=center cellSpacing=1 cellPadding=1 border=0>
<tr bgcolor="#336633" height=25>
<td align=center width="140"><font color="#FFFFFF"><B>เลขทะเบียน</B></font></td>
<td align=center width="480"><font color="#FFFFFF"><B>เรื่อง</B></font></td>
<td width="120" align=center ><font color="#FFFFFF"><B>ว/ด/ป/ที่ส่ง</B></font></td>
<td width="200" align=center ><font color="#FFFFFF"><B>จาก</B></font></td>
<td width="40" align=center ><font color="#FFFFFF"><B>ดู</B></font></td>
</tr>
<?
// CheckUser($_SESSION['user_user']);
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$res[user] = $db->select_query("SELECT * FROM ".TB_user." WHERE username='".$_SESSION['user_user']."' ");
$arr[user] = $db->fetch($res[user]);
$res[usersch] = $db->select_query("SELECT * FROM ".TB_usersch." WHERE id='".$arr[user][sangkad]."' ");
$arr[usersch] = $db->fetch($res[usersch]);
//แสดงบทความ
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$res[tkk7] = $db->select_query("SELECT * FROM ".TB_TKK7." WHERE category like '%,".$arr[user][sangkad].",%' ORDER by update_date DESC ");
while($arr[tkk7] = $db->fetch($res[tkk7]))
{
//Check Comment
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$res[comment] = $db->select_query("SELECT * FROM ".TB_TKK7_COMMENT." WHERE tkk7_id='".$arr[tkk7][id]."' and catno='".$arr[user][sangkad]."' ORDER BY id ");
$arr[comment] = $db->fetch($res[comment]);
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$res[usersch] = $db->select_query("SELECT * FROM ".TB_usersch." WHERE id='".$arr[tkk7][posted]."' ORDER BY id ");
$arr[usersch] = $db->fetch($res[usersch]);
?>
<?
if(($arr[tkk7][id]!=$arr[comment][tkk7_id])){
?>
<tr bgcolor="#FFFFFF">
<td valign="top"><font color="#FF0000"> <?echo$arr[tkk7][tabain];?></font></td>
<td valign="top"><font color="#FF0000"><img src="images/krut.png" width=15 align="absmidd"> <?echo $arr[tkk7][topic];?></font></td>
<td valign="top"><CENTER><font color="#FF0000"><?echo ThaiTimeConvert($arr[tkk7][post_date],'','');?></font></CENTER></td>
<td valign="top"><CENTER><font color="#FF0000"><? echo $arr[usersch][name];?></font></CENTER></td>
<td valign="top"><CENTER><A HREF="?name=tkk7&file=readtkkod&id=<?echo $arr[tkk7][id];?>"><FONT COLOR="#FF0000" ><img src="images/read.png" width=20/></CENTER>
</td>
</tr>
<?
}
?>
<?
}
$db->closedb ();
//จบการแสดงข่าวสาร
?>
</table>
</form>
</TD>
</TR>
</TBODY>
</TABLE>