动易数据转成dedecms的php程序


PS:这个可以举一反三,如新云或NB等asp文章系统都可转为dedecms或其它php的cms

复制代码 代码如下:

<?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 "<br>";
echo mysql_error();
echo "<br>";
//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 "<br>";
echo mysql_error();
echo "<br>";
//exit;
}
}
}
$rs->MoveNext();
$i++;
if($i%50==0)sleep(5);
}
echo "完成";
?>



相关阅读:
javascript仿163网盘无刷新文件上传系统
Linux源码包编译和安装
css使图片变灰的实现方法
javascript 通用滑动门tab类
js动画效果打开层 关闭层
加入跨子网路由 Windows Server 2008 VPN
SqlServer 2005 简单的全文检索
如何使用Administrators组用户运行ASP程序
PHP教程.应用实例--16
javascript判断上传图片的大小和格式
JavaScript 关于元素获取焦点(隐藏元素与div)
Linux内核实时操作性能有望将大幅提高
MYSQL初学者使用指南 下篇
div+css布局及Web标准对网站优化和SEO方面的益处
快速导航

Copyright © 2016 phpStudy | 皖ICP备18014864号-4