php数据库如何上传文件存储 php数据库文件管理系统的搭建

<form action="upload.php" method="post" enctype="multipart/form-data">
  <input type="file" name="file" />
  <button type="submit">上传文件</button>
</form>

$uploadDir = 'uploads/';
$fileName = basename($_FILES['file']['name']);
$targetPath = $uploadDir . $fileName;

if (move_uploaded_file($_FILES['file']['tmp_name'], $targetPath)) {
    // 文件成功保存到服务器
    $fileType = $_FILES['file']['type'];
    $fileSize = $_FILES['file']['size'];

    // 将文件信息存入数据库
    $pdo = new PDO("mysql:host=localhost;dbname=filemanage", "username", "password");
    $stmt = $pdo->prepare("INSERT INTO files (filename, filepath, filesize, filetype, upload_time) VALUES (?, ?, ?, ?, NOW())");
    $stmt->execute([$fileName, $targetPath, $fileSize, $fileType]);

    echo "文件上传成功！";
} else {
    echo "上传失败。";
}

CREATE TABLE files (
    id INT AUTO_INCREMENT PRIMARY KEY,
    filename VARCHAR(255) NOT NULL,
    filepath VARCHAR(500) NOT NULL,
    filesize INT,
    filetype VARCHAR(100),
    upload_time DATETIME
);

// list.php 显示所有文件
$stmt = $pdo->query("SELECT id, filename, filesize, upload_time FROM files");
while ($row = $stmt->fetch()) {
    echo "<a href='download.php?id={$row['id']}'>{$row['filename']}</a> ({$row['filesize']} bytes)<br>";
}

$id = intval($_GET['id']);
$stmt = $pdo->prepare("SELECT filepath, filename FROM files WHERE id = ?");
$stmt->execute([$id]);
$file = $stmt->fetch();

if ($file && file_exists($file['filepath'])) {
    header('Content-Type: application/octet-stream');
    header('Content-Disposition: attachment; filename="' . $file['filename'] . '"');
    readfile($file['filepath']);
    exit;
}