PHP中批量插入多条记录到数据表

yiwai

class test {
/**
* 获取插入的数据SQL
*
* @author wengxianhu
* @created to 2013-05-27
* @param unknown $data
* @return multitype:
*/
public function _getInsertInfo($data)
{
reset($data);
$fields = array();
$values = array();
$length = 1;
if (key($data) === 0 && is_array($data[0]))
{
$length = count($data);
foreach ($data as $_k => $_v)
{
foreach ($_v as $_f => $_fv)
{
$is_array = is_array($_fv);
($_k == 0 && !$is_array) && $fields[] = '`'.$_f.'`';
!$is_array && $values[$_k][] = "'". addslashes(stripslashes($_fv)) . "'";
}
$values[$_k] = '(' . implode(',', $values[$_k]) . ')';
}
}
else
{
foreach ($data as $_k => $_v)
{
$is_array = is_array($_v);
!$is_array && $fields[] = '`'.$_k.'`';
!$is_array && $values[] = "'" . addslashes(stripslashes($_v)) . "'";
}
$values = '(' . implode(',', $values) . ')';
}
$fields = '(' . implode(',', $fields) . ')';
is_array($values) && $values = implode(',', $values);
return compact('fields', 'values', 'length');
}
/**
* 批量插入数据
*
* @author wengxianhu
* @created to 2013-05-27
* @param unknown $set
* @param string $table 表名
*/
public function insertAll($set, $table)
{
$insert_info = $this->_getInsertInfo($set);
$sql = "INSERT INTO {$table} {$insert_info['fields']} VALUES{$insert_info['values']}";
$this->query($sql,'execute');//这里根据当前使用的系统修改
}
}
$goods = array(
array('goods_id'=>2000,'cate_id'=>100,'name'=>'godos1'),
array('goods_id'=>2001,'cate_id'=>101,'name'=>'godos2'),
array('goods_id'=>2002,'cate_id'=>102,'name'=>'godos3'),
);
// $goods = array('goods_id'=>2000,'cate_id'=>100,'name'=>'godos1');
$a = new test();
$a->insertAll($goods, 'ecm_goods');