另外,版主,在此基础上怎么再做一次表单名和数据库字段名的映射呢?<?php
$request = $_REQUEST;
foreach($request as $k=>$v){
if(trim($v)!=''){
$v=str_replace(", ",",",$v);
$v=str_replace(" ",",",$v);
$arr = explode(',', $v);
echo "<hr>key:". $k. "<br>";
foreach($arr as $kk=>$vv){
if(trim($vv)!=''){
echo $k.$kk.'--value:'.$vv.'<br>';
}
}
}
}
?>比如我现在知道了这个form里面的每一个input的name和数据库里面字段col的对应关系表
name125===>col12
name254===>col243
name321===>col3rte
name43===>col4rre
name535===>col5ret
name632===>col6re
name7654===>col7rte如何替换呢?在构造sql和tiaojian时?因为,前端字段对数据库结构有泄露真心感觉不安全呢。
$request = $_REQUEST;
foreach($request as $k=>$v){
if(trim($v)!=''){
$v=str_replace(", ",",",$v);
$v=str_replace(" ",",",$v);
$arr = explode(',', $v);
echo "<hr>key:". $k. "<br>";
foreach($arr as $kk=>$vv){
if(trim($vv)!=''){
echo $k.$kk.'--value:'.$vv.'<br>';
}
}
}
}
?>比如我现在知道了这个form里面的每一个input的name和数据库里面字段col的对应关系表
name125===>col12
name254===>col243
name321===>col3rte
name43===>col4rre
name535===>col5ret
name632===>col6re
name7654===>col7rte如何替换呢?在构造sql和tiaojian时?因为,前端字段对数据库结构有泄露真心感觉不安全呢。
$fields = array(
'name125'=>'col12',
'name254'=>'col243',
'name321'=>'col3rte',
'name43'=>'col4rre',
'name535'=>'col5ret',
'name632'=>'col6re',
'name7654'=>'col7rte',
);
$request = $_REQUEST;
foreach($request as $k=>$v){
if(trim($v)!=''){
$v=str_replace(", ",",",$v);
$v=str_replace(" ",",",$v);
$arr = explode(',', $v);
echo "<hr>key:". $fields[$k]. "<br>";
foreach($arr as $kk=>$vv){
if(trim($vv)!=''){
echo $k.$kk.'--value:'.$vv.'<br>';
}
}
}
}echo "<hr>key:". $fields[$k]. "<br>";