Code
public function register() {
$correct = false;
try {
$con = new PDO( DB_DSN, DB_USERNAME, DB_PASSWORD );
$con->setAttribute( PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION );
$check = $con->prepare('SELECT * FROM users WHERE username = :username');
$items = array(':username' => $this->username);
$check->execute($items);
if($check->rowCount() >= 1)
return 'Account bestaat al';
else{
$sql = "INSERT INTO users(username, password) VALUES(:username, :password)";
$stmt = $con->prepare($sql);
$items_Insert = array(':username' => $this->username, ':password' => $this->password);
$stmt->execute($items_Insert);
return "Registration Successful <br/> <a href='index.php'>Login Now</a>";
}
}
catch( PDOException $e ) {
return $e->getMessage();
}
}
Toon Meer
Probeer dit eens?
Edit: Wat ik eerst poste werkt niet... Wat er nu staat wellicht wel?