php - Publish and unpublish issue

Question

I have this part of code in backend:

if (isset($_GET['publish']) || isset($_GET['unpublish'])) {
$message = "";
if (isset($_GET['publish'])) {
    $message = "Post published successfully";
    $post_id = $_GET['publish'];
} else if (isset($_GET['unpublish'])) {
    $message = "Post successfully unpublished";
    $post_id = $_GET['unpublish'];
}
togglePublishPost($post_id, $message);

}


function togglePublishPost($post_id, $message)
{
global $conn;
$sql = "UPDATE posts SET published=!published WHERE id=$post_id";

if (mysqli_query($conn, $sql)) {
    $_SESSION['message'] = $message;
    header("location: posts.php");
    exit(0);
    }
}

When I try to publish post from "https://....posts.php?publish=36" the page is refreshing and nothing happens. Also there is no logs in error file..Please help me with this..

P.S: the same if I try to unpublish the post. PHP v7.0

Answer 1

Replace: (!published) with (not published) like this:

$sql = "UPDATE posts SET published = not published WHERE id=$post_id";