批量插入数据库的小方法

 

$keybb = $valuebb = $comma = '';
foreach ($kingvalue as $key=>$value)
{
 $keybb .= $comma.'`'.$key.'`';
 $valuebb .=$comma.'\''.$value.'\'';
 $comma = ',';
}

if(empty($valuebb))
{
 echo '<p style="text-align:center;">对不起,没有值传入</p>';
 exit;
}
//
$kk = substr($keybb,0,-11);
$bb = substr($valuebb,0,-5);
$sql ="insert into `king_gnq_order`($kk)values($bb)";

 

 

===============================================

public function insert($_table,$_array){
 $_fields=array();
 $_values=array();
 $_table=str_replace(array('%s','%a'),array(DB_PREFIX,KC_DB_ADMIN),$_table);
 foreach($_array as $_key=>$_val){
  array_push($_fields,$_key);
  array_push($_values,$this->escape($_val));
 }
 $_sql='insert into '.$_table.' ('.implode(',',$_fields).') values (\''.implode('\',\'',$_values).'\');';
 if(!$this->query($_sql)){
  kc_error($_sql);
 }
 return mysql_insert_id();
}