php把圖片存入mysql資料庫中並在網頁上顯示_PHP教程

php把圖片存入mysql資料庫中並在網頁上顯示

php教程把圖片存入mysql教程資料庫教程中並在網頁上顯示

//儲存圖片到資料庫

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 {
echo"You 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 "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;

http://www.bkjia.com/PHPjc/444939.htmlwww.bkjia.comtruehttp://www.bkjia.com/PHPjc/444939.htmlTechArticlephp把圖片存入mysql資料庫中並在網頁上顯示 php教程把圖片存入mysql教程資料庫教程中並在網頁上顯示 //儲存圖片到資料庫 If($Picture != none) {...

