PHP ID 不通过 url

Question

我无法删除一行，因为 id 没有通过 url。这是某个地方的一个简单错误，我环顾了一个小时后找不到解决方案。

这个页面包含一个表格的信息:

    <?php

$result = mysql_query("SELECT review, ratings, date, user FROM reviews")
or die(mysql_error()); ;

if (mysql_num_rows($result) == 0) {
       echo 'There Arent Any Reviews Yet';
    } else {

echo "<table border='0'><table width=100% border='6'><tr><th>Comments/Thoughts</th><th>Ratings</th><th>Date</th><th>User</th><th>Delete</th></tr>";
while($info = mysql_fetch_array($result))
{
        echo "<tr>";
        echo "<td>" . $info['review']. "</td>";
        echo "<td>" . $info['ratings']. " Stars</td>";
        echo "<td>" . $info['date']. "</td>";
        echo "<td>" . $info['user']. "</td>";

        echo "<td>" . " <a href='deletereview.php?review_id=" . $info['review_id'] . "'>Delete</a> </td>";
        echo "</tr>";
        }
    }
echo "</table>";
?>

它转到执行删除功能的 deletereview.php:

    <?php
session_start();
require_once '../includes/db.php';  
$id = $_GET['review_id'];

$info = "DELETE FROM reviews WHERE review_id = '$id'";

mysql_query($info) or die ("Error: ".mysql_error());
echo "<h2>Review Deleted</h2>";

?>

有什么想法吗？

Answer 1

您没有在查询中选择 review_id，因此 $info["review_id"] 始终为 null。