从表单到数据库帮助插入数据 [英] inserting data from form to database help
问题描述
嗨我想知道是否有人可以帮我解决这个代码问题
我正在尝试todo是创建一个注册页面,其中用户输入信息进入数据库继承人代码
[b]表格代码[B /]
[HTML]
< html>
< head>
< title>注册表格< / title>
< / head>
< body>
< form name = form1 method = post action = register.php>
< table width = 100%border = 0 cellpadding = 4 cellspacing = 0>
< tr>
< td width = 24%align = left valign = top>名字< / td>
< td width = 76%><输入名称= first_name type = text id = first_name2>< / td>
< / tr>
< tr>
< td align = left valign = top>姓氏< / td>
< td><输入名称= last_name type = text id = last_name>< / td>
< / tr>
< tr>
< td align = left valign = top>电子邮件地址< / td>
< td>< input name = email_address type = text id = email_address>< / td>
< / tr>
< tr>
< td align = left valign = top>所需的用户名< / td>
< td>< input name = username type = text id = username>< / td>
< / tr>
< tr>
< td align = left valign = top>关于你的信息:< / td>
< td>< textarea name =密码id =密码>< / textarea>< / td> < / TR>
< tr>
< td align = left valign = top> < / TD>
< td><输入类型=提交名称=提交值=立即加入!>< / td>
< / tr>
< / table>
< / form>
< / body>
< / html>
[/ HTML]
数据库代码register.php
[PHP]
<?php
//创建一个新的连接对象
$ adoCon = new COM(" ADODB.Connection");
//使用标准Access连接字符串打开连接
$ adoCon->打开(" Provider = Microsoft.Jet.OLEDB.4.0; Data Source = \ wamp \\\ PRU.mdb");
{$ adoCon->执行
(INSERT INTO tblUsers
(名字,姓氏,电子邮件,用户名,密码)
VALUES
( '' $ _ POST [名字] '', '' $ _ POST [姓氏] '', '' $ _ POST [EMAIL_ADDRESS] '', '' $ _ POST [用户名] '', '' $ _ POST [密码] '') ;"
);
}
//关闭连接,释放资源,杀死所有痕迹>
$ adoCon->关闭();
$ adoCon = null;
{adocon
?> ;
[/ PHP]
并按下提交按钮后出现错误消息
解析错误:解析错误,第23行的C:\ wamp \\\\\ [注册数据
adoCon =新COM(" ADODB.Connection";
//使用标准Access连接字符串打开连接
adoCon-> Open( "提供商= Microsoft.Jet.OLEDB.4.0;数据源= \wamp \\\\PRU.mdb");
{
adoCon->执行
(INSERT INTO tblUsers
(名字,姓氏,电子邮件,用户名,密码)
VALUES
(''
hi im wondering is anyone can help me with this peice of code
what i am trying todo is to create a register page where users type information which goes into a database heres the code
[b]FORM CODE [B/]
[HTML]
<html>
<head>
<title>Signup Form</title>
</head>
<body>
<form name=form1 method=post action=register.php>
<table width=100% border=0 cellpadding=4 cellspacing=0>
<tr>
<td width=24% align=left valign=top>First Name</td>
<td width=76%><input name=first_name type=text id=first_name2></td>
</tr>
<tr>
<td align=left valign=top>Last Name</td>
<td><input name=last_name type=text id=last_name></td>
</tr>
<tr>
<td align=left valign=top>Email Address</td>
<td><input name=email_address type=text id=email_address></td>
</tr>
<tr>
<td align=left valign=top>Desired Username</td>
<td><input name=username type=text id=username></td>
</tr>
<tr>
<td align=left valign=top>Information about you:</td>
<td><textarea name=password id=password></textarea></td> </tr>
<tr>
<td align=left valign=top> </td>
<td><input type=submit name=Submit value=Join Now!></td>
</tr>
</table>
</form>
</body>
</html>
[/HTML]
DATABASE CODE register.php
[PHP]
<?php
// creates a new connection object
$adoCon = new COM("ADODB.Connection");
// opens the connection using a standard Access connection string
$adoCon->Open("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=\wamp\www\PRU.mdb");
{ $adoCon->Execute
( "INSERT INTO tblUsers
(firstname,lastName,email,username,password)
VALUES
(''$_POST[first_name]'',''$_POST[last_name]'',''$_POST[email_address]'',''$_POST[username]'',''$_POST[password]'');"
);
}
// closes the connection, frees up resources, kills all traces
$adoCon->Close();
$adoCon = null;
{ adocon
?>
[/PHP]
and heres the error message after pressing the submit button
Parse error: parse error, unexpected $end in C:\wamp\www\pru\register.php on line 23
adoCon = new COM("ADODB.Connection");
// opens the connection using a standard Access connection string
adoCon->Open("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=\wamp\www\PRU.mdb");
{
adoCon->Execute
( "INSERT INTO tblUsers
(firstname,lastName,email,username,password)
VALUES
(''
这篇关于从表单到数据库帮助插入数据的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!