文章详情页 - 点赞功能 - 常规

文章详情
// 获取连接参数
$wenzhang_id = $_GET['wenzhang_id'];

// 更新对应小程序的views值
$sql = "UPDATE wenzhang SET wenzhang_view = wenzhang_view + 1 WHERE wenzhang_id = '$wenzhang_id'" ;
$con->query($sql);

$sql = "SELECT * FROM wenzhang WHERE wenzhang_id = '$wenzhang_id'" ;
$result = mysqli_query($con, $sql);
$arr = array();
while ($row = mysqli_fetch_array($result)) {
    $arr[] = $row;
    $user_id = $row['user_login_id'];
    $sql2 = "SELECT * FROM user WHERE user_login_id = '$user_id'" ;
    $result2 = mysqli_query($con, $sql2);
    $user_info = mysqli_fetch_assoc($result2);
}
?>

<?php
foreach ($arr as $key => $value) {
    ?>
    <div style="display: inline-block;">
        <?php echo $value['wenzhang_neirong']; ?><?php echo $user_info['user_name']; ?>
        <form action="" method="post">
            <input type="hidden" name="wenzhang_id" value="<?php echo $value['wenzhang_id']; ?>">
            <button type="submit" name="dianzan">点赞</button>
        </form>
        <p>点赞数：<?php echo $value['wenzhang_dianzan']; ?></p>
    </div>
    <?php
}
?>

<?php
if (isset($_POST['dianzan'])) {
    // 获取表单提交的数据
    $wenzhang_id = $_POST['wenzhang_id'];

    // 更新对应文章的点赞数
    $sql = "UPDATE wenzhang SET wenzhang_dianzan = wenzhang_dianzan + 1 WHERE wenzhang_id = '$wenzhang_id'" ;
    $con->query($sql);
}
?>