页面静态化案例---一键生成详情页面静态化(全站静态化+局部动态)

<?php
header("content-type:text/html;charset=utf-8");
//连接数据库
$link = mysqli_connect("127.0.0.1",'root','root','08e');
//设置字符集
mysqli_query($link,'set names utf-8');

//接收传值
$ids = $_GET['ids'];
$id_arr = explode(',',$ids);
for ($i=0;$i<count($id_arr);$i++){
    $sql = 'select * from USER WHERE id='.$id_arr[$i];
    $res = mysqli_query($link,$sql);
    $data = mysqli_fetch_assoc($res);
    if($data['status']==1){
        $a = '启用';
    }else{
        $a = '禁用';
    }
    $content = '<meta charset="utf8">
当前阅读量:<span id="re">'.$data['z'].'</span>
<table>
    <tr>
        <td>ID</td>
        <td id="d_v">'.$data['id'].'</td>
    </tr>
    
    <tr>
        <td>账号</td>
        <td>'.$data['username'].'</td>
    </tr>
    
    <tr>
        <td>密码</td>
        <td>'.$data['password'].'</td>
    </tr>
    
    <tr>
        <td>状态</td>
        <td>'.$a.'</td>
    </tr>
</table>
<script src="jquery-3.3.1.min.js"></script>
<script>
    $(document).ready(function() {
      var id = $("#d_v").text();
      $.get("z_up.php?id="+id,function(data) {
        if(data=="error"){
            alert("error");
        }else{
            $("#re").text(data);
        }
      })
    });
</script>
';

    file_put_contents('list-'.$id_arr[$i].'.html',$content);
}

z_up.php

<?php
header("content-type:text/html;charset=utf-8");
//连接数据库
$link = mysqli_connect("127.0.0.1",'root','root','08e');
//设置字符集
mysqli_query($link,'set names utf-8');
//接收传值
$id = $_GET['id'];
//拼接sql
$sql = 'select * from USER WHERE id='.$id;
//执行sql
$res = mysqli_query($link,$sql);
//转化数组
$data = mysqli_fetch_assoc($res);
//阅读量+1
$last_z = $data['z']+1;
//执行修改
$sql2 = "update user set z=$last_z WHERE id=$id";
$res2 = mysqli_query($link,$sql2);
if($res2){
    echo $last_z;
}else{
    echo 'error';
}
通往牛逼的路上,在意的只有远方!
原文地址:https://www.cnblogs.com/jiangshiguo/p/9767330.html