为什么更新查询仅在phpmyadmin中有效？ [英] Why does update query only work in phpmyadmin?

问题描述

<div id="main">

            <?php

if (isset($_GET['id']))

{

    $i = $_GET['id'];

}

else {

    $i = "";

}

            $sql = "UPDATE tblconcerns SET read_status=1 WHERE message_id = $i";





            $sql = "SELECT * FROM tblconcerns WHERE message_id = $i";

            $result = mysqli_query($conn, $sql);

            ?>
            <div style="text-align: left; margin-bottom: 20px">

                <strong>Subject: </strong>

            <?php

            if ($result)

            {

                echo $sql;

                while ($row = mysqli_fetch_array($result))

                {





                    echo $row['title']."<br/>"
                            . "<strong>Sender's email:</strong> ".$row['sender_email']."<br/>"
                            . "<strong>Date/Time:</strong> ".$row['date']."/".$row['time']
                            ."READ: {$row['read_status']}"
                            . "<hr>";
                    ?>
            </div>
            <div style="text-align: center">
            <?php

            echo $row['concern'];



                }

                ?>
            </div>
                <?php

            }



            else {

                echo mysqli_error();

            }





            ?>
        </div>

我在phpmyadmin尝试了我的更新查询，它运行得很好但是，当我试图查看它是否在实际站点中工作时，它不会更新。我正在使用已启用所有权限的用户root。

I tried my update query in phpmyadmin and it works just fine, however when I'm trying to see if it works in the actual site, it doesn't update. I'm using the user 'root' which has all the privileges enabled.

推荐答案

_GET ['id']））

{

_GET['id'])) {

i =

i =

_GET [' id'];

}

else {

< span class =code-summarycomment>

_GET['id']; } else {

这篇关于为什么更新查询仅在phpmyadmin中有效？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！