PHP脚本持续运行无法终止，新手求助登录应用问题排查

Hey there! Let's figure out why your PHP + MySQL login app is stuck in an endless loop—this is a super common snag for new devs, so let's walk through the fixes step by step:

1. First: Fix Your Database Connection (The #1 Culprit) #

A misconfigured or stuck DB connection is almost always the reason scripts hang. Let's audit your connection.php and config.php:

• Add strict error reporting to your connection file immediately. This will stop PHP from silently failing and hanging, and instead tell you exactly what's wrong:

  mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
  $conn = mysqli_connect(DB_HOST, DB_USER, DB_PASS, DB_NAME);
  

• Double-check your config.php credentials for typos. A wrong host (like using localhost instead of 127.0.0.1 on some setups) or misspelled database name will make PHP wait forever for a connection that never happens.
• Make sure you're not accidentally keeping the connection open unnecessarily. While PHP usually closes connections automatically, explicitly calling mysqli_close($conn); after your login query can rule out lingering connections.

2. Debug Your Login Logic in login.php #

Let's narrow down where the script gets stuck using simple debug checks:

• Add debug logs at key points to see how far the script runs before hanging. For example:

  // Log that Postman data was received
  error_log("Received login data: " . print_r($_POST, true));
  
  // Log after DB connection
  error_log("Successfully connected to database");
  
  // Log after query execution
  error_log("Login query completed");
  

  Check your PHP error log (look in your server's log folder—XAMPP/WAMP/MAMP all have dedicated log sections) to see which log line is the last one appearing. That's where the hang is happening.
• Watch for infinite loops: Double-check any while or for loops in your login code. A loop without a proper exit condition (like while(true) with no break) will lock up the script instantly.
• Optimize your login query: If you're pulling all user data with SELECT * FROM users instead of targeting the specific user with a WHERE clause, it might be taking forever to load large datasets. Use a prepared statement (way more secure too!) like this:

  $stmt = $conn->prepare("SELECT id FROM users WHERE username = ?");
  $stmt->bind_param("s", $_POST['username']);
  $stmt->execute();
  

  Quick side note: Never store plain-text passwords—use password_hash() when saving passwords and password_verify() when checking them!

3. Check Postman & Server Settings #

• In Postman, confirm you're sending a POST request with the correct Content-Type. If you're sending form data, use application/x-www-form-urlencoded; if using JSON, use application/json. Mismatched types can make PHP wait for data that never arrives.
• Test with a shorter execution timeout: Temporarily add ini_set('max_execution_time', 10); at the top of login.php. If the script times out after 10 seconds, you know it's a hang rather than a slow process.
• Restart your local server (Apache/MySQL). Sometimes weird glitches get fixed with a quick restart—don't overlook this simple step!

4. Simplify to Isolate the Problem #

If you're still stuck, strip down your code to the absolute minimum:

• Create a test script that only connects to the database and echoes "Connected!" If this hangs, the problem is definitely in your connection setup.
• If the connection works, add one piece of functionality at a time (first handling POST data, then running the login query) until the script hangs again. This will pinpoint exactly which part is causing the issue.

I’ve wasted hours debugging similar hangs before, so breaking it down piece by piece will almost always reveal the fix. If you share snippets of your code, we can dig even deeper!

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