[新手请问]PHP写入MySQL数据库的有关问题

[新手请教]PHP写入MySQL数据库的问题
现在利用PHP 数组生成了从1-33的任选6个数字的组合数据,约100万条的数据生成了数据.TXT文件,格式如下
[1,2,3,4,5,6]
[1,2,3,4,5,7]
[1,2,3,4,5,8]
[1,2,3,4,5,9]
[1,2,3,4,5,10]
[1,2,3,4,5,11]
[1,2,3,4,5,12]
[1,2,3,4,5,13]
[1,2,3,4,5,14]
[1,2,3,4,5,15]
[1,2,3,4,5,16]
[1,2,3,4,5,17]
[1,2,3,4,5,18]
...............
现在希望将这样的数据入库.现在有数据库表HMK,结构为
"hmkid","int(11)","NO","PRI","","auto_increment"
"l1","int(10) unsigned","NO","","",""
"l2","int(10) unsigned","NO","","",""
"l3","int(10) unsigned","NO","","",""
"l4","int(10) unsigned","NO","","",""
"l5","int(10) unsigned","NO","","",""
"l6","int(10) unsigned","NO","","",""
请问如何在程序运行过程中编写PHP程序直接将数据写入数据库而不存入txt文档啊?
我的想法

PHP code

$db=new mysqli("localhost","admin","admin","ssq");$db->query("truncate table hmk");$info = array(1, 2, 3,4,5,6);//$info是中间生成的的组合数组.foreach ($info as $skey=>$value){     //echo 'my array is underline:'.$key."=>".$value."</br>" ;     $query="insert into hmk(l1,l2,l3,l4,l5,l6) values($values)";       $result=$db->query($query) ;} if (result)echo "good luck"           ;else echo "sorry"    ;$db->close();

PHP code

$a  = range(1, 33);$ar = combination($a, 6);//求组合高效率的10移动法function combination($numArr,$combineLen) {  $numCt    = count($numArr);  if($combineLen > $numCt) return;  $bin    = str_pad('',$combineLen,'1');  $bin    = str_pad($bin,$numCt,'0',STR_PAD_RIGHT);      $find    = $bin;  $rs[]    = implode(' ',array_slice($numArr,0,$combineLen));  $j        = 1;  while(strrev($find) != $bin) {    $k = explode('10',$find,2);    $find = $find{0} === '0' ? strrev($k[0]).'01'.$k[1] : $k[0].'01'.$k[1];    for($i=0;$i<$numCt;$i++) $rs[$j] .=  $find[$i] ?  $numArr[$i] . " " : '';    $j++;  }  return $rs;}

PHP code

$fp = fopen('数据.txt', 'r');while( !feof($fp) ){    $line = trim( fget($fp) );    $sqlvalue .= '('. substr($line, 1, -1) . '),';}$sql = "insert into hmk(l1,l2,l3,l4,l5,l6) values ";$sql = $sql . substr($sqlvalue, -1, 1); // 去掉末尾的 ,$db = new mysqli("localhost","admin","admin","ssq");$result = $db->query($sql);if( ! $result ){    echo $db->error();    var_dump($sql);}
[解决办法]
每次查询只插入一条记录效率太低了，可以批量插入，比如每次50000条：

PHP code
$data = array(array(1,2,3,4,5,6), array(1,2,3,4,57)); //先生成这样的data数组，每个元素是一组号码的数组$idx = 0;while($idx < count($data) - 1)) {    $ar = array();    if ($idx + 50000 < count($data)) $ar = array_slice($data, $idx, 50000);    else $ar = array_slice($data, $idx);    $sql = 'INSERT INTO htm(l1,l2,l3,l4,l5,l6) VALUES ';    $ar_values = array();    foreach($ar as $v) $ar_values[] = '('.join(',', $v).')';    $sql .= join(',', $ar_values);    $result = $db->query($sql);    $idx += 50000;}$db->close();
------解决方案-------------------- 
 
函数改成这样就可以直接入库了
PHP code
function combination($numArr,$combineLen=6) {  global $db;  $numCt    = count($numArr);  if($combineLen > $numCt) return;  $bin    = str_pad('',$combineLen,'1');  $bin    = str_pad($bin,$numCt,'0',STR_PAD_RIGHT);      $find    = $bin;  $rs    = implode(',',array_slice($numArr,0,$combineLen));  while(strrev($find) != $bin) {    $rs = trim($rs, ',');    $db->query("insert into hmk (l1,l2,l3,l4,l5,l6) values ($rs)");    $rs = '';    $k = explode('10',$find,2);    $find = $find{0} === '0' ? strrev($k[0]).'01'.$k[1] : $k[0].'01'.$k[1];    for($i=0;$i<$numCt;$i++) {      $rs .=  $find[$i] ?  $numArr[$i] . "," : '';    }  }}