写了一个注册登录的简单实现,首先要创建名为db的数据库
,并包含名为user 的表
create database db;
use db;
create table user (serial int unsigned not null primary key auto_increment, ID varchar(20) not null , passwd varchar(20) not null);
login.php原码
<html>
<head>
<meta http-equiv="content-type" content="text/html;charset=GB2312" />
<title>会员登录</title>
</head>
<body bgcolor="white" text="black" link="blue" vlink="purple" alink="red">
<h1 align="center">会员登录</h1>
<form name="form2" action="chk.php" method="post">
<p align="center">请输入账号:<input type="text" name="ID" /></p>
<p align="center">请输入密码:<input type="password" name="passwd" /></p>
<p align="center"><input type="submit" name="提交" /><input type="reset" name="重设" /></p>
<h3 align="center"><a href="add.php">注册</a></h3>
</form>
</body>
</html>
<head>
<meta http-equiv="content-type" content="text/html;charset=GB2312" />
<title>会员登录</title>
</head>
<body bgcolor="white" text="black" link="blue" vlink="purple" alink="red">
<h1 align="center">会员登录</h1>
<form name="form2" action="chk.php" method="post">
<p align="center">请输入账号:<input type="text" name="ID" /></p>
<p align="center">请输入密码:<input type="password" name="passwd" /></p>
<p align="center"><input type="submit" name="提交" /><input type="reset" name="重设" /></p>
<h3 align="center"><a href="add.php">注册</a></h3>
</form>
</body>
</html>
add.php原码
<html>
<head>
<meta http-equiv="content-type" content="text/html ; charest=GB2312" />
<title>会员注册</title>
</head>
<body bgcolor="white" text="black" link="blue" vlink="purple" alink="red">
<h1 align="center">会员注册</h1>
<form name="form1" action="add_chk.php" method="post">
<p align="center">请输入你要使用的账号<input type="text" name="ID" /></p>
<p align="center">请输入你要使用的密码<input type="password" name="passwd" /></p>
<p align="center">请重新输入密码以确认<input type="password" name="repasswd" /></p>
<p align="center"><input type="submit" name="提交" /><input type="reset" name="重设" /></p>
</form>
</body>
</html>
<head>
<meta http-equiv="content-type" content="text/html ; charest=GB2312" />
<title>会员注册</title>
</head>
<body bgcolor="white" text="black" link="blue" vlink="purple" alink="red">
<h1 align="center">会员注册</h1>
<form name="form1" action="add_chk.php" method="post">
<p align="center">请输入你要使用的账号<input type="text" name="ID" /></p>
<p align="center">请输入你要使用的密码<input type="password" name="passwd" /></p>
<p align="center">请重新输入密码以确认<input type="password" name="repasswd" /></p>
<p align="center"><input type="submit" name="提交" /><input type="reset" name="重设" /></p>
</form>
</body>
</html>
add_chk.php原码
<?php
// 判断输入
if($_POST['ID']==' ' or $_POST['passwd']==' ' or $_POST['repasswd']==' ')
{ my_msg("账号或密码为空,返回重新输入","add.php"); }
if($_POST['passwd'] != $_POST['repasswd'])
{ my_msg("两次密码不符","add.php"); }
// 连接数据库
$link = mysql_connect("localhost","root","123456");
mysql_select_db("db");
// 写入数据
$sqlstr = "insert into user values(' ','".$_POST['ID']."','".$_POST['passwd']."')";
$result = mysql_query($sqlstr,$link);
echo "注册成功";
//mysql_free_result($result);
mysql_close($link);
?>
// 判断输入
if($_POST['ID']==' ' or $_POST['passwd']==' ' or $_POST['repasswd']==' ')
{ my_msg("账号或密码为空,返回重新输入","add.php"); }
if($_POST['passwd'] != $_POST['repasswd'])
{ my_msg("两次密码不符","add.php"); }
// 连接数据库
$link = mysql_connect("localhost","root","123456");
mysql_select_db("db");
// 写入数据
$sqlstr = "insert into user values(' ','".$_POST['ID']."','".$_POST['passwd']."')";
$result = mysql_query($sqlstr,$link);
echo "注册成功";
//mysql_free_result($result);
mysql_close($link);
?>
chk.php原码
<?php
// 连接数据库
$link = mysql_connect("localhost","root","123456");
mysql_select_db("db");
// 查询
$sqlstr = "select * from user where ID='" .$_POST['ID']."'and passwd='".$_POST['passwd']. " ' ";
$result = mysql_query($sqlstr,$link);
// 判断账号是否唯一
if (mysql_num_rows($result)==1) {
echo "<center>会员登录成功</center>";
} else {
echo "<center>会员登录失败</center>";
}
mysql_free_result($result);
mysql_close($link);
?>
// 连接数据库
$link = mysql_connect("localhost","root","123456");
mysql_select_db("db");
// 查询
$sqlstr = "select * from user where ID='" .$_POST['ID']."'and passwd='".$_POST['passwd']. " ' ";
$result = mysql_query($sqlstr,$link);
// 判断账号是否唯一
if (mysql_num_rows($result)==1) {
echo "<center>会员登录成功</center>";
} else {
echo "<center>会员登录失败</center>";
}
mysql_free_result($result);
mysql_close($link);
?>