php mysql 存储图片_php mysql 存储图片文件

最近做了一个图片上传到mysql中，但是出现了一些问题，就是图片可以上传，却不能够显示图片，请各位高手们帮帮忙：

1、我建了一个数据库

2、index.php文件

"image/bg.gif">

 图片名称： 上传路径：  

include "../conn/conn.php";

$connection = mysql_connect($db_host, $db_username, $db_password);

if(!$connection)

{

die("Could not connect to the database:
". mysql_error());

}

else

{

echo "Connect successful1!
";

}

//select the database

$db_select=mysql_select_db($db_database);

if(!$db_select)

{

die("Could not select the database:
". mysql_error());

}

else{

echo "select successful 1
";

}

if($_GET[page]==""||is_numeric($_GET[page]==false)) //判断当前页的页数

{

$page=1;

}

else{

$page=$_GET[page];

}

$page_size=4; //每页显示4张图片

$query="select count(*) as total from tb_tpsc order by scsj desc";

$result=mysql_query($query); //查询总的记录条数

$message_count=mysql_result($result,0,"total"); //为变量赋值

if($message_count==0){

echo "暂无图片！";

}

else{

if($message_count

{

$page_count=1;

}

else{

if($message_count%$page_size==0)

{

$page_count=$message_count/$page_size;

}

else{

$page_count=ceil($message_count/$page_size);

}}

$offset=($page-1)*$page_size;

$query="select * from tb_tpsc where scsj order by id desc limit $offset,$page_size";

$result=mysql_query($query);

?>

"#d6d7d6">

$i=1;

while($info=mysql_fetch_array($result))

{if($i%2==0)

{?>

图片名称：<?php echo $info[tpmc];?>	上传时间：<?php echo $info[scsj];?>

 

}else{

?>

图片名称：<?php echo $info[tpmc];?>	上传时间： <?php echo $info[scsj];?>

}

$i++;

}

?>

页次：<?php echo $page;?>/<?php echo $page_count;?> 页 记录：<?php echo $message_count;?>条

if($page!=1) { echo "首页 "; echo "上一页 "; } if($page { echo "下一页 "; echo "尾页"; } } ?>

3、图片提交文件：tptj.php

无标题文档

include("../conn/conn.php"); //链接数据源

$connection = mysql_connect($db_host, $db_username, $db_password);

if(!$connection)

{

die("Could not connect to the database:
". mysql_error());

}

else

{

echo "Connect successful!
";

}

//select the database

$db_select=mysql_select_db($db_database);

if(!$db_select)

{

die("Could not select the database:
". mysql_error());

}

else

{

echo "select successful
";

}

$tpmc = $_POST["tpmc"];

$file=$_FILES["filepath"];

$sc=$_POST["sc"];

if($sc!=="")

{

$tpmc=htmlspecialchars($tpmc); //将图片名称中的特殊字符转换成HTML格式

$tpmc=str_replace("\n","
",$tpmc); //将图片名称中的回车符以自动换行符取代

$tpmc=str_replace(""," ",$tpmc); //将图片名称中的空格以“ "取代

$scsj=date("y;m;d"); //设置图片的上传时间

$fp=fopen($file['tmp_name'],"r"); //以只读方式打开文件

//if( $fp==

$file=addslashes(fread($fp,$file['size'])); //将文件中的引号部分加上反斜线

header("Content-Type:image/jpeg");

$query="insert into tb_tpsc(tpmc,file,scsj) values ('".$tpmc."','".$file."','".$scsj."')";//创建插入图片数据的SQL语句

$result= mysql_query($query);

//echo "图片上传成功，请稍等...";

}

mysql_close();

?>

4、image.php

header("Content-Type:image/jpeg");

include "../conn/conn.php";

$connection = mysql_connect($db_host, $db_username, $db_password);

if(!$connection)

{

die("Could not connect to the database:
". mysql_error());

}

else

{

echo "Connect successful2!
";

}

//select the database

$db_select=mysql_select_db($db_database);

if(!$db_select)

{

die("Could not select the database:
". mysql_error());

}

else

{

echo "select successful2
";

}

$query="select * from tb_tpsc where id=".$recid; //查询指定ID的图片信息

$result=mysql_query($query);

if(!$result) die("error:mysql query");

$num=mysql_num_rows($result);

if($num<1) die("error:no this recorder");

//$data = mysql_result($result,0,'file');

//echo $data; //输出图片信息

$row=mysql_fetch_object($result);

echo $row->file;

mysql_close();

?>