============================================================================================第二个文件(registry2)代码============================================================================================<!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=gb2312" />
<title>无标题文档</title>
</head><body><form name="regstep2" method="post" action="registry3.php">
<input type="hidden" name="username" value="<?=$username?>" />
<input type="hidden" name="userpass" value="<?=$userpass?>" />
<input type="hidden" name="pass_rem" value="<?=$pass_rem?>" />
<input type="hidden" name="pass_ans" value="<?=$pass_ans?>" />
<br>
<table width="446" border="1" bordercolor="#000000" align="center" cellspacing="0">
<tr>
<td>
<table width="440" border="0" align="center" bgcolor="#eeeeee" cellspacing="0" cellpadding="0">
<tr>
<td colspan="2" bgcolor="#ffffff">
<div align="center"><img src="images/2.gif" width="298" height="41" /></div>
</td>
</tr>
<tr>
<td>
<div align="center">姓 氏</div>
</td>
<td height="18">
<div align="center">
<input type="text" name="surname" size="20" />
</div>
</td>
</tr>
<tr>
<td bgcolor="#ffffff">
<div align="center">名 字</div>
</td>
<td height="18" bgcolor="#ffffff">
<div align="center">
<input type="text" name="frontname" size="20" />
</div>
</td>
</tr>
<tr>
<td>
<div align="center">身 份 证 号 码</div>
</td>
<td height="18">
<div align="center">
<input type="text" name="sid" size="20" />
</div>
</td>
</tr>
<tr>
<td bgcolor="#ffffff">
<div align="center">昵 称</div>
</td>
<td height="18" bgcolor="#ffffff">
<div align="center">
<input type="text" name="nickname" size="20" />
</div>
</td>
</tr>
<tr>
<td>
<div align="center">性 别</div>
</td>
<td height="18">
<div align="center">
<input name="gentle" type="radio" value="0" checked="checked" />
男
<input name="gentle" type="radio" value="1" />
女
</div>
</td>
</tr>
<tr>
<td bgcolor="#ffffff">
<div align="center">生 日</div>
</td>
<td height="18" bgcolor="#ffffff">
<div align="center">
<input type="text" name="birth" size="20" />
</div>
</td>
</tr>
<tr>
<td>
<div align="center">是 否 已 婚</div>
</td>
<td height="18">
<div align="center">
<input type="radio" name="marriage" value="0" checked="checked" /> 否
<input type="radio" name="marriage" value="1" /> 是
</div>
</td>
</tr>
<tr>
<td bgcolor="#ffffff">
<div align="center">居 住 地 址</div>
</td>
<td height="18" bgcolor="#ffffff">
<div align="center">
<input type="text" name="area" size="20" />
</div>
</td>
</tr>
<tr>
<td>
<div align="center">邮 编</div>
</td>
<td height="18">
<div align="center">
<input type="text" name="zipcode" size="20" />
</div>
</td>
</tr>
<tr>
<td bgcolor="#ffffff">
<div align="center">住 址</div>
</td>
<td height="18" bgcolor="#ffffff">
<div align="center">
<input type="text" name="address" size="20" />
</div>
</td>
</tr>
<tr>
<td>
<div align="center">电 话</div>
</td>
<td height="18">
<div align="center">
<input type="text" name="phone" size="20" />
</div>
</td>
</tr>
<tr>
<td bgcolor="#ffffff">
<div align="center">手 机 号 码</div>
</td>
<td height="18" bgcolor="#ffffff">
<div align="center">
<input type="text" name="mobile" size="20" />
</div>
</td>
</tr>
<tr>
<td colspan="2">
<div align="center">
<input type="reset" name="submit" value="清除重填" />
<input type="submit" class="box2" name="submit2" value="下一步" />
</div>
</td>
</tr>
</table>
</td>
</tr>
</table>
</form>
</body>
</html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
</head><body><form name="regstep2" method="post" action="registry3.php">
<input type="hidden" name="username" value="<?=$username?>" />
<input type="hidden" name="userpass" value="<?=$userpass?>" />
<input type="hidden" name="pass_rem" value="<?=$pass_rem?>" />
<input type="hidden" name="pass_ans" value="<?=$pass_ans?>" />
<br>
<table width="446" border="1" bordercolor="#000000" align="center" cellspacing="0">
<tr>
<td>
<table width="440" border="0" align="center" bgcolor="#eeeeee" cellspacing="0" cellpadding="0">
<tr>
<td colspan="2" bgcolor="#ffffff">
<div align="center"><img src="images/2.gif" width="298" height="41" /></div>
</td>
</tr>
<tr>
<td>
<div align="center">姓 氏</div>
</td>
<td height="18">
<div align="center">
<input type="text" name="surname" size="20" />
</div>
</td>
</tr>
<tr>
<td bgcolor="#ffffff">
<div align="center">名 字</div>
</td>
<td height="18" bgcolor="#ffffff">
<div align="center">
<input type="text" name="frontname" size="20" />
</div>
</td>
</tr>
<tr>
<td>
<div align="center">身 份 证 号 码</div>
</td>
<td height="18">
<div align="center">
<input type="text" name="sid" size="20" />
</div>
</td>
</tr>
<tr>
<td bgcolor="#ffffff">
<div align="center">昵 称</div>
</td>
<td height="18" bgcolor="#ffffff">
<div align="center">
<input type="text" name="nickname" size="20" />
</div>
</td>
</tr>
<tr>
<td>
<div align="center">性 别</div>
</td>
<td height="18">
<div align="center">
<input name="gentle" type="radio" value="0" checked="checked" />
男
<input name="gentle" type="radio" value="1" />
女
</div>
</td>
</tr>
<tr>
<td bgcolor="#ffffff">
<div align="center">生 日</div>
</td>
<td height="18" bgcolor="#ffffff">
<div align="center">
<input type="text" name="birth" size="20" />
</div>
</td>
</tr>
<tr>
<td>
<div align="center">是 否 已 婚</div>
</td>
<td height="18">
<div align="center">
<input type="radio" name="marriage" value="0" checked="checked" /> 否
<input type="radio" name="marriage" value="1" /> 是
</div>
</td>
</tr>
<tr>
<td bgcolor="#ffffff">
<div align="center">居 住 地 址</div>
</td>
<td height="18" bgcolor="#ffffff">
<div align="center">
<input type="text" name="area" size="20" />
</div>
</td>
</tr>
<tr>
<td>
<div align="center">邮 编</div>
</td>
<td height="18">
<div align="center">
<input type="text" name="zipcode" size="20" />
</div>
</td>
</tr>
<tr>
<td bgcolor="#ffffff">
<div align="center">住 址</div>
</td>
<td height="18" bgcolor="#ffffff">
<div align="center">
<input type="text" name="address" size="20" />
</div>
</td>
</tr>
<tr>
<td>
<div align="center">电 话</div>
</td>
<td height="18">
<div align="center">
<input type="text" name="phone" size="20" />
</div>
</td>
</tr>
<tr>
<td bgcolor="#ffffff">
<div align="center">手 机 号 码</div>
</td>
<td height="18" bgcolor="#ffffff">
<div align="center">
<input type="text" name="mobile" size="20" />
</div>
</td>
</tr>
<tr>
<td colspan="2">
<div align="center">
<input type="reset" name="submit" value="清除重填" />
<input type="submit" class="box2" name="submit2" value="下一步" />
</div>
</td>
</tr>
</table>
</td>
</tr>
</table>
</form>
</body>
</html>
============================================================================================第三个文件(registry3)代码============================================================================================<!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=gb2312" />
<title>无标题文档</title>
</head><body>
<form name="regstep3" method="post" action="registry_do.php">
<input type="hidden" name="username" value="<?=$username?>">
<input type="hidden" name="userpass" value="<?=$userpass?>">
<input type="hidden" name="pass_rem" value="<?=$pass_rem?>">
<input type="hidden" name="pass_ans" value="<?=$pass_ans?>">
<input type="hidden" name="surname" value="<?=$surname?>">
<input type="hidden" name="frontname" value="<?=$frontname?>">
<input type="hidden" name="nickname" value="<?=$nickname?>">
<input type="hidden" name="gentle" value="<?=$gentle?>">
<input type="hidden" name="sid" value="<?=$sid?>">
<input type="hidden" name="birth" value="<?=$year."-".$month."-".$day?>">
<input type="hidden" name="marriage" value="<?=$marriage?>">
<input type="hidden" name="area" value="<?=$area?>">
<input type="hidden" name="zipcode" value="<?=$zipcode?>">
<input type="hidden" name="address" value="<?=$address?>">
<input type="hidden" name="phone" value="<?=$phone1."-".$phone2?>">
<input type="hidden" name="mobile" value="<?=$mobile?>">
<br />
<table width="446" border="1" bordercolor="#000000" align="center" cellspacing="0">
<tr>
<td>
<table width="440" border="0" align="center" bgcolor="#eeeeee" cellspacing="0" cellpadding="0">
<tr>
<td colspan="2" bgcolor="#ffffff">
<div align="center"><img src="images/3.gif" width="298" height="41" /></div>
</td>
</tr>
<tr>
<td>
<div align="center">教 育 程 度</div>
</td>
<td height="18">
<div align="center">
<select name="edu">
<option value="硕士">硕士</option>
<option value="博士">博士</option>
<option value="研究生">研究生</option>
<option value="大学本科">大学本科</option>
<option value="大学专科">大学专科</option>
<option value="高中">高中</option>
<option value="中专">中专</option>
<option value="中学">中学</option>
<option value="小学">小学</option>
</select>
</div>
</td>
</tr>
<tr>
<td bgcolor="#ffffff">
<div align="center">职 业</div>
</td>
<td height="18" bgcolor="#ffffff">
<div align="center">
<select name="job">
<option value="电子/通信">电子/通信</option>
<option value="计算机">计算机</option>
<option value="物理化工">物理化工</option>
<option value="教育科学">教育科学</option>
<option value="金融理财">金融理财</option>
</select>
</div>
</td>
</tr>
<tr>
<td>
<div align="center">职 称</div>
</td>
<td height="18">
<div align="center">
<select name="title">
<option value="研究人员">研究人员</option>
<option value="电子工程师">电子工程师</option>
<option value="理财师">理财师</option>
<option value="教育家">教育家</option>
<option value="网络工程师">网络工程师</option>
</select>
</div>
</td>
</tr>
<tr>
<td bgcolor="#ffffff">
<div align="center">兴 趣</div>
</td>
<td height="18" bgcolor="#ffffff">
<div align="center">
<input type="text" name="interest" size="20" />
</div>
</td>
</tr>
<tr>
<td colspan="2">
<div align="center">
<input type="reset" name="submit" value="清除重填" />
<input type="submit" name="submit2" value="提交" >
</div>
</td>
</tr>
</table>
</td>
</tr>
</table>
</form>
</body>
</html>
接上
============================================================================================第四个文件(registry_do.php)代码============================================================================================<?
include("db_conn.php");
include("db_func.php");
//增加会员帐号/密码BEGIN
$sqlstruser = "INSERT INTO member(m_username,m_userpass,m_userfrontname,m_sid,m_pass_rem,m_pass_ans)";
$sqlstruser .= "VALUES('$username','MD5($userpass)','$pass_rem','$pass_ans')";
db_query($sqlstruser);
//增加会员帐号/密码END
//增加会员基本信息BEGIN
$sqlstrinfo = "INSERT INTO member_info (m_surname,m_frontname,m_id,m_nickname,m_gentle,m_birth,m_marriage,m_area,m_zipcode,m_address,m_phone,m_mobile)";
$sqlstr = "VALUES('$surname','$frontname','$nickname','$gentle','$birth','$marriage','$area','$zipcode','$address','$phone','$mobile')";
db_query($sqlstrinfo);
//增加会员基本信息END
//增加会员其他信息BEGIN
$sqlstradd = "INSERT INTO member_add (m_edu,m_job,m_title,m_interest)";
$sqlstradd .= "VALUES ('$edu','$job','$title','$interest')";
db_query($sqlstradd);
//增加会员其他信息END
?><script>
alert("<?php echo "注册完成";?>");
location.href = "registry1.php";
</script>
我提交后只能把第三个文件的信息写入数据库,前两个文件的信息不能写入数据库代码哪里有问题呢???
除非你register_globals = on或使用了extract,否则registry2 registry3 registry_do.php中类似下面的红色部分请使用$_POST如$_POST['username']
<input type="hidden" name="username" value=" <?=$username?>" />
"VALUES('$username','MD5($userpass)','$pass_rem','$pass_ans')";2、使用SESSION
不需要隐藏表单域,只需在session中使用一个变量存储注册信息,如$_SESSION['register']
registry1中unset($_SESSION['register'])
registry2跟registry3中把接的收上一页面的信息全部写进$_SESSION['register'],如$_SESSION['register']['username'] = $_POST['username'];
在registry_do中extract或直接调用session中的信息一并写入数据库。然后删除unset($_SESSION['register'])
echo '<PRE>';
print_r($_POST);
echo '</PRE>';
?>
Sql语句红色部分有问题
你改成$sqlstruser .= "VALUES('{$username}', '".MD5($userpass)."', '{$pass_rem}', '{$pass_ans}');";
这样子没错吧?<?
include("db_conn.php");
include("db_func.php");
//增加会员帐号/密码BEGIN
$sqlstruser = "INSERT INTO member(m_username,m_userpass,m_userfrontname,m_sid,m_pass_rem,m_pass_ans)";
$sqlstruser .= "VALUES('".$_POST["username"]."','".$_POST["userpass"]."','".$_POST["pass_rem"]."','".$_POST["pass_ans"]."')";
db_query($sqlstruser);
//增加会员帐号/密码END
//增加会员基本信息BEGIN
$sqlstrinfo = "INSERT INTO member_info (m_surname,m_frontname,m_id,m_nickname,m_gentle,m_birth,m_marriage,m_area,m_zipcode,m_address,m_phone,m_mobile)";
$sqlstr = "VALUES('".$_POST["surname"]."','".$_POST["frontname"]."','".$_POST["nickname"]."','".$_POST["gentel"]."','".$_POST["birth"]."','".$_POST["marriage"]."','".$_POST["area"]."','".$_POST["zipcode"]."','".$_POST["address"]."','".$_POST["phone"]."','".$_POST["mobile"]."')";
db_query($sqlstrinfo);
//增加会员基本信息END
//增加会员其他信息BEGIN
$sqlstradd = "INSERT INTO member_add (m_edu,m_job,m_title,m_interest)";
$sqlstradd .= "VALUES ('".$_POST["edu"]."','".$_POST["job"]."','".$_POST["title"]."','".$_POST["interest"]."')";
db_query($sqlstradd);
//增加会员其他信息END
?><script>
alert("<?php echo "注册完成";?>");
location.href = "registry1.php";
</script>