Login with two tables

Question

Gale do not know if I did correctly, I have 2 users, admin and distributor, I created 2 tables, do not know if I did the correct, admin has only id name email and password, already the distributor has id name email password and other more fields.... is it correct to create 2 separate tables, or a single table for the 2 users ? As I made 2 tables, I enclosed in the following: in the login I did with only one table...but I need the 2 users to login..

a CRUD of life is like this :

public function select($fields,$table,$cond,$exec){
    $this->prepExc('SELECT '.$fields.' FROM '.$table.' '.$cond.' ',$exec);
    return $this->query;
}

i have this login class :

$this->log = $this->senha == $senha?
        $this->crud->select('*','administrador','WHERE email = ? && senha = ?',array($this->email,$this->cpt->setCripto($this->senha))):
        FALSE;

galera how to log in in this case of 2 tables ?

Answer 1

Solved In my case I decided to make my system creating a table of users only for login question Table users id email password

other type tables Distributor table tel address

if($usuario->select('email','users','WHERE email=? ',array($email))->rowCount() > 0)

print 'email already registered';

Answer 2

You can then do the following procedure:

Check in table A, if e-mail and password exists, if it returns true, check if they are correct, if it returns false, pass the next check in table B, or return false.

Example:

$consultaA = mysqli_query($conexao, "
    SELECT * FROM 
        tabela1 
    WHERE 
        email = '".$_POST['email']."' 
    AND 
        senha '".$_POST['senha']."'
");

if(mysqli_num_rows($consultaA)>0){  
    echo "Logar Administrador"; 
} else {
    $consultaB = mysqli_query($conexao, "
        SELECT * FROM 
            tabela2 
        WHERE 
            email = '".$_POST['email']."' 
        AND 
            senha '".$_POST['senha']."'
    ");

    if(mysqli_num_rows($consultaB)>0){  
        echo "Logar Usuário";       
    } else {    
        echo "Login ou senha inexistente";      
    }
}