- 论坛徽章:
- 0
|
请教各位DX一个问题，我想从表单收集用户的信息，并插入到数据库中。
现在做了两个页面，一个收集用户信息的member和把信息插入数据库的member1,请各位高手帮忙看看
我的代码是哪个地方出了问题，代码如下：
member页面：
<html>;
<head>;
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">;
<title>;无标题文档</title>;
</head>;
<body>;
<form name="form1" method="post" action="member1.php">;
<table width="75%" border="1">;
<tr>;
<td width="24%">;姓名</td>;
<td width="76%">;<input name="name" type="text" id="name">;</td>;
</tr>;
<tr>;
<td>;性别</td>;
<td>;<input name="sex" type="text" id="sex">;</td>;
</tr>;
<tr>;
<td>;年龄</td>;
<td>;<input name="age" type="text" id="age">;</td>;
</tr>;
<tr>;
<td>;工作</td>;
<td>;<input name="work" type="text" id="work">;</td>;
</tr>;
<tr>;
<td>;生日</td>;
<td>;<input name="birthday" type="text" id="birthday">;</td>;
</tr>;
<tr>;
<td>;电子邮件</td>;
<td>;<input name="mail" type="text" id="mail">;</td>;
</tr>;
<tr>;
<td>;电话号码</td>;
<td>;<input name="phone" type="text" id="phone">;</td>;
</tr>;
<tr>;
<td>;联系地址</td>;
<td>;<input name="add" type="text" id="add">;</td>;
</tr>;
<tr>;
<td>;喜欢哪类电脑图书</td>;
<td>;<input name="xingqu" type="text" id="xingqu">;</td>;
</tr>;
<tr>;
<td>;个人爱好</td>;
<td>;<input name="aihao" type="text" id="aihao" value="">;</td>;
</tr>;
<tr>;
<td>;&</td>;
<td>;&</td>;
</tr>;
</table>;
<p>;
<input type="submit" name="Submit" value="提交">;
<input type="reset" name="Submit2" value="重置">;
</p>;
</form>;
</body>;
</html>;
member1页面
<?php
//connect to the database - either include a connection variable file
//or type the following lines:
$connect = mysql_connect("localhost", "peng", "123456"
or die ("Hey loser, check your server connection.";
mysql_select_db("ecommerce";
$query = "INSERT INTO member VALUES (
'$_POST[name]', '$_POST[sex]',
'$_POST[age]','$_POST[work]','$_POST[birthday]',
'$_POST[mail]','$_POST[phone]','$_POST[add]','$_POST[xingqu]','$_POST[aihao]');"
$result = mysql_query($query)
or die(mysql_error());
echo " roducts added successfully!";
?>; |
|
免费注册
发表于 2005-06-03 11:19
发表于 2005-06-04 23:38