$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("");
}