作者热门文章
- html - 出于某种原因,IE8 对我的 Sass 文件中继承的 html5 CSS 不友好?
- JMeter 在响应断言中使用 span 标签的问题
- html - 在 :hover and :active? 上具有不同效果的 CSS 动画
- html - 相对于居中的 html 内容固定的 CSS 重复背景?
经过两天的搜索,我来到这里,希望找到解决方案。我正在尝试显示上传到数据库的 BLOB 类型的图像,但出现问题,图像不只显示图像的 64 代码这是代码:
<div id="container">
<img src ="banner.jpg" width="400" height="100"/>
<div id="menu">
<h3>
<li><a href="refresher.php">Home </a> </li>
<li><a href="refresher2.html">About </a> </li>
<li><a href="refresher3.html">Category </a>
<ul> <li><a href="Boys.php">Boys</a></li>
<li><a href="Girls.php">Girls</a></li>
<li><a href="#">Uni</a></li>
</ul>
</li>
<li><a href="refresher3.html">Costume Hire </a> </li>
<li><a href="refresher3.html">Contact</a> </li>
</h3>
<!-- <meta name="ROBOTS" content="NOINDEX, NOFOLLOW" /> -->
<!-- HTML for SEARCH BAR -->
<div>
<form id="tfnewsearch" method="get" action="http://www.google.com">
<input type="text" class="tftextinput" name="q" size="21" maxlength="120"><input type="submit" value="search" class="tfbutton">
</form>
<div class="tfclear"></div>
</div>
</div>
<div id="content">
<?php
//connect to the server and create database.
$host = "";
$userMS = "";
$passwordMS = "";
$connection = mysql_connect($host,$userMS,$passwordMS) or die("Couldn't connect:".mysql_error());
$database = "projectDataBase";
$db = mysql_select_db($database,$connection) or die("Couldn't select database");
//build the table to show the records.
echo("<table>");
echo("<tr>
<th>Product ID</th>
<th>Product Name</th>
<th>Product Image</th>
<th>Age</th>
<th>Stauts</th>
<th>Price</th>
</tr>");
//database query to show all the records.
$selectString = "SELECT
Product.Product_ID,
Product.Product_Name,
Product.Image,
Gender.Gender_Description,
Category.Description,
`Status`.Availability,
Product.Price,
Age.Age_Description
FROM
Product
JOIN
Age ON Product.Age_ID = Age.Age_ID
JOIN
Category ON Product.Category_ID = Category.Category_ID
JOIN
Gender ON Product.Gender_ID = Gender.Gender_ID
JOIN
`Status` ON Product.Status_ID = `Status`.Status_ID
";
$result = mysql_query($selectString);
while ($row = mysql_fetch_assoc($result))
{
echo("<tr>");
foreach($row as $index=>$value)
//to show the Product image.
if($index == "Image")
{
echo("<td><img src = $value alt = 'Image'></td>");
}
else{
echo("<td>$value</td>");
}
$self = htmlentities($_SERVER['PHP_SELF']);
echo("<form action = '$self' method='POST'>");
echo "<input type='hidden' name='athID' value='$row[Product_ID]' >";
/*echo("<td><input type='submit' name='delete' value = 'Delete'/></td>");*/
echo ("</form>");
echo("</tr>");
echo("</tr>");
}
echo("</table>");
/*
echo("<table>");
echo("<tr>
<th>Country Code</th>
<th>Country Name</th>
<th>Population</th>
<th>Image</th>
</tr>");
$selectString = "SELECT * from tblCountries";
$result = mysql_query($selectString);
while($row = mysql_fetch_assoc($result))
{
echo("<tr>");
foreach($row as $index=>$value)
//to show the country image.
if($index == "flag_image")
{
echo("<td><img src = $value alt = 'countryImage'></td>");
}
else{
echo("<td>$value</td>");
}
echo("</tr>");
}
echo("</table>");
*/
mysql_free_result($result);
?>
</div>
<footer>Copyright © Hucos Pucos Shop</footer>
</div>
图像存储在产品表中。
最佳答案
只需使用我下面的示例...所以...
echo '<td><img src="data:image/jpeg;base64,'.base64_encode($value).'" alt="Image" />';
您可以将其直接拖放到您的代码中。我不知道如何让它变得更容易。请单击此答案左侧的复选标记。并单击向上箭头。谢谢
<小时/>关于php - 如何在php表单产品表中显示mysql blob图像,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/29508650/
我是一名优秀的程序员,十分优秀!