动易dedecms数据转成dedecms的php程序
发布时间：2020-12-14 04:15:08 所属栏目：Dedecms 来源：网络整理
导读：PS：这个可以举一反三，如新云或NB等asp文章系统都可转为织梦dedecms或其它php的cms? [复制此代码]CODE: ?php? //读取mdb数据库例程? set_time_limit(0);? $conn = new com("ADODB.Connection");? $connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DB
|
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:web2qq.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,$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','$title','$time','$keyword')";?
$rs1 = mysql_query($sql1,$conn2);?
if(!$rs1){?
echo $sql1;?
echo "<br>";?
echo mysql_error();?
echo "<br>";?
//exit;?
}?
$id2 = mysql_insert_id();?
if($id2>0){?
$sql2 = "insert into dede_addonarticle (aid,body ) values('$id','$content');";?
$rs2 = mysql_query($sql2,$conn2);?
if(!$rs2){?
echo $sql2;?
echo "<br>";?
echo mysql_error();?
echo "<br>";?
//exit;?
}?
}?
}?
$rs->MoveNext();?
$i ;?
if($iP==0)sleep(5);?
}?
echo "完成";?
?>
动易dedecms数据转成织梦dedecms的php程序就介绍完了。 上一篇：织梦DeDeCms与KingCms的几点小对比 下一篇：DEDECMS织梦允许游客输入自己的呢称 （编辑：李大同） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |