尝试将表格单元格中的图像链接到 sql 记录时卡住 - Stuck trying to link image in table cells to sql record

Stuck trying to link image in table cells to sql record

>我已经在HTML中创建了一个表格，在每个单元格中，我想将其中的图像链接到PHP中的记录，但我对如何去做有点困惑，请帮忙。

<td>
<?php
$con=mysqli_connect("server","username","password","db");
$sql = "SELECT imgurl FROM Workshop_products WHERE id=XXX";
$result = mysql_query($sql) or die(mysql_error());
$row = mysql_fetch_assoc($result);
?>
<img src="<?php echo $row['imgurl'] ?>" />
</td>

尝试向每个单元格添加这样的东西，但它只显示图像。谢谢

将

图像包装成 <a> -tag：

<?php
$link = "user.php?id=$row[id]"; // example: this is the page you want to link to
$img  = $row['imgurl'];
?>
<a href="<?php echo $link; ?>"><img src="<?php echo $img; ?>" /></a>

我认为您正在尝试显示数据库中表示的所有图像，所以也许是这样：

<?php
$con=mysql_connect("bt2201-1213.bimserver2.com","ihamzadb","xK56K7S6","ihamzadb");
$sql = "SELECT imgurl FROM Workshop_products";
print "<table>";
while($row = mysql_fetch_assoc($sql)){
    print "<td><a href ='" . $row['imgurl'] . "'><img src = '" . $row['imgurl'] . "'></a></td>";
}
print "</table>";