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());
/
精彩图集
精彩文章






