上传的图片如何存入数据库?在线等 我只是想试试这种方法。可是我fread后。添加纪录时出错 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 $NameArray = explode(".",$Pic_name);$ExtendName = strtolower($NameArray[1]);$WHArray = getimagesize($Pic);$RatioWH = $WHArray[1]/$WHArray[0];@copy($Pic, "./images/$Pic_name");$Pic_blob = fread(fopen("./images/$Pic_name","r"),filesize("./images/$Pic_name"));@unlink( "./images/$Pic_name");$CreateTime = date("Y-m-d");$query = "INSERT INTO ".PIC_TABLE." SET PicName = '$PicName' ,ExtendName = '$ExtendName' ,Pic = '$Pic_blob', RatioWH = '$RatioWH' ,CreateTime = '$CreateTime' ,UpUser = '$UpUser' ";@mysql_query($query,$DB_CONN); 你的sql有问题吧。字段是不是blob或者long blob 我写的一个简单的上传图片到数据库的程序1,设计表 id int not null auto_increment primary key img blob2,上传表单 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---------------------------<?phpmysql_connect("localhost","root","");mysql_select_db("article");// 得到idif(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"];?> ccterran(iwind)写的好,简单明了 怎么在session间共享?不用DB,及磁盘存储等额外功能 phpmyadmin不能导入大的文件 PHP获得客服端IP问题~~ IIS下的PHP问题 请教使用000webhost空间安装Discuz!论坛 谁能告诉我 phpmailer发送邮件附件 最大允许多少? 我试了下好像很小啊,我传个200多K的压缩包都不行~~~ 高薪诚聘php高手,年薪不低于8万 关于die.帮忙了!! 讨论一下,eregi和strpos PHP curl响应参数与响应header 中的参数值获取 页面刷新 散点分,谈谈最近学习心得体会
$ExtendName = strtolower($NameArray[1]);$WHArray = getimagesize($Pic);
$RatioWH = $WHArray[1]/$WHArray[0];@copy($Pic, "./images/$Pic_name");
$Pic_blob = fread(fopen("./images/$Pic_name","r"),filesize("./images/$Pic_name"));
@unlink( "./images/$Pic_name");$CreateTime = date("Y-m-d");
$query = "INSERT INTO ".PIC_TABLE." SET PicName = '$PicName' ,ExtendName = '$ExtendName' ,Pic = '$Pic_blob', RatioWH = '$RatioWH' ,CreateTime = '$CreateTime' ,UpUser = '$UpUser' ";
@mysql_query($query,$DB_CONN);
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"];
?>