php - 悬停时没有显示 mysql 查询的 img 和没有 stocknr

Question

从数据库上传图片时遇到问题，想知道我做错了什么..

我已经通过使用检查了图像是否存在<img scr='/upload/imgpath.jpg'>

有什么建议么？

$sql1 = "SELECT pic, stocknr, status FROM stock WHERE status = '1'";

$result = mysqli_query($con,$sql1);

while($row1 = mysqli_fetch_assoc($result));
{
$stocknr2 = $row1['stocknr'];
$picname = $row1['pic'];
$upfile = $picname;
echo "<center>";
echo "<a href='details.php?stocknr=$stocknr2'>";
echo "<img src='/upload/$upfile' border=1 width=350 height=280></a>";
echo "</center>";
}
mysqli_free_result($result);

标签： phpdatabaseimage

Answer 1

您只需要更改 while 行；

while($row1 = mysqli_fetch_assoc($result)