|
|
|
ใช้ ajax ในการดึงหน้านี้ แต่อยากให้ next page ด้วย ไม่ทราบว่าทำงัยคับ |
|
|
|
|
|
|
|
Code (PHP)
<?
include('convert_thai.php');
$_GET['keyWord'];
?>
<style type="text/css">
<!--
.class7 {
font-family: "Angsana New";
font-size: 20px;
font-weight: bold;
color: #000;
}
.class8 {
font-family: "Angsana New";
font-size: 22px;
font-weight: bold;
color: #FFF;
}
-->
</style>
<table width="937" border="1" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="115" align="center" bgcolor="#330066" class="class8">หมายเลขปัญหา</td>
<td width="110" align="center" bgcolor="#330066" class="class8">วันที่แจ้งปัญหา</td>
<td width="80" align="center" bgcolor="#330066" class="class8">เวลาที่แจ้ง</td>
<td width="338" align="center" bgcolor="#330066" class="class8">หัวข้อปัญหา</td>
<td width="170" align="center" bgcolor="#330066" class="class8">สถานะของปัญหา</td>
<td width="110" align="center" bgcolor="#330066" class="class8">ผู้แก้ไขปัญหา</td>
</tr>
<?
$objConnect = mssql_connect('172.30.200.131\sdd_db', 'sa', 'sapsad') or die("Error Connect to Database");
mssql_select_db('e_helpdesk',$objConnect);
$strSQL = "SELECT Tickets.Ticket_ID, Tickets.PB_Subject,Tickets.MainModules, time.submit_time1,time.time1,Tickets.Emp_ID,Tickets.followname,Status.Status_Des ";
$strSQL .= "from Tickets INNER JOIN Status ON Tickets.Status_Code = Status.Status_Code ";
$strSQL .= " INNER JOIN time ON time.Ticket_ID = Tickets.Ticket_ID ";
$strSQL .= "WHERE (Tickets.Status_Code = '".$_GET['keyWord']."') AND(Tickets.MainModules !='') order by Tickets.Ticket_ID DESC";
$objQuery = mssql_query($strSQL) or die ("Error Query [".$strSQL."]");
while($objResult = mssql_fetch_array($objQuery))
{
?>
<tr>
<td align="center" bgcolor="#FFFFFF"><a href="spies2.php?Ticket_ID=<?=$objResult["Ticket_ID"];?>">
<?=$objResult["Ticket_ID"];?>
</a></td>
<td align="center" bgcolor="#FFFFFF"><?=tis620_utf8($objResult["submit_time1"]);?></td>
<td align="center" bgcolor="#FFFFFF"><?=tis620_utf8($objResult["time1"]);
?></td>
<td bgcolor="#FFFFFF"><?=tis620_utf8($objResult["PB_Subject"]);?></td>
<td align="center" bgcolor="#FFFFFF"><?=tis620_utf8($objResult["Status_Des"]);?></td>
<td align="center" bgcolor="#FFFFFF"><?=$objResult["followname"];?></td>
</tr>
<? } ?>
</table>
อยากให้แสดงข้อมูลในถัดไปด้วยคับ
Tag : PHP, Ms SQL Server 2008, Ajax
|
|
|
|
|
|
Date :
2011-07-25 10:56:07 |
By :
thiti |
View :
1134 |
Reply :
1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Load balance : Server 02
|