 |
|
ทำให้มันเเบ่งเป็นหน้าเเล้วจากโค๊ดลิงค์นี้ https://www.thaicreate.com/php/forum/070705.html
มี7 ข้อมูล แต่ข้อมูลมันออกมาซ้ำกันหมด ดูตรงไหนเเก้ไงคะ ขอคำแนะนำทีค่ะ
นี่เป็นหน้าที่ไม่ได้เเบ่ง(ไม่มีหน้าถัดไป)
นี่โค๊ดค่ะ
Code (PHP)
<?php
session_start();
include"Dbconnect.php";
?>
<!DOCTYPE html>
<html lang="en">
<head>
<!-- title and meta -->
<meta http-equiv=Content-Type content="text/html; charset=utf-8">
<link rel="stylesheet" href="css/base.css" />
<link rel="stylesheet" href="css/style.css" />
<title>ข้อมูลสินค้า2</title>
</head>
<body>
<?php
$ses_userid =$_SESSION[ses_userid];
$ses_username = $_SESSION[ses_username];
if($_SESSION[ses_status] != "2") {
echo "<center>หน้าสำหรับผู้ดูแลระบบเท่านั้น<br>กรุณาเข้าสู่ระบบก่อน!";
echo "<center><a href=index.php>Back</a><br>";
exit();
}
?>
<table width="960" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td align="center"><div align="center"><img src="img/banner.png" width="960" height="250"></div></td>
</tr>
<tr>
<td><div align="center">
<? include"menu_top.php";?>
</div></td>
</tr></table>
<div align="center" class="txtproduct" >
<p><?php
$sqll1="select count(pro_id) as product from product ";
$resultl=mysql_query($sqll1);
$row=mysql_fetch_array($resultl);
?>
สินค้าทั้งหมด <?=$row['product']?> รายการ
</p>
<?php
$sqll2="select count(status_id) as pawn from product where status_id='1'";
echo mysql_error ();
$resultl1=mysql_query($sqll2);
$row1=mysql_fetch_array($resultl1);
?>
สินค้าจำนำ <?=$row1['pawn']?> รายการ,
</table>
<?php
$sqll3="select count(status_id) as redeem from product where status_id='2'";
echo mysql_error ();
$resultl2=mysql_query($sqll3);
$row2=mysql_fetch_array($resultl2);
?>
สินค้าไถ่ถอน <?=$row2['redeem']?> รายการ,
<?php
$sqll4="select count(status_id) as item from product where status_id='3'";
echo mysql_error ();
$resultl3=mysql_query($sqll4);
$row3=mysql_fetch_array($resultl3);
?>
สินค้าหลุดจำนำ <?=$row3['item']?> รายการ,
<?php
$sqll5="select count(status_id) as sale from product where status_id='4'";
echo mysql_error ();
$resultl4=mysql_query($sqll5);
$row4=mysql_fetch_array($resultl4);
?>
ขายเเล้ว <?=$row4['sale']?> รายการ
</div></p>
<?php
$objConnect = mysql_connect("localhost","root","1234") or die("Error Connect to Database");
$objDB = mysql_select_db("db_5121");
$strSQL = "SELECT * FROM product ";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
$Num_Rows = mysql_num_rows($objQuery);
$Per_Page = 5; // เเสดงกี่รายการ
$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 pro_id DESC LIMIT $Page_Start , $Per_Page";
$objQuery = mysql_query($strSQL);
?>
<table width="960" align="center">
<tr>
<td width="50" align="center" bgcolor="#FFCC66">รหัสสินค้า</td>
<p> </p>
<td width="100" align="center" bgcolor="#FFCC66">วันที่จำนำ</td>
<td width="162" align="center" bgcolor="#FFCC66">รูปสินค้า</td>
<td width="130" align="center" bgcolor="#FFCC66">ชื่อลูกค้า</td>
<td width="120" align="center" bgcolor="#FFCC66">ประเภทสินค้า</td>
<td width="50" align="center" bgcolor="#FFCC66">ราคาจำนำ</td>
<td width="50" align="center" bgcolor="#FFCC66">สถานะ</td>
<td width="60" align="center" bgcolor="#FFCC66">เเก้ไข</td>
<td width="40" align="center" bgcolor="#FFCC66">ลบ</td>
</tr>
<?
//$pagelen =10;
//$page = $_REQUESฃฃT['page'];
//if (empty($page)) { $page=1; }
$sql2="select * from redeem inner join product on redeem.pro_id=product.pro_id order by redeem_id DESC";
$resulty = mysql_query( $sql2 );
$num_rowsy = mysql_num_rows($resulty);
$sql = "SELECT * FROM product inner join customer ON product.c_id=customer.c_id order by pro_id DESC";
$result = mysql_query( $sql );
$num_rows = mysql_num_rows($result);
$sql1 = "SELECT * FROM product inner join pro_type ON product.tp_id=pro_type.tp_id order by pro_id DESC";
$result1 = mysql_query( $sql1);
$num_rows1 = mysql_num_rows($result1);
$sqll = "SELECT * FROM product inner join status_pro ON product.status_id=status_pro.status_id order by pro_id DESC";
$resultt = mysql_query( $sqll);
$num_rowss = mysql_num_rows($resultt);
echo mysql_error ();
/*$sql2 = "SELECT * FROM product inner join redeem ON product.redeem_id=redeem.redeem_id order by redeem_id DESC";
$result2 = mysql_query( $sql2);
$num_rows2 = mysql_num_rows($result2); */
//$db_query=mysql_db_query($db,$sql);
//$totalpage = ceil($num_rows / $pagelen);
//$goto = ($page-1) * $pagelen;
//$sql = "SELECT * from customer order by c_id desc limit $goto,$pagelen";
//$result = mysql_query( $sql );
//$num_rows = mysql_num_rows($result);
For ($i=0; $i < $num_rows; $i++) {
//if($i%2==0) {$row_color="#FFE8EE";} else {$row_color="#ffffff";}
$fetcharr = mysql_fetch_array($result);
$fetcharr1 = mysql_fetch_array($result1);
$fetchar= mysql_fetch_array($resultt);
$fetchary= mysql_fetch_array($resulty);
$pro_id = $fetcharr['pro_id'];
$date = $fetcharr['date'];
$pro_img = $fetcharr['pro_img'];
$c_id = $fetcharr['c_id'];
$c_name = $fetcharr['c_name'];
$tp_name = $fetcharr1['tp_name'];
$pro_name = $fetcharr['pro_name'];
$pro_number = $fetcharr['pro_number'];
$status_name = $fetchar['status_name'];
$status_id = $fetchar['status_id'];
$redeem_price = $fetchary['redeem_price'];
$pro_price = $fetcharr['pro_price'];
$pro_priceformat= number_format($pro_price);
$pro_name = $fetcharr['pro_name'];
$date_redeem = $fetcharr['date_redeem'];
$date_pawitem = $fetcharr['date_pawitem'];
$pro_img = $fetcharr['pro_img'];
$path="img_product";
?>
<?php
while($objResult = mysql_fetch_array($objQuery))
{
?>
<tr onMouseOver="this.style.backgroundColor='#F4EFAF'" onMouseOut="this.style.backgroundColor=''">
<td align="center" ><? echo"$pro_id";?></td>
<td height="138" align="center"><? echo"$date";?></td>
<td align="center"><a href="show_cusperson.php?pro_id=<?=$pro_id?>"><span class="txtgray"> <img src="<?=$path?>/<?=$pro_img?>" width="155" height="130" style="border:2px solid #F93"/></span></a></td>
<td align="center"><? echo"$c_name";?></td>
<td align="center"><? echo"$tp_name";?><br> <? echo"$pro_name";?></td>
<td align="center"><? echo"$pro_priceformat";?></td>
<td align="center"><font color="#FF0000"><?=$status_name?></td>
<td align="center"><h3><a href="edit_product.php?pro_id=<? echo $pro_id?>"><img src="images/edit_profile.png" width="60" height="60"></a></h3></td>
<td align="center"><a href="delete_product.php?pro_id=<? echo $pro_id?>"><img src="images/file_delete.png" width="40" height="40"></a></td>
</tr>
<? }?>
<?php
}
?>
</table>
<br>
<div align="center">
ทั้งหมด <?php echo $Num_Rows;?> รายการ :
<?php // echo $Num_Pages;?> หน้าที่ :
<?php
if($Prev_Page)
{
echo " <a href='$_SERVER[SCRIPT_NAME]?Page=$Prev_Page'><< Back</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'>Next>></a> ";
}
mysql_close($objConnect);
?>
<p> </p>
Tag : PHP, MySQL, HTML/CSS, Web (ASP.NET), WebService, Web Service
|
ประวัติการแก้ไข
2016-07-21 16:12:30
2016-07-21 16:13:14
2016-07-21 16:13:51
2016-07-21 16:14:48
2016-07-21 18:28:54
|
 |
 |
 |
 |
| Date :
2016-07-21 16:11:18 |
By :
ployploy |
View :
894 |
Reply :
3 |
|
 |
 |
 |
 |
|
|
|
|
 |
Load balance : Server 04
