国产探花免费观看_亚洲丰满少妇自慰呻吟_97日韩有码在线_资源在线日韩欧美_一区二区精品毛片,辰东完美世界有声小说,欢乐颂第一季,yy玄幻小说排行榜完本

首頁 > 網(wǎng)站 > 建站經(jīng)驗 > 正文

動易CMS數(shù)據(jù)轉(zhuǎn)成dedecms的php程序

2024-04-25 20:49:21
字體:
供稿:網(wǎng)友

PS:這個可以舉一反三,如新云或NB等asp文章系統(tǒng)都可轉(zhuǎn)為dedecms或其它php的cms 
[復(fù)制此代碼]CODE:
<?php 
//讀取mdb數(shù)據(jù)庫例程 
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 "完成"; 
?>

發(fā)表評論 共有條評論
用戶名: 密碼:
驗證碼: 匿名發(fā)表
主站蜘蛛池模板: 嘉祥县| 息烽县| 如皋市| 楚雄市| 宁德市| 武山县| 洛隆县| 塘沽区| 丘北县| 彝良县| 凤翔县| 博白县| 竹溪县| 都匀市| 特克斯县| 郧西县| 双城市| 阳山县| 车致| 黑龙江省| 陆河县| 新河县| 友谊县| 自贡市| 阿拉尔市| 涞水县| 昌平区| 邵武市| 襄城县| 武夷山市| 麟游县| 富宁县| 资兴市| 余干县| 兴城市| 噶尔县| 岢岚县| 芜湖市| 砀山县| 平和县| 南和县|