Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- // variable declaration
- $username = "";
- $email = "";
- $errors = array();
- $_SESSION['success'] = "";
- // connect to database
- $db = mysqli_connect('localhost', 'root', '', 'registration');
- // REGISTER USER
- if (isset($_POST['reg_user'])) {
- // receive all input values from the form
- $title = mysqli_real_escape_string($db, $_POST['title']);
- $firstname = mysqli_real_escape_string($db, $_POST['firstname']);
- $lastname = mysqli_real_escape_string($db, $_POST['lastname']);
- $code = mysqli_real_escape_string($db, $_POST['code']);
- $mobile = mysqli_real_escape_string($db, $_POST['mobile']);
- $username = mysqli_real_escape_string($db, $_POST['username']);
- $email = mysqli_real_escape_string($db, $_POST['email']);
- $password_1 = mysqli_real_escape_string($db, $_POST['password_1']);
- $password_2 = mysqli_real_escape_string($db, $_POST['password_2']);
- // form validation: ensure that the form is correctly filled
- if (empty($username)) { array_push($errors, "Username is required"); }
- if (empty($email)) { array_push($errors, "Email is required"); }
- if (empty($password_1)) { array_push($errors, "Password is required"); }
- if ($password_1 != $password_2) {
- array_push($errors, "The two passwords do not match");
- }
- $query = mysql_query("SELECT * FROM user3 WHERE email='$email'");
- if(mysql_num_rows($query) > 0 ) { //check if there is already an entry for that username
- echo "email already exists!";
- }else{ echo"login";
- }
- // register user if there are no errors in the form
- if (count($errors) == 0) {
- $password = md5($password_1);//encrypt the password before saving in the database
- $query = "INSERT INTO user3 (title,firstname,lastname,code,mobile,username, email, password)
- VALUES('$title','$firstname','$lastname','$code','$mobile','$username', '$email', '$password')";
- mysqli_query($db, $query);
- $_SESSION['email'] = $email;
- $_SESSION['success'] = "You are now logged in";
- $_SESSION['mobile']=$mobile;
- header('location: index.php');
- }
- }
Add Comment
Please, Sign In to add comment