/dao/LoginDao.php

https://bitbucket.org/denissilva/cgpdi_admin · PHP · 28 lines · 26 code · 2 blank · 0 comment · 1 complexity · bc2105c2f4eea01acaeb1416def1ad54 MD5 · raw file

  1. <?php
  2. require_once ('../../classes/Login.php');
  3. require_once ('../../classes/Database.php');
  4. class LoginDao {
  5. private $conexao;
  6. public function __construct(){
  7. $db = new Database();
  8. $this->conexao = $db->getConection();
  9. }
  10. public function logar(Login $login) {
  11. try {
  12. $sql = "SELECT * FROM usuarios_novo WHERE email = '{$login->getEmail()}' AND senha = '{$login->getSenha()}'";
  13. $result = $this->conexao->query($sql);
  14. $rows = array();
  15. if($result->num_rows > 0) {
  16. while($row = $result->fetch_assoc()) {
  17. $rows[] = $row;
  18. }
  19. }
  20. return json_encode($rows);
  21. } catch (Exception $ex) {
  22. echo $ex->getMessage();
  23. }
  24. }
  25. }
  26. ?>