dedecms如果是新聞與軟件表我們只要操作三個表就可以了,如果我們要對批量插入的數據設置未設置狀態只要在主表字段arcrank設置為-1就可以了哦,下面看一個例子,代碼如下:

1. <?php 
2. // 本類由系統自動生成，僅供測試用途 
3. class IndexAction extends Action { 
4.     public function index(){ 
5.         $id = $this->_get('id');     $endid = $this->_get('endid');                
6.         $typeid = 9;//寫入的欄目 
7.         $db = M();              if(!$id || !$endid){ 
8.                     $listend = $db->table('dede_archives')->limit(1)->order('id desc')->find();     
9.                     exit('no id and endid id must start big from '.$listend['id']); //必須大于某id開始  
10.                     }  
11.         $list = $db->table('tb1')->where('status=0')->find();//查找待發布DB未發布的 
12.         if($list){ 
13.             $time=time(); 
14.             $r1= $db->query("INSERT INTO `dede_arctiny` VALUES(".$id.", ".$typeid.", '0', 0, 1, ".$time.", ".$time.", 1)");//寫入到織夢DB  
15.                 $data2['arcrank']=-1; 
16.                 $data2['title']=$list['title']; 
17.                 $data2['typeid']=$typeid; 
18.                 $data2['id']=$id;               $data2['pubdate']=$time; 
19.                 $data2['senddate']=$time;               $data2['sortrank']=$time; 
20.                 $data2['mid']=1; 
21.                 $data2['dutyadmin']=1; 
22.                 $data2['weight']=1; 
23.             $r2=$db->table('dede_archives')->add($data2); 
24.             if($r2>0){//寫入成功后寫入附加表 
25.                 $r3= $db->query('INSERT INTO `dede_addonarticle` VALUES('.$id.', '.$typeid.', "'.$list['content'].'", "", "", "127.0.0.1")'); 
26.                 $r4 = $db->table('tb1')->where("id = ".$list['id'])->setField('status',1);//寫入成功后標記為已發布 
27.                 if($r4){ 
28.                     $nextid = $id+1; 
29.                     //$this->redirect("index",array('id'=>$nextid));                  //if($id=99999 || $id=88888) exit; 
30.                     echo 'ok '.$id; 
31.                     echo 'next '.$nextid;                   if($endid==$id) exit('<br>the end id!'); 
32.                     echo"<script>window.location.href='/Sphp/index.php?s=/Index/index/id/".$nextid."/endid/".$endid."'</script>"; 
33.                 } //Vevb.com 
34.             } 
35.             //dump($r2); 
36.             //dump($r3); 
37.             exit; 
38.               
39.         }else{      echo 'no article yet';      } 
40.           
41.       
42.       
43.     } 
44. }