phpÁ¬½Ómysql·ÖÒ³

ʱ¼ä£º2013.09.01 ·¢²¼ÈË£ºfasf8523t

phpÁ¬½Ómysql·ÖÒ³

Òѽâ¾öÎÊÌâ

¹È¸èfasf8523tÓû§ÔÚ2013.09.01Ìá½»Á˹ØÓÚ¡°ËûÄÇôÁÃphpÁ¬½Ómysql·ÖÒ³¡±µÄÌáÎÊ£¬»¶Ó­´ó¼ÒÓ¿Ô¾·¢±í×Ô¼ºµÄ¹Ûµã¡£Ä¿Ç°¹²ÓÐ1¸ö»Ø´ð£¬×îºó¸üÐÂÓÚ2024-08-26T09:24:14¡£ÏÔʾÓï¾ä

<html>
<head>
<title>²éѯ**¿â±íÐÅÏ¢</title>
<metahttp-equiv="Content-Type"content="text/html;charset=utf-8"><styletype="text/css">
<!--
body{
background-color:#999999;
}
-->
</style></head>
<body>

<tableborder="1"cellspacing="0"cellpadding="0">
<caption>²éѯÐÅÏ¢±í</caption>
<thbordercolor="#FFFFFF">id</th>
<th>ÐÕÃû</th>
<th>ÄêÁä</th>
<th>ÐÔ±ð</th>

<?php

$link=mysql_connect("localhost","root","123456")ordie("**¿âÁ´½Óʧ°Ü~!");
$n_id=$_GET['id'];
mysql_select_db("xiecong",$link);
$sql="**LECTid,name,age,**FROM`1`";
$result=mysql_query($sql);
$RecordCount=mysql_**m_rows($result);
$PageSize=2;
$PageCount=ceil($RecordCount/$PageSize);
if(!isset($_GET["Page"]))
{
$PageIndex=1;
}
else
{
$PageIndex=$_GET["Page"];
}
?>
<?php
$i=0;
mysql_data_seek($result,($PageIndex-1)*$PageSize);
while($row=mysql_fetch_array($result))
{
$i++;
?>
<?php{
echo"<tr><td>$row[0]</td><td>$row[1]</td><td>$row[2]</td><td>$row[3]</td></tr>";
}
?>
<?php
if($i==$PageSize)
{
bre**;
}
}
?>
<tdheight="32"colspan="4"align="right"valign="middle">**ÓÐ
<?=$RecordCount?>
Ìõ**Ò³´Î
<?=$PageIndex?>
/
<?=$PageCount?>
<ahref="?Page=1&$id=<?=$n_id?>">Ê×Ò³</a><ahref="?Page=<?=$PageIndex+1?>&$id=<?=$n_id?>">ÏÂÒ»Ò³</a><ahref="?Page=<?=$PageIndex-1?>&$id=<?=$n_id?>">ÉÏÒ»Ò³</a><ahref="?Page=<?=$PageCount?>&$id=<?=$n_id?>">×îºóÒ»Ò³</a></td>
</table>

</body>
</html>




Notice:Undefinedindex:idinC:\Inetpub\wwwroot\lx\untitled\chaxun.phponline25



ÕâÒ»¾ä°¡$n_id=$_GET['id'];Ï£Íû´ó¼ÒÄܹ»°ïÖúËý¡£

ÏêϸÎÊÌâÃèÊö¼°ÒÉÎÊ£ºÏÔʾÓï¾ä

<html>
<head>
<title>²éѯ**¿â±íÐÅÏ¢</title>
<metahttp-equiv="Content-Type"content="text/html;charset=utf-8"><styletype="text/css">
<!--
body{
background-color:#999999;
}
-->
</style></head>
<body>

<tableborder="1"cellspacing="0"cellpadding="0">
<caption>²éѯÐÅÏ¢±í</caption>
<thbordercolor="#FFFFFF">id</th>
<th>ÐÕÃû</th>
<th>ÄêÁä</th>
<th>ÐÔ±ð</th>

<?php

$link=mysql_connect("localhost","root","123456")ordie("**¿âÁ´½Óʧ°Ü~!");
$n_id=$_GET['id'];
mysql_select_db("xiecong",$link);
$sql="**LECTid,name,age,**FROM`1`";
$result=mysql_query($sql);
$RecordCount=mysql_**m_rows($result);
$PageSize=2;
$PageCount=ceil($RecordCount/$PageSize);
if(!isset($_GET["Page"]))
{
$PageIndex=1;
}
else
{
$PageIndex=$_GET["Page"];
}
?>
<?php
$i=0;
mysql_data_seek($result,($PageIndex-1)*$PageSize);
while($row=mysql_fetch_array($result))
{
$i++;
?>
<?php{
echo"<tr><td>$row[0]</td><td>$row[1]</td><td>$row[2]</td><td>$row[3]</td></tr>";
}
?>
<?php
if($i==$PageSize)
{
bre**;
}
}
?>
<tdheight="32"colspan="4"align="right"valign="middle">**ÓÐ
<?=$RecordCount?>
Ìõ**Ò³´Î
<?=$PageIndex?>
/
<?=$PageCount?>
<ahref="?Page=1&$id=<?=$n_id?>">Ê×Ò³</a><ahref="?Page=<?=$PageIndex+1?>&$id=<?=$n_id?>">ÏÂÒ»Ò³</a><ahref="?Page=<?=$PageIndex-1?>&$id=<?=$n_id?>">ÉÏÒ»Ò³</a><ahref="?Page=<?=$PageCount?>&$id=<?=$n_id?>">×îºóÒ»Ò³</a></td>
</table>

</body>
</html>




Notice:Undefinedindex:idinC:\Inetpub\wwwroot\lx\untitled\chaxun.phponline25



ÕâÒ»¾ä°¡$n_id=$_GET['id'];ÆÚ´ýÄúµÄ´ð°¸£¬ÄãÊÇÎҵı¦±´,ÄãÊÇÎҵύ,ллÄã¶ÔÎҵİïÖú£¡

Ï£ÍûÒÔϵĻشð£¬Äܹ»°ïÖúÄã¡£

µÚ1¸ö»Ø´ð

Óû§Ãû£ºmolulan  

mysql_data_seek()º¯Êý£ºrow_**mÎÊ´ðberµÄȡֵ·¶Î§Ó¦¸Ã´Ó0µ½mysql_**m_rows-1
ÄãµÄÈ¡Ö**¬³öÁËÕâ¸ö·¶Î§ËùÒÔ³ö´í¡£
ÔÚÕâ¸öÏÂÃæ$PageIndex=1Óͼ¶ÊÔÅ£;
}
else
{
Ôö¼ÓÒÔ¼°¼òµ¥µÄÅжϣº

if($_GET['Page']<1){
$_GE×¼ÐûÏØ²é²èT['Page']=1;
}
if($_GET['Page']>$PageCount){
$_GET['Page']=$PageCount;
}
ÆäËû²»±ä£¬¾ÍÄܽâ¾ö¡£
ÖÁÓÚidµÄÎÊÌâ¡£ÂÊÄÚÅú¿ÉÒÔÏÖÉè¸ö@$n_id=isset($_GET['id'])?$_GET['id']:1;ÕâÑù¾ÍÄܽâ¾öÁË¡£