如何使用PHP将文件上传到服务器时将文件名存储在数据库中以及其他信息？

要使用PHP将文件上传到服务器并将文件名存储在数据库中，您需要遵循以下步骤：

创建一个HTML表单，允许用户选择要上传的文件。

<form action="upload.php" method="post" enctype="multipart/form-data">
   <input type="file" name="fileToUpload" id="fileToUpload">
   <input type="submit" value="Upload File" name="submit">
</form>

在服务器上创建一个PHP文件（例如：upload.php），以处理表单提交并将文件上传到服务器。

<?php
$target_dir = "uploads/";
$target_file = $target_dir . basename($_FILES["fileToUpload"]["name"]);
$uploadOk = 1;
$imageFileType = strtolower(pathinfo($target_file,PATHINFO_EXTENSION));

// Check if image file is a actual image or fake image
if(isset($_POST["submit"])) {
    $check = getimagesize($_FILES["fileToUpload"]["tmp_name"]);
    if($check !== false) {
        echo "File is an image - " . $check["mime"] . ".";
        $uploadOk = 1;
    } else {
        echo "File is not an image.";
        $uploadOk = 0;
    }
}

// Check if file already exists
if (file_exists($target_file)) {
    echo "Sorry, file already exists.";
    $uploadOk = 0;
}

// Allow certain file formats
if($imageFileType != "jpg" && $imageFileType != "png" && $imageFileType != "jpeg"
&& $imageFileType != "gif" ) {
    echo "Sorry, only JPG, JPEG, PNG & GIF files are allowed.";
    $uploadOk = 0;
}

// Check if $uploadOk is set to 0 by an error
if ($uploadOk == 0) {
    echo "Sorry, your file was not uploaded.";
// if everything is ok, try to upload file
} else {
    if (move_uploaded_file($_FILES["fileToUpload"]["tmp_name"], $target_file)) {
        echo "The file ". basename( $_FILES["fileToUpload"]["name"]). " has been uploaded.";
    } else {
        echo "Sorry, there was an error uploading your file.";
    }
}
?>

在上传文件后，将文件名和其他信息存储在数据库中。

<?php
// Connect to database
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "myDB";

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

// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

// Prepare and bind statement
$stmt = $conn->prepare("INSERT INTO files (file_name, file_type, file_size) VALUES (?, ?, ?)");
$stmt->bind_param("ssi", $file_name, $file_type, $file_size);

// Set parameters and execute
$file_name = basename( $_FILES["fileToUpload"]["name"]);
$file_type = $_FILES["fileToUpload"]["type"];
$file_size = $_FILES["fileToUpload"]["size"];
$stmt->execute();

echo "New record created successfully";

$stmt->close();
$conn->close();
?>

在数据库中创建一个名为“files”的表，以存储文件名、文件类型和文件大小。

CREATE TABLE files (
    id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    file_name VARCHAR(30) NOT NULL,
    file_type VARCHAR(30) NOT NULL,
    file_size INT(10) UNSIGNED NOT NULL
);

通过遵循这些步骤，您可以使用PHP将文件上传到服务器，并将文件名和其他信息存储在数据库中。