Home > Article > Backend Development > How to use PHP to implement a simple online photo album function

How to use PHP to implement a simple online photo album function

WBOYOriginal: 2023-09-25 16:55:471204browse

Use PHP to implement a simple online photo album function

With the popularity of digital cameras and smartphones, it has become very easy to take and store a large number of photos. To make it easier to browse and share these photos, we can create a simple online photo album feature. PHP is a widely used programming language suitable for developing dynamic websites. The following will introduce how to use PHP to implement a simple online photo album, and provide specific code examples.

Preparation
First, we need to install PHP on the web server. Apache, PHP, and MySQL can be installed using packages such as XAMPP, WAMP, or MAMP so they can be debugged in a local development environment. At the same time, a database is needed to store the album information, and MySQL or other databases can be used. In this article, we will use the MySQL database.

Create database and table
Create a new database in the MySQL database and name it "gallery". Then create a table named "photos" with the following columns: id, filename, title, and description.

PHP code implementation
First, create a file named "index.php" as the home page of the album. The homepage will display thumbnails of all the photos and provide links to each photo's page.

<!DOCTYPE html>
<html>
<head>
    <title>在线相册</title>
    <style>
        .thumbnail {
            width: 200px;
            height: 200px;
            object-fit: cover;
        }
    </style>
</head>
<body>
    <h1>我的相册</h1>

    <?php
    $db = mysqli_connect("localhost", "username", "password", "gallery");
    $query = "SELECT * FROM photos";
    $result = mysqli_query($db, $query);

    while ($row = mysqli_fetch_assoc($result)) {
        $id = $row['id'];
        $filename = $row['filename'];
        $title = $row['title'];

        echo '<a href="photo.php?id=' . $id . '">';
        echo '<img src="images/' . $filename . '" alt="' . $title . '" class="thumbnail">';
        echo '</a>';
    }

    mysqli_close($db);
    ?>

</body>
</html>

Then, create a file called "photo.php" that displays the details of a single photo.

<!DOCTYPE html>
<html>
<head>
    <title>照片详情</title>
</head>
<body>
    <?php
    $db = mysqli_connect("localhost", "username", "password", "gallery");
    $id = $_GET['id'];

    $query = "SELECT * FROM photos WHERE id = $id";
    $result = mysqli_query($db, $query);
    $row = mysqli_fetch_assoc($result);

    $filename = $row['filename'];
    $title = $row['title'];
    $description = $row['description'];

    echo '<h1>' . $title . '</h1>';
    echo '<img src="images/' . $filename . '" alt="' . $title . '">';
    echo '<p>' . $description . '</p>';

    mysqli_close($db);
    ?>

</body>
</html>

Please replace "username" and "password" in the code with your database username and password, and make sure there are corresponding image files in the images folder.

Upload photos
In order to upload photos to the album, we can create a file named "upload.php". The file will provide a simple form where the user can select a photo file and enter a title and description.

<!DOCTYPE html>
<html>
<head>
    <title>上传照片</title>
</head>
<body>
    <h1>上传照片</h1>

    <?php
    if ($_SERVER['REQUEST_METHOD'] === 'POST') {
        $db = mysqli_connect("localhost", "username", "password", "gallery");

        $file = $_FILES['photo'];
        $filename = $file['name'];
        $title = $_POST['title'];
        $description = $_POST['description'];

        $target = 'images/' . $filename;
        move_uploaded_file($file['tmp_name'], $target);

        $query = "INSERT INTO photos (filename, title, description) VALUES ('$filename', '$title', '$description')";
        mysqli_query($db, $query);

        echo '<p>照片已上传成功！</p>';

        mysqli_close($db);
    }
    ?>

    <form action="upload.php" method="post" enctype="multipart/form-data">
        <input type="file" name="photo" required>
        <input type="text" name="title" placeholder="标题" required>
        <textarea name="description" placeholder="描述" required></textarea>
        <button type="submit">上传</button>
    </form>

</body>
</html>

The above code implements a simple online photo album function. Users can add photos to the album through the photo upload form, and browse and view detailed information about each photo on the homepage.

Summary
By using PHP and MySQL, we can easily create a simple online photo album function. This makes browsing and sharing photos even more convenient. Hopefully the above code examples will help you get started building your own online photo album project.

The above is the detailed content of How to use PHP to implement a simple online photo album function. For more information, please follow other related articles on the PHP Chinese website!

php mysql 数据库 apache

Statement：

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Previous article：How to use PHP to develop a simple classified information publishing systemNext article：How to use PHP to develop a simple classified information publishing system

See more

How to use PHP to implement a simple online photo album function

Related articles