我在变量中有这两个字符串。
$column = "name,body"$data = "testname,testbody"我想从它动态地更新MySQL查询。
查询应该像这样输出。
$query = "UPDATE `mytable` SET `name`='testname',`body`'testbody' WHERE id=1";或将字符串组合为变量。
$generatedquery = "columnname='value',columnname='value'"
$query = "UPDATE `mytable` SET $generatedquery WHERE id=1";以上两个变量是动态出现的,它们可以有多个值。
发布于 2014-04-29 08:11:57
将此代码用于动态字段
$field = explode(',',$column);
$value = explode(',',$data);
$query = "UPDATE `mytable` SET ";
for($i=0;$i<count($field);$i++){
$query .= $field[$i]." = '".$value[$i]."' ";
if($i<count($field)-1){
$query .= ", ";
}
}
$query .= " WHERE id=1";发布于 2014-04-29 08:14:43
你可以试试这个方法
$column = "name,body";
$data = "testname,testbody";
$column_arr=explode(",",($column));
$data_arr=explode(",",($data));
foreach($column_arr as $ckey=>$cval){
$where[]=$cval."='".$data_arr[$ckey]."'";
}
echo $query = "UPDATE `mytable` SET ".implode(",",$where)." WHERE id=1";发布于 2014-04-29 08:19:35
使用下面的代码对您有帮助
<?php
$column = "name,body"
$data = "testname,testbody"
$column_arr=explode(",",($column));
$data_arr=explode(",",($data));
foreach($column_arr as $ckey=>$cval){
$where[]=$cval."=".$data_arr[$ckey];
}
$query = "UPDATE `mytable` SET implode(",",$where) WHERE id=1";
?>https://stackoverflow.com/questions/23359005
复制相似问题