大家好,早上好。
我有一个问题,我正在尝试使用PHP将我的注册表单链接到我的数据库,所以当有人填写表单时,所有数据都应该进入数据库,但问题是它不起作用,代码传递所有内容,他转到ELSE句子,请让我知道我做错了什么,如果有解决方案,请解释一下,以便我从中学习。
代码有趣的最后一个假句子。
PHP代码:
$hostname="*************";
$username="*************";
$password="*************";
$database="*************";
$connect=mysql_connect($hostname,$username,$password);
if(!$connect)
{
die('Connection Failed'.mysql_error());
}
mysql_select_db($database);
if(isset($_REQUEST['Submit']))
{
$username = ($_REQUEST['username']); // SANITIZE INPUTS !
$firstname = ($_REQUEST['firstname']);
$pincode = ($_REQUEST['pincode']);
$lastname = ($_REQUEST['lastname']);
$email = ($_REQUEST['email']);
$password = ($_REQUEST['password']);
$website = ($_REQUEST['website']);
$phonenumber = ($_REQUEST['phonenumber']);
$zipcode = ($_REQUEST['zipcode']);
$address1 = ($_REQUEST['address1']);
$address2 = ($_REQUEST['address2']);
$company = ($_REQUEST['company']);
$sq = ($_REQUEST['sq']);
$country = ($_REQUEST['Country']);
$city = ($_REQUEST['city']);
$sql = "INSERT INTO customers
VALUES (0,'$pincode','$username','$firstname','$lastname',
'$email','$password', '$sq', '$company', '$website',
'$address1', '$address2', '$city','$zipcode',
'$country')";
$res=mysql_query($sql);
if($res)
{
echo "Sumbimted";
}
else
{
echo "Something went wrong ";
}
}
else
{
echo "false";
}
?>
我的表单页面代码 :
<form role="form" class="signup" action="SignUpPHP.php" method="post">
<div class="form-group">
<label for="FirstName">Username</label>
<input type="text" class="form-control" id="username" name="username" placeholder="Enter a username" required>
</div>
<div class="form-group">
<label for="FirstName">Pin Code</label>
<input type="text" class="form-control" id="pincode" name="pincode" placeholder="Pin Code from 4 Digite" required>
</div>
<div class="form-group">
<label for="FirstName">First Name</label>
<input type="text" class="form-control" id="FirstName" name="firstname" placeholder="Enter Your First Name" required>
</div>
<div class="form-group">
<label for="FirstName">Last Name</label>
<input type="text" class="form-control" id="FirstName" name="lastname" placeholder="Enter Your First Name" required>
</div>
<div class="form-group">
<label for="exampleInputEmail1">Email address</label>
<input type="email" class="form-control" id="exampleInputEmail3" name="email" placeholder="Enter email" required>
</div>
<div class="form-group">
<label for="exampleInputPassword1">Password</label>
<input type="password" class="form-control" id="exampleInputPassword3" name="password" placeholder="Password" required>
</div>
<div class="form-group">
<label for="FirstName">Phone Number</label>
<input type="text" class="form-control" id="phonenumber" name="phonenumber" placeholder="Your Phone Number" required>
</div>
<br>
<label class="control-label col-lg-2" for="inputSuccess">Country</label>
<div class="col-lg-10">
<select class="form-control m-bot15" value="" name="country" required>
<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, Plurinational State of</option>
<option value="BQ">Bonaire, Sint Eustatius and Saba</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">Côte d'Ivoire</option>
<option value="HR">Croatia</option>
<option value="CU">Cuba</option>
<option value="CW">Curaçao</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="GG">Guernsey</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 Island 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="IM">Isle of Man</option>
<option value="IL">Israel</option>
<option value="IT">Italy</option>
<option value="JM">Jamaica</option>
<option value="JP">Japan</option>
<option value="JE">Jersey</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">Libya</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="ME">Montenegro</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="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">Réunion</option>
<option value="RO">Romania</option>
<option value="RU">Russian Federation</option>
<option value="RW">Rwanda</option>
<option value="BL">Saint Barthélemy</option>
<option value="SH">Saint Helena, Ascension and Tristan da Cunha</option>
<option value="KN">Saint Kitts and Nevis</option>
<option value="LC">Saint Lucia</option>
<option value="MF">Saint Martin (French part)</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="RS">Serbia</option>
<option value="SC">Seychelles</option>
<option value="SL">Sierra Leone</option>
<option value="SG">Singapore</option>
<option value="SX">Sint Maarten (Dutch part)</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="SS">South Sudan</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, Province of China</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, Bolivarian Republic of</option>
<option value="VN">Viet Nam</option>
<option value="VG">Virgin Islands, British</option>
<option value="VI">Virgin Islands, U.S.</option>
<option value="WF">Wallis and Futuna</option>
<option value="EH">Western Sahara</option>
<option value="YE">Yemen</option>
<option value="ZM">Zambia</option>
<option value="ZW">Zimbabwe</option>
</select>
</div>
<br>
<div class="form-group">
<label for="FirstName">City</label>
<input type="text" class="form-control" id="city" name="city" placeholder="Your City" required>
</div>
<div class="form-group">
<label for="FirstName">Zip Code</label>
<input type="text" class="form-control" id="zipcode" name="zipcode" placeholder="Enter Your Zip Code" required>
</div>
<div class="form-group">
<label for="FirstName">Address (1) :</label>
<input type="text" class="form-control" id="address1" name="address1" placeholder="" required>
</div>
<div class="form-group">
<label for="FirstName">Address (2) :</label>
<input type="text" class="form-control" id="address2" name="address2" placeholder="Optional">
</div>
<div class="form-group">
<label for="FirstName">Security Question :</label>
<input type="text" class="form-control" id="sq" name="sq" placeholder="" required>
</div>
<div class="form-group">
<label for="FirstName">Website :</label>
<input type="text" class="form-control" id="website" name="website" placeholder="Optional">
</div>
<div class="form-group">
<label for="FirstName">Company :</label>
<input type="text" class="form-control" id="company" name="company" placeholder="Optional">
</div>
<div class="checkbox">
<label>
<input type="checkbox" required> Agree on our <a href="https://newtecplanet.com/terms.html">Terms</a>
</label>
</div>
<button type="submit" class="btn btn-primary" name="Submit">Submit</button>
</form>
我假设它正在显示
Something went wrong
消息
您没有正确测试查询处理中的错误。
如果您显示数据库生成的错误,它将帮助您解决问题,而不仅仅是echo "Something went wrong ";
因此,请更改此部分:
if($res === false) {
echo 'Query failed ' . mysql_error();
echo "'n$sql'n";
exit;
} else {
echo "Submited";
}
哦,就像我上面说的:
请不要使用
mysql_
数据库扩展,它 已弃用(在 PHP7 中永远消失) 特别是如果你只是在学习PHP,把你的精力花在学习PDO
数据库扩展上。 从这里开始
我在这里猜测,但我猜你不需要 VALUES 子句中的第一个参数,即 VALUES (0,
因为我假设这是一个auto-increment
列,所以总是使用 0 会导致错误。
如果是这种情况,请不要添加该参数,即
VALUES ('$pincode','$username','$firstname','$lastname',
'$email','$password', '$sq', '$company', '$website',
'$address1', '$address2', '$city','$zipcode',
'$country')";
或传递空
VALUES (NULL,'$pincode','$username','$firstname','$lastname',
'$email','$password', '$sq', '$company', '$website',
'$address1', '$address2', '$city','$zipcode',
'$country')";
完全关闭它更简单
交替
您可能以错误的顺序获取参数,即与数据库定义的顺序不匹配。在这种情况下,它可能会失败,因为数据类型不匹配,或者传递的数据对于它所在的列来说太大。
使用表单总是最安全的
INSERT INTO Table (column1, column2) VALUES ('data1', 'data2' )
确保值进入正确的列。请记住,总是可以更改数据库中的列,添加/删除并影响列的默认顺序,然后所有此类语句都将失败,您必须搜索代码以查找发生的奇怪错误。请记住,修改表格布局的可能不是您。
列顺序错误
您不会从屏幕上的用户那里收集C_securityanswer。因此,您不会将其传递给查询!因此,上面我调用 Alternative 的部分将生效,并且以下所有列都是 1 漂移。这实际上并不会导致问题(数据类型或列大小 wize),直到我们尝试将 TEXT $country放入列C_zipcode这是一个 int(10),在那里它会匆忙变坏。
实际上,该字段可能不应该是 int,但这就是导致查询失败的原因。
$sql = "INSERT INTO customers
VALUES (0,'$pincode','$username','$firstname','$lastname',
'$email','$password', '$sq',
??? there is a column here on the database
'$company', '$website',
'$address1', '$address2', '$city','$zipcode',
'$country')";
但是,您当前错误的真正原因是您已经删除了此行
$res=mysql_query($sql);
因此,查询实际上永远不会运行!!!呜