php存储图片到mysql数据库_php将图片以二进制保存到mysql数据库并显示

$conn = mysql_connect('localhost', 'root', '');

mysql_select_db('study', $conn);

mysql_query("SET NAMES UTF-8");

?>

(2)图片上传并以二进制保存到数据库文件：upload.php

include('./conn.php');

if ($_POST['submit']) {

if ($_FILES['image']['size']) {

$names = $_FILES['image']['name'];

$arr = explode('.', $names);

$name = $arr[0]; //图片名称

$date = date('Y-m-d H:i:s'); //上传日期

$fp = fopen($_FILES['image']['tmp_name'], 'rb');

$type = $_FILES['image']['type'];

if (!$fp) {

showInfo('读取图片失败！');

} else {

$image = addslashes(fread($fp, filesize($_FILES['image']['tmp_name'])));

if ($image) {

$q = "insert into image (name, pic, type, date) values ('$name','$image','$type','$date')";

$result = mysql_query($q);

if ($result) {

showInfo('上传成功！');

} else {

showInfo('上传失败！');

}

} else {

showInfo('请选择要上传的文件！');

}

}

} else {

showInfo('请选择要上传的文件！');

}

}

function showInfo($info)

{

echo "

";

echo "";

echo "";

echo "

" . $info . "……";

echo "";

}

?>

三.从数据库中读取以二进制保存的图片并显示:image.php

include('./conn.php');

$id = $_GET['id'];

$sql = "select * from image where id='$id'";

$result = mysql_query($sql, $conn);

if (!$result)

die("读取图片失败！");

$num = mysql_num_rows($result);

if ($num < 1)

die("暂无图片");

$data = mysql_result($result, 0, 'pic');

$type = mysql_result($result, 0, 'type');

mysql_close($id);

Header("Content-type: $type");

echo $data;

?>

四.上传并显示图片的页面：index.php

include('./conn.php');

?>

/p>

"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

$ret = mysql_query('select * from image order by id desc');

if ($ret) {

while ($row = mysql_fetch_array($ret)) {

?>

<?php

echo $row['name'];

?>

echo $row['date'];

?>

}

}

?>