PHP图片与文本同时上传至数据库失败求助

Hey there! Let's troubleshoot why your combined image and text upload isn't saving to the database properly. Since you're new to PHP, I'll break this down into simple, actionable steps.

1. Double-Check Your Form's enctype Attribute #

This is the most common mistake when uploading files alongside text! Your HTML form must include enctype="multipart/form-data"—without it, PHP can't receive both file and text data at the same time. Here's what a valid form should look like:

<form action="your-upload-script.php" method="POST" enctype="multipart/form-data">
  <!-- Text input field -->
  <input type="text" name="post_title" placeholder="Enter title">
  <!-- File upload field -->
  <input type="file" name="uploaded_image">
  <button type="submit" name="upload">Submit</button>
</form>

2. Debug Your Inputs First #

Since your image saves to the folder but the database fails, let's confirm PHP is actually receiving your text data. Add these debug lines at the top of your script (you can delete them later):

// Print all received text data
var_dump($_POST);
// Print all received file data
var_dump($_FILES);

If your text fields don't show up in the $_POST output, either your form's name attributes are misspelled, or you forgot the enctype from step 1.

3. Catch Database Errors Directly #

The "failed" message isn't helpful on its own—let's make PHP tell us exactly why the database insert failed. Here's how to add error reporting for both mysqli and PDO:

For mysqli: #

// After preparing your SQL statement
$stmt = mysqli_prepare($conn, "INSERT INTO your_table (title, image_path) VALUES (?, ?)");
mysqli_stmt_bind_param($stmt, "ss", $your_text_var, $image_path);

if(mysqli_stmt_execute($stmt)) {
  echo "Success!";
} else {
  // This will show the exact database error
  echo "Database Error: " . mysqli_stmt_error($stmt);
}

For PDO: #

try {
  $stmt = $pdo->prepare("INSERT INTO your_table (title, image_path) VALUES (?, ?)");
  $stmt->execute([$your_text_var, $image_path]);
  echo "Success!";
} catch(PDOException $e) {
  echo "Database Error: " . $e->getMessage();
}

Common errors here include misspelled column names, missing required fields, or data type mismatches (e.g., trying to insert a string into a numeric column).

4. Validate Required Fields #

If your database has NOT NULL constraints on text fields, an empty input will cause the insert to fail. Add quick checks before hitting the database:

$post_title = isset($_POST['post_title']) ? trim($_POST['post_title']) : '';

if(empty($post_title)) {
  die("Please enter a title before uploading!");
}

5. Working Example Code #

Here's a simplified, tested script you can compare to your own code:

<?php
include_once 'dbh.inc.php';
session_start();

if(isset($_POST['upload'])) {
  // 1. Grab and validate text input
  $post_title = trim($_POST['post_title']);
  if(empty($post_title)) {
    die("Error: Title cannot be empty!");
  }

  // 2. Handle image upload
  $target_dir = "uploads/";
  $file_name = basename($_FILES["uploaded_image"]["name"]);
  $target_file = $target_dir . $file_name;
  $allowed_types = ['jpg', 'png', 'jpeg', 'gif'];
  $file_type = strtolower(pathinfo($target_file, PATHINFO_EXTENSION));

  // Validate image type
  if(in_array($file_type, $allowed_types)) {
    // Save image to folder
    if(move_uploaded_file($_FILES["uploaded_image"]["tmp_name"], $target_file)) {
      // 3. Insert into database with prepared statement (prevents SQL injection)
      $stmt = mysqli_prepare($conn, "INSERT INTO posts (title, image_url) VALUES (?, ?)");
      mysqli_stmt_bind_param($stmt, "ss", $post_title, $target_file);
      
      if(mysqli_stmt_execute($stmt)) {
        echo "Upload successful! Data saved to database.";
      } else {
        echo "Database save failed: " . mysqli_stmt_error($stmt);
      }
      mysqli_stmt_close($stmt);
    } else {
      echo "Error: Could not save image to folder.";
    }
  } else {
    echo "Error: Only JPG, PNG, JPEG, and GIF files are allowed.";
  }
}
?>

内容的提问来源于stack exchange，提问作者Sonder Systems