通过PHP将文件内容读入表中

$servername = "数据库服务器地址";
$username = "用户名";
$password = "密码";
$dbname = "数据库名";

// 创建连接
$conn = new mysqli($servername, $username, $password, $dbname);

// 检查连接是否成功
if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

// 创建表
$sql = "CREATE TABLE files (
    id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    filename VARCHAR(255) NOT NULL,
    content TEXT NOT NULL
)";

if ($conn->query($sql) === TRUE) {
    echo "表创建成功";
} else {
    echo "表创建失败: " . $conn->error;
}

$filename = "文件路径"; // 文件路径和名称

// 读取文件内容
$content = file_get_contents($filename);

// 准备插入语句
$sql = "INSERT INTO files (filename, content) VALUES ('$filename', '$content')";

if ($conn->query($sql) === TRUE) {
    echo "文件内容插入成功";
} else {
    echo "文件内容插入失败: " . $conn->error;
}

// 关闭连接
$conn->close();