这个是ccterran大大以前贴过的,希望对你有帮助1,设计表
id int not null auto_increment primary key
img blob
2,上传表单 i.php
------------------------------
<form action="a.php" method="post" enctype="multipart/form-data">
<input type="file" name="file"><P>
<input type="submit" value="上传图片到数据库">
</form>3,接收程序 a.php
--------------------------
<?php
$file=$_FILES["file"];
if(empty($file)){
echo"上传失败了";
exit;
}$tmpfile=$file["tmp_name"];$data=addslashes(fread(fopen($tmpfile,"rb"),$file["size"]));mysql_connect("localhost","root","");
mysql_select_db("article");$res=@mysql_query("insert into photo (img) values ('$data')");if($res){
echo"成功啦";
}
else{
echo"失败啦";
}?>4,从数据库中读出图片来。根据id,比如 b.php?id=2
---------------------------
<?php
mysql_connect("localhost","root","");
mysql_select_db("article");// 得到id
if(isset($_GET["id"])){
$id=$_GET["id"];
}else{
$id="1";
}$res=mysql_query("select * from photo where id='$id'");
$arr=mysql_fetch_array($res);
header("content-type:image/png");echo $arr["img"];
?>
id int not null auto_increment primary key
img blob
2,上传表单 i.php
------------------------------
<form action="a.php" method="post" enctype="multipart/form-data">
<input type="file" name="file"><P>
<input type="submit" value="上传图片到数据库">
</form>3,接收程序 a.php
--------------------------
<?php
$file=$_FILES["file"];
if(empty($file)){
echo"上传失败了";
exit;
}$tmpfile=$file["tmp_name"];$data=addslashes(fread(fopen($tmpfile,"rb"),$file["size"]));mysql_connect("localhost","root","");
mysql_select_db("article");$res=@mysql_query("insert into photo (img) values ('$data')");if($res){
echo"成功啦";
}
else{
echo"失败啦";
}?>4,从数据库中读出图片来。根据id,比如 b.php?id=2
---------------------------
<?php
mysql_connect("localhost","root","");
mysql_select_db("article");// 得到id
if(isset($_GET["id"])){
$id=$_GET["id"];
}else{
$id="1";
}$res=mysql_query("select * from photo where id='$id'");
$arr=mysql_fetch_array($res);
header("content-type:image/png");echo $arr["img"];
?>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货