得得CMS 插入数据库的接口及思路

最新推荐文章于 2024-09-17 20:18:24 发布

小小优化师 anny

最新推荐文章于 2024-09-17 20:18:24 发布

阅读量286

点赞数

分类专栏： PHP 文章标签： php 数据库

本文链接：https://blog.csdn.net/q28000/article/details/131291081

版权

PHP 专栏收录该内容

13 篇文章 0 订阅

订阅专栏

该PHP代码段展示了如何从data.txt文件中读取数据并将其插入到织梦CMS（DedeCMS）的数据库中。它首先处理文本数据，然后连接到数据库，创建新的文章条目，包括标题、内容和分类，并更新相关信息。如果插入成功，文件将重命名，否则显示错误信息。

摘要由CSDN通过智能技术生成

<?php
//dedeCMS 织梦执行入库
set_time_limit(0);
date_default_timezone_set("PRC");
function getData(){
$finaldata = array();
$content=@file_get_contents('data.txt');
$key=explode('=e=',$content);
for($i=0;$i<count($key)-1;$i++){
	$keys=explode('=t=',$key[$i]);
	$j=0;
	foreach($keys as $keyes){
		$finaldata[$i][$j]=$keyes;
		$j++;
		if($j>=2)break;
	}
}
return $finaldata;
}

 
 include_once ($_SERVER['DOCUMENT_ROOT']."/data/common.inc.php"); 
//dede数据库连接信�?
// $cfg_dbhost = 'localhost';
// $cfg_dbname = '789dede.com';
// $cfg_dbuser = 'root';
// $cfg_dbpwd = 'root';
// $cfg_dbprefix = 'tf_';
// $cfg_db_language = 'utf8';
 
 $archives= $cfg_dbprefix."archives";
 $arctiny= $cfg_dbprefix."arctiny";
 $addonarticle= $cfg_dbprefix."addonarticle" ; 

 
//echo DB_HOST;
	$link=mysqli_connect($cfg_dbhost,$cfg_dbuser,$cfg_dbpwd) or die("database connect wrong".mysql_error());//自己设置
  mysqli_select_db($link,$cfg_dbname)  or die("database wrong".mysql_error());//自己设置
	mysqli_set_charset($link,'utf8');  
	$datatitle="";
	$postcontent="";
    $id=mysqli_query($link,"select max(id) from $archives");//得到当前最大信息id以免信息id重复
		 
 
	while($t_result = mysqli_fetch_array($id) ){
 	$testarr=$t_result;
	}
	$dataid=$testarr[0]+1;
	$mm=getData();
	$tt=(array_values($mm));
	//print_r ($tt);
 

	for($i=0; $i<count($mm); $i++){
	        $posttitle =$tt[$i][0];   
			$postcontent = $tt[$i][1].$posttitle; // echo "$postcontent ";
 
  			//$postname = preg_replace("/[^\w]/i","-",$posttitle);//得到 postname (url)
  			//$postname = preg_replace("/[^\x{4e00}-\x{9fa5}a-zA-Z0-9]/i","",$postname); //hanzi汉字 
 	        $postname= urlencode ($posttitle ) ;
 	        $postname = preg_replace("/^[\W]/i","",$postname);//把开头为非[\W].替换成空'
 	        $postname = preg_replace("/\+/i","-",$postname);//把+.替换成'
			$postname = preg_replace("/-{2,}/i","-",$postname);
			$postname = preg_replace("/\+{2,}/i","-",$postname);
			$postname = preg_replace("/-$/i","",$postname);//把最后的-.替换成空''
			$postname = preg_replace("/^-/i","",$postname);//把开头为-.替换成空'
			$postname = preg_replace("/\+$/i","",$postname);//把为+.替换成空'
			$postname = preg_replace("/^\+/i","",$postname);//把开头为+.替换成空'
			$postname = preg_replace("/^0A/i","",$postname);//把开头为+.替换成空'
			

			
             
            $intime=  "1646982832"; //strtotime(date("Y/m/d"));  echo $intime ; // strtotime(date("Y/m/d"));
            $fenlei="62"; //分类ID
            
//INSERT INTO `789dede.com`.`tf_archives` (`id`, `typeid`, `typeid2`, `sortrank`, `flag`, `ismake`, `channel`, `arcrank`, `click`, `money`, `title`, `shorttitle`, `color`, `writer`, `source`, `litpic`, `pubdate`, `senddate`, `mid`, `keywords`, `lastpost`, `scores`, `goodpost`, `badpost`, `voteid`, `notpost`, `description`, `filename`, `dutyadmin`, `tackid`, `mtype`, `weight`) VALUES ('0', '0', '0', '0', NULL, '0', '62', '0', '0', '0', 'titl', '', '', '', '', '', '0', '0', '0', '', '0', '0', '0', '0', '', '0', '455', '', '0', '0', '0', '0');
//
//INSERT INTO `789dede.com`.`tf_arctiny` (`id`, `typeid`, `typeid2`, `arcrank`, `channel`, `senddate`, `sortrank`, `mid`) VALUES (NULL, '62', '0', '0', '1', '1646982832', '1646982742', '2');
//
//INSERT INTO `789dede.com`.`tf_addonarticle` (`aid`, `typeid`, `body`, `redirecturl`, `templet`, `userip`) VALUES ('903', '62', ' ', '', '', '127.0.0.1');

$result=mysqli_query($link," INSERT INTO `$archives` (`id`, `title`,`description`,`typeid`,`pubdate`, `senddate`,`ismake`,`mid`   ) VALUES ( '$dataid' ,' $posttitle' ,' $posttitle ', '$fenlei' ,'$intime','$intime','1','2'   )  ");

$result2=mysqli_query($link,"INSERT INTO `$arctiny` (`id`, `typeid`,  `senddate`, `sortrank`, `mid` ) VALUES ('$dataid' ,' $fenlei' ,'$intime','$intime' , '2' ) " ) ;
$result3=mysqli_query($link,"INSERT INTO `$addonarticle` (`aid`, `typeid`, `body`  ) VALUES ('$dataid' ,' $fenlei' ,'$postcontent' ) " ) ;
 

 $dataid++;
			
  
	} //for
	 
if($result3){
//unlink('data.txt');
echo 'yes<br>';
rename("data.txt", "data-1.txt");
}else{
echo 'error <br>';
}
  

 mysqli_close($link);
?>

得得CMS 插入数据库的接口及思路需要预处理数据