所以我试图建立一个登录系统的网站开发,我是很新的php,所以我已经跳在深端有点。我的目标是创建一个注册表单,如果密码不匹配,它不添加数据,并显示一个错误,如果用户名采取。我已经找到了这两个代码,但我不确定如何实现它们在一起。
<?php
$dbhost = "localhost";
$dbuser = "root";
$dbpass = "";
$dbname = "immo";
//Connection to the DB
$con = mysqli_connect($dbhost,$dbuser,$dbpass,$dbname) or die ($dberror1);
session_start();
if (isSet($_POST['Register']) && isSet($_POST['Username']) && isSet($_POST['Password']) && $_POST['Username'] != '' && $_POST['Password'] != '') {
$Password = $_POST['Password'];
$passMD5 = md5($Password);
$Username = $_POST['Username'];
$q = mysqli_query($con, "SELECT * FROM `users` WHERE `Username`='$Username'");
if (mysqli_num_rows($q) > 0) {
echo 'That username is already taken.';
}
if ($_POST['Password']!= $_POST['ConfirmPassword']){
echo("Oops! Password did not match! Try again. ");
}
else{
$qq = mysqli_query($con, "INSERT INTO `users` VALUES ('', '$Username', '$passMD5')");
if ($qq) {
echo 'Registered successfully!';
}else
echo 'Failed to register.';
}
}
?>
<form method="post" class="registration_form">
<fieldset>
<legend>Registration Form </legend>
<table>
<tbody>
<tr>
<td class="label"><label for="Username">Username :</label></td>
<td class="input"><input type="text" id="Username" name="Username" required/></td>
<td class="error"></td>
</tr>
<tr>
<td class="label"><label for="Fname">First Name :</label></td>
<td class="input"><input type="text" id="Firstname" name="Firstname" required/></td>
<td class="error"></td>
</tr>
<tr>
<td class="label"> <label for="Lname">Last Name :</label></td>
<td class="input"><input type="text" id="Lastname" name="Lastname" required/></td>
<td class="error"></td>
</tr>
<tr>
<td class="label"><label for="e-mail">E-mail :</label></td>
<td class="input"><input type="email" id="Email" name="Email" required/></td>
<td class="error"></td>
</tr>
<tr>
<td class="label"><label for="Password">Password:</label></td>
<td class="input"><input type="password" id="Password" name="Password" required/></td>
<td class="error"></td>
</tr>
<tr>
<td class="label"><label for="ConfirmPassword">Confirm Password:</label></td>
<td class="input"><input type="password" id="ConfirmPassword" name="ConfirmPassword" required/></td>
<td class="error"></td>
</tr>
<tr>
<td><input type="hidden" name="formsubmitted" value="TRUE" /></td>
<td><input type="submit" id="Register" value="Register" name="Register" /></td>
<td class="error"></td>
</tr>
</tbody>
</table>
</fieldset>
</form>
不好看,但是:
<?php
session_start();
if (isSet($_POST['Register']) && isSet($_POST['Username']) && isSet($_POST['Password']) && $_POST['Username'] != '' && $_POST['Password'] != '') {
$Password = $_POST['Password'];
$passMD5 = md5($Password);
$Username = $_POST['Username'];
$q = mysqli_query($con, "SELECT * FROM `users` WHERE `Username`='$Username'");
if (mysqli_num_rows($q) == 0) {
if ($_POST['Password'] == $_POST['ConfirmPassword']){
$qq = mysqli_query($con, "INSERT INTO `users` VALUES ('', '$Username', '$passMD5')");
if ($qq) {
echo 'Registered successfully!';
} else {
echo 'Failed to register.';
}
} else {
echo "Oops! Password did not match! Try again.";
}
} else {
echo 'That username is already taken.';
}
}
?>