相册管理系统php

<?php
// 数据库连接
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "gallery";

$conn = new mysqli($servername, $username, $password, $dbname);

if ($conn->connect_error) {
    die("连接失败: " . $conn->connect_error);
}

// 图片上传处理
if ($_SERVER['REQUEST_METHOD'] == 'POST' && isset($_FILES['image'])) {
    $target_dir = "uploads/";
    $target_file = $target_dir . basename($_FILES["image"]["name"]);
    $imageFileType = strtolower(pathinfo($target_file,PATHINFO_EXTENSION));

    // 检查文件是否为图片
    $check = getimagesize($_FILES["image"]["tmp_name"]);
    if($check !== false) {
        if (move_uploaded_file($_FILES["image"]["tmp_name"], $target_file)) {
            echo "图片上传成功。";
        } else {
            echo "图片上传失败。";
        }
    } else {
        echo "文件不是图片。";
    }
}

// 显示图片
$sql = "SELECT * FROM images";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        echo "<img src='uploads/" . $row["filename"] . "' alt='图片'>";
    }
} else {
    echo "没有图片。";
}

$conn->close();
?>