How to Upload Images and Store File Names in a Database?

Uploading Images and Storing File Name in Database

When uploading an image to a server, it's often necessary to store the file name along with other information in a database. This allows for easy retrieval and management of the uploaded files. This question seeks to address this requirement and provides a detailed solution.

The provided form allows users to upload a photo and enter various details about a band member, such as their name, position, biography, and other bands they have been in. To process the data and store it in a database, the following code is used:

<?php

// Connect to the database
$mysqli = new mysqli("yourhost", "username", "password", "dbName");
if ($mysqli->connect_error) {
    die("Connection to database failed: " . $mysqli->connect_error);
}

// Prepare the data from the form
$name = $_POST['nameMember'];
$bandMember = $_POST['bandMember'];
$photo = $_FILES['photo']['name'];
$about = $_POST['aboutMember'];
$bands = $_POST['otherBands'];

// Prepare the SQL statement
$sql = "INSERT INTO tableName (nameMember, bandMember, photo, aboutMember, otherBands) VALUES (?, ?, ?, ?, ?)";

// Bind the parameters to the SQL statement
$stmt = $mysqli->prepare($sql);
$stmt->bind_param("sssss", $name, $bandMember, $photo, $about, $bands);

// Execute the SQL statement
$stmt->execute();

// Check if the photo was uploaded successfully
if (move_uploaded_file($_FILES['photo']['tmp_name'], "your directory/" . $photo)) {
    echo "The file ". basename( $_FILES['photo']['name']). " has been uploaded, and your information has been added to the database";
}
else {
    echo "Sorry, there was a problem uploading your file.";
}

// Close the database connection
$stmt->close();
$mysqli->close();
?>

This code first connects to the database, prepares the data and the SQL statement, binds the parameters to the SQL statement, executes the statement, and finally checks if the photo has been uploaded successfully. If the upload is successful, it prints a success message. Otherwise, it prints an error message.

By implementing this solution, you can successfully upload an image to a server and store its name and other relevant information in a database.

The above is the detailed content of How to Upload Images and Store File Names in a Database?. For more information, please follow other related articles on the PHP Chinese website!