smarty自定义插件

最新推荐文章于 2025-12-12 10:48:03 发布

原创最新推荐文章于 2025-12-12 10:48:03 发布 · 1.1k 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#each #list #null

php 专栏收录该内容

3 篇文章

订阅专栏

本文详细介绍了如何使用PHP的smarty模板引擎进行数据查询，并实现分页功能，包括参数处理、SQL构造、结果集获取及分页输出。

1.$smarty->setPlugin("../../plugins");

2.实例：block.purchases.php文件

<?php function smarty_block_purchases($params, $content, &$smarty, &$repeat) { global $db, $config, $counter; $l = count($smarty->_tag_stack);//找出父块函数 if(empty($params['name'])) $params['name'] = "purchases";//本来是空的 if(empty($smarty->blockvars[$l])) { $sqlstr = "select * from {$config->db_prefix}purchases where 1=1"; if (!empty($params['id'])) $sqlstr .= " and id = ".$db->qstr($params['id']); //echo $params['id']; if (!empty($params['productid'])) $sqlstr .= " and productid = ".$db->qstr($params['productid']); if (!empty($params['shopid'])) $sqlstr .= " and shopid = ".$db->qstr($params['shopid']); if (!empty($params['keywords'])) $sqlstr .= " and (productid=". $db->qstr($params['keywords']) ." or product like ". $db->qstr("%".$params['keywords']."%") .")"; if (!empty($params['sdate'])) $sqlstr .= " and thedate>=". strtotime($params['sdate']); if (!empty($params['edate'])) $sqlstr .= " and thedate<=". strtotime($params['edate']); if (!empty($params['cond'])) $sqlstr .= " and ({$params['cond']})"; if (!empty($params['counter'])) $counter = $db->getrow(str_replace("*", "sum(number) number, sum(pricebuy*number) price", $sqlstr)); if (!empty($params['order'])) $sqlstr .= " order by {$params['order']}"; $limit = empty($params['limit'])?9999:$params['limit']; $page = empty($params['page'])?1:$params['page']; $pager = new pager($limit, $page); $smarty->blockvars[$l] = $pager->execute($db, $sqlstr);//将查询到的结果赋值给blockvars数组 // if(!$smarty->blockvars[$l]) return $repeat = false; if(!empty($params['pager'])) $smarty->assign($params['pager'], $pager);//将$pager这一实现赋值给参数pager，在模板上只要调用{pager->method()}，就可以实现操作 } if(list($key, $item) = each($smarty->blockvars[$l])) {//返回数组当前值并将指针向前移动一步 $repeat = true;//如果为false则标签停止循环 if(!empty($counter)) $item["counter"] = $counter; $smarty->assign($params['name'], $item); } else { $repeat = false; $counter = ""; reset($smarty->blockvars[$l]); } if(!is_null($content)) print $content; if(!$repeat) $smarty->blockvars[$l] = array(); } ?>

smarty自定义插件

1 条评论