<link href="//maxcdn.bootstrapcdn.com/bootstrap/4.1.1/css/bootstrap.min.css" rel="stylesheet" id="bootstrap-css">
<script src="//maxcdn.bootstrapcdn.com/bootstrap/4.1.1/js/bootstrap.min.js"></script>
<script src="//cdnjs.cloudflare.com/ajax/libs/jquery/3.2.1/jquery.min.js"></script>
<?php
class Usuario
{
private $pdo;
public $msgErro = "";//tudo ok
public function conectar($nome, $host, $usuario, $senha)
{
global $pdo;
try {
$pdo = new PDO("mysql:dbname=".$nome.";host=".$host,$usuario,$senha);
}catch (PDOException $e) {
$msgErro = $e->getMessage();
}
}
public function cadastrar($nome, $telefone, $email, $senha)
{
global $pdo;
//verificar se já existe o email cadastrado
$sql = $pdo->prepare("SELECT id_usuario FROM usuarios WHERE email = :e");
$sql->bindValue(":e",$email);
$sql->execute();
if($sql->rowCount() > 0)
{
return false; //ja esta cadastrado
}
else
{
//caso nao, Cadastrar
$sql = $pdo->prepare("INSERT INTO usuarios (nome, telefone, email, senha) VALUES (:n, :t, :e, :s)");
