1、登陆界面如下 功能包括注册,登陆到留言界面,判断用户是否注册,密码或账号是否正确
<?php session_start(); ?> <!--设置使用session-->
<!DOCTYPE html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>登陆</title>
</head>
<body>
<center>
<h1>登陆</h1>
<?php
include "conn.php";
if (isset($_POST["submit"])){//判断submit是否被设置
if (empty($_POST["user"]) or empty($_POST["password"])) {
echo "<font color='red'> 用户名或者密码不能为空,请重新输入!</font>";
}else{
$user = $_POST["user"];
$password = $_POST["password"];
$sql = "select * from user where username = '$user' and password = '$password'";
//echo $sql;
$result = mysqli_query($conn,$sql);
if (mysqli_num_rows($result) > 0) {
//echo "<font color='green'>登陆成功!</font>";
$persion = mysqli_fetch_array($result);//取结果集result的值赋给persion
$_SESSION["username"] = $persion["username"];//session取值方便后面的使用
//echo $_SESSION["username"];
$_SESSION["uid"] = $persion["uid"];//取当前登陆用户的uid,每个用户的uid是固定的唯一的
//echo $_SESSION["uid"];
echo "<script>alert('登陆成功')</script>";
echo "<script>window.location.href='ly.php'</script>";//本地跳转到ly.php页面
}else{
echo "<font color='red'>用户名或者密码不存在!</font>";
}
}
}
?>
<form action="<?php echo $_SERVER["PHP_SELF"]; ?>" method="post" > <!--$_SERVER["PHP_SELF"]固定函数表示返回当前执行脚本的文件名。-->
<table border="0" >
<tr >
<td >用户名</td>
<td ><input type="text" name="user" ></td>
</tr>
<br />
<tr>
<td>密码</td>
<td><input type="password" name="password"></td>
</tr>
<br />
<tr> <!--colspan 属性规定单元格可横跨的列数。-->
<td colspan="2" align="center"><input type="submit" value="登陆" name="submit">
<input type="submit" name="zhuce" value="注册" onClick="window.open('zhuce.php')">
<!--<input type="button" value="注册" οnclick="document.location.href='http://127.0.0.1/5.php'" >-->
</td>
</tr>
</table>
</form>
</center>
</body>
</html>
效果图
2、登陆前需要注册,注册源码如下,其中的功能包括用户名,邮箱,密码为空时提醒;注册输入两次密码不一样时提醒(功能不是很完善,需要修改)
<!DOCTYPE html>
<html>
<head>
<title>注册</title>
<meta charset="utf-8">
</head>
<body>
<?php
//$user = $_POST["user"];
//$youxiang = $_POST["youxiang"];
//$sex = $_POST["sex"];
//$password = $_POST["password"];
//$repassword = $_POST["repassword"];
include "conn.php";
$user = $youxiang = $sex = $password = "";
$userErr = $youxiangErr = $sexErr = $passwordErr = $repasswordErr = "";
if (isset($_POST["submit"])){//判断是否点击了提交,点击后执行下面的程序
if (empty($_POST["user"])) {
$userErr = "用户名不能为空";
} else {
$user = $_POST["user"];
//echo $user;
echo "<br>";
}
if (empty($_POST["youxiang"])) {
$youxiangErr = "邮箱不能为空";
} else {
$youxiang = $_POST["youxiang"];
//echo $youxiang;
echo "<br>";
}
if (empty($_POST["sex"])) {
$sexErr = "性别不能为空";
} else {
$sex = $_POST["sex"];
//echo $sex;
echo "<br>";
}
if (empty($_POST["password"]) or empty($_POST["repassword"])) {
$passwordErr = "密码不能为空";
} else if ($_POST["password"] != $_POST["repassword"])
{
$passwordErr = "两次密码不一致";
} else{
$password = $_POST["password"];
//
$repassword = $_POST["repassword"];
//echo $password;
echo "<br>";
}
//inclued "conn.php";
//if (isset($user,$email,$sex,$password)){
/* $servername = "localhost";
$username = "root";
$password = "";
$database = "lyb";
// 创建连接
$conn = mysqli_connect("$servername", "$username", "$password","$database");
if (!isset($conn)) {
die("数据库连接错误". mysql_error());
}else{
echo "连接成功!";
}*/
$sql = "select * from user where username = \"$user\"";
//echo $sql;
$result = mysqli_query($conn,$sql);
if (mysqli_num_rows($result) > 0)
{
echo "<script>alert('用户名已存在或未注册,请重新输入!')</script>";
}else{
$time = date("Y-m-d");
$sql = "insert into user(username,email,sex,password,time) VALUES(\"$user\",\"$youxiang\",\"$sex\",\"$password\",\"$time\")";
//echo $sql;
$result1 = mysqli_query($conn,$sql);
//echo $result1;
//var_dump($result1);
if ($result1) {
echo "<script>alert('注册成功!')</script>";
}else{
echo "<script>alert('数据库错误!')</script>";
}
//mysql_close($conn);
}
//}
}
?>
<form action="<?php echo $_SERVER["PHP_SELF"]; ?>" method="post">
<center>
<h1>注 册 界 面</h1>
<table border="1"width="380" cellpadding="4">
<tr>
<td colspan="2" align="center"><font color="red">* 为必填项</fond></td>
</tr>
<tr>
<td>用户名</td>
<th><input type="text" name="user"><font color="red">*<?php echo "$userErr";?></font>
<br></th>
</tr>
<tr>
<td>邮箱</td>
<td>
<input type="text" name="youxiang"><font color="red">*<?php echo $youxiangErr; ?></font>
<br>
</td>
</tr>
<tr>
<td>性别</td>
<td>
<input type="radio" name="sex" value="man">男
<input type="radio" name="sex" value="woman">女<font color="red">*<?php echo $sexErr;?></font>
<br>
</td>
</tr>
<tr>
<td>密码</td>
<td><input type="password" name="password"><font color="red">*<?php echo $passwordErr;?></font>
<br>
</td>
</tr>
<tr>
<td>确认密码</td>
<td><input type="password" name="repassword"><font color="red"><?php echo $repasswordErr;?></font><br></td>
</tr>
<tr>
<td colspan="2" align="center">
<input type="submit" name="submit" value="注册">
<input type="reset" name="reset" value="重置">
</td>
</tr>
</table>
<br />
<a href="123.php">返回登陆</a>
</form>
</center>
</body>
</html>
效果图:
什么都不输入时:
不输入用户名时提醒 用户名不能为空