Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- //Minha conexão
- $host = 'localhost';
- $dbname = 'testar';
- $user = 'root';
- $pass = 'root123';
- try {
- $conn = new PDO(sprintf('mysql:host=%s;dbname=%s', $host, $dbname), $user, $pass);
- $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
- $conn->exec('SET NAMES utf8');
- } catch(PDOException $E) {
- echo 'connexao_erro';
- die;
- }
- /*
- * TESTE CONEXAO
- *
- $stmt = $conn->prepare('SELECT * FROM testa');
- $stmt->execute();
- $row = $stmt->fetch(PDO::FETCH_OBJ);
- var_dump($row->email);*/
- if (isset($_GET['email'])) {
- $email = filter_input(INPUT_GET, 'email', FILTER_SANITIZE_EMAIL);
- $senha = filter_input(INPUT_GET, 'senha', FILTER_DEFAULT);
- $stmt = $conn->prepare("SELECT * FROM testa WHERE email = ? and senha = ?");
- $stmt->bindValue(1, $email);
- $stmt->bindValue(2, $senha);
- $stmt->execute();
- $row = $stmt->fetch(PDO::FETCH_OBJ);
- if ($stmt->rowCount() > 0) {
- var_dump($row->email);
- exit;
- }
- echo 'Dados inválidos.';
- }
Add Comment
Please, Sign In to add comment