织梦，dedecms,导入到EYOU
<?php
header("Content-type:text/html;charset=utf-8");
$con = mysqli_connect("localhost", "root", "root", "dedecmsv57utf8sp2");
if (!$con) {
die('Could not connect: ' . mysqli_error());
}
mysqli_query($con, 'SET NAMES UTF8');
//连接数据库
$con2 = mysqli_connect("localhost", "root", "root", "yjfybjy");
if (!$con2) {
die('Could not connect: ' . mysqli_error());
}
mysqli_query($con2, 'SET NAMES UTF8');
$sql = "select a.*,b.body from yjfuyoubaojian_archives a left join yjfuyoubaojian_addonarticle b on b.aid = a.id where a.typeid=30 order by a.id asc";
$res = mysqli_query($con, $sql);
while ($v = mysqli_fetch_assoc($res) ) {
$title = addslashes($v['title']);
$content = addslashes($v['body']);
$add_time = $v['pubdate'];
$litpic = $v['litpic'];
$typeid = 63;
$seo_title = $v['title'];
$keywords = $v['keywords'];
$description = $v['description'];
$channel = 1;
$sql = "insert into yjfybjy_archives(typeid,title,channel,is_litpic,litpic,click,arcrank,seo_title,seo_keywords,seo_description,sort_order,lang,add_time,update_time) values($typeid, '".$title."', $channel, 1, '$litpic',0,0,'$title','$keywords','$description','1000','cn','$add_time','$add_time');";
$r = mysqli_query($con2, $sql);
if (!$r) {
die($sql);
}
$id = mysqli_insert_id($con2);
$ljj = $v['jj'];
$sql = "insert into yjfybjy_article_content(aid,content,add_time,update_time) values($id,'$content','$add_time','$add_time')";
mysqli_query($con2, $sql);
//exit();
}
exit('已完成');
?>
