分享火车头8.X 2.X mysql语法导入ECMS帝国7.0完美无错版

G275483360

1. INSERT INTO phome_ecms_stock(classid,title,newstime,Brand,subtitle,goods,moq,spq,Description,stock,leadtime,RMB,qq,com,username,userid,havehtml,newspath,stb) VALUES('[标签:分类ID]','[标签:标题]','[系统时间戳]','[标签:品牌]','[标签:标题]','[标签:类型]','0','0','[标签:描述]','[标签:stock]','1-2周','[标签:Price]','257386','[标签:公司]','admin','1','1','20141002','1')
   
2. 
   
3. INSERT INTO phome_ecms_stock_data_2(id,classid,keyid,dokey,newstempid,closepi,haveaddfen,infotags) VALUES ('[文章编号:phome_ecms_stock]','[标签:分类ID]','','0','0','0','0','0')
   
4. 
   
5. INSERT INTO phome_ecms_stock_index(id,classid,checked,newstime,truetime,lastdotime,havehtml) VALUES('[文章编号:phome_ecms_stock]','[标签:分类ID]','1','[系统时间戳]','[系统时间戳]','[系统时间戳]','1')
   
6. 
   
7. update  phome_ecms_stock set `filename`=`id` where id=[文章编号:phome_ecms_stock]
   
8. 
   
9. update `phome_ecms_stock` set titleurl=CONCAT('/stock/','[系统时间戳],'/','[文章编号:phome_ecms_stock]','.html')

复制代码

每个人的需求不一样，字段也不一样，请根据自己的需求更改。

以上是5句MYSQL，每段一个回车，顺应火车头的mysql语法要求。
以及不要在msyq命令后面增加结束符号【;】注意分号哦，分号是命令结束符号。
分享也当做是自己后期的备忘录吧。

G275483360

以下为帝国ECMS结合火车头的文件，类似于自定义API工具吧，相关信息需要自己去修改。

1. <?php
   
2. /**
   
3. 1、本接口基本上全部是数据库操作，因此所采集的数据一定要对应数据库字段，否则内容就不是自己想要的了。
   
4. 2、本接口只适合帝国CMS7.0系统，如果您用的是7.0以下系统请自行修改文件。
   
5. 3、此接口经过差不多1个月的测试，没有问题。可以正常的更新和添加文章，因此如果您觉得不好用可以找其他接口。
   
6. 4、由于根据自己的需要做的接口，因此如果你想自己用可能得自己修改了，这个接口只是做一个参考，如果你懂一点点代码改起来应该不难。
   
7. 
   
8. **/
   
9. header('conten-type:text/html;charset=gb2312');
   
10. $password='stock';                        // 验证密码所用， 发表地址后缀： /e/admin/stock.php?pw=stock
    
11. if($password!=$_GET['pw']) exit('验证密码错误');   //安全检测,密码不符则退出
    
12. define('InEmpireCMS',TRUE);
    
13. include("e/config/config.php");
    
14. define('DB_HOST',$ecms_config['db']['dbserver']);        //数据库登录地址
    
15. define('DB_PASSWORD',$ecms_config['db']['dbpassword']);//数据库密码
    
16. define('DB_USER',$ecms_config['db']['dbusername']);//数据库用户名
    
17. define('DB_NAME',$ecms_config['db']['dbname']);////数据库名
    
18. $db = mysql_connect(DB_HOST,DB_USER,DB_PASSWORD) ;
    
19. mysql_select_db(DB_NAME,$db) ;
    
20. mysql_query("set names gb2312");
    
21. mysql_query("SET character_set_results=gb2312");
    
22. /////////////////////////////////////////////初始化配置
    
23. $times = time();
    
24. $times2 = time(); //对应自动发布时间
    
25. $id =  $_POST['stock_id'];//ID必须有
    
26. /////////////////////////////////////////////主表phome_ecms_stock
    
27. $stock = ''; //这个为分类，你采集的文章肯定有分类，每个分类对应一个栏目
    
28. $title = $_POST['title'] ;
    
29. $subtitle = $_POST['subtitle'] ;
    
30. $stock_id = $_POST['stock_id'] ; //ID必须有
    
31. $titlepic = $_POST['titlepic'] ;
    
32. $smalltext = $_POST['smalltext'] ;
    
33. $newstime =  $times ; //
    
34. $diggtop = $_POST['diggtop'] ; //顶
    
35. $diggdown = $_POST['diggdown'] ; //踩,如果自己没有加这个字段可以自己加也可放着
    
36. $infopfen = $_POST['infopfen'] ; //评分数
    
37. $infopfennum = $_POST['infopfennum'] ; //评分人数
    
38. $onclick = $_POST['onclick'] ; //浏览人数
    
39. $filename= $id ;
    
40. $ttid='0';
    
41. $plnum=0;
    
42. $totaldown=0;
    
43. $newspath='';
    
44. $userid=1; //管理员ID
    
45. $username='admin';   //发布账号
    
46. $firsttitle=0;
    
47. $isgood=0;
    
48. $ispic=0;
    
49. $istop=0;
    
50. $isqf='0';
    
51. $ismember=0;
    
52. $isurl=0;
    
53. $truetime=$times;
    
54. $lastdotime=$times;
    
55. $havehtml=1;
    
56. $groupid=0;
    
57. $userfen=0;
    
58. $titlefont='';
    
59. $stb=0;
    
60. $fstb=1;
    
61. $restb=1;
    
62. $keyboard='';
    
63. $goods=$_POST['goods'];
    
64. $moq=$_POST['moq'];
    
65. $spq=$_POST['spq'];
    
66. $box=$_POST['box'];
    
67. $Description=$_POST['Description'];
    
68. $stock=$_POST['stock'];
    
69. $leadtime=$_POST['leadtime'];
    
70. $RMB=$_POST['RMB'];
    
71. $qq=$_POST['qq'];
    
72. $com=$_POST['com'];
    
73. $Brand=$_POST['Brand'];
    
74. 
    
75. 
    
76. /////////////////////////////////////////////副表phome_ecms_stock_data_1
    
77. $writer = $_POST['writer'] ;
    
78. $befrom = $_POST['befrom'] ;
    
79. $newstext = $_POST['newstext'] ;
    
80. $stock_pf = $_POST['stock_pf'] ;
    
81. $keyid='';
    
82. $dokey=0;
    
83. $newstempid=0;
    
84. $closepl=0;
    
85. $haveaddfen=0;
    
86. $infotags='';
    
87. /////////////////////////////////////////////索引表phome_ecms_stock_index
    
88. $checked=0; //信息属性:审核   1 为审核  0为非审核，只有为0的时候才能延迟发布文章
    
89. /////////////////////////////////////////////phome_enewsinfovote
    
90. $id3 = 1000010000000000 + $id ;
    
91. $pubid = number_format($id3,'','','') ;
    
92. $votenum = 0 ;
    
93. $voteip = '';
    
94. $votetext ='';
    
95. $voteclass = 0;
    
96. $doip = 0;
    
97. $dotime ='0000-00-00';
    
98. $tempid =1 ;
    
99. $width = 500 ;
    
100. $height = 300 ;
     
101. $diyotherlink = '';
     
102. $infouptime = $times2 ;
     
103. $infodowntime = 0;
     
104. $copyids = '';
     
105. 
     
106. 
     
107. 
     
108. 
     
109. 
     
110. ?>
     
111. <?php
     
112. $enews=$_POST['enews'];
     
113. if(empty($enews))
     
114. {
     
115.         $enews=$_GET['enews'];
     
116. }
     
117. if(!$_POST){
     
118. // 列出终极栏目
     
119. $qbrand = mysql_query("SELECT classid,classname,bclassid FROM `".$dbtbpre."enewsclass` where islast=1  order by myorder,classid desc ");
     
120.     echo '<select name="classid">';
     
121.     while($row = mysql_fetch_array($qbrand)){
     
122.         $qbrand2 = mysql_query("SELECT classid,classname,bclassid FROM `".$dbtbpre."enewsclass` where classid='".$row['bclassid']."'");
     
123.          while($row2 = mysql_fetch_array($qbrand2)){
     
124.           echo '<option value="'.$row['classid'].'">'.$row2['classname'].$row['classname'].'</option>';
     
125.                 }
     
126.                 }
     
127.         echo '</select><br />';               
     
128. }else{
     
129.    if ( get_magic_quotes_gpc ()) {
     
130.       stripslashes ( $_POST );
     
131.     }
     
132. @extract($_POST);
     
133. ?>
     
134. 
     
135. <?php
     
136. $qbrand3 = mysql_query("SELECT classid , classpath  FROM `".$dbtbpre."enewsclass` where classname='".$stock."' and bclassid='".$bclassid."' ");
     
137. while($row3 = mysql_fetch_array($qbrand3)){
     
138. $classid = $row3['classid'] ;  //该栏目的ID
     
139. $classpath = $row3['classpath'] ;
     
140.                 }       
     
141. if(!$classpath){
     
142. $classid = 709;
     
143. $classpath = 'lingshi';
     
144. }
     
145. $titleurl = '/' . $classpath . '/' . $id . '.html'; //外部链接       
     
146.        
     
147. $qbrand4 = mysql_query("SELECT stock_id  FROM `".$dbtbpre."ecms_stock` where id='".$id."' ");
     
148. while($row4 = mysql_fetch_array($qbrand4)){
     
149. $id_4 = $row4['stock_id'] ;  //
     
150.                 }
     
151. $qbrand5 = mysql_query("SELECT stock_id  FROM `".$dbtbpre."ecms_stock_check` where id='".$id."' ");
     
152. while($row5 = mysql_fetch_array($qbrand5)){
     
153. $id_5 = $row5['stock_id'] ;  //
     
154.                 }
     
155. ?>       
     
156. <?php
     
157. mysql_query("BEGIN");
     
158. if($enews=="AddNews"){
     
159. if($id_4)
     
160. {
     
161. $checked=1;
     
162. $phome_ecms_stock = mysql_query(" UPDATE ".$dbtbpre."ecms_stock  SET  classid='$classid' , ttid='$ttid' , onclick='$onclick' , plnum='$plnum' , totaldown='$totaldown' , newspath='$newspath' , filename='$filename' , userid='$userid' , username='$username' , firsttitle='$firsttitle' , isgood='$isgood' , ispic='$ispic' , istop='$istop' , isqf='$isqf' , ismember='$ismember' , isurl='$isurl' , truetime='$truetime' , lastdotime='$lastdotime' , havehtml='$havehtml' , groupid='$groupid' , userfen='$userfen' , titlefont='$titlefont' , titleurl='$titleurl' , stb='$stb' , fstb='$fstb' , restb='$restb' , keyboard='$keyboard' , title='$title' , newstime='$newstime' , titlepic='$titlepic' , subtitle='$subtitle' , smalltext='$smalltext' , diggtop='$diggtop' , infopfen='$infopfen' , infopfennum='$infopfennum' , diggdown='$diggdown' , stock='$stock'  , stock_tel='$stock_tel' , stock_xy='$stock_xy' , stock_xyurl='$stock_xyurl' , stock_rz='$stock_rz' , stock_tg='$stock_tg' , stock_jt='$stock_jt' , stock_rel='$stock_rel' , stock_30yj='$stock_30yj' , stock_dq='$stock_dq' WHERE id = '$id_4'goods=goods',moq=moq',spq=spq',box=box',Description=Description',stock=stock',leadtime=leadtime',RMB=RMB',qq=qq',com=com',Brand=Brand'");
     
163. echo '$phome_ecms_stock ' . mysql_errno() . ": " . mysql_error()  ;
     
164. 
     
165. $phome_ecms_stock_data_1 = mysql_query(" UPDATE ".$dbtbpre."ecms_stock_data_1 SET classid='$classid' , keyid='$keyid' , dokey='$dokey' , newstempid='$newstempid' , closepl='$closepl' , haveaddfen='$haveaddfen' , infotags='$infotags' , writer='$writer' , befrom='$befrom' , newstext='$newstext' , stock_pf='$stock_pf' WHERE id = '$id_4'  ");
     
166. 
     
167. echo '$phome_ecms_stock_data_1 ' .  mysql_errno() . ": " . mysql_error()  ;
     
168. 
     
169. $phome_ecms_stock_index = mysql_query(" UPDATE ".$dbtbpre."ecms_stock_index SET classid='$classid' , checked='$checked' , newstime='$newstime' , truetime='$truetime' , lastdotime='$lastdotime' , havehtml='$havehtml' WHERE id = '$id_4'  ");
     
170. 
     
171. echo '$phome_ecms_stock_index ' .  mysql_errno() . ": " . mysql_error()  ;
     
172. 
     
173. $phome_enewsinfovote = mysql_query(" UPDATE ".$dbtbpre."enewsinfovote SET pubid='$pubid' , classid='$classid' , title='$title' , votenum='$votenum' , voteip='$voteip' , votetext='$votetext' , voteclass='$voteclass' , doip='$doip' , dotime='$dotime' , tempid='$tempid' , width='$width' , height='$height' , diyotherlink='$diyotherlink' , infouptime='$infouptime' , infodowntime='$infodowntime' , copyids='$copyids'  WHERE id = '$id_4' ");
     
174. echo '$phome_enewsinfovote ' . mysql_errno() . ": " . mysql_error()  ;
     
175. 
     
176. echo "id_4已审核产品发布成功！" ;
     
177. 
     
178. mysql_query("END");
     
179. 
     
180. mysql_close($db);       
     
181. }
     
182. elseif($id_5)
     
183. {
     
184. $phome_ecms_stock_check = mysql_query(" UPDATE ".$dbtbpre."ecms_stock_check  SET  classid='$classid' , ttid='$ttid' , onclick='$onclick' , plnum='$plnum' , totaldown='$totaldown' , newspath='$newspath' , filename='$filename' , userid='$userid' , username='$username' , firsttitle='$firsttitle' , isgood='$isgood' , ispic='$ispic' , istop='$istop' , isqf='$isqf' , ismember='$ismember' , isurl='$isurl' , truetime='$truetime' , lastdotime='$lastdotime' , havehtml='$havehtml' , groupid='$groupid' , userfen='$userfen' , titlefont='$titlefont' , titleurl='$titleurl' , stb='$stb' , fstb='$fstb' , restb='$restb' , keyboard='$keyboard' , title='$title' , newstime='$newstime' , titlepic='$titlepic' , subtitle='$subtitle' , smalltext='$smalltext' , diggtop='$diggtop' , infopfen='$infopfen' , infopfennum='$infopfennum' , diggdown='$diggdown' , stock='$stock' , stock_id='$stock_id' , stock_tel='$stock_tel' , stock_xy='$stock_xy' , stock_xyurl='$stock_xyurl' , stock_rz='$stock_rz' , stock_tg='$stock_tg' , stock_jt='$stock_jt' , stock_rel='$stock_rel', stock_30yj='$stock_30yj', stock_dq='$stock_dq' WHERE id = '$id_5'goods=goods',moq=moq',spq=spq',box=box',Description=Description',stock=stock',leadtime=leadtime',RMB=RMB',qq=qq',com=com',Brand=Brand' ");
     
185. echo '$phome_ecms_stock_check ' . mysql_errno() . ": " . mysql_error()  ;
     
186. 
     
187. $phome_ecms_stock_check_data = mysql_query(" UPDATE ".$dbtbpre."ecms_stock_check_data SET classid='$classid' , keyid='$keyid' , dokey='$dokey' , newstempid='$newstempid' , closepl='$closepl' , haveaddfen='$haveaddfen' , infotags='$infotags' , writer='$writer' , befrom='$befrom' , newstext='$newstext' , stock_pf='$stock_pf' WHERE id = '$id_5'  ");
     
188. 
     
189. echo '$phome_ecms_stock_check_data ' . mysql_errno() . ": " . mysql_error()  ;
     
190. 
     
191. $phome_ecms_stock_index = mysql_query(" UPDATE ".$dbtbpre."ecms_stock_index SET classid='$classid' , checked='$checked' , newstime='$newstime' , truetime='$truetime' , lastdotime='$lastdotime' , havehtml='$havehtml' WHERE id = '$id_5'  ");
     
192. 
     
193. echo '$phome_ecms_stock_index ' . mysql_errno() . ": " . mysql_error()  ;
     
194. 
     
195. $phome_enewsinfovote = mysql_query(" UPDATE ".$dbtbpre."enewsinfovote SET pubid='$pubid' , classid='$classid' , title='$title' , votenum='$votenum' , voteip='$voteip' , votetext='$votetext' , voteclass='$voteclass' , doip='$doip' , dotime='$dotime' , tempid='$tempid' , width='$width' , height='$height' , diyotherlink='$diyotherlink' , infouptime='$infouptime' , infodowntime='$infodowntime' , copyids='$copyids'  WHERE id = '$id_5' ");
     
196. 
     
197. echo '$phome_enewsinfovote ' . mysql_errno() . ": " . mysql_error()  ;
     
198. 
     
199. echo $id_5 . "id_5未审核产品发布成功！";
     
200. 
     
201. mysql_query("END");
     
202. 
     
203. mysql_close($db);       
     
204. 
     
205. }
     
206. else{
     
207. ?>
     
208. 
     
209. <?php
     
210. if($checked==0){
     
211. $phome_ecms_stock_check = mysql_query("INSERT INTO ".$dbtbpre."ecms_stock_check (id,classid,ttid,onclick,plnum,totaldown,newspath,filename,userid,username,firsttitle,isgood,ispic,istop,isqf,ismember,isurl,truetime,lastdotime,havehtml,groupid,userfen,titlefont,titleurl,stb,fstb,restb,keyboard,title,newstime,titlepic,subtitle,smalltext,diggtop,infopfen,infopfennum,diggdown,stock,stock_id,stock_tel,stock_xy,stock_xyurl,stock_rz,stock_tg,stock_jt,stock_rel,stock_30yj,stock_dq) VALUES ('$id','$classid','$ttid','$onclick','$plnum','$totaldown','$newspath','$filename','$userid','$username','$firsttitle','$isgood','$ispic','$istop','$isqf','$ismember','$isurl','$truetime','$lastdotime','$havehtml','$groupid','$userfen','$titlefont','$titleurl','$stb','$fstb','$restb','$keyboard','$title','$newstime','$titlepic','$subtitle','$smalltext','$diggtop','$infopfen','$infopfennum','$diggdown','$stock','$stock_id','$stock_tel','$stock_xy','$stock_xyurl','$stock_rz','$stock_tg','$stock_jt','$stock_rel','$stock_30yj','$stock_dq')");
     
212. echo '$phome_ecms_stock_check ' . mysql_errno() . ": " . mysql_error()  ;
     
213. 
     
214. $phome_ecms_stock_check_data = mysql_query("INSERT INTO ".$dbtbpre."ecms_stock_check_data (id,classid,keyid,dokey,newstempid,closepl,haveaddfen,infotags,writer,befrom,newstext,stock_pf) VALUES ('$id','$classid','$keyid','$dokey','$newstempid','$closepl','$haveaddfen','$infotags','$writer','$befrom','$newstext','$stock_pf')");       
     
215. 
     
216. echo '$phome_ecms_stock_check_data ' . mysql_errno() . ": " . mysql_error()  ;
     
217. }
     
218. else{
     
219. $phome_ecms_stock = mysql_query("INSERT INTO ".$dbtbpre."ecms_stock (id,classid,ttid,onclick,plnum,totaldown,newspath,filename,userid,username,firsttitle,isgood,ispic,istop,isqf,ismember,isurl,truetime,lastdotime,havehtml,groupid,userfen,titlefont,titleurl,stb,fstb,restb,keyboard,title,newstime,titlepic,subtitle,smalltext,diggtop,infopfen,infopfennum,diggdown,stock,stock_id,stock_tel,stock_xy,stock_xyurl,stock_rz,stock_tg,stock_jt,stock_rel,stock_30yj,stock_dq,'goods','moq','spq','box','Description','stock','leadtime','RMB','qq','com','Brand') VALUES ('$id','$classid','$ttid','$onclick','$plnum','$totaldown','$newspath','$filename','$userid','$username','$firsttitle','$isgood','$ispic','$istop','$isqf','$ismember','$isurl','$truetime','$lastdotime','$havehtml','$groupid','$userfen','$titlefont','$titleurl','$stb','$fstb','$restb','$keyboard','$title','$newstime','$titlepic','$subtitle','$smalltext','$diggtop','$infopfen','$infopfennum','$diggdown','$stock','$stock_id','$stock_tel','$stock_xy','$stock_xyurl','$stock_rz','$stock_tg','$stock_jt','$stock_rel','$stock_30yj','$stock_dq','$goods','$moq','$spq','$box','$Description','$stock','$leadtime','$RMB','$qq','$com','$Brand')");
     
220. 
     
221. echo '$phome_ecms_stock ' . mysql_errno() . ": " . mysql_error()  ;
     
222. 
     
223. $phome_ecms_stock_data_1 = mysql_query("INSERT INTO ".$dbtbpre."ecms_stock_data_1 (id,classid,keyid,dokey,newstempid,closepl,haveaddfen,infotags,writer,befrom,newstext,stock_pf) VALUES ('$id','$classid','$keyid','$dokey','$newstempid','$closepl','$haveaddfen','$infotags','$writer','$befrom','$newstext','$stock_pf')");       
     
224. 
     
225. echo '$phome_ecms_stock_data_1 ' . mysql_errno() . ": " . mysql_error()  ;
     
226. 
     
227. }
     
228. $phome_ecms_stock_index = mysql_query("INSERT INTO ".$dbtbpre."ecms_stock_index (id,classid,checked,newstime,truetime,lastdotime,havehtml) VALUES ('$id','$classid','$checked','$newstime','$truetime','$lastdotime','$havehtml')");
     
229. 
     
230. echo '$phome_ecms_stock_index ' . mysql_errno() . ": " . mysql_error()  ;       
     
231. 
     
232. $phome_enewsinfovote = mysql_query("INSERT INTO ".$dbtbpre."enewsinfovote (pubid,id,classid,title,votenum,voteip,votetext,voteclass,doip,dotime,tempid,width,height,diyotherlink,infouptime,infodowntime,copyids) VALUES ('$pubid','$id','$classid','$title','$votenum','$voteip','$votetext','$voteclass','$doip','$dotime','$tempid','$width','$height','$diyotherlink','$infouptime','$infodowntime','$copyids')");
     
233. 
     
234. echo '$phome_enewsinfovote ' . mysql_errno() . ": " . mysql_error()  ;       
     
235. 
     
236. echo "产品发布成功！";
     
237. 
     
238. mysql_query("END");
     
239. 
     
240. mysql_close($db);                       
     
241. 
     
242. }
     
243. }
     
244. ?>
     
245. 
     
246. <?php
     
247. }
     
248. ?>
     

复制代码

fk1985

请问这个是做什么用的？谢谢。。

wincy

貌似不能用吧。一楼提到的那几个表。7.0的帝国。都没有这些表了。

guxiaokang

是呀！
有好几个表没有
怎么弄！

jixiejianshe

01.<?php

02./**

03.1、本接口基本上全部是数据库操作，因此所采集的数据一定要对应数据库字段，否则内容就不是自己想要的了。

04.2、本接口只适合帝国CMS7.0系统，如果您用的是7.0以下系统请自行修改文件。

05.3、此接口经过差不多1个月的测试，没有问题。可以正常的更新和添加文章，因此如果您觉得不好用可以找其他接口。

06.4、由于根据自己的需要做的接口，因此如果你想自己用可能得自己修改了，这个接口只是做一个参考，如果你懂一点点代码改起来应该不难。

07.

08.**/

09.header('conten-type:text/html;charset=gb2312');

10.$password='stock';                        // 验证密码所用， 发表地址后缀：http://www.jixiejianshe.com/

11.if($password!=$_GET['pw']) exit('验证密码错误');   //安全检测,密码不符则退出

12.define('InEmpireCMS',TRUE);

13.include("e/config/config.php");

14.define('DB_HOST',$ecms_config['db']['dbserver']);        //数据库登录地址

15.define('DB_PASSWORD',$ecms_config['db']['dbpassword']);//数据库密码

16.define('DB_USER',$ecms_config['db']['dbusername']);//数据库用户名

17.define('DB_NAME',$ecms_config['db']['dbname']);////数据库名

18.$db = mysql_connect(DB_HOST,DB_USER,DB_PASSWORD) ;

19.mysql_select_db(DB_NAME,$db) ;

20.mysql_query("set names gb2312");

21.mysql_query("SET character_set_results=gb2312");