php实现创建相册
PHP实现创建相册的方法
数据库准备
创建一个数据库表用于存储相册信息,例如:
CREATE TABLE albums (
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(255) NOT NULL,
description TEXT,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
创建相册表单
设计一个HTML表单用于提交相册信息:

<form action="create_album.php" method="post">
<input type="text" name="name" placeholder="相册名称" required>
<textarea name="description" placeholder="相册描述"></textarea>
<button type="submit">创建相册</button>
</form>
处理表单提交
创建PHP脚本(create_album.php)处理表单数据并插入数据库:
<?php
$db = new PDO('mysql:host=localhost;dbname=your_database', 'username', 'password');
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
$name = $_POST['name'];
$description = $_POST['description'];
$stmt = $db->prepare("INSERT INTO albums (name, description) VALUES (?, ?)");
$stmt->execute([$name, $description]);
header('Location: albums.php'); // 跳转到相册列表页
exit;
}
?>
显示相册列表
创建albums.php页面展示所有相册:

<?php
$db = new PDO('mysql:host=localhost;dbname=your_database', 'username', 'password');
$albums = $db->query("SELECT * FROM albums")->fetchAll(PDO::FETCH_ASSOC);
foreach ($albums as $album) {
echo "<div class='album'>
<h3>{$album['name']}</h3>
<p>{$album['description']}</p>
</div>";
}
?>
安全增强
对用户输入进行过滤和验证:
$name = filter_input(INPUT_POST, 'name', FILTER_SANITIZE_STRING);
$description = filter_input(INPUT_POST, 'description', FILTER_SANITIZE_STRING);
文件上传功能
如需支持上传图片到相册,可扩展表单和PHP处理逻辑:
<input type="file" name="photos[]" multiple>
foreach ($_FILES['photos']['tmp_name'] as $key => $tmp_name) {
move_uploaded_file($tmp_name, "uploads/" . $_FILES['photos']['name'][$key]);
}






