php - 我正在尝试通过 href 将一个值传递给 php 页面，以从 mysql 数据库的那一行检索其余数据

Question

我试图通过 href 将一个值传递给 PHP，以返回我的 mysql 数据库表中该行中的其余数据。

so  when I click on  <a href="datainflux.php?id=id_num>Details</a>

 I want it to send the id number (id=id_num) to datainflux.php to return the 'item', 'ranking', 'descript' and 'type' that use                      

那个身份证号码。我很确定 href 和 php 都有缺陷。

This is the PHP code I'm using

<?php
$hostname="localhost"; //local server name default localhost
$username="root";  //mysql username default is root.
$password="";       //blank if no password is set for mysql.
$database="spkwi312_Organic";  //database name which you created
$con=mysql_connect($hostname,$username,$password);
  if(! $con)
    {
      die('Connection Failed'.mysql_error());
}

mysql_select_db($database,$con);


$id_num = id_num

$query = sprintf("SELECT item, ranking, descript, type FROM og4real 
   WHERE id_num='%s'",
   mysql_real_escape_string($id_num));

$result = mysql_query($query);

if (!$result) {
   $message  = 'Invalid query: ' . mysql_error() . "\n";
   $message .= 'Whole query: ' . $query;
   die($message);
  }

while ($row = mysql_fetch_assoc($result)) {
  echo $row['item'];
  echo $row['ranking'];
  echo $row['descript'];
  echo $row['type'];

?>

感谢任何帮助。

Answer 1

改变:

$id_num = id_num;

到

$id_num = $_GET['id_num']; 

上一页的链接应该是:

<a href="datainflux.php?id_num=value">Details</a>

PS : value 应该替换成真正的ID_NUM