Verificar se Login e E-mail existe. Deu um pequeno erro, alguém poderi
<?php
//Cadastro Usuário
function Register($name, $email, $username, $password, $status = true){
$password = CryptPassword($password);
$userkey = KeyGenerator();
$register = time();
$query = "INSERT INTO clientes (name, email, username, password, userkey, register, status)";
$query .= "VALUES ('$name', '$email', '$username', '$password', '$userkey', $register, $status,)";
$result = mysql_query($query) or die(mysql_error());
return $result;
}
//Verifica se Existe Login
function UserNameExists($username){
$query = "SELECT username FROM clientes WHERE username = '$username'";
$result = mysql_query($query) or die (mysql_error());
if(mysql_num_rows($result) <= 0)
return true;
else
return false;
}
//Verifica se Existe E-mail
function EmailExists($email){
$query = "SELECT email FROM clientes WHERE email = '$email'";
$result = mysqli_query($connect, $query) or die (mysql_error()); // LINHA ESTÁ DANDO ERRO
if(mysql_num_rows($result) <= 0)
return true;
else
return false;
}
8
//ABRE conexão com MysSQLI
function Connect(){
$link = @mysqli_connect(HOSTNAME, USERNAME, PASSWORD, DATABASE) or die(mysqli_connect_error());
mysqli_set_charset($link, CHARSET) or die(mysqli_error($link));
return $link;
}
//"FECHA conexão com MysSQLI"
function Close($link){
@mysqli_close($link) or die (mysqli_error($link));
}
//"PROTEGE contra SQL Injection"
function Escape($dados){
$link = Connect();
if(!is_array($dados))
$dados = mysqli_real_escape_string($link, $dados);
else{
$arr = $dados;
foreach ($arr as $key => $value){
$key = mysqli_real_escape_string($link, $key);
$value = mysqli_real_escape_string($link, $value);
$dados[$key] = $value;
}
}
Close($link);
return $dados;
}
//"EXECUTA Querys"
function Execute($query){
$link = Connect();
$result = @mysqli_query($link, $query) or die(mysqli_error($link));
Close($link);
return $result;
}
//"LER Registros"
function Read($table, $params = null, $fields = '*'){
$params = ($params) ? " {$params}" : null;
$query = "SELECT {$fields} FROM {$table}{$params}";
$result = Execute($query);
if(!mysqli_num_rows($result))
return false;
else {
while ($res = mysqli_fetch_assoc($result)) {
$data[] = $res;
}
return $data;
}
}
//"GRAVAR Registros"
function Create($table, array $data){
$table = PREFIX.'_'.$table;
//return $table;
$data = Escape($data);
//return $data;
$fields = implode(', ', array_keys($data));
$values = "'".implode("', '", $data)."'";
$query = "INSERT INTO {$table} ( {$fields} ) VALUES ({$values})";
return Execute($query);
}
?>Discussão (3)
Carregando comentários...