一个简单的web注册实例 [复制链接]

darkfire

注册会员

Rank: 2

电梯直达

楼主

发表于 2012-9-14 15:56:05 |只看该作者 |倒序浏览

本帖最后由 darkfire 于 2012-9-14 16:06 编辑

<?php
$con = mysql_connect("localhost","SQL帐号","SQL密码");//链接数据库
if (!$con)
{
die('Could not connect: ' . mysql_error());
}
mysql_select_db("数据库名", $con);
mysql_query("set names 'gbk'");
if ($_POST)//判断是否有提交
{
//查询库中是否已用帐号
$sql = "SELECT MAX(UserID) FROM fcm_user_info";
$row = mysql_fetch_row(mysql_query($sql));
//判断如果有帐号，得到最大的帐号id并加1,如果没有则默认从500开始注册
if(reset($row)) $id=$row['0']+1; else $id=500;
//提交过来的相关字段，自己可根据需要扩展
$nikename = trim($_POST['usernikename']);
$pw = trim($_POST['password']);
$birth = trim($_POST['birthday']);
$mb = trim($_POST['mobile']);
$ph = trim($_POST['phone']);
$rgtime = date('Y-m-d H:i:s',time());
//插入数据库
$sql = "INSERT INTO fcm_user_info (`UserID`, `UserName`, `UserPwd`, `UserNickname`, `BloodType`, `ConStellation`, `Career`, `ShengXiao`, `FinishSchool`, `HomePage`, `Brief`, `EMail`, `Address`, `PostalCode`, `FixedPhone`, `Mobile`, `Birthday`, `Age`, `Sex`, `Country`, `Province`, `City`, `ImgIdx`, `HasMoney`, `PwdProtect`, `ProtectText`, `RegTime`, `Member`, `OnlineTime`, `Signature`, `CardStyle`, `ThirdAccount`) VALUES ('$id','$nikename','$pw','$nikename','0','0','0','0','','','','','','','$ph','$mb','$birth','0','1','','','','0','20','0','','$rgtime','0','','','','')";
mysql_query($sql);
echo "注删成功！";

}
mysql_close($con);//关闭数据链接
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gbk" />
<title>简单注册程序</title>
</head>
<body>
<form name="form1" method="post" action="">
<p>昵称：<input type="text" name="usernikename" /></p>
<p>密码：<input type="password" name="password" /></p>
<p>生日：<input type="text" name="birthday" />格式：1980-01-02</p>
<p>手机：<input type="text" name="mobile" /></p>
<p>电话：<input type="text" name="phone" /></p>
<input type="submit" value="立即注册" title="立即注册" tabindex="21" id="submit"/>
</form>
</body>
</html>

官方要是能出一个数据字典就更加方便了