公共文件:config.inc.php
存放:
$fp=fopen($file,"r");
$file_data=fread($fp,$file_size);
fclose($fp);
$file_data=addslashes($file_data);
$result=mysql_query("insert into savepic(fname,file_data,file_size,ftype) values ('$file_name',.....)";
<img src=showpic.php>
读取showpic.php:
$result=mysql_query("select * from savepic order by id desc")
$arr=mysql_fetch_array($result);
$file_name=$arr['file_name'];
echo $file_name;
存放:
$fp=fopen($file,"r");
$file_data=fread($fp,$file_size);
fclose($fp);
$file_data=addslashes($file_data);
$result=mysql_query("insert into savepic(fname,file_data,file_size,ftype) values ('$file_name',.....)";
<img src=showpic.php>
读取showpic.php:
$result=mysql_query("select * from savepic order by id desc")
$arr=mysql_fetch_array($result);
$file_name=$arr['file_name'];
echo $file_name;
我的测试数据库为:bs 表:pic
表结构及数据如下:
+----+----------+
| id | picname |
+----+----------+
| 1 | logo.gif |
+----+----------+
showpic.php(我用的是showpic.inc)
<?php
function showconncet(){
$id=mysql_connect("localhost","root");
$db=mysql_select_db("bs");
$result=mysql_query("select * from pic where id=1");
$arr=mysql_fetch_array($result);
$file_name=$arr['picname'];
echo $file_name;
}
?> 显示图片文件test.php代码
<?php
include ("showpic.inc");
showconncet();
?>
<html>
<body>
<img src="<?php showconncet();?>">
</body>
</html>测试通过,能正显示试图片