如何更新会话空值-解网

问：

我正在PHP MYSQLI中创建消息对话删除脚本。我正在尝试更新会话空值。我的问题我可以更新列。但是我无法更新传入的消息列。我想更新或列空会话值。from_deleteto_deletefrom_deleteto_delete

这是我的 pm 表

id  from_id     to_id    msg               sent_date              from_delete      to_delete
1   2           3        hi how are you?   2019-12-05 04:14:20    0                3
2   3           2        fine              2019-12-05 05:15:58    0                2
3   2           3        hi                2019-12-05 03:20:34    0                3     
4   5           2        hi                2019-12-05 08:30:40    0                2

这是我的源代码

<?php

require_once "config.php";
if (isset($_GET['deleteid'])) {
    $id = $_GET['id'];
    $session_id = $_SESSION['userid'];
}
$stmt = $con->prepare("UPDATE pm SET from_delete = ? or to_delete =? WHERE id=? ");
$stmt->bind_param("sss", $session_id, $session_id, $id);
if ($stmt->execute()) {
    echo"deleted successfully";
} else {
    echo "Failed to delete<br/>";
}

PHP 会话 mysqli

<?php

require_once "config.php";
if (isset($_GET['deleteid'])) {
    $id = $_GET['id'];
    $session_id = $_SESSION['userid'];
}
// Mark from_delete only if user is the sender
$stmt = $con->prepare("UPDATE pm SET from_delete = ? WHERE id = ? AND from_id = ?");
$stmt->bind_param("sss", $session_id, $id, $session_id);
if ($stmt->execute()) {
    echo"deleted successfully";
} else {
    echo "Failed to delete<br/>";
}
// Mark to_delete only if user is receiver
$stmt = $con->prepare("UPDATE pm SET to_delete = ? WHERE id = ? AND to_id = ?");
$stmt->bind_param("sss", $session_id, $id, $session_id);
if ($stmt->execute()) {
    echo"deleted successfully";
} else {
    echo "Failed to delete<br/>";
}

如何更新会话空值

How to update session empty value

评论

评论