prepare("SELECT id FROM users WHERE email=? ALLOW FILTERING;"); $result = $session->execute($statement, array('arguments' => array($email))); if ($result->count() != 0) { echo('That email address is already in use. Please try another email address.'); exit(); } $statement = $session->prepare('INSERT INTO users (id,email,username,password_hash) VALUES (?,?,null,?);'); $result = $session->execute($statement, array('arguments' => array($id,$email,$hash))); echo('Registration successful.'); ?>