<?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);
$cpf=filter_input(INPUT_POST,'cpf',FILTER_SANITIZE_SPECIAL_CHARS);
$senha=filter_input(INPUT_POST,'senha',FILTER_SANITIZE_SPECIAL_CHARS);
$telefone=filter_input(INPUT_POST,'telefone',FILTER_SANITIZE_SPECIAL_CHARS);


$sql="INSERT INTO usuarios(nome,email,cpf,senha,telefone) VALUES (:nome,:email,:cpf,:senha,:telefone)";

$stmt = $conn->prepare($sql);
$stmt->bindValue(':nome',$nome);
$stmt->bindValue(':email',$email);
$stmt->bindValue(':cpf',$cpf);
$stmt->bindValue(':senha',$senha);
$stmt->bindValue(':telefone',$telefone);

//select PDO verificar email


//    $stmt->bindParam(':id', $produto->pk, PDO::PARAM_INT);


$stmt->execute();