/dao/LoginDao.php
https://bitbucket.org/denissilva/cgpdi_admin · PHP · 28 lines · 26 code · 2 blank · 0 comment · 1 complexity · bc2105c2f4eea01acaeb1416def1ad54 MD5 · raw file
- <?php
- require_once ('../../classes/Login.php');
- require_once ('../../classes/Database.php');
- class LoginDao {
- private $conexao;
- public function __construct(){
- $db = new Database();
- $this->conexao = $db->getConection();
- }
- public function logar(Login $login) {
- try {
- $sql = "SELECT * FROM usuarios_novo WHERE email = '{$login->getEmail()}' AND senha = '{$login->getSenha()}'";
- $result = $this->conexao->query($sql);
- $rows = array();
- if($result->num_rows > 0) {
- while($row = $result->fetch_assoc()) {
- $rows[] = $row;
- }
- }
- return json_encode($rows);
- } catch (Exception $ex) {
- echo $ex->getMessage();
- }
- }
- }
- ?>