登陆界面 login.php
[html] view plain copy 在CODE上查看代码片派生到我的代码片
<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] view plain copy 在CODE上查看代码片派生到我的代码片
<?php
if(isset($_POST["submit"]) && $_POST["submit"] == "登陆")
{
$user = $_POST["username"];
$psw = $_POST["password"];
if($user == "" || $psw == "")
{
echo "<script>alert('请输入用户名或密码！'); history.go(-1);</script>";
}
else
{
mysql_connect("localhost","root","sixx");
mysql_select_db("vt");
mysql_query("set names 'gbk'");
$sql = "select username,password from user where username = '$_POST[username]' and password = '$_POST[password]'";
$result = mysql_query($sql);
$num = mysql_num_rows($result);
if($num)
{
$row = mysql_fetch_array($result); //将数据以索引方式储存在数组中
echo $row[0];
}
else
{
echo "<script>alert('用户名或密码不正确！');history.go(-1);</script>";
}
}
}
else
{
echo "<script>alert('提交未成功！'); history.go(-1);</script>";
}
?>
注册界面 register.php
[html] view plain copy 在CODE上查看代码片派生到我的代码片
<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] view plain copy 在CODE上查看代码片派生到我的代码片
<?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)
{
mysql_connect("localhost","root","sixx"); //连接数据库
mysql_select_db("vt"); //选择数据库
mysql_query("set names 'gdk'"); //设定字符集
$sql = "select username from user where username = '$_POST[username]'"; //SQL语句
$result = mysql_query($sql); //执行SQL语句
$num = mysql_num_rows($result); //统计执行结果影响的行数
if($num) //如果已经存在该用户
{
echo "<script>alert('用户名已存在'); history.go(-1);</script>";
}
else //不存在当前注册用户名称
{
$sql_insert = "insert into user (username,password,phone,address) values('$_POST[username]','$_POST[password]','','')";
$res_insert = mysql_query($sql_insert);
//$num_insert = mysql_num_rows($res_insert);
if($res_insert)
{
echo "<script>alert('注册成功！'); history.go(-1);</script>";
}
else
{
echo "<script>alert('系统繁忙，请稍候！'); history.go(-1);</script>";
}
}
}
else
{
echo "<script>alert('密码不一致！'); history.go(-1);</script>";
}
}
}
else
{
echo "<script>alert('提交未成功！'); history.go(-1);</script>";
}
?>
数据表
-- --------------------------------------------------------
-- 主机: 127.0.0.1
-- 服务器版本: 5.1.72-community - MySQL Community Server (GPL)
-- 服务器操作系统: Win32
-- HeidiSQL 版本: 8.1.0.4545
-- --------------------------------------------------------
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
-- 导出 vt 的数据库结构
CREATE DATABASE IF NOT EXISTS `vt` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `vt`;
-- 导出 表 vt.user 结构
CREATE TABLE IF NOT EXISTS `user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` varchar(100) NOT NULL,
`password` varchar(100) NOT NULL,
`phone` varchar(100) DEFAULT NULL,
`address` varchar(255) DEFAULT NULL,
KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1 COMMENT='用户表';
-- 正在导出表 vt.user 的数据：~0 rows (大约)
/*!40000 ALTER TABLE `user` DISABLE KEYS */;
INSERT INTO `user` (`id`, `username`, `password`, `phone`, `address`) VALUES
(1, 'a', '1', '', ''),
(2, 'b', '1', '', ''),
(3, 'c', '1', '', '');
/*!40000 ALTER TABLE `user` ENABLE KEYS */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
