PHP实现本地CSV文件上传至服务器代码求助：执行报错

Hey there! Let's get that CSV upload working smoothly. Below is a complete, tested implementation including both the frontend form and backend PHP handler, plus a breakdown of common issues that might have caused your original error.

1. Frontend HTML Form #

First, create a simple form to let users select their local CSV file:

<!DOCTYPE html>
<html>
<head>
    <title>CSV Uploader</title>
</head>
<body>
    <h2>Upload Your CSV File</h2>
    <form enctype="multipart/form-data" method="POST" action="upload.php">
        <label for="csv_file">Select CSV File:</label>
        <input type="file" name="csv_file" id="csv_file" accept=".csv" required>
        <br><br>
        <button type="submit" name="upload">Upload CSV</button>
    </form>
</body>
</html>

The enctype="multipart/form-data" is critical here—it tells the browser to send file data correctly. The accept=".csv" helps guide users to select the right file type, but we'll validate this on the server too.

2. Backend PHP Handler (upload.php) #

This script handles the file upload, validates it, and saves it to your server:

<?php
// Check if form was submitted
if (isset($_POST['upload'])) {
    // Define upload directory (create this folder first!)
    $uploadDir = 'uploads/';
    
    // Create directory if it doesn't exist
    if (!file_exists($uploadDir)) {
        mkdir($uploadDir, 0755, true);
    }

    // Get file details from the upload
    $file = $_FILES['csv_file'];
    $fileName = $file['name'];
    $fileTmpName = $file['tmp_name'];
    $fileSize = $file['size'];
    $fileError = $file['error'];
    $fileType = $file['type'];

    // Validate upload error
    if ($fileError !== UPLOAD_ERR_OK) {
        $errors = [
            UPLOAD_ERR_INI_SIZE => "File exceeds upload_max_filesize limit in php.ini",
            UPLOAD_ERR_FORM_SIZE => "File exceeds MAX_FILE_SIZE specified in the form",
            UPLOAD_ERR_PARTIAL => "File was only partially uploaded",
            UPLOAD_ERR_NO_FILE => "No file was uploaded",
            UPLOAD_ERR_NO_TMP_DIR => "Temporary folder not found",
            UPLOAD_ERR_CANT_WRITE => "Failed to write file to disk",
            UPLOAD_ERR_EXTENSION => "File upload stopped by PHP extension"
        ];
        die("Upload error: " . ($errors[$fileError] ?? "Unknown error"));
    }

    // Validate file is a CSV (server-side check)
    $fileExt = strtolower(pathinfo($fileName, PATHINFO_EXTENSION));
    $allowedExts = ['csv'];
    $allowedMimeTypes = ['text/csv', 'application/vnd.ms-excel', 'text/plain'];

    if (!in_array($fileExt, $allowedExts) || !in_array($fileType, $allowedMimeTypes)) {
        die("Error: Only CSV files are allowed");
    }

    // Generate a safe unique filename to avoid overwriting existing files
    $safeFileName = uniqid('csv_', true) . '.' . $fileExt;
    $destination = $uploadDir . $safeFileName;

    // Move the uploaded file to the target directory
    if (move_uploaded_file($fileTmpName, $destination)) {
        echo "Success! Your CSV file has been uploaded to: " . $destination;
    } else {
        die("Error: Failed to move uploaded file. Check directory permissions.");
    }
} else {
    die("Error: Form not submitted correctly");
}
?>

If you were getting errors before, check these first:

• Directory Permissions: Make sure the uploads/ folder has write permissions for your web server user. On most systems, setting permissions to 0755 works, but you might need 0777 temporarily for testing (just remember to tighten it afterward).
• PHP.ini Limits: Open your php.ini file and increase these values if needed:
  • upload_max_filesize = 10M (adjust to fit your CSV size)
  • post_max_size = 12M (should be slightly larger than upload_max_filesize)
  • max_execution_time = 30 (increase if uploading large files takes time)
• Path Traversal Risks: Never use the original filename directly without sanitizing it—our script uses uniqid() to avoid this.
• File Type Spoofing: The server-side validation checks both the file extension and MIME type to prevent fake CSV files.

内容的提问来源于stack exchange，提问作者SWAYAM MITTAL