关于PHP从数据库取出图片显示问题.(之前发的怎么被人删了?)

jackwang520 2005-10-29 11:28:18

第一个文件home.php选取图片文件
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head>
<body>
<center>
<form method="POST" name="pic1" action="pic.php" enctype="multipart/form-data">
<table>
<tr><td>上传图片</td></tr>
<tr><td>图片名称:</td><td><input type=text name="name" size=35></td></tr>
<tr><td>图片说明:</td><td><textarea name="info" cols=35 rows=8></textarea></td></tr>
<tr><td>图片文件:</td><td><p><input type=file name="pic" size=35></td></tr>
<tr><td><input type=submit value="提交" name="submit"><input type=reset value="重写" name="B2">
</table>
</form></center>
</body>
</html>
第二个文件pic.php将图片储存入数据库.
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>图片加入数据库过程</title>
</head>
<body>
<? $result=mysql_connect("localhost","root","root")or("连接错误");
$info=nl2br($_POST['info']);
if($pic!="none"){
$fp=fopen($pic,"r");
$data=fread($fp, filesize($pic));
$data=addslashes($data);
}
$filesize=filesize($pic);
$filetype=filetype($pic);
$filename=basename($pic);
$date=date("Y-m-d H:i:s");
$quary="insert into photo(info,name,time,pic,filename,filesize,filetype) values('$info','$name','$date','$data','$filename','$filesize','$filetype')";
if(mysql_db_query("photo",$quary))
{echo "数据已成功插入!!!!!";}
?>
</body>
</html>
第三个文件和第四个文件picture.php和3.php用来显示图片.
picture.php:
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head>

<body>
<?php
mysql_connect('localhost',"root","root")or("连接错误");
//for($id=1;$id<7;$id++){

$query="SELECT * FROM photo";

$result=mysql_db_query("photo",$query);

while($row=mysql_fetch_object($result)){
Header( "Content-type: image/gif");
echo "<IMG SRC=\"3.php? id=$row->id\">";
}
?>

</body>
</html>
3.php:
<?
//mysql_connect('localhost',"root","root")or("连接错误");
$result=mysql_query("SELECT * FROM photo WHERE id=$id") or die("Can't perform Query");
$row=mysql_fetch_object($result);
Header( "Content-type: image/gif");
echo $row->pic;
?>
问题是这样的,图片储存过程顺利完成,但图片显示时,却总是显示不出图片,只显示了两个叉(因为我储存了两个图片文件,所以是两个叉)..
请问这是怎么回事????????????????
为了让大家更了解我这个程序,所以我把前面图片选取和图片储存两个程序也发上来.

...全文