PHP代码不工作,没有提到任何错误


PHP code not working and no errors mentioned

我试着找出这个错误已经有一段时间了。甚至尝试过尝试接球,但都无济于事。我得到的输出是"查询失败"(这是其他部分)。此外,该代码在另一台机器上工作。有人能帮我弄清楚吗?

<?php
session_start();
//Include database connection details
    require_once('connect.php');
    //Array to store validation errors
    $errmsg_arr = array();
    //Validation error flag
    $errflag = false;
//Function to sanitize values received from the form. Prevents SQL injection
    function clean($str) {
    $str = @trim($str);
    if(get_magic_quotes_gpc()) {
        $str = stripslashes($str);
    }
    return mysql_real_escape_string($str);
}
    try {
    //Sanitize the POST values
    $username = clean($_POST['username']);
    $phone = clean($_POST['phone']);
    /*$username = 'Ajay M';
    $phone = '9810827804';*/
    //Input Validations
    if($username == '') {
        $errmsg_arr[] = 'Username missing';
        $errflag = true;
    }
    if($phone == '') {
        $errmsg_arr[] = 'phone missing';
        $errflag = true;
    }
//If there are input validations, redirect back to the login form
if($errflag) {
    $_SESSION['ERRMSG_ARR'] = $errmsg_arr;
    session_write_close();
    header("location: log.php");
    exit();
}
//Create query
        $qry="SELECT * FROM app_user WHERE name='$username' AND phone='$phone'";
    $result=mysql_query($qry);
    //Check whether the query was successful or not
    if($result) {
        if(mysql_num_rows($result) > 0) {
            //Login Successful
            session_regenerate_id();
            $member = mysql_fetch_assoc($result);
            $_SESSION['SESS_MEMBER_ID'] = $member['id'];
            $_SESSION['SESS_NAME'] = $member['username'];
            $_SESSION['SESS_PHONE'] = $member['phone'];
            session_write_close();
            header("location: suzuki_home.php");
            exit();
        }else {
            //Login failed
            $errmsg_arr[] = 'user name and phone not found';
            $errflag = true;
            if($errflag) {
                $_SESSION['ERRMSG_ARR'] = $errmsg_arr;
                session_write_close();
                header("location: fail.php");
                exit();
            }
        }
    }else {
        die("Query failed");
    }
}
catch (Exception $e) {
    echo ($e->getMessage());
}
?>

nameMySQL上的保留字。因此,在查询中使用回溯标记将列名括起来。

$qry="SELECT * FROM `app_user` WHERE `name`='$username' AND `phone`='$phone'";

错误报告必须在.ini文件中设置,但也可以在.php文件中设置:

ini_set("display_errors", true);
error_reporting(E_ALL);