Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <form method="post">
- <fieldset>
- Username: <input type="text" name="username" required maxlength="32" minlenght="3"><br>
- Email: <input type="email" name="email" required maxlength="255" minlenght="6"><br>
- Password: <input type="password" name="password" required>
- <input type="submit" name="submited" value="register!">
- </fieldset>
- </form>
- <?php
- if(isset($_POST['submited'])) {
- try {
- $query = $dbh->prepare("SELECT * from users WHERE login = :username OR email = :email");
- $query->bindParam(':username', $_POST['username'], PDO::PARAM_STR, 32);
- $query->bindParam(':email', $_POST['email'], PDO::PARAM_STR, 255);
- $query->execute();
- $result = $query->fetchAll();
- if(empty($result)) {
- $query = $dbh->prepare("INSERT INTO users (login, pwdhash, email, regdate) VALUES (:username, :pwdhash, :email, NOW())");
- $query->bindParam(':username', $_POST['username'], PDO::PARAM_STR, 32);
- $query->bindParam(':email', $_POST['email'], PDO::PARAM_STR, 255);
- $query->bindParam(':pwdhash', sha1($_POST['password']), PDO::PARAM_STR, 41);
- $query->execute();
- } else {
- echo "Login or email already taken, plea
- se choose different.";
- foreach($result as $row) {
- echo $row['uid'];
- }
- }
- }
- catch(PDOException $e) {
- echo $e->getMessage();
- }
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement