用php登录sql,sql / php - 验证用户登录

尝试在php上验证用户登录。即使我使用正确的信息，我也只是被发送到'index2.php'。任何想法我应该如何调试这个或我需要做什么？

谢谢

**我还将查询更改为SELECT COUNT(ID)FROM CUSTOMER

并将if语句设置为“if($ result> 1){”

但仍然发送到'index2.php'

// ----------------------

// Retrieve login information

include("db_info.php");

// ----------------------

// Connect to database

$conn = oci_connect($db_user, $db_pwd, '(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(Host=*****.edu)(Port=1521)))(CONNECT_DATA=(SID=asuka)))');

if (!$conn) {

$e = oci_error();

print_r($e);

exit();

}

// ----------------------

// Authenticate User

// Create query

$sql = "SELECT COUNT(ID) FROM CUSTOMER WHERE EMAIL='$email' AND PASSWORD='$password'";

// Create database query statement

$statement_id = oci_parse($conn, $sql);

// Execute query statement

$result = oci_execute($statement_id, OCI_COMMIT_ON_SUCCESS);

// Check for successful authentication

if ($result==1) {

if ($email=="admin@hotmail.com") {

$db_login_status = 2;

header("location: index1.php");

} else {

$db_login_status = 1;

header("location: index.php");

}

} else {

header("location: index2.php");

}

// ----------------------

// Close connections

oci_free_statement($statement_id);

oci_close($conn);