读取文件

数据库连接

config.php

 

<?php

$CFG['database'] = 'mysql';
$CFG['pconnect'] = '0';
$CFG['db_host'] = '127.0.0.1';
$CFG['db_name'] = 'liaoyang';
$CFG['db_user'] = 'root';
$CFG['db_pass'] = 'root';
$CFG['db_charset'] = 'utf8';

?>

读取文件方法

global.php

<?php
//$url="C:/Users\Administrator\Desktop\news_content\451915\info0\";

//$path="D://news_content/451915/info0/";

function read_file($path){
 
 
 $handler = opendir($path);
 $fileArr=array();
 $i=0;
while( ($filename = readdir($handler)) !== false ) {
      //3、目录下都会有两个文件，名字为’.'和‘..’，不要对他们进行操作
      if($filename != "." && $filename != "..")
      {
     // 4、进行处理
      //这里简单的用echo来输出文件名
      //echo $filename."<br>";
     
       $fileArr[$i++]=$filename;
      }
}
closedir($handler);

return $fileArr;
}
?>

页面

readfile.php

<?php

require 'config.php';
require 'gobal.php';

$con=mysql_connect($CFG['db_host'],$CFG['db_user'],$CFG['db_pass']);

if(!$con){
  die('Could not connect: ' . mysql_error());
}

$d=mysql_select_db($CFG['db_name']);

//$path="D://news_content/451915/";
$path_file="D://news_content/451915/";
$fileArr=read_file($path_file);
    /*
    echo "<pre>";
    print_r($fileArr);
    echo "<pre>";
    exit("D");
*/

$i=0;
foreach ($fileArr as $val){
 
 $pathname=$path_file.$val;
 $file_arr=read_file($pathname);
  
 /*
 echo "<pre>";
    print_r($file_arr);
    echo "<pre>";
    exit("D");
 */
 
    $info=$val.'/';
    //print_r($info);
 
    foreach ($file_arr as $file){
 
 /*
    print_r($file);
 echo "<br>";
 */
  
 $url=$path_file.$info.$file;
 //print_r($url);
 //echo "<br>";
    $tid = substr($file,0,strlen($file)-4);
 //print_r($tid);
 $html=file_get_contents($url);
 
 //$html=iconv('UTF-8','UTF-8',$html);
 //print_r($html);
 //exit("DD");
 mysql_query('SET NAMES utf8');
 $sql="insert into tz_news(content,tid)values('$html','$tid')";
    //print_r($sql);
    //exit("DD");
    $re=mysql_query($sql);
    $id=mysql_insert_id();
    if($re) echo $id."插入成功！<br>";
    //exit("DD");
          }
 
    $i++;
   // print_r($i);
   // exit("DD");
  
}

 

?>

转载于:https://my.oschina.net/u/2310017/blog/495847