程式師世界 >> 編程語言 >> 更多編程語言 >> 編程綜合問答 >> php編程-php網頁制作數據庫的翻頁顯示

php編程-php網頁制作數據庫的翻頁顯示

編輯：編程綜合問答

php網頁制作數據庫的翻頁顯示

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

無標題文檔

<?php include("top.php")?>

<?php include("left.php")?>

檢索結果

<?php
$conn = mysql_connect("localhost:3306","root","123456") or die("數據連接失敗".mysql_error());
mysql_select_db("db",$conn) or die("數據庫選擇失敗".mysql_error());
mysql_query("set names utf8");
if(!empty($_REQUEST['test1']))
{
$content = $_REQUEST["test1"];
$type = $_REQUEST["select"];
$sql = mysql_query("select * from tb_info where checkstate=1 and type='$type' and(content like'%$content%' or title like'%$content%' or linkman like'%$content%' or tel like'%$content%')");
$rbll = mysql_num_rows($sql);
if(!empty($_GET["find"]))
$sessin = $_GET["find"];//當前頁
if(!isset($sessin)){
$sessin = 1;
}
//echo $sessin;
$c = 6;//每次要顯示在頁面上的記錄條數
$s = ceil($rbll/$c-1);//一共分幾頁
$p = ($sessin-1)*$c;//從第幾條記錄開始顯示
$sql = mysql_query("select * from tb_info where checkstate=1 and type='$type' and(content like'%$content%' or title like'%$content%' or linkman like'%$content%' or tel like'%$content%')limit $p,$c");

$rowb= mysql_fetch_array($sql);
if($rbll>0)
{

                                do{?>
                                    <table height="100" border="0">
                                        <tr>
                                            <td height="26">
                                                【<?php echo str_replace($content,"<font color='#FF0000'>".$content."</font>",$rowb["type"]);?>】
                                                <?php echo str_replace($content,"<font color='#FF0000'>".$content."</font>",$rowb["title"]);?>&nbsp;&nbsp;
                                                <?php echo str_replace($content,"<font color='#FF0000'>".$content."</font>",$rowb["edate"]);?>
                                            </td>
                                        </tr>
                                        <tr>
                                            <td height="26">
                                                <?php echo str_replace($content,"<font color='#FF0000'>".$content."</font>",$rowb["content"]);?>&nbsp;
                                            </td>
                                        </tr>
                                        <tr>
                                            <td height="26">聯系人:
                                                <?php echo str_replace($content,"<font color='#FF0000'>".$content."</font>",$rowb["linkman"]);?>&nbsp;&nbsp;
                                                聯系電話:<?php echo str_replace($content,"<font color='#FF0000'>".$content."</font>",$rowb["tel"]);?>
                                            </td>
                                        </tr>
                                    </table>
                                    <div style="width:561px; border-bottom:1px dashed #CCCCCC;"></div> 
                            <?php }while($rowb = mysql_fetch_array($sql));
                            }
                    ?>
                </div>
                <div style="width:560px; height:20px; border:1px #000000 solid; margin-left:217px; font-size:13px;">
                         <?php echo "當前為第".$sessin."頁";
                            echo "共".$s."頁";
                            echo "  ";
                            echo "共".$c."條記錄";
                         ?> 
                        <?php
                            $prev_page = $sessin - 1;//定義上一頁為該頁減一
                            $next_page = $sessin + 1;//定義下一頁為該頁加一
                          if($sessin<=1)
                            {
                            echo "<a href='find.php?find=1'>首頁</a>";
                            }
                           else
                            {

                                echo"<a href='find.php?find=1'>首頁</a>";
                            }
                            if($prev_page<=1)
                            {
                                echo "上一頁";   
                            }
                            else
                            {
                                echo"<a href='find.php?find=$prev_page'>上一頁</a>";
                            }
                            if($prev_page>$s)
                            {
                                echo "下一頁";
                            }
                            else
                            {
                                echo"<a href='find.php?find=$next_page'>下一頁</a>";

                             }
                            if($sessin>=$s)
                            {
                                echo "尾頁";
                            }
                            else
                            {
                                echo"<a href='find.php?find=$s'>尾頁</a>";
                            }
                        }
                    ?>
                </div>      
         </div>
        <div style="clear:both">
            <?php include("bottom.php")?>
        </div>
    </div>

求大神幫忙看一下我那寫錯了翻頁後數據不顯示幫忙改正謝謝。。。。。。