I've been working all through the night trying to get this registration form to insert everything into my db withough one successful attempt. I'm getting frustrated because I have to have this site ready for the organization within the next few hours. Please, can someone take a look at this code and tell me what's going wrong and how I might be able to fix it? <?php session_start(); function register(){ $connect = mysql_connect("localhost", "username", "password"); if(!$connect){ $response = mysql_error(); } $select_db = mysql_select_db("db_name", $connect); if(!$select_db){ $response = mysql_error(); } $first = mysql_real_escape_string ($_POST['first']); $last = mysql_real_escape_string ($_POST['last']); $email = mysql_real_escape_string ($_POST['email']); $user = mysql_real_escape_string ($_POST['username']); $pass = mysql_real_escape_string ($_POST['password']); $conf_pass = mysql_real_escape_string ($_POST['conf_pass']); $ip = $_SERVER["REMOTE_ADDR"]; if(empty($username)){ $response = "Please enter your username!"; } if(empty($password)){ $response = "Please enter your password!<br>"; } if(empty($conf_pass)){ $response = "Please confirm your password!<br>"; } if(empty($email)){ $response = "Please enter your email!"; } $user_check = mysql_query("SELECT username FROM members WHERE username='$username'"); $do_user_check = mysql_num_rows($user_check); $email_check = mysql_query("SELECT email FROM members WHERE email='$email'"); $do_email_check = mysql_num_rows($email_check); if($do_user_check > 0){ $response = "Username is already in use!"; } if($do_email_check > 0){ $response = "Email is already in use!"; } if($password != $conf_pass){ $response = "Passwords don't match!"; } $insert = mysql_query("INSERT INTO members (`id`, `first`, `last`, `username`, `password`, `email`, `regIP`) VALUES (NULL , '$first', '$last', '$email' '$user', md5('$pass'), '$ip')"); if(!$insert){ $response = "There's a little problem: ".mysql_error(); } else { $response = "Congrats " . $username . "! You are now registered"; } } ?> <form action="" id="login" method="post"> <h1>Register</h1> <fieldset id="inputs"> <input autofocus id="first" name="first" placeholder="First Name" required type="text"> <input id="last" name="last" placeholder="Last Name" required type="text"> <input id="email" name="email" placeholder="someone@example.com" required type="email"> <input id="username" name="username" placeholder="Username" required type="text"> <input id="password" name="password" placeholder="Password" required type="password"> <input id="password" name="conf_pass" placeholder="Confirm Password" required type="password"> </fieldset> <fieldset id="actions"> <input id="submit" type="submit" value="Register"> <a href="">Forgot your password?</a><a href="login.php">Log In</a> </fieldset> </form> <?php if(isset($response)) echo "<p class='alert'>" . $response . "</p>"; ?>

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.

Sign In

Registration Form

Recommended Posts

mroberts46

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information