VPS租用 > 教程 > CMS教程 > 正文
vps广告

【 动易cmsphp】-动易CMS数据转成dedecms的php程序

五彩互联编辑部发布时间:2017-04-19 21:50:23浏览:0
摘要:关键字描述:程序 数据 ?php //读取mdb数据库例程 set_time_limit(0); $conn = new com(ADODB.Connection); $connstr = DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=. re
关键字描述:程序 数据 ?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 ArticleID0 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 br;
echo mysql_error();
echo br;
//exit;
}
$id2 = mysql_insert_id();
if($id20){
$sql2 = insert into dede_addonarticle (aid ,typeid, body ) values('$id','$classid','$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 完成;
?


    联系我们