PHP使用两个mysql表中的详细信息登录

Question

I looking for a way to login by using details from two mysql tables. I made a code and everything works fine but when I login it show the message that the email or password is incorrect and then login successfully.

Here is my code:

if(isset($_POST['submit']))
{
    $email = $_POST['Email'];  
    $password = $_POST['password'];

    $checkUser1 = "SELECT * FROM table1 where theEmail  = '$email' AND thePass = '$password' ";
    $checkUser2 = "SELECT * FROM table2 where theEmail  = '$email' AND thePass = '$password' ";

    $run = mysql_query($checkUser1,$checkUser2);

    if (mysql_num_rows($run) > 0){
        $_SESSION['Email']= $email;   

        echo "<script>window.open('HomePage.php','_self')</script>";      
    } else {
        echo "<script>alert('incorrect email or password  !')</script>";
    }
}

Answer 1

I'm going to skip over the fact that you:

1. Shouldn't store passwords in plain text; use bcrypt or password_hash() instead.
2. Should use prepared statements (PDO / mysqli) and drop the use of deprecated mysql_ functions; alternatively make sure to escape all user input.
3. Should only use a single table to store user credentials.

You can simply use a JOIN:

$checkUser = sprintf("SELECT * 
    FROM table1 
    INNER JOIN table2 USING (theEmail)
    WHERE table1.theEmail = '%s' AND table1.thePass = '%s'",
        mysql_real_escape_string($email),
        mysql_real_escape_string($password)
);
mysql_query($checkUser) or die("Oops!");