$ _POST数据有问题 [英] Trouble with $_POST data
问题描述
大家好,
我正在尝试从表单发送数据并将其插入到MSSQL DB中。
当我提交时我收到的数据:警告:mssql_query()
[function.mssql-query]:message:名称Todd这个上下文中不允许使用
。有效表达式是常量,常量表达式和
(在某些上下文中)变量。不允许使用列名。 (严重性
15)在我的文件中
如果我没有使用POST数据并明确地编写查询,它就可以工作。 />
感谢任何帮助。
谢谢,
托德
WinXP SP2
MSSQL Express 2005
IIS 5.1
PHP 5.2.1
它''基本形式:
< body>
< form id =" form1"名称= QUOT; form1的"方法= QUOT;交" action =" flextest.php">
< label>用户名
< input name =" username"类型= QUOT;文本" ID = QUOT;用户名" />
< / label>
< label>电子邮件地址
< input name =" emailaddress"类型= QUOT;文本" ID = QUOT; EMAILADDRESS" />
< / label>
< p>
< input type =" submit"命名= [提交"值= [提交" />
< / p>
< / form>
< / body>
这里是MSSQL插页:
if($ _POST [" emailaddress"] AND $ _POST [" username"])
{
//添加用户
$查询= sprintf(''INSERT INTO用户(用户名,电子邮件地址)
VALUES(%s ,%s)'',$ _POST [" username"],$ _POST [" emailaddress"]);
$ Result = mssql_query($ Query);
}
Hi all,
I am trying to send data from a form and insert it into a MSSQL DB.
When I submit the data I get: Warning: mssql_query()
[function.mssql-query]: message: The name "Todd" is not permitted in
this context. Valid expressions are constants, constant expressions, and
(in some contexts) variables. Column names are not permitted. (severity
15) in "Myfile"
If I don''t use the POST data and write the query explicitly, it works.
Any help is appreciated.
Thanks,
Todd
WinXP SP2
MSSQL Express 2005
IIS 5.1
PHP 5.2.1
It''s a basic form:
<body>
<form id="form1" name="form1" method="post" action="flextest.php">
<label>User Name
<input name="username" type="text" id="username" />
</label>
<label>Email Address
<input name="emailaddress" type="text" id="emailaddress" />
</label>
<p>
<input type="submit" name="Submit" value="Submit" />
</p>
</form>
</body>
And here is the MSSQL insert:
if( $_POST["emailaddress"] AND $_POST["username"])
{
//add the user
$Query = sprintf(''INSERT INTO users (username, emailaddress)
VALUES (%s, %s)'', $_POST["username"], $_POST["emailaddress"]);
$Result = mssql_query($Query);
}
推荐答案
_POST [" emailaddress"] AND
_POST["emailaddress"] AND
_POST ["用户名"])
{
//添加用户
_POST["username"])
{
//add the user
Query = sprintf(''INSERT INTO users (用户名,电子邮件地址)
VALUES(%s,%s)'',
Query = sprintf(''INSERT INTO users (username, emailaddress)
VALUES (%s, %s)'',
这篇关于$ _POST数据有问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!