|
 |
| |
เลขลำดับหน้าเพจที่สองไม่นับต่อจากหน้า 1 พอเปิดหน้าสอง มันเริ่มนับใหม่ รบกวนผู้รู้ช่วยที่ครับ |
| |
 |
|
|
 |
 |
|
คือตอนนี้ผมทำการแบ่งการแสดงข้อมูลให้เป็นหน้า แต่พอเปิดไปหน้าสองมันไมม่ยอมนับต่อจากหน้าหนึ่ง ผู้รู้รบกวนช่วยแนะนำหน่อยครับ
หน้าที่ 2
นี่คือโค๊ดของผมครับ รบกวนผู้รู้แนะนำหน่อยครับว่าผมต้องแก้ไขในส่วนไหนครับ
Code (PHP)
<?php
session_start();
if(!isset($_SESSION['txtUsername'])){
?>
<h2><font color="red"><center><br><br>Please Login</font></h2>
<center><input type="button" value="Go to login" onClick="window.location='login.php'" />
<?php
}else{
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>ระบบแจ้งซ่อมออนไลน์ - Helpdesk System</title>
<!--
function MM_preloadImages() { //v3.0
var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
//-->
</script>
<style type="text/css">
<!--
.style1 {
font-size: 14px;
color: #333333;
font-family: Arial, Helvetica, sans-serif;
}
.style13 {font-size: 12px; color: #666666; }
.style16 {font-size: 14px; color: #000000; }
.style15 {font-size: 12px;
font-weight: bold;
}
a:link {
text-decoration: none;
}
a:visited {
text-decoration: none;
}
a:hover {
text-decoration: none;
}
a:active {
text-decoration: none;
}
body {
background-image: url(pic/bg_header.gif);
background-color: #F7F6F5;
background-repeat: repeat-x;
}
-->
</style>
</head>
<? function DateThai($strDate)
{
$strYear = date("y",strtotime($strDate))+43;
$strMonth= date("n",strtotime($strDate));
$strDay= date("j",strtotime($strDate));
$strMonthCut = Array("","ม.ค.","ก.พ.","มี.ค.","เม.ย.","พ.ค.","มิ.ย.","ก.ค.","ส.ค.","ก.ย.","ต.ค.","พ.ย.","ธ.ค.");
$strMonthThai=$strMonthCut[$strMonth];
return "$strDay $strMonthThai $strYear";
}
?>
<body>
<div id="container">
<table width="1072" height="293" border="0" align="center" cellpadding="2" cellspacing="2">
<tr>
<td height="225" colspan="2" align="center" class="style15"><div align="right">
<p><a href="memberpage.php"></a></p>
<p><a href="memberpage.php"><img src="pic/login_large.png" width="545" height="194" border="0" /></a></p>
<p><img src="pic/clock.png" width="18" height="18" />กำลังดำเนินการ <img src="pic/comment.png" width="18" height="18" />ดำเนินการเสร็จสิ้น </p>
</div></td>
</tr>
<?
$objConnect = mysql_connect("localhost","root","1234") or die("Error Connect to Database");
$objDB = mysql_select_db("datahelps");
$strSQL = "select * from quesdata_admin";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
$Num_Rows = mysql_num_rows($objQuery);
$Per_Page = 10; // Per Page
$Page = $_GET["Page"];
if(!$_GET["Page"])
{
$Page=1;
}
$Prev_Page = $Page-1;
$Next_Page = $Page+1;
$Page_Start = (($Per_Page*$Page)-$Per_Page);
if($Num_Rows<=$Per_Page)
{
$Num_Pages =1;
}
else if(($Num_Rows % $Per_Page)==0)
{
$Num_Pages =($Num_Rows/$Per_Page) ;
}
else
{
$Num_Pages =($Num_Rows/$Per_Page)+1;
$Num_Pages = (int)$Num_Pages;
}
$strSQL .=" order by Id_Ques DESC LIMIT $Page_Start , $Per_Page";
$objQuery = mysql_query($strSQL);
?>
<tr> <?php echo $rob++; ?>
<td width="84" align="center" bgcolor="#FFCC00" class="style15">เลขที่แจ้งซ่อม</td>
<td width="466" align="center" bgcolor="#FFCC00" class="style15">ปัญหาการแจ้งซ่อม</td>
<td width="149" align="center" bgcolor="#FFCC00" class="style15">วันที่แจ้ง</td>
<td width="123" align="center" bgcolor="#FFCC00" class="style15">ชือผู้แจ้ง</td>
<td width="134" align="center" bgcolor="#FFCC00" class="style15">หน่วยงาน</td>
<td width="78" align="center" bgcolor="#FFCC00" class="style15">รายละเอียด</td>
</tr>
<?
$db_name="datahelps";// Database name
$connection=mysql_connect("localhost","root","1234") or die("I Couldn't connect");
$db=mysql_select_db($db_name,$connection) or die("I Couldn't select your database");
$sql="select * from quesdata_admin where Username='$Username' ORDER BY Id_Ques DESC";
$result=mysql_query($sql,$connection) or die(mysql_error());
$i=0;
while($row=mysql_fetch_array($objQuery)) {
$Username=$row['Username'];
$i++;
if($i%2==0)
{
$bg = "#CCCCCC";
}else
{
$bg="#FFFFFF";
}
?>
<tr bgcolor="<?=$bg;?>">
<td height="23" align="center" class="style13" ><?php echo $rob++; ?> </td>
<td class="style13"><? echo $row['6']; ?></td>
<td class="style13"><? echo DateThai ($row['8']); ?></td>
<td class="style13"> <? echo $row['2']; ?></td>
<td class="style13"> <? echo $row['3']; ?></td>
<td align="center"><a href="<? echo "show_answer_detail.php?Id_Ques=".$row['0']; ?>" class="style16">
<? if($row['9']==""){?>
<img src="pic/clock.png" width="16" height="16" border="0" />
<? }else{ ?>
<img src="pic/comment.png" width="16" height="16" border="0" />
<? }?>
</a></td>
<? } ?>
</tr>
</table>
<tr>
<div align="center"><br>
ทั้งหมด
<?= $Num_Rows;?>รายการ
:
<?=$Num_Pages;?>
หน้า :
<?
if($Prev_Page)
{
echo " <a href='$_SERVER[SCRIPT_NAME]?Page=$Prev_Page'><< กลับ</a> ";
}
for($i=1; $i<=$Num_Pages; $i++){
if($i != $Page)
{
echo "[ <a href='$_SERVER[SCRIPT_NAME]?Page=$i'>$i</a> ]";
}
else
{
echo "<b> $i </b>";
}
}
if($Page!=$Num_Pages)
{
echo " <a href ='$_SERVER[SCRIPT_NAME]?Page=$Next_Page'>ต่อไป>></a> ";
}
mysql_close($objConnect);
?>
<?
$i = 1;
while($objResult = mysql_fetch_array($objQuery))
{
?>
<tr>
<td><div align="center"><?=$i;?></div></td>
.
.
.
.
<?
$i++;
}
?>
</div>
</div>
<p> </p>
<p> </p>
</body>
<? } ?>
</html>
Tag : PHP, MySQL
|
|
|
 |
 |
 |
 |
| Date :
2012-10-02 11:29:56 |
By :
blackberryone |
View :
1058 |
Reply :
5 |
|
 |
 |
 |
 |
|
|
|
|
 |
 |
|
 |
 |
| |
|
|
|
| |
|
Code (PHP)
$i = 1;
if($Page > 1)
{
$i = ($Per_Page * ($Page-1)) + 1;
}
|
| |
|
|
| |
| Date :
2012-10-02 12:09:42 |
By :
pokultra |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
ผมต้องจัดหรือใช้งานยังไงครับ
|
| |
|
|
| |
| Date :
2012-10-02 12:46:03 |
By :
blackberryone |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
Code (PHP)
?>
<body>
<div id="container">
<table width="1072" height="293" border="0" align="center" cellpadding="2" cellspacing="2">
<tr>
<td height="225" colspan="2" align="center" class="style15"><div align="right">
<p><a href="memberpage.php"></a></p>
<p><a href="memberpage.php"><img src="pic/login_large.png" width="545" height="194" border="0" /></a></p>
<p><img src="pic/clock.png" width="18" height="18" />กำลังดำเนินการ <img src="pic/comment.png" width="18" height="18" />ดำเนินการเสร็จสิ้น </p>
</div></td>
</tr>
<?
$objConnect = mysql_connect("localhost","root","1234") or die("Error Connect to Database");
$objDB = mysql_select_db("datahelps");
$strSQL = "select * from quesdata_admin";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
$Num_Rows = mysql_num_rows($objQuery);
$Per_Page = 10; // Per Page
$Page = $_GET["Page"];
if(!$_GET["Page"])
{
$Page=1;
}
$Prev_Page = $Page-1;
$Next_Page = $Page+1;
$Page_Start = (($Per_Page*$Page)-$Per_Page);
if($Num_Rows<=$Per_Page)
{
$Num_Pages =1;
}
else if(($Num_Rows % $Per_Page)==0)
{
$Num_Pages =($Num_Rows/$Per_Page) ;
}
else
{
$Num_Pages =($Num_Rows/$Per_Page)+1;
$Num_Pages = (int)$Num_Pages;
}
$strSQL .=" order by Id_Ques DESC LIMIT $Page_Start , $Per_Page";
$objQuery = mysql_query($strSQL);
?>
<tr>
<td width="84" align="center" bgcolor="#FFCC00" class="style15">เลขที่แจ้งซ่อม</td>
<td width="466" align="center" bgcolor="#FFCC00" class="style15">ปัญหาการแจ้งซ่อม</td>
<td width="149" align="center" bgcolor="#FFCC00" class="style15">วันที่แจ้ง</td>
<td width="123" align="center" bgcolor="#FFCC00" class="style15">ชือผู้แจ้ง</td>
<td width="134" align="center" bgcolor="#FFCC00" class="style15">หน่วยงาน</td>
<td width="78" align="center" bgcolor="#FFCC00" class="style15">รายละเอียด</td>
</tr>
<?
$db_name="datahelps";// Database name
$connection=mysql_connect("localhost","root","1234") or die("I Couldn't connect");
$db=mysql_select_db($db_name,$connection) or die("I Couldn't select your database");
$sql="select * from quesdata_admin where Username='$Username' ORDER BY Id_Ques DESC";
$result=mysql_query($sql,$connection) or die(mysql_error());
$i=0;
$O = $page_Start+1;////////////////////เพิ่ม/////////////////////////////////
while($row=mysql_fetch_array($objQuery)) {
$Username=$row['Username'];
$i++;
if($i%2==0)
{
$bg = "#CCCCCC";
}else
{
$bg="#FFFFFF";
}
?>
<tr bgcolor="<?=$bg;?>">
<td height="23" align="center" class="style13" ><?=$O; ?> </td>/////////////////////////เพิ่ม///////////////////////////
<td class="style13"><? echo $row['6']; ?></td>
<td class="style13"><? echo DateThai ($row['8']); ?></td>
<td class="style13"> <? echo $row['2']; ?></td>
<td class="style13"> <? echo $row['3']; ?></td>
<td align="center"><a href="<? echo "show_answer_detail.php?Id_Ques=".$row['0']; ?>" class="style16">
<? if($row['9']==""){?>
<img src="pic/clock.png" width="16" height="16" border="0" />
<? }else{ ?>
<img src="pic/comment.png" width="16" height="16" border="0" />
<? }?>
</a></td>
<? } ?>
</tr>
<?
$O++; ///////////////////////////////////////เพิ่ม////////////////////////////////
?>
</table>
<tr>
<div align="center"><br>
ทั้งหมด
<?= $Num_Rows;?>รายการ
:
<?=$Num_Pages;?>
หน้า :
<?
if($Prev_Page)
{
echo " <a href='$_SERVER[SCRIPT_NAME]?Page=$Prev_Page'><< กลับ</a> ";
}
for($i=1; $i<=$Num_Pages; $i++){
if($i != $Page)
{
echo "[ <a href='$_SERVER[SCRIPT_NAME]?Page=$i'>$i</a> ]";
}
else
{
echo "<b> $i </b>";
}
}
if($Page!=$Num_Pages)
{
echo " <a href ='$_SERVER[SCRIPT_NAME]?Page=$Next_Page'>ต่อไป>></a> ";
}
mysql_close($objConnect);
?>
<?
$i = 1;
while($objResult = mysql_fetch_array($objQuery))
{
?>
<tr>
<td><div align="center"><?=$i;?></div></td>
.
.
.
.
<?
$i++;
}
?>
</div>
</div>
<p> </p>
<p> </p>
</body>
<? } ?>
|
| |
|
|
| |
| Date :
2012-10-02 13:01:24 |
By :
popypreaw |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
หลังจากที่เพิ่งตามที่คุณ popypreaw ได้แน่นำมาแล้ว ผลการทดลองที่ได้เป็นแบบนี้ครับ ต้องแก้ไขในส่วนไหนอีกครับ
|
| |
|
|
| |
| Date :
2012-10-02 13:30:56 |
By :
blackberryone |
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
| |
|
 Load balance : Server 02
|
