destoon 笔记

cmseasy

http://help.destoon.com/book/

★新建模块
1.destoon_module插入数据
2.新建/test/ [中转文件夹](模仿down)
2.新建/module/test/ [业务层文件夹](模仿down)
3.修改/module/test/admin/config.inc.php 中 $MCFG['name'] $MCFG['moduleid']
4.新建/template/default/test/ [模板文件夹]
5.新建destoon_test表

★模块设置
/file/cache/module-23.php
/module/test/admin/template/setting.tpl.php
$MOD['upload']

★模板
include template('index', 'member');

★
SELECT * FROM destoon_sell WHERE status=3 ORDER BY addtime DESC LIMIT 0,10
<!--{tag("moduleid=5&condition=status=3&order=addtime desc&pagesize=10")}-->
不用模板
<!--{php $tags=tag("moduleid=...&template=null");}-->
{loop $tags $k}
...{date('Y-m-d', $k[addtime])} {dsubstr($v[introduce], 80, '...')}
{/loop>
联合查询
{tag("table=destoon_member m,destoon_company c&prefix=&condition=m.userid=c.userid and m.username='destoon'&template=list-com")}

★数据库
执行
$db->query("INSERT INTO `{$DT_PRE}table` (`xxx`) VALUES ('yyy')");
$db->query("UPDATE `{$DT_PRE}table` SET `xxx`='yyy' WHERE `zzz`=1");
$db->query("DELETE FROM `{$DT_PRE}table` WHERE `zzz`=1");
$db->insert_id()
多条信息
$A = array();
$result = $db->query("SELECT * FROM `{$DT_PRE}table` WHERE `xxx`='yyy' ORDER BY `zzz` DESC LIMIT 0,10");
while($r = $db->fetch_array($result)) {
$A[] = $r;
}
print_r($A);
单条信息
$A = $db->get_one("SELECT * FROM `{$DT_PRE}table` WHERE `xxx`='yyy'");
print_r($A);
计算总数
$A = $db->get_one("SELECT COUNT(*) AS num FROM `{$DT_PRE}table` WHERE `xxx`='yyy'");
echo $A['num'];

★消息
global.func.php
send_message/send_mail

转载于:https://www.cnblogs.com/foxtk/archive/2013/03/13/2956982.html