Advertisement
Guest User

PHP Registration Form

a guest
Sep 20th, 2016
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.39 KB | None | 0 0
  1. <?php
  2.     include ("../db_conn/db.php"); 
  3.  
  4.     //$msg = "";
  5.     if(isset($_POST["submit"]))
  6.     {
  7.         $username = $_POST["username"];
  8.         $email = $_POST["email"];
  9.         $password = $_POST["password"];
  10.  
  11.         $username = mysqli_real_escape_string($db, $username);
  12.         $email = mysqli_real_escape_string($db, $email);
  13.         $password = mysqli_real_escape_string($db, $password);
  14.         $password = md5($password);
  15.        
  16.         //$con = mysqli;
  17.         //$sql="SELECT email FROM users WHERE email='$email'";
  18.         //$result=mysqli_query($db, $sql);
  19.         print($username . " " . $email . " ");
  20.         $sql = "SELECT username, email FROM users WHERE username = ? OR email = ?";
  21.        
  22.         if($sql = mysqli_prepare($db,$sql)){
  23.         mysqli_stmt_bind_param($sql, "ss", $user,$email);
  24.         mysqli_stmt_execute($sql);
  25.         $result = mysqli_stmt_get_result($sql);
  26.         $result = bind_result($username, $email);
  27.         if(mysqli_num_rows($result) !== 0){
  28.         $row = mysqli_fetch_assoc($result);
  29.         if($row['username']==$user){
  30.             print('username exists <br />');
  31.         }
  32.         elseif($row['email']==$email){
  33.             print('email exists <br />');
  34.         }
  35.         }
  36.         else {
  37.         print('username/email don\'t exist');
  38.         }
  39.         }
  40.         else {
  41.             if (mysqli_query($db,"INSERT INTO users (username, email, password)VALUES ('$username', '$email', '$password')") === TRUE){
  42.                 print("INSERTED '$username', '$email' and Password into table users");
  43.             }else{
  44.                 print("Error INSERTING to table users");
  45.             }
  46.         }
  47.     }
  48. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement