HTML/PHP 根据数据库在网页上显示图片并在点击后在新网页上显示相应信息(以商店举例)

$sql = "select * from raz_kandidaten INNER JOIN raz_exresult ON raz_kandida

$sql = "select * from table order by price";

$result = $db->query($sql) or die ("Can't find it!");

while ($row = $result->fetch_assoc())

{

$id = $row['ID'];

$Product = $row['Product'];

$price = str_replace(".",",",$row['Price']);

$photo = "<img src='images/$id.png'>";

echo "<在这里插入对应id的图片以及信息，并在图片标签上插入超链接<a href='information.php?id=$id'>$photo</a>>";

}

 

新网页展示信息：

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

{

$id = $_GET['id'];

$sql = "select * from table where ID='$id'";

$result = $db->query($sql);

$row = $result->fetch_assoc();

$product = $row['Product'];

$describe = $row['Describe'];

$price = $row['Price'];

}

else

{

Header("");

}