小程式實作僞靜态分頁

注 ： 資料的話随便     做僞靜态需要先配置window可接window如何實作僞靜态linux可接linux如何實作僞靜态

頁面名稱叫：boke.php（代碼下）

<?php
header("content-type:text/html;charset=utf-8");
$con = mysqli_connect('127.0.0.1','root','root','book');//連接配接資料庫
$con->set_charset('utf8');
if (mysqli_connect_errno($con))//判斷是否連接配接上資料庫
{
    echo "連接配接 MySQL 失敗: " . mysqli_connect_error();
}
//查詢總條數
$sql1 = "select count(*) as num from csdn";
$res1 = mysqli_query($con,$sql1);
$count = mysqli_fetch_assoc($res1);
$count_num = $count['num'];

//每頁顯示條數
$num = 5;
//總頁碼
$page_count = ceil($count_num/$num);
$p=empty($_GET['id'])?1:$_GET['id'];
if($p<1){
    $p=1;
}elseif($p>$page_count){
    $p=$page_count;
}
//偏移量
$page_num = ($p-1)*$num;
//查詢所有資料
$sql = "select * from csdn limit $page_num,$num";
$res = mysqli_query($con,$sql);
while($arr = mysqli_fetch_assoc($res)){
    $data[]=$arr;
}

?>
<h3>張erdan的部落格</h3>
<table 1">
    <tr>
        <td>blog_ID</td>
        <td>blog_title</td>
        <td>blog_author</td>
        <td>blog_content</td>
        <td>blog_url</td>
        <td>blog_hot</td>
        <td>blog_ctime</td>
    </tr>
    <?php foreach($data as $k => $v){?>
        <tr>
            <td><?php echo $v['id'];?></td>
            <td><?php echo $v['b_tilte'];?></td>
            <td><?php echo $v['b_author'];?></td>
            <td><?php echo htmlspecialchars_decode($v['b_content']); ?></td>
            <td><a href="<?php echo $v['b_url'];?>" target="_blank"><?php echo $v['b_url'];?></a></td>
            <td><?php echo $v['b_number'];?></td>
            <td><?php echo $v['b_time'];?></td>
        </tr>
    <?php }?>
</table>
</br>
<?php for($p=1;$p<=$page_count;$p++){ ?>
    <a href="boke_csdn_<?php echo $p;?>.html"><?php echo $p; ?></a>//跳轉時的路徑重點html形式
<?php    } ?>


      

.htaccess檔案的代碼

RewriteEngine on
RewriteRule ^boke_csdn_(.*).html$ boke.php?id=$1      

.htaccess檔案必須和boke.php檔案同級

htmlspecialchars_decode()函數是将儲存時用的htmlspecialchars()函數變後的資料轉回來