上次的入门已经介绍了后台管理插件开发的基本步骤,下面简单写一个示例查询一下用户表

需要已完成以下操作:

1.已创建test后台管理插件 //详见 http://www.cnblogs.com/savokiss/p/3937055.html

1.在test1.inc.php中添加以下代码:

$sql         = "SELECT * FROM ".DB::table('common_member')." LIMIT 10"; //定义sql语句,查询common_member表中的前10个用户
$test_result = DB::fetch_all($sql);                        //查询数据库,将数据存入变量中

这里用到了DB类的两个静态方法,一个是DB::table(),一个是DB::fetch_all(),其他静态方法详见:DB类常用方法

2.修改template文件夹下的test.htm模板

<table class="reg_yest_table">
<tr>
<th>id</th>
<th>用户名</th>
<th>邮箱</th>
</tr>
<!--{loop $test_result $val}-->
<tr>
<td>
$val['uid']
</td>
<td>
$val['username']
</td>
<td>
$val['email']
</td>
</tr>
<!--{/loop}-->
</table>

这里用到discuz模板引擎的loop循环,模板引擎详细语法见:模板标签说明

然后点击插件页面,即可看到查询出来的数据了

aaarticlea/png;base64,iVBORw0KGgoAAAANSUhEUgAAAaIAAABXCAIAAADJQdYmAAAAA3NCSVQICAjb4U/gAAAQBklEQVR4Xu3deVwUdR8H8NkbduUUJE5NkBdpgEimqIGWjz4JaZiS4VWWT5piXhlqmpb2mKJgTyiZiTdCZpoHmpDK45MHZiqKIKSA3NfCcu09z7KgkXEoM84O8Nk/fMnOzvf3/b2/M9+dmR0WDkmSBB4QgAAEOq8At/NODTODAAQgUC+ANoftAAIQ6OQCaHOdvMCYHgQgwG+WICgoqNnn8SQEIAABhgXi4uIojth8m9MFpR6aYmZdZHXdOwqomak1qJlxpncUWg65cNJKb1EQDQIQYJ0A2hzrSoKEIAABegXQ5uj1RDQIQIB1AmhzrCsJEoIABOgVQJuj1xPRIAAB1gmgzbGuJEgIAhCgVwBtjl5PRIMABFgngDbHupIgIQhAgF4BtDl6PRENAhBgnQDaHOtKgoQgAAF6BdDm6PVENAhAgHUCaHOsKwm1hDQV136MvVCqaTkKqZCW1bayvOU1u8gSdUHit3t+l+m/bpZUVZUUPHiUVKn0T2qkKWd/K2kk1JTfSLpWBk9Wbxwt/up+61krM3csijIPXTfevkkAbXniiqU3JkUscDdufW0sfUIBZfbRbbGpNX/7nmeR84TZE5xFTaPxjETF53Yl+LwwyUnQ3CjaisvbPjvpsmT5q7btrH1zUTvVc9ra+7fSNEqdNodQZsWtWJXczdGcpyjOVvitjZjuLKjLPBwVnfrsrcsSLsG3sFP893B275sXxByC4PcYGhToYYZjB7ZtD+3c1Pk2ftOChZY8tk2nk+ajqbhb0jv4kwmOfOmZNZHckOV+5hxCU3T8s+hyDeGsm7SmOCFs7aFsVf38tbWl5bWfhiQZ1+9tXIsh81dOcWnshNqqmzEb9uRZOdbu3niD0Moy07jj16961QZ1bNhwFPeO7j6RUydLL8lN2xWZYdTN9dVBhKj3xGWrh6viV35RMNheSFanxGzPGLFyufeNiP1GU1+v2LHfd9mygTc2x5rMnOdrZSRCj2PhTtjONqcuOrd7v3moh6M9rybjeNSWHy7nEw6DRrvL/3bAwcI5d8KUSJWsjD9s/mfjmh5dE0TNlfWfXlM01ERTlR4fteW06qV5K99wFXPIuoyD63bYTvTtgR73cINQFV29VNhv6kBZSr6lp4fJyb03yrzNdUtJ1f3EX1S+C5yNCFKq7hEw26f25wSnd6Y5WZnVzVho62zBd/jXhFIzYzQ5lu5b7WxzD2ZD1qXuDfteOnLRV6OeKf75q3UX5S+wdKIdPC3d+8r2jX+IOcrizEzO1+sv6k5ISXl+HnfKn/PiCsUSieSvBTXi6U6l6h+a4nPRP0mHLlyoPrEtLGbCdLfb0bEVoz96/3lJ4ws6uA9t6Qutn/PqV/3jJbv+A7pfOlDQEFd+58T/RC+v0p/mW3gF+JHSM+kZvNFB1sTVf6/fWWVrJeIQpKKkwPSd8FBvMW25IBBdAhTbnOJuQjJ/eOhYDxsRYTN2ql/ClzV0ZYY4TQRIns3wmYvfcODpT1rnLnl40vrna9T5pyJW/q7b35o8NLIsuYv+Z16Pl+d9VP8fcvqUrNDP19ybsPCTWc+Z4AyrKVf9/7V10pLyGrVSVlrKlWsblwodhw5Q7D6R4TfNTVh+YdeOM/fzM/7gRKy77tZHafXy3E8C7fiEOu/Qp7sfrPBoVPxsWAGKbU5TLVWZulsK9ZPgWziY89MNO5/OOTqpUZE8bivHXaRWxbV7ZdqsYZaPNC4OT2LVeGFOU5V9JeHoj0eS7pK9vJ1zT0d/fVqvJXIe945/z4YSdk6+J5iVtir10HcllcV5Rru283MVjg2r8kw9gmf0Cd333zGrRln7zFjkmrhizl3LgJC5bqlrTsdEb84Sc3WXRHOKtMFPMBReypwAxTbHN+kulOWUq4j6TqeW5lWomUu964xEKqurCs7vCEsXEC2ctKrLc2vMfZ2dHCTNq2hKEsPWHFe7e4sVziGRCwc8PLFS5x5ed7hUjTbX6MY183431D955Q67RaHdv1ly9gEnx7iXt1VpUqFylLWxpvhyUjFHLT0cf3e+E9/Gd/qHD4/mmtfHs4YWoNjmRM+OHKhZt/OI97zRumtze5OkmgGGnlEnHF9Vlq3qO3XpAk9j3UWh5k5a6+79+oexa9Bf7iz5iwPPesSi8Ff4ZMGRVfeNdFfwHrY5lVjY2lFiJ8R88ilpa+/9L/H3sqv5IgdTPkHKrh1OthviwrMcUngwUSgvSsLR3JObMrwGxTZHGLtNXjwxKnJTyEHSfnDgpP6VGQxPoAsMpyr87bbY07/FJqYpSoq5JPL5/JnWisnl605ncRNrW5uLVnY1ekNeZcF9Ufh6QU6d/SjdClyBkbrgTn6PwDljnQTq/BMn1f+Y5PxzjMjng0W8Kxuu42iuLVTDL29tz2glO6HLjP+ENSyXuAQsCg948NpxrayERe0SqEuPv95r7LLGq25c/cGX/E5MxJ6reUqP+XxClf/rr6oR//J3aPZ24EeHlGcc2PD5yYdX8HQf1xZKej/6oq77M1fSZ/Tkt5zrr1TKU7dvbrjSLLD1mzJ7RCOKXcCS2YTsl591Nw/r3jo4qoLEqC/TdPcoauvyCgTTu64cq2fOIclmbnXDn3pjrGiPQU2qFVqe6MGtIc1lpisih9PKJxTNrdP1nmubmlTX1aqFEiP9rYT1P6gERlyFgisWCx7Rrd9tQM7ENtR21R4ji3YezT1GZLyELgEOX9TGLbzY4eix5vCN/7zx8MEP/OZuhIM4PeIMRcGNUwxBYxgIQMBQAmhzhpLHuBCAAEMCaHMMQWMYCEDAUAJoc4aSx7gQgABDAmhzDEFjGAhAwFACaHOGkse4EIAAQwJocwxBYxgIQMBQAmhzhpLHuBCAAEMCaHMMQWMYCEDAUAJoc4aSx7gQgABDAmhzDEFjGAhAwFACLf7qvqESwrgQgAAEmgrExcVRBGnxV/eph6aYWRdZnZYvYOgiVhSnCWqKgAZZXVc16uPipJW6ISJAAAKsFkCbY3V5kBwEIEBdAG2OuiEiQAACrBZAm2N1eZAcBCBAXQBtjrohIkAAAqwWQJtjdXmQHAQgQF0AbY66ISJAAAKsFkCbY3V5kBwEIEBdAG2OuiEiQAACrBZAm2N1eZAcBCBAXQBtjrohIkAAAqwWQJtjdXmQHAQgQF2AWpvTlp/5fGlsjop6HojQbgFteeLy98NT6toIoMzcEbL4UJ66jZdhcSsCtFKTNffO7QlfvXjW1KCgqe8vWLFx3/mcWrKV0ZsuojWTxxyzA7+sxW8oaWNOpLIkLfnS+eMHUqoD2ngpFrNCgG/jNy1YaMljRTKdO4m2qTWV1+M2fZ2gHhz0+sw3XR1NFEVZt84f2fPxnMQ3P1kyztmYQxNQ25nQNBDLw7S7zdUV3k69rzQxF1SzfIYdPj2y9u6p7VsPXsiWaSU9h02e//5IeyFB1mQcj9ryw+V8wmHQaHe5/iBAlXNgaaTKzyXt2Nm7aqeR7012vBwd8+t9rdM/5i57d6Ck6Nzu/eahHo498g8s3cobNyDz4PFrRfw+/iEfTfY0o3ZU3+GNGyfAELUq99j6/1zrO2/jRKecI1GbdmbVmA7wd00ve3HG8NToDXtdw9/ra1THaNFJZcH5XV/vPZtRJXF+6a25M4bbC1WFF/ZE7v4lXSqw7e//7uzxHua81jcwCxZvQ+1NjWvmPn7m7PfGu2MHecr7uKYocWts0eAPI777duOsPmkHvr8jJ8i61L1h30uHLPhq25dvO948fV/emITi3tl0lw/Ct64eozkVvulm/8WR21aP0SYdvFymbZqmMutkAjfws61RK0YrT+9JKtY85Tl0kPDMUGull/ac4L6x4E23yiNrIzO9F4Rv2ThdFB9f/byvb3BIgOBi/B05M5k8LIsq96ew6GyveZu/DZvlkbUzPL5AXnAy/JtUl5kbv9u2erwkMSLqUoX+rfQxNzC2Fby9bY5t8+i8+XC7+y0JWzbO3UYiEom78ZVVCi2huJuQzB/+9lgPG7Me7mOn+lk8OCjnWb342hB7sWmv/v16WPm8NthWbObs3c9cXb9SkwdH7Pb6q25mxhauL3p1V1XU/WVh56Vsa2aMUJOVKYlZvccOs6m7HhOvHj1thL2QKzK3FFv0G+QgEli7WGnLKxQcRouuyj17ruaF4IB+VmZ2Xq/P/eC1Z3nFF8+WuU+ZMOAZE7OeL70VaH371C1ZfZ97zA2sLWmml7f3pJXpPLvueBxCkXUyetOVPJXYxtao4Rq1plqqMnW3FOpV+BYO5vz0BiCuUCysf+ficLk8oUT/X93//3alh9vtGXOBfg2O7tGwKv4lGKFWlWaUmrraGWtkOUWE7T8tdXugtuL2b7Le/r2MCEXmrTKzvj0lXKKCwaKrq4vlEhcL/RbBMXYc5OeouHNZIbGzFOq3Dd3WYsWvKde/GT7mBsa2jQlHc2yryCP5aMuSNm+54fz26k1ha5fNGmWv3xb5Jt2Fspzyhk+41dK8iif8/BStrbmqM0NNEqRWWasieWa97Iis5MwqRWly7IHbfIfunPJrcduvukx5rSeP2aLzxJbC2sLKho1Ifu9UXEK+wFJUk1+u1DNpa4pK1WJz4w7cKzpw6s1tqZ3vOVKjVBGibt1EXLU05dhPd2pVcjUpenbkQM2ZnUdSimUlN4/uTZLi4hoNlWeGWmjTz052JblQ3c3z7Xe9srZ+FLo17bkp/tYXvvx43XHtuOWzvE05zGRCEJqKtIsXbkt5jn5DBBf3n7hdXluZHr899kqNyHawr0XKvkO/F9XIspP2/VDsNup5kw582I+TVhr2j6cZgmc9bNqoixGLp+836+nt7z/ONfrbzUluy30nL54YFbkp5CBpPzhwUv/KjKeZQxeJzQw1x9QraMT+NZGHPVdMGDpz7dCZDbojXpr2JzMzmRCEMvtoZKR2Uf+PPd9YPOW7yI1zYqqMnIYFf/hPWyPhmIUzSyO/WfhOOd/Gc8z8OT66D1I77v2xLf4BQ/xlL2Z2bvy5KWacdaOwh1qZn7jlix0p3UcFBw7r19vBgivLTbtVbOvjYy9iTKOjDERL1XA011HKjTw7j4DQ7pUPwz2uHYs9FhOxL7uoWisyd+zrG+z5or0It28/jTKjzT0NVcSEQBsCHIG1V+Bcr8A2XobFtAjgIwhaGBEEAhBgrwDaHHtrg8wgAAFaBNDmaGFEEAhAgL0CaHPsrQ0ygwAEaBFAm6OFEUEgAAH2CqDNsbc2yAwCEKBFAG2OFkYEgQAE2CuANsfe2iAzCECAFgG0OVoYEQQCEGCvANoce2uDzCAAAVoE0OZoYUQQCECAvQItfkMJe1NGZhCAQFcSoP5tSS3+6j710F2pEO2fKy3fM9P+4bvSmqDuiNXWVY162jhppW6ICBCAAKsF0OZYXR4kBwEIUBdAm6NuiAgQgACrBdDmWF0eJAcBCFAXQJujbogIEIAAqwXQ5lhdHiQHAQhQF0Cbo26ICBCAAKsF/g8TIgCSa5BBTQAAAABJRU5ErkJggg==" alt="" />

其他数据已略去

注:本文只是示例,正规开发可能会使用discuz缓存机制,有待深入研究

04-30 12:46