Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $dsn = 'mysql:host=localhost;dbname=4linhas';
- $user = 'root';
- $password ='' ;
- try {
- $conn = new PDO($dsn, $user, $password);
- $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
- $conn->exec("set names utf8");
- } catch (PDOException $e) {
- echo $e->getMessage();
- exit;
- }
- $nome = filter_input(INPUT_POST, 'nome', FILTER_SANITIZE_SPECIAL_CHARS);
- $email = filter_input(INPUT_POST, 'email', FILTER_SANITIZE_SPECIAL_CHARS);
- if($email != "chicosilva1gmail.com"){
- exit('Seu email não');
- }
- // select pdo
- // select id, nome FROM usuários Where email = :email
- $sql = "select id, nome FROM usuários Where email = :email";
- $stmt = $conn->prepare($sql);
- $stmt->bindValue(':email',$email);
- $resultado = $stmt->execute();
- if($resultado){
- exit('vc nao está cadastrado');
- }
- $sql = "INSERT INTO usuarios (nome,email) VALUES (:nome,:email)";
- $stmt = $conn->prepare($sql);
- $stmt->bindValue(':nome',$nome);
- $stmt->bindValue(':email',$email);
- // $stmt->bindParam(':id', $produto->pk, PDO::PARAM_INT);
- $stmt->execute();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement