dedecms5.7转帝国CMS系统之tag标签导入

01
query("select * from {$dbtbpre}ecms_news order by id desc limit 1000000"); //查询新闻表最新10条记录
11
while($r=$empire->fetch($sql)) //循环获取查询记录
12
{
13
 //echo"标题：".$r['newstime']."
";
14
 echo"标题：".$r['title'].$r['id']."
";
15
 $tagstr = array();
16
 $tsql=$empire->query("select * from dede_taglist where aid=".$r['id']." limit 100"); //
17
 while($tr=$empire->fetch($tsql)) //循环获取查询记录
18
 {
19
     if($tr['tag'] != ''){
20
   $tagstr[] = $tr['tag'];
21
      }
22
 }
23
 if(count($tagstr) > 0){
24
     if(eReturnInfoTags($r[classid], $r[id], 1) == ''){
25
  echo $tags = implode(',', $tagstr);
26
  eInsertTags($tags,$r[classid], $r[id],$r[newstime]);
27
  $indexsql=$empire->query("update {$dbtbpre}ecms_news_data_1 set infotags='$tags' where id='$r[id]' limit 1");
28
     }
29
     //
30
 
31
 
32
 }
33
 echo '
';
34
}
35
db_close();   //关闭MYSQL链接
36
$empire=null;   //注消操作类变量
37
?>