因为访客ip存在几十万条,无法一次性插入到数据库中,于是使用array_chunk()将ip数组切割成无数个小数组,一次执行sql语句。
$visitorIp = array();
//$start = memory_get_usage();
for( $i = 0; $i < 200000; $i++ ) { //200000条ip地址
$visitorIp[] = [ 'ips' => '192.168.0.' . $i ];
}
/**
* 防止数据量过大,sql不能被执行(取50000条,占用字节数约为2MB,不同环境下可能存在差异)
*/
$currentTime = date('Y-m-d H:i:s');
$visitorIp = array_chunk($visitorIp,50000);
foreach ( $visitorIp as $ik => $iv ) {
$sql = "INSERT INTO RECORD_VISITORS_IP(IP,AddTime) VALUES";
foreach( $iv as $k => $v ) {
$sql .= "('{$v['ips']}','{$currentTime}'),";
}
$sql = rtrim($sql,',');
$result = mysqli_query($link,$sql);
}
$cars=array("Volvo","BMW","Toyota","Honda","Mercedes","Opel");
print_r(array_chunk($cars,2));
Array
(
[0] => Array
(
[0] => Volvo
[1] => BMW
)
[1] => Array
(
[0] => Toyota
[1] => Honda
)
[2] => Array
(
[0] => Mercedes
[1] => Opel
)
)