Guest User

Untitled

a guest
Feb 3rd, 2018
202
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.93 KB | None | 0 0
  1. <?php
  2.  
  3. //Minha conexão
  4. $host = 'localhost';
  5. $dbname = 'testar';
  6. $user = 'root';
  7. $pass = 'root123';
  8.  
  9. try {
  10.  
  11. $conn = new PDO(sprintf('mysql:host=%s;dbname=%s', $host, $dbname), $user, $pass);
  12. $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
  13. $conn->exec('SET NAMES utf8');
  14.  
  15. } catch(PDOException $E) {
  16. echo 'connexao_erro';
  17. die;
  18. }
  19. /*
  20. * TESTE CONEXAO
  21. *
  22. $stmt = $conn->prepare('SELECT * FROM testa');
  23. $stmt->execute();
  24. $row = $stmt->fetch(PDO::FETCH_OBJ);
  25. var_dump($row->email);*/
  26.  
  27. if (isset($_GET['email'])) {
  28.  
  29. $email = filter_input(INPUT_GET, 'email', FILTER_SANITIZE_EMAIL);
  30. $senha = filter_input(INPUT_GET, 'senha', FILTER_DEFAULT);
  31.  
  32.  
  33. $stmt = $conn->prepare("SELECT * FROM testa WHERE email = ? and senha = ?");
  34. $stmt->bindValue(1, $email);
  35. $stmt->bindValue(2, $senha);
  36. $stmt->execute();
  37.  
  38.  
  39. $row = $stmt->fetch(PDO::FETCH_OBJ);
  40. if ($stmt->rowCount() > 0) {
  41. var_dump($row->email);
  42. exit;
  43. }
  44.  
  45. echo 'Dados inválidos.';
  46. }
Add Comment
Please, Sign In to add comment