01 <?php

02  

03 $m = mysql_connect('127.0.0.1','root','') or die("Invalid query: " . mysql_error());

04  

05 mysql_select_db('discuz', $m) or die("Invalid query: " . mysql_error());

06  

07  

08 $handle = fopen("aa.txt", "r");

09 while (!feof($handle)) {

10     $buffer =  ($handle);

11     $ss[] = explode('&nbsp', $buffer);

12     

13 }

14 //var_dump($ss);

15  

16 mysql_query("set names 'utf8'",$m);

17 foreach($ss as $k => $v){

18         //addslashes($v);

19         //foreach($v as $k = $value){

20         //$vv = addslashes($value);

21     //mysql_query("insert into match_view_test_2 (`kanum`, `username`, `mid`, `rank`, `num` ,`zunum` ,`sex` ,`yucolor` ,`eye` ,`backtime` ,`kongju` ,`fengspeed` )

22         //values ('123','123', 20111014060110765 ,1,'123','123','123','123','123','123','123','123')") or die("Invalid query: " . mysql_error());

23     //}

24     $kanum = $v[1];

25     $username = $v[2];

26     

27     $rank = (int)$v[0];

28     

29     $num = $v[3];

30     $zunum = $v[4];

31     $sex = $v[5];

32     //echo $sex;

33     $yucolor = $v[6];

34     //$eye = $v[7];

35     $backtime = $v[8].' '.$v[9];

36     $kongju = $v[10];

37     $fengspeed = $v[11];

38     mysql_query("insert into match_view_test (`kanum`, `username`, `mid`, `rank`, `num` ,`zunum` ,`sex` ,`yucolor` ,`eye` ,`backtime` ,`kongju` ,`fengspeed` )

39         VALUES('$kanum','$username', 20111014060110765,$rank,'$num','$zunum','$sex','$yucolor','$eye','$backtime','$kongju','$fengspeed')") or die("Invalid query: " . mysql_error());

40     }

41