数据库存储图片示例。。

图片存储数据库一例
?mode=store" method="post" enctype="multipart/form-data">
文件:
';
echo '图片存储数据库一例';
echo '';
echo '上传图片';
$conn = mysql_connect("localhost","root","");
mysql_select_db("test",$conn);
//echo $file;
$file = $_FILES['file']['tmp_name'];
$type = $_FILES['file']['type'];//文件类型
$data = addslashes(fread(fopen($file,"r"),filesize($file)));
$sql = "insert into photo(data,type)
values('$data','$type')";
mysql_query($sql,$conn);
$id = mysql_insert_id();
echo "你上传的图片效果:
";
echo '';
mysql_close($conn);
echo '';
echo '';
break;
default:
echo "要么上传要么不上传";
break;
}
?>
photo表说明
CREATE TABLE `photo` (
`id` SMALLINT( 255 ) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY ,
`data` LONGBLOB NOT NULL ,
`type` VARCHAR( 30 ) NOT NULL
) ;