問題描述
首先澄清一下，我知道有更好的方法可以做到這一點，但我決心進行實驗.
Just to first clarify, I know there are better ways to do this, but I'm determined to experiment.
基本上，我試圖從表單帖子中獲取圖像，然后將其發送到數據庫 MEDIUMBLOB 字段中.
Basically, I'm trying to grab an image from a form post, then send that into a database MEDIUMBLOB field.
不幸的是，使用我當前的方法，數據庫列中的最終結果始終為零字節.
Unfortunately, using my current method, the end result in the database column is always zero bytes. phpMyAdmin Screenshot
這里是表單上傳圖片的代碼:
Here is the code for the image upload on the form:
input type="file" name="_imagePost">
這是頁面上的 PHP 代碼，我使用的是 MySQLi :
Here is the PHP code on the page, I'm using MySQLi :
if(isset($_POST['_imagePost']))
{
$_useImagePost = 1;
$_imagePost = file_get_contents($_FILES['_imagePost']);
// Open DB Connection
$_conn = databaseConnect();
$_stmt = $_conn->prepare("INSERT INTO Question (Question_Type, Question_Text, Question_Answer, Question_UseImage, Question_Image) VALUES (?, ?, ?, ?, ?)");
$_stmt->bind_param("sssib", $_typePost, $_textPost, $_answerPost, $_useImagePost, $_null);
$_stmt->send_long_data(4,$_imagePost);
$_stmt->execute();
// Close DB Connection
$_conn->close();
}
我不確定的是，當輸入類型為文件時，isset($_POST['_imagePost'])"是否有效.
What I am unsure of is if "isset($_POST['_imagePost'])" works when the input type is file.
然而，我可以肯定的是，當前的設置根本不起作用.
What I am sure of, however, is that the current setup doesn't work at all.
推薦答案
你寫的:
$_imagePost = file_get_contents($_FILES['_imagePost']);
正確的語法是:
$_imagePost = file_get_contents($_FILES['_imagePost']['tmp_name']);
$_FILES 是一個帶有以下鍵的關聯數組:
$_FILES is an associative array whit following keys:
- [name] => 原始文件名；
- [type] => 上傳文件的 mimetype;
- [tmp_name] => 臨時文件路徑(上傳文件的存儲位置)；
- [錯誤] => 錯誤；
- [size] => 上傳文件的大小.
- 查看更多關于$_FILES
這篇關于使用 Blob 將圖像上傳到 MySQL 數據庫的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！