抓网页生成的数组是下面这样 有上千万条!结构也不相同,有什么办法导入按 $KEY 的值对应导入数据库的表,
就是$KEY=0导入第一列,$KEY=1 的导第二列,以此类推,。只导入到$key=10的,大于11的不导入,
$KEY 只有5位的就只导入5! 其实我只要 $KEY 到10 的这个结构的数组 做数据,其他的我是想全部导入数据库后才处理删除我用的是 ODBC连接 SQL2000 请各位帮我写这样的代码!Array
(
[0] => 02-04 09:34:36
[1] => 888
[2] => type
[3] => news
[4] => 10000
[5] => -10000
[6] => 0.0
[7] => 0 / 0.0
[8] => 50 / 0.0
[9] => 50 / 0.0
[10] => 192.168.12.5
)Array
(
[0] => 02-05 19:34:36
[1] => 999
[2] => type
[3] => news
[4] => 20000
[5] => -30000
[6] => 0.0
[7] => 0 / 0.0
[8] => 50 / 0.0
[9] => 50 / 0.0
[10] => 102.18.12.56
)
Array
(
[0] =>
[1] =>
[2] => type
[3] => news
[4] => 20000
[5] => -30000)
Array
(
[0] => 02-05 19:34:36
[1] => 999
[2] => type
[3] => news
[4] => type
[5] => news
[6] => type
[7] => news
[8] => type
[9] => news
[10] => type
[11] => news
[12] => 20000
[13] => -30000
[14] => 0.0
[15] => 0 / 0.0
[16] => 50 / 0.0
[17] => 50 / 0.0
[18] => 102.18.12.56
)
Array
(
[0] => 02-05 19:34:36
[1] => 999
[2] => type
[3] => news
[4] => 20000
[5] => -30000
[6] => 0.0
[7] => 0 / 0.0
[8] => 50 / 0.0
[9] => 50 / 0.0
[10] => 102.18.12.56
)
Array
(
[0] => 02-05 19:34:36
[1] => 999
[2] => type
[3] => news
[4] => type
[5] => news
[6] => type
[7] => news
[8] => type
[9] => news
[10] => type
[11] => news
[12] => 20000
[13] => -30000
[14] => 0.0
[15] => 0 / 0.0
[16] => 50 / 0.0
[17] => 50 / 0.0
[18] => 102.18.12.56
[19] => 50 / 0.0
[20] => 50 / 0.0
[21] => 102.18.12.56
)
就是$KEY=0导入第一列,$KEY=1 的导第二列,以此类推,。只导入到$key=10的,大于11的不导入,
$KEY 只有5位的就只导入5! 其实我只要 $KEY 到10 的这个结构的数组 做数据,其他的我是想全部导入数据库后才处理删除我用的是 ODBC连接 SQL2000 请各位帮我写这样的代码!Array
(
[0] => 02-04 09:34:36
[1] => 888
[2] => type
[3] => news
[4] => 10000
[5] => -10000
[6] => 0.0
[7] => 0 / 0.0
[8] => 50 / 0.0
[9] => 50 / 0.0
[10] => 192.168.12.5
)Array
(
[0] => 02-05 19:34:36
[1] => 999
[2] => type
[3] => news
[4] => 20000
[5] => -30000
[6] => 0.0
[7] => 0 / 0.0
[8] => 50 / 0.0
[9] => 50 / 0.0
[10] => 102.18.12.56
)
Array
(
[0] =>
[1] =>
[2] => type
[3] => news
[4] => 20000
[5] => -30000)
Array
(
[0] => 02-05 19:34:36
[1] => 999
[2] => type
[3] => news
[4] => type
[5] => news
[6] => type
[7] => news
[8] => type
[9] => news
[10] => type
[11] => news
[12] => 20000
[13] => -30000
[14] => 0.0
[15] => 0 / 0.0
[16] => 50 / 0.0
[17] => 50 / 0.0
[18] => 102.18.12.56
)
Array
(
[0] => 02-05 19:34:36
[1] => 999
[2] => type
[3] => news
[4] => 20000
[5] => -30000
[6] => 0.0
[7] => 0 / 0.0
[8] => 50 / 0.0
[9] => 50 / 0.0
[10] => 102.18.12.56
)
Array
(
[0] => 02-05 19:34:36
[1] => 999
[2] => type
[3] => news
[4] => type
[5] => news
[6] => type
[7] => news
[8] => type
[9] => news
[10] => type
[11] => news
[12] => 20000
[13] => -30000
[14] => 0.0
[15] => 0 / 0.0
[16] => 50 / 0.0
[17] => 50 / 0.0
[18] => 102.18.12.56
[19] => 50 / 0.0
[20] => 50 / 0.0
[21] => 102.18.12.56
)
//$a //假如这是采集到的数组
foreach($a as $i=>$v){
if($i < 11){
mssql_query("insert into table ($i) values ('{$v}')");
}else{
break ;
}
}