索引的PHP代码.php
<?php
include("connection.php");
$sql = "SELECT prod_cost, prod_name, prod_image FROM products";
$result = mysqli_query($con, $sql);
$row = mysqli_fetch_all($result, MYSQLI_ASSOC);
//free result from memory
mysqli_free_result($result);
//close connection
mysqli_close($con);
?>
图像在下面代码段第二行的src""中读取.一切正常,但只有一半的图像显示.
<div class="col-1" onclick="location.href='item1.html';" style="cursor: pointer;">
<img src="data:image/ppg;charset=utf8;base64,<?php echo base64_encode($row[0]['prod_image'])?> " alt="Rooster Chicken #18">
<h4><?php echo $row[0]['prod_name']; ?></h4>
<p>$ <?php echo $row[0]['prod_cost']; ?> <strike> $17.80 </strike></p>
</div>
图像直接添加到数据库中
INSERT INTO products(prod_name, prod_stock,prod_cost,prod_image)
VALUES ('Rooster Chicken #18',100,17.65,LOAD_FILE('C:/xampp/htdocs/SNS/Images/products/rooster18.png'));
注意:上面显示的PHP代码片段来自同一个名为index的页面,PHP