首页建站经验 动易CMS数据转成dedecms的php程序

动易CMS数据转成dedecms的php程序

PS:这个可以举一反三,如新云或NB等asp文章系统都可转为dedecms或其它php的cms 
[复制此代码]CODE:

PS:这个可以举一反三,如新云或NB等asp文章系统都可转为dedecms或其它php的cms 
[复制此代码]CODE:
<?php 
//读取mdb数据库例程 
set_time_limit(0); 
$conn = new com("ADODB.Connection"); 
$connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=". realpath("E:/web2/qq.mdb"); 
$conn->Open($connstr); 
$rs = new com("ADODB.RecordSet"); 
$rs->Open("select * from PE_Article Where ArticleID>0 orDER BY ArticleID ASC",$conn,1,1);
$conn2 = mysql_connect("localhost","root",""); 
mysql_select_db("dede",$conn2); 
mysql_query("SET NAMES GBK",$conn2); 
$i=0; 
while(! $rs->eof) { 
$id = $rs->Fields('ArticleID')->value; 
$title = addslashes($rs->Fields('Title')->value); 
$classid = $rs->Fields('ClassID')->value; 
$keywordstr = $rs->Fields('Keyword')->value; 
$keywordstr = str_replace("|"," ",$keywordstr); 
$keyword = trim($keywordstr); 
$datestr = $rs->Fields('UpdateTime')->value; 
$datearr = explode("-",$datestr); 
$yy = $datearr[0] ; 
$mm = $datearr[1] ; 
$dd = rand(1,28); 
$time=mktime(0,0,0,$mm,$dd,$yy); 
$content =addslashes($rs->Fields('Content')->value); 
$content = str_replace('[InstallDir_ChannelDir]{$UploadDir}','/UploadFiles',$content);

//$uploadfile = $rs->Fields('UploadFiles')->value; 
$sql0 = "select ID from dede_archives where ID='$id'"; 
$rs0 = mysql_query($sql0,$conn2); 
$row = mysql_fetch_array($rs0); 
if(intval($row['ID'])==0){ 
$sql1 = "insert into dede_archives (ID,typeid,channel,title,sortrank,pubdate,senddate,adminID,keywords) values ('$id','$classid',1,'$title','$time','$time','$time',1,'$keyword')"; 
$rs1 = mysql_query($sql1,$conn2); 
if(!$rs1){ 
echo $sql1; 
echo "
"; 
echo mysql_error(); 
echo "
"; 
//exit; 

$id2 = mysql_insert_id(); 
if($id2>0){ 
$sql2 = "insert into dede_addonarticle (aid ,typeid, body ) values('$id','$classid','$content');"; 
$rs2 = mysql_query($sql2,$conn2); 
if(!$rs2){ 
echo $sql2; 
echo "
"; 
echo mysql_error(); 
echo "
"; 
//exit; 



$rs->MoveNext(); 
$i ; 
if($iP==0)sleep(5); 

echo "完成"; 
?>

本文来自网络,不代表1号站长-站长学院|资讯交流平台立场。转载请注明出处: https://www.1cn.cc/jianzhan/jingyan/21362.html
上一篇dedecms5.3 flash幻灯片(标题在底部)代码-仿admin5
下一篇 DEDECMS允许游客输入自己的呢称
admin

作者: admin

这里可以再内容模板定义一些文字和说明,也可以调用对应作者的简介!或者做一些网站的描述之类的文字或者HTML!

为您推荐

评论列表()

    联系我们

    联系我们

    0898-88888888

    在线咨询: QQ交谈

    邮箱: email@wangzhan.com

    工作时间:周一至周五,9:00-17:30,节假日休息

    关注微信
    微信扫一扫关注我们

    微信扫一扫关注我们

    关注微博
    返回顶部