/**
* 将数组转化为键值对
* @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;
}
将数组转化为键值对
推荐阅读
- 关于 flutter_boost监听flutter页面生命周期
- 关于 mac安装java8sdk Cask 'java8' is unavailable: '/usr/local/Homebrew/Library/Taps/homebrew/homebrew-cask-versions/Casks/java8.rb' does not exist.
- 关于 flutter_boost集成到ios后flutter用自带的navigator跳转到flutter右滑返回直接返回到native问题
- JavaScript中const、var和let区别浅析
- 对HTTP、HTTPS、Socket的理解以及三者的关系
- iOS开发必备HUD(透明指示层)
- 套接字
- iOS 判断相机权限是否被限制,判断相机是否可以使用
- iOS 第一次安装应用,拒绝相机调用,页面卡死的解决方案
- iOS 消息转发机制