我的代码中遇到了某种php错误,但我不确定它是什么 当你到达底部PHP时,我的代码在最后开始变得有趣。我正在尝试验证用户名和密码,但我收到某种类型的错误
<?php
include 'config.php';
?>
<!DOCTYPE html>
<html>
<head>
<title>Register Page</title>
<link rel="stylesheet" href="style.css">
</head>
<body>
<div id="main-wrapper">
<center>
<h2 style="color: white;">Register Page</h2>
<img class="avatar" src="spaceman2.jpg" style="height: 100px; width: 100px" />
</center>
<form class="my-form" action="register.php" method="post">
<label><b>Username<b></label>
<input name="username" type="text" class="input-values" placeholder="Your username" required/>
<label><b>Password<b></label>
<input name="password" type="password" class="input-values" placeholder="Your password" required/>
<label><b>Confirm Password<b></label>
<input name="cpassword" type="password" class="input-values" placeholder="Confirm password" required/>
<input name="signup_btn" id="signup-btn" type="submit" value="Sign Up"/>
<br/>
<a href="login.php"><input id="back-btn" type="button" value="<- Back"/></a>
</form>
<?php
if(isset($_POST['signup_btn']))
{
//echo '<script type="text/javascript"> alert("You are now signed in!")</script>';
$username = $_POST['username'];
$password = $_POST['password'];
$cpassword = $_POST['password'];
if($password == $cpassword)
{
$query= "SELECT * FROM user WHERE username ='$username'";
$query_run = mysqli_query($con,$query);
if(mysqli_num_rows($query_run)>0)
{
echo '<script type="text/javascript"> alert("Astronaut name already exist") </script>';
}
{
$query= "insert into user values('$username','$password')";
$query_run = mysqli_query($con, $query);
if($query_run)
{
echo '<script type="text/javascript"> alert("Astronaut is now registered! Go to Login Page!") </script>';
}
else
{
echo '<script type="text/javascript"> alert("Error!") </script>';
}
}
?>
几件事:
您的$cpassword引用的是您的 $_POST['password'] 而不是 cpassword。
插入语句缺少 VALUES 之前的列引用。
您还应该考虑一些密码散列/加密。
您的代码由于以下原因而出错
特别是在PHP中
你忘记了else
,你用password
来$cpasswrod
在html
你不关闭</b>
<?php
include 'config.php';
if(isset($_POST['signup_btn']))
{
//echo '<script type="text/javascript"> alert("You are now signed in!")</script>';
$username = $_POST['username'];
$password = $_POST['password'];
$cpassword = $_POST['cpassword'];
if($password == $cpassword){
$query= "SELECT * FROM user WHERE username ='$username'";
$query_run = mysqli_query($con,$query);
if(mysqli_num_rows($query_run)>0)
{
echo '<script type="text/javascript"> alert("Astronaut name already exist") </script>';
}
else{
$query= "insert into user values('$username','$password')";
$query_run = mysqli_query($con, $query);
if($query_run)
{
echo '<script type="text/javascript"> alert("Astronaut is now registered! Go to Login Page!") </script>';
}
else
{
echo '<script type="text/javascript"> alert("Error!") </script>';
}
}
}
}
?>
<html>
<head>
<title>Register Page</title>
<link rel="stylesheet" href="style.css" />
</head>
<body>
<div id="main-wrapper">
<center>
<h2 style="color: white;">Register Page</h2>
<img class="avatar" src="spaceman2.jpg" style="height: 100px; width: 100px" />
</center>
<form class="my-form" action="index.php" method="post">
<label><b>Username</b></label>
<input name="username" type="text" class="input-values" placeholder="Your username" required/>
<label><b>Password</b></label>
<input name="password" type="password" class="input-values" placeholder="Your password" required/>
<label><b>Confirm Password</b></label>
<input name="cpassword" type="password" class="input-values" placeholder="Confirm password" required/>
<input name="signup_btn" id="signup-btn" type="submit" value="Sign Up"/>
<br/>
<a href="login.php"><input id="back-btn" type="button" value="<- Back"/></a>
</form>
</div>
</body>
</html>
我希望它有所帮助
下面是代码的新版本:(试试看(
<?php
include 'config.php';
?>
<!DOCTYPE html>
<html>
<head>
<title>Register Page</title>
<link rel="stylesheet" href="style.css">
</head>
<body>
<div id="main-wrapper">
<center>
<h2 style="color: white;">Register Page</h2>
<img class="avatar" src="spaceman2.jpg" style="height: 100px; width: 100px" />
</center>
<form class="my-form" action="register.php" method="post">
<label><b>Username</b></label>
<input name="username" type="text" class="input-values" placeholder="Your username" required />
<label><b>Password</b></label>
<input name="password" type="password" class="input-values" placeholder="Your password" required />
<label><b>Confirm Password</b></label>
<input name="cpassword" type="password" class="input-values" placeholder="Confirm password" required />
<input name="signup_btn" id="signup-btn" type="submit" value="Sign Up"/>
<br/>
<a href="login.php"><input id="back-btn" type="button" value="<- Back"/></a>
</form>
<?php
if(isset($_POST['signup_btn']))
{
//echo '<script type="text/javascript"> alert("You are now signed in!")</script>';
$username = $_POST['username'];
$password = $_POST['password'];
$cpassword = $_POST['cpassword'];
if($password == $cpassword)
{
$query= "SELECT * FROM user WHERE username ='$username'";
$query_run = mysqli_query($con,$query);
if(mysqli_num_rows($query_run)>0)
{
echo '<script type="text/javascript"> alert("Astronaut name already exist") </script>';
}else
{
$query= "insert into user (username, password) values('$username','$password')";
$query_run = mysqli_query($con, $query);
if($query_run)
{
echo '<script type="text/javascript"> alert("Astronaut is now registered! Go to Login Page!") </script>';
}
else
{
echo '<script type="text/javascript"> alert("Error!") </script>';
}
}
}
}
?>
</div>
</body>
</html>