PHP表单查询无法更新数据库，迷你邮件/聊天标记功能失效求助

Hey there, let's work through this issue step by step!

First, let's recap the key details you shared:

• Your project has a mini mail/chat system with mark messages as read and tag users functionality, which broke after modifying some code
• The project doesn't support newer PHP versions
• Relevant data points:
  • $m['id'] = 22
  • $m['read'] = 0 (unread state)
  • Query 1: array(3) { ["id"]=> string(2) "28" ["mark_read_x"]=> string(2) "10" ["mark_read_y"]=> string(2) "10" }
  • Query 2: array(3) { ["id"]=> string(2) "28" ...

1. Fix the Mismatched Message ID First #

This jumps out immediately: your target message ID is 22, but both queries are using ID 28. That's almost certainly a critical issue:

• Double-check if you accidentally hardcoded ID 28 somewhere when modifying code, or if the frontend is passing the wrong ID to the backend.
• Verify the logic that fetches the current message ID (the one stored in $m['id'])—is it correctly pulling the ID of the message the user is trying to interact with, not a random/old one?

2. Audit the "Mark as Read" Database Update Logic #

Since $m['read'] is 0 (unread), let's make sure your update logic is solid:

• First, check if your SQL statement handles the reserved word read correctly. In MySQL, you need to wrap it in backticks, otherwise the query will fail silently:

  $sql = "UPDATE messages SET `read` = 1 WHERE id = ?";
  

• Confirm you're binding the correct ID ($m['id'] = 22) to the query, not the 28 from your sample queries.
• After executing the query, check how many rows were affected: use mysqli_affected_rows($connection) (for mysqli) or $pdo->rowCount() (for PDO). If it returns 0, your query isn't targeting the right row.

3. Debug the "Tag User" Functionality #

This is likely tied to the ID mismatch, but here's what to check:

• Does the tagging logic rely on the correct message ID? If you're passing 28 instead of 22, the tag will be applied to the wrong message (or no message at all).
• Verify the table joins if tagging involves linking messages and users tables—make sure the join condition uses the correct message ID column.

4. Rule Out PHP Version Compatibility Issues #

Since your project doesn't support newer PHP versions, check if your recent code changes used syntax/functions that aren't supported:

• Did you use PHP 7+ features like the null coalescing operator (??), type declarations, or PHP 8+ functions like str_contains()? These will throw errors in older versions, breaking functionality.
• Enable PHP error logging and check for syntax errors, undefined functions, or deprecated warnings—these often cause features to fail silently.

5. Quick Debugging Tips #

• Print variables at key steps: Before executing the mark/tag action, print the target message ID, user ID, and any relevant parameters to confirm they match what you expect.
• Print the full executed SQL: After binding parameters, output the final SQL string and run it directly in your database client—this will tell you if the query itself is valid.
• Check frontend requests: Use your browser's dev tools to inspect the network request sent when triggering the action—make sure the correct message ID is being sent to the backend.

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