php下将图片以二进制存入mysql数据库中并显示的实现代码
2018-09-07 15:18
//保存图片到数据库的php代码
复制代码 代码如下:
If($Picture != none) {
$PSize = filesize($Picture);
$mysqlPicture = addslashes(fread(fopen($Picture, r), $PSize));
mysql_connect($host,$username,$password) or die(Unable to connect to SQL server);
@mysql_select_db($db) or die(Unable to select database);
mysql_query(INSERT INTO Images (Image) VALUES ($mysqlPicture)) or die(Cant Perform Query);
}else {
echoYou did not upload any picture;
}
//以img标签读取数据库中的图片的代码
复制代码 代码如下:
mysql_connect($host,$username,$password) or die(Unable to connect to SQL server);
@mysql_select_db($db) or die(Unable to select database);
$result=mysql_query(SELECT * FROM Images) or die(Cant Perform Query);
While($row=mysql_fetch_object($result)) {
echo <IMG src=Second.php3? PicNum=$row->PicNum>;
//如secoed.php文件代码如下
$result=mysql_query(SELECT * FROM Images WHERE PicNum=$PicNum) or die(Cant perform Query);
$row=mysql_fetch_object($result);
Header( Content-type: image/gif);
echo $row->Image;
文章标题：php下将图片以二进制存入mysql数据库中并显示的实现代码
文章链接：http://soscw.com/essay/14337.html