Registration script problem

SirChick · #1 06-25-2007, 03:08 PM

This is the script, its not working for some reason ! I cannot understand why!

Quote:

PHP Code:

  <?php

$username = $_POST['username'];

$password = $_POST['password'];

$password2 = ['password2'];

 
If ($password == $password2) {

mysql_connect("localhost", "blahblah", "blah") or die mysql_error());

mysql_select_db("databasename") or die mysql_error());

mysql_query("INSERT INTO 'registrationdetails' (Username) Values ('$username')") or die(mysql_error()); }

elseif ($password != $password2) {

echo "passwords did not match" };

?>

this still wont work :S i think 'registrationdetails' (Username) Values ('$username')") is the part that is not working. I dont think $username is actually getting assigned to the string that the user inputted into the editbox, meaning the code is insert nothing so no new records are being made..

this is the html for the edit box:

HTML Code:

<input type="text" id="Editbox2" size="16" name="Username" value="" maxlength="11">

should it be

PHP Code:

  $username = $_POST['editbox2'];

navaldesign · #2 06-25-2007, 04:15 PM

No. Your editbox (in the login form) is named "Username" so the string that is passed over to the verification script is "Username". Under this point of view, your script correctly has "username" but you need to change the editbox name in "username" with lowercase "u" .

And, why you inserting in the database only the username and not the password also ?

Also, as a good rule, the database fields should be the same as the php script and form variables. So, if you use "username" for the form and script, it would be wise that the database field for the username should be also "username" and not "Username" so that you will not get confused and make mistakes.

Watdaflip · #3 06-25-2007, 08:01 PM

Also
$password2 = ['password2'];
needs to be
$password2 = $_POST['password2'];

You may also want to encrypt your password before inserting it into a database. As well as verify that you user filled in the information

navaldesign · #4 06-25-2007, 09:01 PM

I need better glasses!!!! Thanks watdaflip!!

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)