将数组转化为键值对

最新推荐文章于 2024-07-23 20:10:20 发布

weixin_34146805

最新推荐文章于 2024-07-23 20:10:20 发布

阅读量1.2k

点赞数

CC 4.0 BY-SA版权

文章标签： php java python

原文链接：http://www.cnblogs.com/rickons/p/5368208.html

/**
* 将数组转化为键值对
* @param type $array
* @param type $type
* @param type $exclude
* @return type
*/
public function array_to_sql($array, $type = 'insert', $exclude = array()) {
$sql = '';
if (count($array) > 0) {
foreach ($exclude as $exkey) {
unset($array[$exkey]); //剔除不要的key
}
if ('insert' == $type) {
$keys = array_keys($array);
$values = array_values($array);
$col = implode("`, `", $keys);
$val = implode("', '", $values);
$sql = "(`$col`) values('$val')";
} else if ('update' == $type) {
$tempsql = '';
$temparr = array();
foreach ($array as $key => $value) {
$tempsql = "`$key` = '$value'";
$temparr[] = $tempsql;
}
$sql = implode(",", $temparr);
}
}
return $sql;
}