我找到了解决问题的方法,我使用base64_encode($blob);函数
<?php
// Server credentials
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "unirentas";
// Creating mysql connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Checking mysql connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
// Writing a mysql query to retrieve data
$sql = "SELECT ID_renta, calle, smz, mz, lote, precio, universidad, fecha, imagen, nombre, telefono, correo FROM propiedades";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
// Show each data returned by mysql
while($row = $result->fetch_assoc()) {
$ID_renta = $row["ID_renta"];
$calle = $row["calle"];
$smz = $row["smz"];
$mz = $row["mz"];
$lote = $row["lote"];
$precio = $row["precio"];
$universidad = $row["universidad"];
$fecha = $row["fecha"];
$blob = $row["imagen"];
$nombre = $row["nombre"];
$telefono = $row["telefono"];
$correo = $row["correo"];
echo "
<!-- USING HTML HERE : -->
<p> ID : $ID_renta</p>
<p> Calle : $calle </p>
<p> Smz : $smz </p>
<p> Mz : $mz </p>
<p> Lote : $lote </p>
<p> Precio : $precio </p>
<p> Universidad : $universidad </p>";
echo '<img src="data:image/png;base64,'.base64_encode($blob).'"/>';
echo "<p> Fecha_ $fecha </p>
<p> Nombre : $nombre </p>
<p> Telefono : $telefono </p>
<p> Correo : $correo </p>
<p>////////////////////////////////////////////////////////////////////////////////</p>
";
}
} else {
echo "0 results";
}
// Closing mysql connection
$conn->close();
?>