public function echo_sql() {
$A_LIST = M('driver')->limit(10)->select();
$sql = $this->add_sql('driver', $A_LIST, '');
}
public function add_sql($table, $info, $sql) {
$sql = '';
foreach ($info as $val) {
$sql .= 'insert into hd_'.$table.' (';
$left = '';
$right = '';
foreach ($val as $k=>$v) {
$left .= $k.',';
$right .= '\''.$v.'\',';
}
$left = rtrim($left, ',');
$right = rtrim($right, ',');
$sql .= $left.') values ('.$right.');'.'<br/>';
}
return $sql;
}
转载原创文章请注明,转载自:
随意写的一段PHP数据集转insert插入语句的代码
-
冯俊豪博客
(https://www.junphp.com/details/318.jsp)