php文件上传与下载页面连接户数据库
时间: 2024-01-02 18:05:25 浏览: 27
好的,以下是一个将文件上传和下载页面与 MySQL 数据库连接的示例代码:
上传处理代码(upload.php):
```php
<?php
// 连接数据库
$servername = "localhost";
$username = "your_username";
$password = "your_password";
$dbname = "your_database";
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
die("连接失败: " . $conn->connect_error);
}
if(isset($_FILES['file'])){
$file_name = $_FILES['file']['name'];
$file_size = $_FILES['file']['size'];
$file_tmp = $_FILES['file']['tmp_name'];
$file_type = $_FILES['file']['type'];
$file_folder = "uploads/";
$file_path = $file_folder.$file_name;
move_uploaded_file($file_tmp, $file_path);
// 将文件信息插入数据库
$sql = "INSERT INTO files (file_name, file_path, file_size, file_type) VALUES ('$file_name', '$file_path', '$file_size', '$file_type')";
if ($conn->query($sql) === TRUE) {
echo "上传成功!";
} else {
echo "上传失败: " . $sql . "<br>" . $conn->error;
}
}
$conn->close();
?>
```
下载页面代码:
```php
<!DOCTYPE html>
<html>
<head>
<title>文件下载页面</title>
</head>
<body>
<h2>下载文件</h2>
<ul>
<?php
// 连接数据库
$servername = "localhost";
$username = "your_username";
$password = "your_password";
$dbname = "your_database";
$conn = new mysqli($servername, $username, $password, $dbname);
if ($conn->connect_error) {
die("连接失败: " . $conn->connect_error);
}
// 从数据库中获取文件信息
$sql = "SELECT file_name, file_path FROM files";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
$file_name = $row["file_name"];
$file_path = $row["file_path"];
echo "<li><a href='".$file_path."' download>".$file_name."</a></li>";
}
} else {
echo "没有文件可下载";
}
$conn->close();
?>
</ul>
</body>
</html>
```
在这个示例中,我们将文件信息存储在一个名为 `files` 的表中。在上传处理代码中,我们将文件信息插入该表中。在下载页面中,我们从该表中获取文件信息,并创建下载链接。您需要根据您的实际情况更改数据库连接信息和表结构。