Nuv Posted March 31, 2008 Share Posted March 31, 2008 Hey i am trying to make a registration page and it says "Field not entered" even when i have entered everything properly Here is my html code <html> <head> <title> User Information....!! </title> </head> <body><center> <img src="C:\html page files\FB_logo.gif"> <h4> <font type="Times New Roman"> Customer Support: +91 22 40 490 490 <br> Email:[email protected] </font> <img src="C:\html page files\assurance.gif"> </h4> <table width="900" cellpadding="0" cellspacing="0"><tr><td style="border:1px #666 solid;padding:2px;" bgcolor="#eeeeee"> <table width="900" cellpadding="0" cellspacing="0" style="margin-top:3px;"><tr><td style="border:1px #666 solid;padding:2px;" bgcolor="#eeeeee"> <center> <font size="2" face="verdana"> <b> <a href="shop.html">Home</a> - <a href="info.html">Register</a> - <a href="login.html">Login</a> - <a href="contact.html">Contact</a> </b> </font> </center> </td> <td style="border-bottom:1px #666 solid;" width="2%"> </td></tr></table> <center> <br> <h4> <font color="Red" > Create a New User Login : <br> </font> </h4> <h5> <font color="Blue" > Fields Marked With asterix(*) are mandatory </h5> <form name="Register" action ="reg.php"> <h4> <font color="Indigo" > <ins> User Id and Password </ins> </font> <br> <br> <font color="Blue"> Email:                     </font> <sup> <font color="Red" > * </font> </sup> <input type ="text" name="email"> <br> <br> <font color="Blue"> Password :             </font> <sup> <font color="Red" > * </font> </sup> <input type ="password" name="password"> <br> <br> <font color="Blue"> Verify Password : </font> <sup> <font color="Red" > * </font> </sup> <input type ="password" name="cpassword"> <br> <h4> <font color="Indigo" > <ins> Billing Address </ins> </font> <br> <br> <font color="Blue"> First Name :         </font> <sup> <font color="Red" > * </font> </sup> <input type ="text" name="firstname"> <br> <font color="Blue"> Last Name :         </font> <sup> <font color="Red" > * </font> </sup> <input type ="text" name="lastname"> <br> <br> <font color="Blue"> Address line1 :     </font> <sup> <font color="Red" > * </font> </sup> <input type ="text" name="address1"> <br> <font color="Blue"> Address line2 :       </font> <input type ="text" name="address2"> <br> <br> <font color="Blue"> City :                     </font> <sup> <font color="Red" > * </font> </sup> <input type ="text" name="city"> <br> <center> <br> <font color="Blue">          Country :               </font> <sup> <font color="Red" > * </font> </sup><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> <br> <br> <font color="Blue"> PinCode :               </font> <sup> <font color="Red" > * </font> </sup> <input type ="text" name="pincode"> <br> <br> <font color="Blue"> Telephone :           </font> <sup> <font color="Red" > * </font> </sup> <input type ="text" name="telephone"> <br> <br> <font color="Blue"> Where did you hear about us?:> </font> <select name="info"> <option value="friend"> Friend</option> <option value="Internet"> Internet</option> <option Value="Newspaper">Newspaper</option> <option value="Magazine"> Magazine</option> </select> <br> <input type="submit" value="Proceed !!"> <br> </form><center/> ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------ <br> <img src="C:\html page files\PC_banner.gif" align="left"> Copyright © 2006 Futurebazaar India Ltd. Designated trademarks, products & brands are the property of their respective owners. All Rights Reserved. Use of this website constitutes acceptance of the FutureBazaar India Ltd. User Agreement & Privacy Policy. <img src="C:\html page files\fb.gif" align="right"> </body> </html> Here is my php code <?php $link = mysql_connect("localhost","root",""); if(!$link) die("Couldn'nt connect mysql"); //echo"Successfully connected to the database"; mysql_select_db("nuv"); $email = $_POST['email']; $cpassword = $_POST['password']; $password = $_POST['cpassword']; $firstname = $_POST['firstname']; $lastname = $_POST['lastname']; $address1 = $_POST['address1']; $address2 = $_POST['address2']; $city = $_POST['city']; $country = $_POST['country']; $pincode = $_POST['pincode']; $telephone = $_POST['telephone']; if((!$address1) || (!$password) || (!$firstname) || (!$lastname) || (!$city) || (!$email) || (!$country) || (!$address2) || (!$cpassword) || (!$telephone) || (!$pincode)) { echo"Some field(s) not entered"; } else { if($password!=$cpassword) { echo"Password and conformation password don't match!!"; } else { $password = md5(md5(md5(md5($password)))); $check = mysql_query("SELECT `email` FROM `members` WHERE `email` = '$email'"); $check = mysql_num_rows($check); if($check>=1) { echo"Email already registered"; } else { $cpassword = addslashes(htmlspecialchars($cpassword)); $password = addslashes(htmlspecialchars($password)); $firstname = addslashes(htmlspecialchars($firstname)); $lastname = addslashes(htmlspecialchars($lastname)); $email = addslashes(htmlspecialchars($email)); $city = addslashes(htmlspecialchars($city)); $country - addslashes(htmlspecialchars($country)); $address1 = addslashes(htmlspecialchars($address1)); $address2 - addslashes(htmlspecialchars($address2)); $telephone = addslashes(htmlspecialchars($telephone)); $pincode = addslashes(htmlspecialchars($pincode)); $add = mysql_query("INSERT INTO `members` (`email`, `password`, `firstname` ,`lastname` ,`address1` ,`address2` ,`city` ,`country` ,`pincode` ,`telephone`) VALUES('$email','$password','$firstname', '$lastname', '$address1' ,'$address2' ,'$city' ,'$country' ,'$pincode' ,'$telephone')") or die(mysql_error()); echo"Email has been registered"; setcookie("email", $email); header('Location: home.html'); } } } ?> Link to comment https://forums.phpfreaks.com/topic/98853-field-not-entered/ Share on other sites More sharing options...
atl_andy Posted March 31, 2008 Share Posted March 31, 2008 It looks like $email is not passed to the query properly. $check = mysql_query("SELECT `email` FROM `members` WHERE `email` = '$email'"); try: $check = mysql_query("SELECT email FROM members WHERE email = ' ".$email." ' "); // Added spaces so you can see the type of characters needed. Hope that helps Link to comment https://forums.phpfreaks.com/topic/98853-field-not-entered/#findComment-505808 Share on other sites More sharing options...
Nuv Posted March 31, 2008 Author Share Posted March 31, 2008 Oh i forgot to mention the "method" in form MY bad Link to comment https://forums.phpfreaks.com/topic/98853-field-not-entered/#findComment-505822 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.