php读取mysql图片数据类型_我如何显示图像存储为MySQL中的blob数据类型与PHP？

How do i display an image stored in mySQL database as BLOB ?

What it tried so far:

1. Created a new php function/file to get picture (getpicture.php).

2. In the html, I have the following code:

/*below is the getpicture.php*/

@ $db = new MySQLi('localhost','root','','myDatabase');

if(mysqli_connect_errno()) {

echo 'Connection to database failed:'.mysqli_connect_error();

exit();

}

if(isset($_GET['People_Id'])) {

$id = mysqli_real_escape_string($_GET['People_Id']);

$query = mysqli_query("SELECT * FROM 'people' WHERE 'People_Id' = '$id'");

while($row = mysqli_fetch_assoc($query)) {

$imageData =$row['image'];

}

header("content-type: image/jpeg");

echo $imageData;

echo $id;

}

else {

echo "Error!";

echo $id;

}

?>

What's wrong with the codes ? Please help!

解决方案

I answered my own question, it's working now..

Below is the getpicture.php:

$db = new MySQLi('localhost', '', '', 'mydatabase');

if ($db->connect_errno) {

echo 'Connection to database failed: '. $db->connect_error;

exit();

}

if (isset($_GET['id'])) {

$id = $db->real_escape_string($_GET['id']);

$query = "SELECT `Picture` FROM member WHERE `Id` = '$id'";

$result = $db->query($query);

while($row = mysqli_fetch_array($result)) {

$imageData = $row['Picture'];

header("Content-type:image/jpeg");

echo $imageData;

}

}

?>

The php script which retrieve the getpicture.php above looks like this:

echo '';

Thaank you all for the help