discuzX2.5 background Operations Custom database tables

Ext.: http://xuliewei.cn/archives/3071

Mainly about how to set up in the background to a database table additions and deletions, if there is a coincidence, if there is improper welcome to point out
1. Build a table with phpMyAdmin

1. CREATE TABLE IF not EXISTS ' pre_jianyanxmlb ' (
2. ' Lbid ' mediumint (8) unsigned not NULL auto_increment,
3. ' Flbid ' mediumint (8) unsigned not NULL default ' 0 ',
4. ' Lbname ' varchar (255) Not NULL default ' ',
5. PRIMARY KEY (' lbid ')
6. ) Engine=myisam DEFAULT CHARSET=GBK auto_increment=28;

2. Then create the file
File list:
./source/admincp/menu/menu_jianyannav.php
./source/language/lang_admincp_jianyannav.php
./source/admincp/admincp_jianyannav.php
./source/admincp/jianyannav/list.php
./source/admincp/jianyannav/publish.php
./template/default/jianyancp/list.htm
./template/default/jianyancp/publish.htm
3. Document source code
menu_jianyannav.php

1. <?php
2. $menu [' Global '][]=array (' menu_jianyannav_mytest ', ' jianyannav_mytest ');//in ' Global ' definition menu menu_jianyannav_mytest ”
3. ?>

lang_admincp_jianyannav.php

1. <?php
2. $extend _lang=array (' menu_jianyannav_mytest ' = ' Jianyan ');//define a name for the background menu
3. $GLOBALS [' Admincp_actions_normal '][]= ' jianyannav ';//define the event file for the background menu
4. ' Admincp_jianyannav.php '
5. ?>

admincp_jianyannav.php

1. <?php
2. $Discuz =discuz_core::instance ();
3. $modarray =array (' list ', ' Publish ');
4. $mod =!in_array ($discuz->var[' mod '), $modarray)? ' List ': $discuz->var[' mod ');
5. $discuz->init ();
6. Require './source/admincp/jianyannav/'. $mod. PHP ';
7. ?>

list.php

1. <?php
2. if (!defined (' In_discuz '))
3. {
4. Exit (' Access denied ');
5. }
6. $list =array ();
7. $query =db::query ("SELECT * from".) Db::table (' jianyanxmlb '). "ORDER by Flbid,lbid");
8. while ($xmlb =db::fetch ($query))
9. {
10. $list []= $xmlb;
11. }
12. if (Submitcheck (' Submitdel '))
13. {
14. $lbid =dhtmlspecialchars (stripslashes ($_post[' lbid '));
15. Db::query ("delete from".) Db::table (' jianyanxmlb '). "Where". Db::field (' Lbid ', $lbid));
16. Cpmsg ("Delete succeeded", ' action=jianyannav&mod=list ');
17. }
19. Include_once Template ("Jianyancp/list");
20. ?>

List.htm

2. <div id= "CT" >
6. <div class = "BM" >
8. <table border=1px>
10. <tr><td><b> category id</b></td><td><b> Parent category id</b></td><td> <b> Category name </b></td><td><b></b></td><td><b></b></td ></tr>
12. <!--{if $list}-->
14. <!--{Loop $list $xmlb}-->
16. <tr>
18. <td> $xmlb [' Lbid ']</td>
20. <td> $xmlb [' Flbid ']</td>
22. <td> $xmlb [' Lbname ']</td>
24. <td>
26. <form method= "POST" action= "Admin.php?action=jianyannav&mod=list" >
28. <input type= "hidden" name= "Formhash" id= "Formhash" value= "{Formhash}" >
30. <input name= "Lbid" id= "Lbid" type= "hidden" value= $xmlb [' Lbid ']>
32. <input type= "Submit" Name= "Submitdel" value= "Delete" >
34. </form>
36. </td>
38. <td>
40. <form method= "POST" action= "Admin.php?action=jianyannav&mod=publish" >
42. <input type= "hidden" name= "Formhash" id= "Formhash" value= "{Formhash}" >
44. <input name= "Lbid" id= "Lbid" type= "hidden" value= $xmlb [' Lbid ']>
46. <input type= "Submit" Name= "SubmitEdit" value= "edit" >
48. </form>
50. </td>
54. </tr>
58. <!--{/loop}-->
60. <!--{else}-->
62. <p> no data for the time being </p>
64. <!--{/if}-->
66. </table>
68. </div>
70. </div>

publish.php

2. <?php
4. if (!defined (' In_discuz '))
6. {
8. Exit ("Access denied");
10. }
12. if (!$_g[' uid '))
14. {
16. ShowMessage (' Sorry, not yet logged in, cannot be published ');
18. }
20. if (Submitcheck (' SubmitEdit '))
22. {
24. $lbid =dhtmlspecialchars (stripslashes ($_post[' lbid '));
26. Echo $lbid;
28. $XMLB =db::fetch_all ("SELECT * from".) Db::table (' jianyanxmlb '). "Where". Db::field (Lbid, $lbid));
30. echo $xmlb [0][' lbid '];
32. echo $xmlb [0][' flbid '];
34. echo $xmlb [0][' Lbname '];
36. }
38. if (Submitcheck (' Submit '))
40. {
42. $lbid =dhtmlspecialchars (stripslashes ($_post[' lbid '));
44. $flbid = Cutstr (Dhtmlspecialchars (stripslashes ($_post[' flbid ')), 80, "); Intercept 150 bytes of content
46. $lbname = Cutstr (Dhtmlspecialchars (stripslashes ($_post[' lbname ')), 150, "); Intercept 150 bytes of content
48. if (! $lbid)
50. {
52. Db::query ("INSERT into".) Db::table (' jianyanxmlb '). " (lbid,flbid,lbname) VALUES (null, ' ". $flbid." ', ' ". $lbname." ') ");
54. Cpmsg ("Publishing Success", ' action=jianyannav&mod=list ');
56. }
58. Else
60. {
62. Db::query ("Update". Db::table (' jianyanxmlb '). "Set". Db::field (Flbid, $flbid). ",". Db::field (Lbname, $lbname). "Where". Db::field (Lbid, $lbid));
64. echo "Update". Db::table (' jianyanxmlb '). "Set". Db::field (Flbid, $flbid). ",". Db::field (Lbname, $lbname). "Where". Db::field (Lbid, $lbid);
66. Cpmsg ("Editorial success", ' action=jianyannav&mod=list ');
68. }
72. }
74. Include_once Template ("Jianyancp/publish");
78. ?>

Publish.htm

2. <div id= "CT" >
4. <form method= "POST" action= "Admin.php?action=jianyannav&mod=publish" >
5. <input type= "hidden" name= "Formhash" id= "Formhash" value= "{Formhash}" >
6. <input type= "hidden" name= "Lbid" id= "Lbid" value= $xmlb [0][' Lbid ']>
7. <b> parent category Id:</b><input name= "Flbid" id= "Flbid" value= $xmlb [0][' Flbid ']><br>
8. <b> category name: </b><input name= "Lbname" id= "Lbname" value= $xmlb [0][' Lbname ']><br>
10. <input type= "Submit" name= "Submit" value= "POST" style= "Float:left" ><br>
11. </form>
13. </div>

discuzX2.5 background Operations Custom database tables