数据库新建采集表:
在后台创建按钮,手动执行采集导入数据库。
<form action="caiji.php" method="post" >
<tr>
<td colspan="2" bgcolor="#f5f5f5" style="height:30px; line-height:30px; font-size:14px; text-align:center; color:#333;">采集导入设置</td>
</tr>
<tr>
<th width="150">导入分类:</th>
<td>
<select name="class" class="common-text required">
<option value="" >所有分类</option>
<option value="分类值ID" >分类值ID</option>
<option value="分类值ID" >分类值ID</option>
<option value="分类值ID" >分类值ID</option>
</select>
<input type="submit" class="btn btn-primary btn6 mr10" value="文章导入">
</form>
caiji.php采集文件代码:
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<?php
session_start();
header("content-Type: text/html; charset=utf-8");
require_once("include/mysql.Open.php"); //开启数据库链接
require_once("conn.php"); //个人配置文件
$createtime=date("Y-m-d H:i:s");// 获取系统时间
$class = $_POST['class']; //获取后台传来指定分类,导入指定分类
$sql = "select * from web_product_class where Id='$class' order by Id";
$value = $db->getOneRow($sql);
// 获取文件夹中的所有txt文件名
$dir = "txt/";
$handle = opendir($dir.".");
$row = array();
while (false!=($file=readdir($handle))) //找出所有的txt文件,赋值给file
{
if($file!="."&&$file!="..")
{
$row[] = str_replace('.txt','',iconv('gb2312','utf-8',$file));//输出文件名,系统语言都是gb2312,转成utf-8好存入数据库,不然会出现乱码
}
}
if(!$row){
echo "没有可导入文章";
exit;
}else{
foreach ($row as $rs) {
$arr['title'] = str_replace('.txt','',$rs);
$arr['content'] = file_get_contents(iconv('utf-8','gb2312',$dir.$rs.".txt"));
$arr['createtime']= $createtime;
$arr['class']= $class;
$arr['status']='0';
$result = $db->insert('web_caiji' ,$arr); //录入数据库
if($result){
//导入成功后删除文件
unlink(iconv('utf-8','gb2312',$dir.$rs.".txt"));
echo "导入成功";
}
}
closedir($handle);
exit;
}
?>
fabu.php设置发布代码
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<?php
session_start();
header("content-Type: text/html; charset=utf-8");
require_once("include/mysql.Open.php");
require_once("conn.php");
$createtime=date("Y-m-d H:i:s");// 获取当前系统时间
$mnid = '6';
$sql="select * from web_caiji where status=0 order by Id limit 0,2";
$result = $db->getList($sql);
foreach($result as $rs){
if($createtime>$rs['createtime']){ //判断系统时间大于采集导入时间,是就发布两条数据到指定文章分类
$arr['p_name']=$rs['title'];
$arr['p_detail']=$rs['content'];
$arr['p_createtime']=$createtime;
$arr['p_class']= $rs['class'];
$arr['p_symbol']= 'y';
$arr['mn_id'] = $mnid;
$data = $db->insert('web_product',$arr);
if($data){
echo '发布成功';
$arr2['status'] ='1'; //发布成功后,修改采集数据库的数据状态,改为已发布
$update=$db->update('web_caiji', $arr2, "Id=".$rs['Id']);
}
}
} //foreahc end
?>