Jump to content

Field not entered


Nuv

Recommended Posts

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: &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp  </font> <sup> <font color="Red" > * </font> </sup>  <input type ="text" name="email"> <br> 

<br>  <font color="Blue"> Password :  &nbsp &nbsp &nbsp &nbsp &nbsp &nbsp </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 :   &nbsp &nbsp &nbsp &nbsp  </font> <sup> <font color="Red" > * </font> </sup>  <input type ="text" name="firstname"> <br>

      <font color="Blue"> Last Name :  &nbsp &nbsp &nbsp &nbsp </font> <sup> <font color="Red" > * </font> </sup>  <input type ="text" name="lastname"> <br>

<br>  <font color="Blue"> Address line1 : &nbsp &nbsp </font> <sup> <font color="Red" > * </font> </sup>  <input type ="text" name="address1"> <br>

      <font color="Blue"> Address line2 :  &nbsp &nbsp &nbsp </font>  <input type ="text" name="address2"> <br>

<br>  <font color="Blue"> City :  &nbsp &nbsp &nbsp  &nbsp &nbsp &nbsp  &nbsp &nbsp &nbsp &nbsp </font> <sup> <font color="Red" > * </font> </sup>  <input type ="text" name="city"> <br>
<center>
<br>  <font color="Blue">&nbsp &nbsp &nbsp &nbsp &nbsp Country :  &nbsp &nbsp &nbsp  &nbsp &nbsp &nbsp &nbsp </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 : &nbsp &nbsp &nbsp  &nbsp &nbsp &nbsp &nbsp </font> <sup> <font color="Red" > * </font> </sup>  <input type ="text" name="pincode"> <br>

<br>  <font color="Blue"> Telephone : &nbsp &nbsp &nbsp  &nbsp &nbsp  </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

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

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.