求教!请详细谈一下在MYSQL中如何存取图片?

Question

http://expert.csdn.net/Expert/topic/1113/1113409.xml?temp=.4967615

Answer 1

$filename = "test.jpg";
// 读取文件
$fp = fopen($filename,"rb");
$picture = fread($fp,filesize($filename));
$picture = base64_encode($picture);
fclose($fp);
// 操作MYSQL
$conn=mysql_connect("localhost","root","");
@mysql_select_db("test",$conn);
// 存入数据库
$query="insert into pic (filename,picture) values ('$filename','$picture')";
$result=mysql_query($query);
$id=mysql_insert_id();
// 读取数据
$query="select * from pic where id='$id'";
$result=mysql_query($query);
$row=mysql_fetch_array($result);
$data = base64_decode($row[picture]);
// 显示文件
header("Content-type: image/jpeg");
echo $data;

Answer 2

http://www.google.com/search?q=%E5%9B%BE%E7%89%87+%E6%95%B0%E6%8D%AE%E5%BA%93+MySQL&ie=UTF-8&oe=UTF-8&hl=zh-CN&btnG=Google%E6%90%9C%E7%B4%A2&lr=