php+mysql 圖象輸入輸出
我看了網上的例子~用了~發現圖片進資料庫沒問題~但是關於輸出部分總是報錯~
代碼如下
建庫:
CREATE TABLE Images ( PicNum int NOT NULL AUTO_INCREMENT PRIMARY KEY, Image BLOB );
進庫:<?php
$Picture=$_POST[file]; //flie是 我那個圖片上傳頁的表單的傳遞
If($Picture != "none")
{ $PSize = filesize($Picture);
$mysqlPicture = addslashes(fread(fopen($Picture, "r"), $PSize));
mysql_connect("localhost","root","") or die("Unable to connect to SQL server");
@mysql_select_db("mymg") or die("Unable to select database");
mysql_query("INSERT INTO images (image) VALUES ('$mysqlPicture')") or die("Cant Perform Query"); }
else
{ echo"You did not upload any picture"; }
?>
程式到這裡都沒問題~我用CMD看了下 資料庫裡也有東西.
輸出:
<html>
<body>
<?php
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.php ? PicNum=$row- > PicNum'/>"};! ?>
</body>
</html>
'Second.php:
<?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;
?>
