| Server IP : 172.67.187.206 / Your IP : 172.71.28.156 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 : E:/Inetpub/www/myschool/triamudom/2567/ |
Upload File : |
<?
header("Content-type: application/vnd.ms-excel");
// header('Content-type: application/csv'); //*** CSV ***//
header("Content-Disposition: attachment; filename=3.xls");
?>
<?
include "mainfile.php";
?>
<table width=100% height=450 border="0" align="left" cellpadding="0" cellspacing="0">
<tr>
<td Valign="top" >
<?
$db->connectdb(DB_NAME,DB_USERNAME,DB_PASSWORD);
$strSQL = "SELECT * FROM ".TB_TKK4." where date(from_unixtime(post_date)) like '____-03-__' ";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
$strSQL .=" ORDER BY post_date asc ";
$objQuery = mysql_query($strSQL);
?>
<table width="99%" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#000000" >
<tr bgcolor="#FFFFFF">
<td width="5%" align="center"><b>ที่</b></td>
<td width="10%" align="center"><b>เลขหนังสือ</b></td>
<td width="40%" align="center"><b>เรื่อง</b></td>
<td width="10%" align="center"><b>วัน เดือน ปี</b></td>
<td width="10%" align="center"><b>จาก</b></td>
<td width="25%" align="center"><b>ถึง</b></td>
</tr>
<?
$i=1;
while($objResult = mysql_fetch_array($objQuery))
{
if ($i%2==0)
{
?><tr bgcolor="#FFFFC6" class="unnamed1"><?
} else {
?><tr bgcolor="ffffff" class="unnamed1"><?
} ?>
<td class="unnamed2"><div align="center"><?echo "$objResult[id]"; ?></div></td>
<td class="unnamed1"><div align="left"> ศธ <? echo "$objResult[tabain]"; ?></div></td>
<td class="unnamed2"><div align="left"><A HREF="?name=tkk4&file=readtkk4_3&id=<? echo"$objResult[id]"; ?>"> <?echo "$objResult[topic]"; ?></A></div>
</td><td class="unnamed2"><div align="center"><?echo thai_date_fullmonth(strtotime("$objResult[date]"));?></div></td>
<td class="unnamed2"><div align="left"> <?=WEB_AREA;?></div></td>
<td class="unnamed2"><div align="left"> <?echo "$objResult[group_ska]"; ?></div></td>
</tr>
<?
$i++;
}
?>
</table>
<br>
<?
mysql_close();
?>
</body>
</html>