StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POPHP, AJAX for Signup Form
text
Body
copied!<p>I am new to all of this so bare with me. I am trying to set up my first PHP site and I really want to do it the right way. I am working on the form located: <a href="http://www.bwgblog.com/signup" rel="nofollow noreferrer">http://www.bwgblog.com/signup</a>. </p> <p>I have set up the following form:</p> <pre><code> <p><form action="/signup/register.php" method="post"> <label for="first_name">First Name</label> <input type="text" name="first_name" /> <label for="last_name">Last Name</label> <input type="text" name="last_name" /> <label for="company">Company</label> <input type="text" name="company" /> <label for="job_title">Job Title</label> <input type="text" name="job_title" /> <label for="phone">Phone</label> <input type="text" name="phone" /> <label for="email">Email</label> <input type="text" name="email" /> <label for="username">Choose a Username</label> <input type="text" name="username" /> <label for="password">Choose a Password</label> <input type="text" name="password" /> <label for="confirm_password">Confirm Your Password</label> <input type="text" name="confirm_password" /> <input type="submit" value="Get Started" /> </form> </code></pre> <p>And here is my PHP page, register.php:</p> <pre><code> <?php ini_set('display_errors', 1); error_reporting(E_ALL); $con = mysql_connect("localhost","*******","******"); //Replace with your actual MySQL DB Username and Password if (!$con) { die('Could not connect: ' . mysql_error()); } mysql_select_db("bwgblog", $con); //Replace with your MySQL DB Name $first_name=mysql_real_escape_string($_POST['first_name']); $last_name=mysql_real_escape_string($_POST['last_name']); $company=mysql_real_escape_string($_POST['company']); $job_title=mysql_real_escape_string($_POST['job_title']); $phone=mysql_real_escape_string($_POST['phone']); $email=mysql_real_escape_string($_POST['email']); $username=mysql_real_escape_string($_POST['username']); $password=mysql_real_escape_string($_POST['password']); $confirm_password=mysql_real_escape_string($_POST['confirm_password']); $sql="INSERT INTO members (first_name,last_name,company,job_title,phone,email,username,password,confirm_password) VALUES ('$first_name','$last_name','$company','$job_title','$phone','$email','$username','$password','$confirm_password')"; if (!mysql_query($sql,$con)) { die('Error: ' . mysql_error()); } echo "The form data was successfully added to your database."; mysql_close($con); ?> </code></pre> <p>I am trying to figure out how to add in AJAX such that it gives me two things. 1) The ability for it to check in realtime the username field as that field should be unique, and 2) the ability to have the confirm password field render a green checkmark if it == password field.</p> <p>I have been looking all day for how to do this and can't get a clear look at it. Here is how the files are laid out:</p> <p>signup (folder) -> index.php -> register.html.php -> register.php</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload