php 读txt文件并插入数据库
php 读txt文件并插入数据库 php 读txt文件插入数据库[代码片段(41行)]
php 读txt文件插入数据库
<?php $m = mysql_connect('127.0.0.1','root','') or die("Invalid query: " . mysql_error()); mysql_select_db('discuz', $m) or die("Invalid query: " . mysql_error()); $handle = fopen("aa.txt", "r"); while (!feof($handle)) { $buffer = ($handle); $ss[] = explode(' ', $buffer); } //var_dump($ss); mysql_query("set names 'utf8'",$m); foreach($ss as $k => $v){ //addslashes($v); //foreach($v as $k = $value){ //$vv = addslashes($value); //mysql_query("insert into match_view_test_2 (`kanum`, `username`, `mid`, `rank`, `num` ,`zunum` ,`sex` ,`yucolor` ,`eye` ,`backtime` ,`kongju` ,`fengspeed` ) //values ('123','123', 20111014060110765 ,1,'123','123','123','123','123','123','123','123')") or die("Invalid query: " . mysql_error()); /
精彩图集
精彩文章