php - 单击超链接时查看详细的 MySQL 结果

Question

我正在努力实现以下目标。在主页上，MySQL 查询返回表“parcid”的结果(但结果有限)。下一步是，我想超链接一个字段(最好是“ID”)以使用相同的 ID 打开一个新页面，但返回更详细的结果。下面的代码可以工作，但显然我在某个地方遗漏了一些东西，因为它返回所有结果，而不仅仅是单击 ID 的结果。任何帮助将不胜感激。

首页网址:“http://localhost/”

详细网址:“http://localhost/pdetail/”

Query on "Home" page

<?php

// set database server access variables:
$host = "localhost";
$user = "root";
$pass = "";
$db = "wordpress";

// open connection
$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!");

// select database
mysql_select_db($db) or die ("Unable to select database!");

// create query
$query =  "SELECT * FROM parcid";

// execute query
$result = mysql_query($query) or die ("Error in query: $query. ".mysql_error());

// see if any rows were returned
if (mysql_num_rows($result) > 0) {
    // yes
    // print them one after another
    echo "<table cellpadding=1 >";
        echo "<tr>";
        echo "<td>"."ID"."</td>"; 
        echo "<td>"."City"."</td>";          
        echo "<td>"."Destination City"."</td>";
        echo "<td>"."Weight"."</td>";
        echo "<td>"."Length"."</td>";
        echo "<td>"."Width"."</td>";
        echo "<td>"."Height"."</td>";
        echo "<td>"."Type"."</td>";
        echo "<td>"."Courier Option"."</td>";
        echo "</tr>";
    while($row = mysql_fetch_row($result)) {
        echo "<tr>";
        echo '<td><a href="http://localhost/pdetail/'.$row[0].'">'.$row[0].'</a></td>';
        echo "<td>" . $row[6]."</td>";      
        echo "<td>" . $row[12]."</td>";
        echo "<td>" . $row[14]."</td>";
        echo "<td>" . $row[15]."</td>";
        echo "<td>" . $row[16]."</td>";
        echo "<td>" . $row[17]."</td>";
        echo "<td>" . $row[18]."</td>";
        echo "<td>" . $row[19]."</td>";
        echo "<td>" . $row[20]."</td>";
        echo "</tr>";
    }
    echo "</table>";
}
else {
    // no
    // print status message
    echo "No rows found!";
}

// free result set memory
mysql_free_result($result);

// close connection
mysql_close($connection);

?>

Query on"pdetailed" page.

<?php

// set database server access variables:
$host = "localhost";
$user = "root";
$pass = "";
$db = "wordpress";

// open connection
$connection = mysql_connect($host, $user, $pass) or die ("Unable to connect!");

// select database
mysql_select_db($db) or die ("Unable to select database!");

$ID = $_GET['ID'];

// create query
$query =   "SELECT * FROM parcid WHERE ID LIKE '%$ID%'";

// execute query
$result = mysql_query($query) or die ("Error in query: $query. ".mysql_error());

// see if any rows were returned
if (mysql_num_rows($result) > 0) {
    // yes
    // print them one after another
    echo "<table cellpadding=1 >";
        echo "<tr>";
        echo "<td>"."ID"."</td>";
        echo "<td>"."CID"."</td>";
        echo "<td>"."From"."</td>";
        echo "<td>"."Street"."</td>";
        echo "<td>"."Suburb"."</td>";
        echo "<td>"."Post Code"."</td>";
        echo "<td>"."City"."</td>";
        echo "<td>"."Province"."</td>";
        echo "<td>"."Receiver"."</td>";
        echo "<td>"."Destination Street"."</td>";
        echo "<td>"."Destination Suburb"."</td>";
        echo "<td>"."Destination Postcode"."</td>";
        echo "<td>"."Destination City"."</td>";
        echo "<td>"."Destination Province"."</td>";
        echo "<td>"."Weight"."</td>";
        echo "<td>"."Length"."</td>";
        echo "<td>"."Width"."</td>";
        echo "<td>"."Height"."</td>";
        echo "<td>"."Type"."</td>";
        echo "<td>"."Courier Option"."</td>";
        echo "</tr>";
    while($row = mysql_fetch_row($result)) {
        echo "<tr>";
        echo "<td>" . $row[0]."</td>";
        echo "<td>" . $row[1]."</td>";
        echo "<td>" . $row[2]."</td>";
        echo "<td>" . $row[3]."</td>";
        echo "<td>" . $row[4]."</td>";
        echo "<td>" . $row[5]."</td>";
        echo "<td>" . $row[6]."</td>";
        echo "<td>" . $row[7]."</td>";
        echo "<td>" . $row[8]."</td>";
        echo "<td>" . $row[9]."</td>";
        echo "<td>" . $row[10]."</td>";
        echo "<td>" . $row[11]."</td>";
        echo "<td>" . $row[12]."</td>";
        echo "<td>" . $row[13]."</td>";
        echo "<td>" . $row[14]."</td>";
        echo "<td>" . $row[15]."</td>";
        echo "<td>" . $row[16]."</td>";
        echo "<td>" . $row[17]."</td>";
        echo "<td>" . $row[18]."</td>";
        echo "<td>" . $row[19]."</td>";
        echo "<td>" . $row[20]."</td>";
        echo "</tr>";
    }
    echo "</table>";
}
else {
    // no
    // print status message
    echo "No rows found!";
}

// free result set memory
mysql_free_result($result);

// close connection
mysql_close($connection);

?>

Answer 1

如果您只想要 $ID 标识的单行，那么查询是

$query = "SELECT * FROM parcid WHERE ID = '$ID'";

此外，当您知道应该只从查询中接收单个结果行时，您不需要在 while 循环中运行 mysql_fetch_row($result)。

Please dont use the mysql_ database extension, it is deprecated (gone for ever in PHP7) Especially if you are just learning PHP, spend your energies learning the PDO or mysqli_ database extensions, and here is some help to decide which to use

除非您使用框架，否则此声明可能是错误的

echo '<td><a href="http://localhost/pdetail/'.$row[0].'">'.$row[0].'</a></td>';

也许应该是

echo '<td><a href="http://localhost/pdetail?ID='.$row[0].'">'.$row[0].'</a></td>';