Skip to content

A simple PHP web application showcasing photo upload and display functionality. Users can input their details, upload photos, and view a table of user information, including uploaded photos.

Notifications You must be signed in to change notification settings

AmanKumarSinhaGitHub/Image-Upload-and-Display-using-PHP-MySQL

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

1 Commit
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Photo Upload and Display - PHP Assignment

This PHP project is a simple web application that allows users to input details, upload photos, and displays user information, including photos.

Prerequisites

  • PHP development environment (e.g., XAMPP, WampServer).
  • MySQL database.
  • Create a "uploads" folder in the project directory to store uploaded images.

Getting Started

  1. Clone or download the project to your local machine.
  2. Set up your MySQL database and update the connection details in connect.php.
  3. Create a folder named "uploads" in the project directory.
  4. Open the project in your PHP development environment.

Database Setup

  1. Create a MySQL database named "assignment":

    CREATE DATABASE assignment;
  2. Create a "user" table within the database:

    CREATE TABLE user (
      id INT AUTO_INCREMENT PRIMARY KEY,
      name VARCHAR(255) NOT NULL,
      description TEXT,
      photo VARCHAR(255)
    );

File Structure

  • connect.php: Database connection details.
  • index.php: User input form and photo upload.
  • handleInput.php: Handles form submission, uploads photos, and inserts user details into the database.
  • displayUserDetails.php: Displays user details, including photos, in a table.

Usage

1. Input User Details and Upload Photo

Open index.php in your browser, fill in the form with user details, select a photo, and click "Submit." The photo will be uploaded to the "uploads" folder, and user details will be stored in the database.

<!-- index.php -->

<!-- ... -->

<form action="handleInput.php" method="post" enctype="multipart/form-data">
  <!-- ... -->

  <!-- Input field for user's photo -->
  <div class="mb-3">
    <label for="photo" class="form-label">Photo</label>
    <input type="file" class="form-control" id="photo" name="photo" accept="image/*">
  </div>

  <!-- ... -->

  <button type="submit" class="btn btn-primary" name="submit">Submit</button>
</form>

<!-- ... -->

2. Display User Details with Photos

Visit displayUserDetails.php in your browser to view a table displaying user details, including photos.

<!-- displayUserDetails.php -->

<!-- ... -->

<!-- Loop through each user record -->
while ($row = mysqli_fetch_assoc($result)) {
  $id = $row["id"];
  $name = $row["name"];
  $description = $row["description"];
  $photo = $row["photo"];

  echo
    '<tr>
      <th scope="row">' . $id . '</th>
      <td>' . $name . '</td>
      <td>' . $description . '</td>

      <!-- Display user photo -->
      <td><img src="uploads/' . $photo . '" alt="User Photo" style="width: 75px; height: 75px;"></td>
    </tr>';
}

<!-- ... -->

More

CRUD APP using PHP MySQl

Live Demo

About

A simple PHP web application showcasing photo upload and display functionality. Users can input their details, upload photos, and view a table of user information, including uploaded photos.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published