PHP无法从SQL数据库显示请求数据：特定标签电影查询无结果

I’ve run into similar tag-related bugs before, so let’s break down the most likely culprits and targeted fixes—since you’ve already checked basics like DB config and tag presence in the database, these steps should help you zero in on the problem:

• Double-check your tag matching logic in tag.php
  This is where most of these issues hide. Let’s cover common gotchas:

  • Case sensitivity: If your database uses a case-sensitive collation (like utf8_bin), #Action won’t match #action. Either switch to a case-insensitive collation (e.g., utf8_general_ci) or adjust your query to ignore case, like:

    $sanitized_tag = mysqli_real_escape_string($conn, $tag);
    $sql = "SELECT title, poster FROM movies WHERE LOWER(tags) LIKE LOWER('%$sanitized_tag%')";
    

  • Comma-separated tag pitfalls: If your tags field stores values like #Action,#Drama, an exact match (tags = '$tag') will never work. Use a pattern that accounts for surrounding commas to avoid partial matches (like #Action incorrectly matching #ActionAdventure):

    $sanitized_tag = mysqli_real_escape_string($conn, $tag);
    $sql = "SELECT title, poster FROM movies WHERE CONCAT(',', tags, ',') LIKE '%,$sanitized_tag,%'";
    

  • Prepared statement mishaps: If you’re using prepared statements (smart move!), make sure you bind parameters correctly. For mysqli, wrap your tag in the necessary wildcards before binding:

    $stmt = $conn->prepare("SELECT title, poster FROM movies WHERE CONCAT(',', tags, ',') LIKE ?");
    $like_pattern = "%," . $tag . ",%";
    $stmt->bind_param("s", $like_pattern);
    $stmt->execute();
    

• Debug the actual query being executed
  Add a temporary debug line to tag.php to print the final SQL query before running it:

  echo "Running query: " . $sql; // Delete this line after debugging
  

  Copy that query and run it directly in your database tool (phpMyAdmin, MySQL CLI, etc.) with the exact tag you’re testing. If it returns no results, your query logic is off. If it does return results, the problem lies in how you’re fetching or displaying data.

• Confirm tag formatting in the database
  Pop open your database and check the tags field for the movie you’re testing. Is it stored with the # prefix? If your query looks for #Action but the DB has Action (no hashtag), they won’t match. Also watch for extra whitespace—if the tag is #Action (with a trailing space), your query for #Action will fail. Either clean up stored tags or use TRIM() in your query to handle spaces.

• Validate your data fetching and display code
  Even if the query returns results, you might be missing steps to show them. Double-check:

  • Are you looping through results correctly? For mysqli, use fetch_assoc() properly:

    $result = $stmt->get_result();
    if ($result->num_rows > 0) {
      while ($row = $result->fetch_assoc()) {
        // Display poster and title here
        echo "<div class='movie-card'><img src='{$row['poster']}' alt='{$row['title']}'><h3>{$row['title']}</h3></div>";
      }
    } else {
      echo "No movies under that tag";
    }
    

  • Are you using the right column names? If your poster URL is stored in poster_url but you’re calling $row['poster'], nothing will render.

• Uncover silent errors
  Just because you don’t see an error doesn’t mean there isn’t one. Enable PHP error reporting temporarily:

  error_reporting(E_ALL);
  ini_set('display_errors', 1);
  

  For mysqli, add error checks after query execution:

  if (!$stmt->execute()) {
    echo "Database Error: " . $stmt->error;
  }
  

  This might reveal typos in column names or hidden connection issues.

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