使用超文本标记语言表单将BLOB上传到MySQL

<form action="upload.php" method="post" enctype="multipart/form-data">
  <input type="file" name="blobFile">
  <input type="submit" value="Upload">
</form>

<?php
$blobFile = $_FILES['blobFile'];

// 获取文件名、临时文件路径、文件类型等信息
$fileName = $blobFile['name'];
$tmpFilePath = $blobFile['tmp_name'];
$fileType = $blobFile['type'];

// 将文件内容读取为二进制数据
$blobData = file_get_contents($tmpFilePath);

// 连接到MySQL数据库
$servername = "数据库服务器地址";
$username = "数据库用户名";
$password = "数据库密码";
$dbname = "数据库名";
$conn = new mysqli($servername, $username, $password, $dbname);

// 插入BLOB数据到数据库表
$stmt = $conn->prepare("INSERT INTO table_name (blob_column) VALUES (?)");
$stmt->bind_param("b", $blobData);
$stmt->execute();

// 关闭数据库连接
$stmt->close();
$conn->close();
?>

CREATE TABLE table_name (
  id INT AUTO_INCREMENT PRIMARY KEY,
  blob_column BLOB
);