1. public function echo_sql() {
  2. $A_LIST = M('driver')->limit(10)->select();
  3. $sql = $this->add_sql('driver', $A_LIST, '');
  4. }
  5. public function add_sql($table, $info, $sql) {
  6. $sql = '';
  7. foreach ($info as $val) {
  8. $sql .= 'insert into hd_'.$table.' (';
  9. $left = '';
  10. $right = '';
  11. foreach ($val as $k=>$v) {
  12. $left .= $k.',';
  13. $right .= '\''.$v.'\',';
  14. }
  15. $left = rtrim($left, ',');
  16. $right = rtrim($right, ',');
  17. $sql .= $left.') values ('.$right.');'.'<br/>';
  18. }
  19. return $sql;
  20. }