用户登陆login.php:
<form action="logincheck.php" method="post">
用户名:<input type="text" name="username" />
<br />
密码:<input type="password" name="password" />
<br />
<input type="submit" name="submit" value="登陆" />
<a href="register.php">注册</a>
</form>
用户登陆检查logincheck.php:
<?php
if(isset($_POST["submit"]) && $_POST["submit"] == "登陆")
{
$user = $_POST["username"];
$psw = $_POST["password"];
if($user == "" || $psw == "")
{
echo "<script>alert('请输入用户名或密码!'); history.go(-1);</script>";
}
else
{
$con = mysqli_connect("localhost","root","123456");
mysqli_select_db($con,"user");
mysqli_query($con,"set names 'utf-8'");
$sql = "select username,password from userregister where username = '$_POST[username]' and password = '$_POST[password]'";
$result = mysqli_query($con,$sql);
if ($result != false)
{
$num = mysqli_num_rows($result);
if($num)
{
$row = mysqli_fetch_array($result); //将数据以索引方式储存在数组中
echo $row[0];
}
else
{
echo "<script>alert('用户名或密码不正确!');history.go(-1);</script>";
}
}
mysqli_close($con);
}
}
else
{
echo "<script>alert('提交未成功!'); history.go(-1);</script>";
}
?>
用户注册register.php:
<form action="regcheck.php" method="post">
用户名:<input type="text" name="username" />
<br/>
密码:<input type="password" name="password"/>
<br/>
确认密码:<input type="password" name="confirm"/>
<br/>
<input type="Submit" name="Submit" value="注册"/>
</form>
用户注册检查regcheck.php:
<?php
if(isset($_POST["Submit"]) && $_POST["Submit"] == "注册")
{
$user = $_POST["username"];
$psw = $_POST["password"];
$psw_confirm = $_POST["confirm"];
if($user == "" || $psw == "" || $psw_confirm == "")
{
echo "<script>alert('请确认信息完整性!'); history.go(-1);</script>";
}
else
{
if($psw == $psw_confirm)
{
$con = mysqli_connect("localhost","root","123456"); //连接数据库
mysqli_select_db($con,"user"); //选择数据库
mysqli_query($con,"set names 'utf-8'"); //设定字符集
$sql = "select username from userregister where username = '$_POST[username]'"; //SQL语句
$result = mysqli_query($con,$sql); //执行SQL语句
if ($result != false)
{
$num = mysqli_num_rows($result); //统计执行结果影响的行数
if($num) //如果已经存在该用户
{
echo "<script>alert('用户名已存在'); history.go(-1);</script>";
}
else //不存在当前注册用户名称
{
$sql_insert = "insert into userregister (username,password) values('$_POST[username]','$_POST[password]')";
mysqli_free_result($num);
$res_insert = mysqli_query($con,$sql_insert);
//$num_insert = mysqli_num_rows($res_insert);
if($res_insert)
{
echo "<script>alert('注册成功!'); history.go(-1);</script>";
}
else
{
echo "<script>alert('系统繁忙,请稍候!'); history.go(-1);</script>";
}
}
mysqli_close($con);
}
}
else
{
echo "<script>alert('密码不一致!'); history.go(-1);</script>";
}
}
}
else
{
echo "<script>alert('提交未成功!'); history.go(-1);</script>";
}
?>
mysql:(命令大全:http://c.biancheng.net/cpp/html/1448.html)
参考文章地址:
http://blog.csdn.net/jimoshuicao/article/details/17403327