免費mysql資料庫 php下將圖片以二進位存入mysql資料庫中並顯示的實現代碼

//儲存圖片到資料庫的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 {
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;

以上就介紹了免費mysql資料庫 php下將圖片以二進位存入mysql資料庫中並顯示的實現代碼，包括了免費mysql資料庫方面的內容，希望對PHP教程有興趣的朋友有所協助。

