服务报价 | 域名主机 | 网络营销 | 软件工具| [加入收藏]
 热线电话: #
当前位置: 主页 > php教程 > dedecms教程 >

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

时间:2018-01-25 12:38来源:未知 作者:最模板编辑 点击:
PS:这个可以举一反三,如新云或NB等asp文章系统都可转为织梦dedecms或其它php的cms [复制此代码]CODE: ?php //读取mdb数据库例程 set_time_limit(0); $conn = new com(ADODB.Connection); $connstr = DRIVER={Micr
 
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 "<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($iP==0)sleep(5); 
echo "完成"; 
?>
动易dedecms数据转成织梦dedecms的php程序就介绍完了。
(责任编辑:最模板)
顶一下
(0)
0%
踩一下
(0)
0%
------分隔线----------------------------
栏目列表
热点内容