PHP5.3开发的teachers.php在BlueHost PHP4.3服务器无法运行问题排查

Hey there, let's figure out why your teacher tracking page works locally on PHP 5.3 but breaks on BlueHost's PHP 4.3 server. The main culprit is PHP 4.3 doesn't support the mysqli extension (it was introduced officially in PHP 5), plus a few small version-specific quirks. Let's walk through each problem and the best fixes:

1. Big Issue: mysqli Functions Don't Exist in PHP 4.3 #

Your code relies heavily on mysqli_* functions like mysqli_real_escape_string, mysqli_query, and mysqli_num_rows—but PHP 4.3 only supports the older mysql_* extension. This is almost certainly what's causing the page to fail entirely.

Fix: Replace All mysqli Calls with mysql Equivalents #

Note that the parameter order is different for some functions! Here's how to swap them out:

• mysqli_real_escape_string($con, $value) → mysql_real_escape_string($value, $con) (connection comes second in PHP 4's version)
• mysqli_query($con, $sql) → mysql_query($sql, $con)
• mysqli_num_rows($result) → mysql_num_rows($result)
• Don't forget to update your scripts/connect_db.php too—swap mysqli_connect() with mysql_connect() (example below).

2. Other Small Compatibility Tweaks #

(1) Secure session_start() Execution #

PHP 4.3 requires session_start() to run before any output at all (even stray spaces or HTML tags). Make sure your connect_db.php file doesn't have any accidental output (like extra spaces before <?php), otherwise sessions won't initialize correctly. Also, add exit; after header redirects to stop code from running further:

if(!isset($_SESSION['teacher'])) {
    header('Location: teacher_login.php');
    exit; // Critical for PHP 4.3 to prevent unwanted execution
}

(2) Ditch Unnecessary @ Error Suppression #

While @ works in PHP 4, it hides useful debug info and can mask real issues. Replace lines like @mysqli_real_escape_string(...) with explicit checks for empty values:

// Old: $quiz = @mysqli_real_escape_string($con,$_POST['quiz']);
// New:
$quiz = !empty($_POST['quiz']) ? mysql_real_escape_string($_POST['quiz'], $con) : 'non';

(3) Tighten Array Checks #

Instead of count($array_one) != 0, use !empty($array_one)—it's more readable and works the same way in both PHP versions.

Full Fixed Code Snippet #

Here's the adjusted version of your core code, with all PHP 4.3 compatibility fixes applied:

<?php
require_once("scripts/connect_db.php"); 
session_start(); 

if(!isset($_SESSION['teacher'])) {
    header('Location: teacher_login.php');
    exit;
}

$result = ""; 
if (isset($_POST["logout"])) { 
    session_destroy(); 
    header('Location: index.php');
    exit;
}

$err = ""; 
if (isset($_POST["add_class"]) && !empty($_POST['class_names']) && $_SESSION['teacher']) { 
    $class_name = mysql_real_escape_string($_POST['class_names'], $con); 
    $school_pin = $_SESSION['teacher_school_pin']; 
    $teacher_username = $_SESSION['teacher_username']; 
    $teacher_id = $_SESSION['teacher_id']; 
    $query = mysql_query("INSERT INTO classes (teacher_username, teacher_id, school_pin, class_name) VALUES('$teacher_username','$teacher_id', '$school_pin', '$class_name')", $con); 
}

if (isset($_POST["track_button"])) { 
    $var = mysql_real_escape_string($_POST['user_name'], $con); 
    $quiz = !empty($_POST['quiz']) ? mysql_real_escape_string($_POST['quiz'], $con) : 'non'; 
    $school_pin = !empty($_POST['school_pin']) ? mysql_real_escape_string($_POST['school_pin'], $con) : ''; 
    $class_name = !empty($_POST['class_name']) ? mysql_real_escape_string($_POST['class_name'], $con) : ''; 
    $top = !empty($_POST['top']) ? mysql_real_escape_string($_POST['top'], $con) : ''; 

    $array_one = comma_separated_to_array($var); 
    $query_conditions = array(); 

    if($quiz != "non"){ 
        array_push($query_conditions," quiz_id=".$quiz." "); 
    } 
    if(!empty($array_one)){ 
        array_push($query_conditions," username IN ('".implode("','",$array_one)."') "); 
    } 
    if(!empty($class_name) && $class_name !== "all"){ 
        array_push($query_conditions," class_name='".$class_name."' "); 
    } 
    if(!empty($school_pin)){ 
        array_push($query_conditions," school_pin='".$school_pin."' "); 
    } 

    $sql_base = "SELECT " . ($quiz == "non" ? "DISTINCT username" : "*") . " FROM quiz_takers WHERE ";
    $sql = $sql_base . implode(" AND ",$query_conditions) . " ORDER BY percentage DESC LIMIT ".$top;
    
    $result = mysql_query($sql, $con); 
    if(!$result) {
        $err = "Enter Your student data to Track, Please!"; 
    } elseif(mysql_num_rows($result) == 0){ 
        $err = "No Result Found!"; 
    } 
} 

// Escape session data to prevent SQL injection
$escaped_teacher_username = mysql_real_escape_string($_SESSION['teacher_username'], $con);
$all_classes = mysql_query("SELECT class_name FROM classes WHERE teacher_username='".$escaped_teacher_username."'", $con);
?>

Critical: Update Your Database Connection File #

Your scripts/connect_db.php needs to use mysql functions instead of mysqli. Here's a compatible version:

<?php
// Replace with your actual database credentials
$host = "localhost";
$user = "your_db_username";
$pass = "your_db_password";
$db_name = "your_db_name";

$con = mysql_connect($host, $user, $pass);
if (!$con) {
    die('Could not connect to database: ' . mysql_error());
}
mysql_select_db($db_name, $con);
?>

Extra Tips for Debugging #

• Enable error reporting temporarily to catch any leftover issues:

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

• Keep in mind: PHP 4.3 is extremely outdated and insecure. If possible, ask BlueHost to upgrade your server to a supported PHP version (even PHP 5.6 would be a huge improvement). But for now, the fixes above should get your page running.

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