【Mysql】批量插入数据

insert_batch.php

function insert_batch($table, $data)
{
    global $ms_import;
    $keys = array_keys(current($data));

    $values = [];

    foreach ($data as $clean) {
        foreach ($clean as $kk=>$vv) {
            $clean[$kk] = '\'' . addslashes($vv) . '\'';
        }
        $values[] =  '('.implode(',', $clean).')';
    }

    $sql = _insert_batch($table, $keys, $values);
    $res = $ms_import->query($sql);
    return $res;
}

function _insert_batch ($table, $keys, $values)
{
    return "INSERT INTO ".$table." (".implode(', ', $keys).") VALUES ".implode(', ', $values);

}