从FORM中提取数据并保存到DB的更智能方法? [英] Smarter way to extract data from FORM and save to DB?
问题描述
你好
出于好奇,是否有一种更智能,更简单的方式来读取
表格发送的数据,并将它们保存到数据库中?我有大约20个字段,并且
如果我可以使用循环来遍历一个数组,那就更容易了。
在几个字段中生成SQL查询行:
======
//如果''id''set -update;否则-insert
if($ _ POST [''id''])
$ sql = sprintf(" UPDATE $ table SET name =''%s'' ,tel =''%s''WHERE
id =%s",$ _ POST [''name''],$ _ POST [''tel''],$ _ POST [''id '']);
else
$ sql = sprintf(" INSERT INTO $ table(id,name,tel)VALUES
( NULL,''%s'',''%s'')",$ _ POST [''name''],$ _ POST [''tel'']);
== ====
谢谢。
Hello
Out of curiosity, is there a smarter, easier way to read data sent by
a form, and save them into a database? I have about 20 fields, and
it''d be easier if I could just use a loop to go through an array and
generate the SQL query in a couple of lines:
======
//If ''id'' set -update; Otherwise -insert
if($_POST[''id''])
$sql = sprintf("UPDATE $table SET name=''%s'', tel=''%s'' WHERE
id=%s",$_POST[''name''],$_POST[''tel''],$_POST[''id'']);
else
$sql = sprintf("INSERT INTO $table (id,name,tel) VALUES
(NULL,''%s'',''%s'')",$_POST[''name''],$_POST[''tel'']);
======
Thank you.
推荐答案
_POST [''id''])
_POST[''id''])
sql = sprintf(" UPDATE
sql = sprintf("UPDATE
table SET name =''%s'',tel ='''%s' 'WHERE
id =%s",
table SET name=''%s'', tel=''%s'' WHERE
id=%s",
这篇关于从FORM中提取数据并保存到DB的更智能方法?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!