Advertisement
thebys

W33 - registerform

Dec 3rd, 2011
120
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.28 KB | None | 0 0
  1. <form method="post">
  2. <fieldset>
  3. Username: <input type="text" name="username" required maxlength="32" minlenght="3"><br>
  4. Email: <input type="email" name="email" required maxlength="255" minlenght="6"><br>
  5. Password: <input type="password" name="password" required>
  6. <input type="submit" name="submited" value="register!">
  7. </fieldset>
  8. </form>
  9. <?php
  10. if(isset($_POST['submited'])) {
  11.     try {
  12.         $query = $dbh->prepare("SELECT * from users WHERE login = :username OR email = :email");
  13.         $query->bindParam(':username', $_POST['username'], PDO::PARAM_STR, 32);
  14.         $query->bindParam(':email', $_POST['email'], PDO::PARAM_STR, 255);
  15.         $query->execute();
  16.         $result = $query->fetchAll();
  17.         if(empty($result)) {
  18.             $query = $dbh->prepare("INSERT INTO users (login, pwdhash, email, regdate) VALUES (:username, :pwdhash, :email, NOW())");
  19.             $query->bindParam(':username', $_POST['username'], PDO::PARAM_STR, 32);
  20.             $query->bindParam(':email', $_POST['email'], PDO::PARAM_STR, 255);
  21.             $query->bindParam(':pwdhash', sha1($_POST['password']), PDO::PARAM_STR, 41);
  22.             $query->execute();
  23.         } else {
  24.             echo "Login or email already taken, plea
  25.      se choose different.";
  26.             foreach($result as $row) {
  27.                 echo $row['uid'];
  28.             }
  29.         }
  30.     }
  31.     catch(PDOException $e) {
  32.         echo $e->getMessage();
  33.     }
  34. }
  35. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement