要求:
1、表单必须与数据库交互
2、注册和登录功能都必须有
登录html代码:
<!DOCTYPE html>
<html>
<head>
<meta charset="GBK" />
<title>表单验证作业</title>
</head>
<body>
<form action="a.php">
<center>
账号:<input type="text" name="username" /><br />
密码:<input type="password" name="password" /><br />
<input type="submit" value="登录" /><br />
<a href="b.html">注册</a>
</center>
</form>
</body>
</html>
注册html代码:
<!DOCTYPE html>
<html>
<head>
<meta charset="GBK">
<title>注册</title>
</head>
<body>
<form action="c.php" method="post">
<center>
账号:<input type="text" name="username" /><br />
密码:<input type="password" name="password" /><br />
确认密码:<input type="password" name="password2" /><br />
<input type="submit" value="注册" />
</center>
</form>
</body>
</html>
登录php代码:
<?php
header(‘content-type: text/html; charset=GBK’);
@$username=$_POST[‘username’];
@$password=$_POST[‘password’];
$conn = mysqli_connect(“127.0.0.1”,”root”,”root”,”sem”);//连接数据库
$sql =” select * from admin where username=’$username’ and password=’$password’”;
$result = mysqli_query($conn,$sql);
$s = mysqli_fetch_array($result);
if($s[‘username’] == $username and $s[‘password’] == $password){
echo ‘登陆成功’;
}else{
echo ‘登陆失败’;
}
?>
注册php代码:
<?php
header(‘content-type: text/html; charset=GBK’);
@$username=$_POST[‘username’];
@$password=$_POST[‘password’];
@$password2=$_POST[‘password2’];
if($password != $password2)
echo “<script>alert(‘两次输入的密码不匹配,请重新输入’);window.location.href=’b.html’</script>“;
$conn = mysqli_connect(“127.0.0.1”,”root”,”root”,”sem”); //连接数据库
$sql2 =” insert into admin(username,password) value(‘$username’,’$password’)”; //插入数据
$result = mysqli_query($conn,$sql2);
$s = $result;
if($s[‘username’] == $username and $s[‘password’] == $password){
echo ‘该账户已存在’;
}else{
echo ‘注册成功’;
}
?>
注意:访问登录和注册页面不应使用绝对路径,应该使用相对路径127.0.0.1访问
登录和注册页面如下: