Nuv Posted February 24, 2008 Share Posted February 24, 2008 I have been trying to make a registration page and i am getting : "Successfully connected to the databaseSome field(s) not enteredPHP Notice: Undefined index: firstname in C:\Documents and settings\Nuv\Desktop\register.php on line 10" here is the code <?php $link = mysql_connect("localhost","root",""); if(!$link) die("Couldn'nt connect mysql"); echo"Successfully connected to the database"; mysql_select_db("nuv"); $username = $_POST["username"]; $password = $_POST["password"]; $email = $_POST["email"]; $firstname = $_POST["firstname"]; $lastname = $_POST["lastname"]; $gender = $_POST["gender"]; $country = $_POST["country"]; if((!$username) || (!$password) || (!$firstname) || (!$lastname) || (!$gender) || (!$email) || (!$country)) { echo"Some field(s) not entered"; } else { if($password!=$cpassword) { echo"Password and conformation password dont match"; } else { $password = md5(md5(md5(md5($password)))); $check = mysql_query("SELECT `username` FROM `members` WHERE `username` = '$username'"); $result = mysql_num_rows($check); if($result<=1) { echo"Username has already been taken"; } else { $username = addslashes(htmlspecialchars($username)); $password = addslashes(htmlspecialchars($password)); $firstname = addslashes(htmlspecialchars($firstname)); $lastname = addslashes(htmlspecialchars($lastname)); $email = addslashes(htmlspecialchars($email)); $gender = addslashes(htmlspecialchars($gender)); $country - addslashes(htmlspecialchars($country)); $add = mysql_query("INSERT INTO `members` (`username`, `password`, `email`, `firstname` ,`lastname` ,`gender` ,`country`) VALUES('$username','$password','$email','$firstname', '$lastname', '$gender' ,'$country')"); echo"Username has been registered"; } } } ?> Here is my html code <html> <head> <title>Registration</title> </head> <body> <h2 align="center">Registration</h2> <br><br> <center> <form action="register.php" name="register" method="post"> <fieldset class="fieldset"> <legend>Username</legend> <table cellpadding="0" cellspacing="3" border="0" width="400"> <tr> <td colspan="2"><center>Please enter username.</center></td> </tr><td> <br><center><strong>Username:</strong></center> <center><input type="text" class="bginput" name="username" size="25" maxlength="50" value="" dir="ltr" /> </center></td> </table></fieldset><br> <fieldset class="fieldset"> <legend>Password</legend> <table cellpadding="0" cellspacing="3" border="0" width="400"> <tr> <td colspan="2"><center>Please enter a password. Note that passwords are case-sensitive.</center></td> </tr> <tr> <td><strong> Password:</strong><br /> <input type="password" class="bginput" name="password" size="25" maxlength="50" value="" /> </td> <td> <strong>Confirm Password:</strong><br /> <input type="password" class="bginput" name="cpassword" size="25" maxlength="50" value="" /> </td> </tr> </table> </fieldset><br> <fieldset class="fieldset"> <legend>Email Address</legend> <table cellpadding="0" cellspacing="3" border="0" width="400"> <tr> <td colspan="2"><center>Please enter a valid email address.<center></td> </tr> <td> <br><center><strong>Email Address:</strong></center> <center><input type="text" class="bginput" name="email" size="25" maxlength="50" value="" dir="ltr" /> </center></td> </table> </fieldset><br> <fieldset class="fieldset"> <legend>Personal Information</legend> <table cellpadding="0" cellspacing="3" border="0" width="400"> <tr> <td colspan="2"><center>Please enter some personal details.<center></td> </tr> <tr><td> <br><center><strong>Name:</strong></center> <center><input type="text" class="bginput" name="name" size="25" maxlength="50" value="" dir="ltr" /> </center></td> <td> <br><center><strong>Last name:</strong></center> <center><input type="text" class="bginput" name="lastname" size="25" maxlength="50" value="" dir="ltr" /> </center></td> </tr></table><table><br><strong>Gender:</strong> <input type="radio" name="gender" value="male"> Male <input type="radio" name="gender" value="female"> Female <br><br><name="input"></table> <td width="165" align="left" valign="top"><font size="2" face="Arial, Helvetica, sans-serif" color="#000000"><strong>Country of Residence:</strong></font></td> <td width="393" align="left" valign="top"><select name="country" id="country" tabindex="12"><option value="">--- Select One ---</option> <option value="US">United States</option> <option value="AF">Afghanistan</option> <option value="AX">Aland Islands</option> <option value="AL">Albania</option> <option value="DZ">Algeria</option> <option value="AS">American Samoa</option> <option value="AD">Andorra</option> <option value="AO">Angola</option> <option value="AI">Anguilla</option> <option value="AQ">Antarctica</option> <option value="AG">Antigua and Barbuda</option> <option value="AR">Argentina</option> <option value="AM">Armenia</option> <option value="AW">Aruba</option> <option value="AU">Australia</option> <option value="AT">Austria</option> <option value="AZ">Azerbaijan</option> <option value="BS">Bahamas</option> <option value="BH">Bahrain</option> <option value="BD">Bangladesh</option> <option value="BB">Barbados</option> <option value="BY">Belarus </option> <option value="BE">Belgium </option> <option value="BZ">Belize </option> <option value="BJ">Benin </option> <option value="BM">Bermuda </option> <option value="BT">Bhutan </option> <option value="BO">Bolivia </option> <option value="BA">Bosnia and Herzegovina </option> <option value="BW">Botswana </option> <option value="BV">Bouvet Island </option> <option value="BR">Brazil </option> <option value="IO">British Indian Ocean Territory </option> <option value="BN">Brunei Darussalam </option> <option value="BG">Bulgaria </option> <option value="BF">Burkina Faso </option> <option value="BI">Burundi </option> <option value="KH">Cambodia </option> <option value="CM">Cameroon </option> <option value="CA">Canada </option> <option value="CV">Cape Verde </option> <option value="KY">Cayman Islands </option> <option value="CF">Central African Republic </option> <option value="TD">Chad </option> <option value="CL">Chile </option> <option value="CN">China </option> <option value="CX">Christmas Island </option> <option value="CC">Cocos (Keeling) Islands </option> <option value="CO">Colombia </option> <option value="KM">Comoros </option> <option value="CG">Congo </option> <option value="CD">Congo, the Democratic Republic of the</option> <option value="CK">Cook Islands </option> <option value="CR">Costa Rica </option> <option value="CI">Cote D'Ivoire </option> <option value="HR">Croatia </option> <option value="CU">Cuba </option> <option value="CY">Cyprus </option> <option value="CZ">Czech Republic </option> <option value="DK">Denmark </option> <option value="DJ">Djibouti </option> <option value="DM">Dominica </option> <option value="DO">Dominican Republic </option> <option value="EC">Ecuador </option> <option value="EG">Egypt </option> <option value="SV">El Salvador </option> <option value="GQ">Equatorial Guinea </option> <option value="ER">Eritrea </option> <option value="EE">Estonia </option> <option value="ET">Ethiopia </option> <option value="FK">Falkland Islands (Malvinas) </option> <option value="FO">Faroe Islands </option> <option value="FJ">Fiji </option> <option value="FI">Finland </option> <option value="FR">France </option> <option value="GF">French Guiana </option> <option value="PF">French Polynesia </option> <option value="TF">French Southern Territories </option> <option value="GA">Gabon </option> <option value="GM">Gambia </option> <option value="GE">Georgia </option> <option value="DE">Germany </option> <option value="GH">Ghana </option> <option value="GI">Gibraltar </option> <option value="GR">Greece </option> <option value="GL">Greenland </option> <option value="GD">Grenada </option> <option value="GP">Guadeloupe </option> <option value="GU">Guam </option> <option value="GT">Guatemala </option> <option value="GN">Guinea </option> <option value="GW">Guinea-Bissau </option> <option value="GY">Guyana </option> <option value="HT">Haiti </option> <option value="HM">Heard and McDonald Islands </option> <option value="VA">Holy See (Vatican City State)</option> <option value="HN">Honduras </option> <option value="HK">Hong Kong </option> <option value="HU">Hungary </option> <option value="IS">Iceland </option> <option value="IN">India </option> <option value="ID">Indonesia </option> <option value="IR">Iran, Islamic Republic of</option> <option value="IQ">Iraq </option> <option value="IE">Ireland </option> <option value="IL">Israel </option> <option value="IT">Italy </option> <option value="JM">Jamaica </option> <option value="JP">Japan </option> <option value="JO">Jordan </option> <option value="KZ">Kazakhstan </option> <option value="KE">Kenya </option> <option value="KI">Kiribati </option> <option value="KP">Korea, Democratic People's Republic of </option> <option value="KR">Korea, Republic of </option> <option value="KW">Kuwait </option> <option value="KG">Kyrgyzstan </option> <option value="LA">Lao People's Democratic Republic </option> <option value="LV">Latvia </option> <option value="LB">Lebanon </option> <option value="LS">Lesotho </option> <option value="LR">Liberia </option> <option value="LY">Libyan Arab Jamahiriya </option> <option value="LI">Liechtenstein </option> <option value="LT">Lithuania </option> <option value="LU">Luxembourg </option> <option value="MO">Macao </option> <option value="MK">Macedonia, the former Yugoslav Republic of </option> <option value="MG">Madagascar </option> <option value="MW">Malawi </option> <option value="MY">Malaysia </option> <option value="MV">Maldives </option> <option value="ML">Mali </option> <option value="MT">Malta </option> <option value="MH">Marshall Islands </option> <option value="MQ">Martinique </option> <option value="MR">Mauritania </option> <option value="MU">Mauritius </option> <option value="YT">Mayotte </option> <option value="MX">Mexico </option> <option value="FM">Micronesia, Federated States of </option> <option value="MD">Moldova, Republic of </option> <option value="MC">Monaco </option> <option value="MN">Mongolia </option> <option value="MS">Montserrat </option> <option value="MA">Morocco </option> <option value="MZ">Mozambique </option> <option value="MM">Myanmar </option> <option value="NA">Namibia </option> <option value="NR">Nauru </option> <option value="NP">Nepal </option> <option value="NL">Netherlands </option> <option value="AN">Netherlands Antilles </option> <option value="NC">New Caledonia </option> <option value="NZ">New Zealand </option> <option value="NI">Nicaragua </option> <option value="NE">Niger </option> <option value="NG">Nigeria </option> <option value="NU">Niue </option> <option value="NF">Norfolk Island </option> <option value="MP">Northern Mariana Islands </option> <option value="NO">Norway </option> <option value="OM">Oman </option> <option value="PK">Pakistan </option> <option value="PW">Palau </option> <option value="PS">Palestinian Territory, Occupied</option> <option value="PA">Panama </option> <option value="PG">Papua New Guinea </option> <option value="PY">Paraguay </option> <option value="PE">Peru </option> <option value="PH">Philippines </option> <option value="PN">Pitcairn </option> <option value="PL">Poland </option> <option value="PT">Portugal </option> <option value="PR">Puerto Rico </option> <option value="QA">Qatar </option> <option value="RE">Reunion </option> <option value="RO">Romania </option> <option value="RU">Russian Federation </option> <option value="RW">Rwanda </option> <option value="SH">Saint Helena </option> <option value="KN">Saint Kitts and Nevis </option> <option value="LC">Saint Lucia </option> <option value="PM">Saint Pierre and Miquelon </option> <option value="VC">Saint Vincent and the Grenadines </option> <option value="WS">Samoa </option> <option value="SM">San Marino </option> <option value="ST">Sao Tome and Principe </option> <option value="SA">Saudi Arabia </option> <option value="SN">Senegal </option> <option value="CS">Serbia and Montenegro </option> <option value="SC">Seychelles </option> <option value="SL">Sierra Leone </option> <option value="SG">Singapore </option> <option value="SK">Slovakia </option> <option value="SI">Slovenia </option> <option value="SB">Solomon Islands </option> <option value="SO">Somalia </option> <option value="ZA">South Africa </option> <option value="GS">South Georgia and the South Sandwich Islands</option> <option value="ES">Spain </option> <option value="LK">Sri Lanka </option> <option value="SD">Sudan </option> <option value="SR">Suriname </option> <option value="SJ">Svalbard and Jan Mayen </option> <option value="SZ">Swaziland </option> <option value="SE">Sweden </option> <option value="CH">Switzerland </option> <option value="SY">Syrian Arab Republic </option> <option value="TW">Taiwan </option> <option value="TJ">Tajikistan </option> <option value="TZ">Tanzania, United Republic of </option> <option value="TH">Thailand </option> <option value="TL">Timor-Leste</option> <option value="TG">Togo </option> <option value="TK">Tokelau </option> <option value="TO">Tonga </option> <option value="TT">Trinidad and Tobago </option> <option value="TN">Tunisia </option> <option value="TR">Turkey </option> <option value="TM">Turkmenistan </option> <option value="TC">Turks and Caicos Islands </option> <option value="TV">Tuvalu </option> <option value="UG">Uganda </option> <option value="UA">Ukraine </option> <option value="AE">United Arab Emirates </option> <option value="GB">United Kingdom </option> <option value="US">United States</option> <option value="UM">United States Minor Outlying Islands </option> <option value="UY">Uruguay </option> <option value="UZ">Uzbekistan </option> <option value="VU">Vanuatu </option> <option value="VE">Venezuela </option> <option value="VN">Vietnam </option> <option value="VG">Virgin Islands (British) </option> <option value="VI">Virgin Islands (U.S.) </option> <option value="WF">Wallis And Futuna Islands </option> <option value="EH">Western Sahara </option> <option value="YE">Yemen </option> <option value="ZM">Zambia </option> <option value="ZW">Zimbabwe</option></select></td> </tr></fieldset> <br><br><br><input type="Submit" value="Register" alt="[submit]"> </form></center> </body> </html> Hope someone helps me with it Quote Link to comment Share on other sites More sharing options...
darkfreaks Posted February 24, 2008 Share Posted February 24, 2008 its telling you there is no field in the database called firstname Quote Link to comment Share on other sites More sharing options...
Bauer418 Posted February 24, 2008 Share Posted February 24, 2008 its telling you there is no field in the database called firstname Actually it's saying that there's no form field called firstname. In your HTML, the field is called 'name', but in PHP, you're trying to access 'firstname' Quote Link to comment Share on other sites More sharing options...
Nuv Posted February 24, 2008 Author Share Posted February 24, 2008 Wow i checked that thing twice still i didnt get that...well i corrected it but now it says "Successfully connected to the databaseUsername has been registered" but thats not the truth..i know something is wrong with the code..can anyone help me with it pls and tell me my mistake. Quote Link to comment Share on other sites More sharing options...
Bauer418 Posted February 24, 2008 Share Posted February 24, 2008 Change this line: $add = mysql_query("INSERT INTO `members` (`username`, `password`, `email`, `firstname` ,`lastname` ,`gender` ,`country`) VALUES('$username','$password','$email','$firstname', '$lastname', '$gender' ,'$country')"); To this: $add = mysql_query("INSERT INTO `members` (`username`, `password`, `email`, `firstname` ,`lastname` ,`gender` ,`country`) VALUES('$username','$password','$email','$firstname', '$lastname', '$gender' ,'$country')") or die(mysql_error()); You must have an error in your query, and that will tell us what it is. Quote Link to comment Share on other sites More sharing options...
Nuv Posted February 24, 2008 Author Share Posted February 24, 2008 Nope i did it and the same thing..Successfully connected to the databaseUsername has been registered Quote Link to comment Share on other sites More sharing options...
Bauer418 Posted February 24, 2008 Share Posted February 24, 2008 Nope i did it and the same thing..Successfully connected to the databaseUsername has been registered And you are entirely positive that the record is in fact not added to the table of the database? If you have no MySQL errors, you are connected to your DB, and you insert the data with no problems, it should be there. Quote Link to comment Share on other sites More sharing options...
Nuv Posted February 24, 2008 Author Share Posted February 24, 2008 Yes as am using xampp and i made a database which is empty,but i am using it for like second time..so i am not 100% sure..if you could check it,it would be very nice of you. Quote Link to comment Share on other sites More sharing options...
Bauer418 Posted February 24, 2008 Share Posted February 24, 2008 I don't have a database to test this on currently. You could run a SELECT query (with no WHERE clause, just select all entries from your members table) to see if anything has been added. Quote Link to comment Share on other sites More sharing options...
Nuv Posted February 24, 2008 Author Share Posted February 24, 2008 Plus i see that when i dont check that gender then it does give an error "Some field(s) not enteredPHP Notice: Undefined index: gender in C:\Documents and Settings\Owner\Desktop\register.php on line 13" but it should only give "Some fields not found" Why is that? And thanks for all your help Quote Link to comment Share on other sites More sharing options...
revraz Posted February 24, 2008 Share Posted February 24, 2008 You need to do some validation on your form to make sure data is actually entered. Quote Link to comment Share on other sites More sharing options...
Nuv Posted February 24, 2008 Author Share Posted February 24, 2008 Well i did with a line "if(!$username || !$password || !$firstname || !$lastname || !$gender || !$email || !$country)" and everything else is working fine...usernames are being registered Quote Link to comment Share on other sites More sharing options...
BlueSkyIS Posted February 24, 2008 Share Posted February 24, 2008 the Undefined index error will be displayed if you reference an unset index when you have your error reporting set too high. turn down error reporting to get rid of that error. Quote Link to comment Share on other sites More sharing options...
Nuv Posted February 24, 2008 Author Share Posted February 24, 2008 I see am using enginesite php editor and i dont know how to do that so ill leave that..LOL Yet i dont understand that error :-\ Quote Link to comment Share on other sites More sharing options...
revraz Posted February 24, 2008 Share Posted February 24, 2008 Or better yet, set the variables. the Undefined index error will be displayed if you reference an unset index when you have your error reporting set too high. turn down error reporting to get rid of that error. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.