function smarty_function_get($params, &$smarty)
{
$sql = $params['sql'];
$var = $params['var'];
$rows = $params['rows'];


if(empty($sql))
$smarty->trigger_error('fckeditor: required parameter "sql" missing');

if(empty($var))
$smarty->trigger_error('fckeditor: required parameter "var" missing');

if(!empty($rows) && !preg_match("~\slimit\s~is",$sql))
$sql .= ' LIMIT '.$rows;

$db = Db::initConnect();
/* if(!empty($params['page'])){

$pagesplit = &loadObj('page');
$pagesplit->init($sql,&$db,'',2,$rows);
$sql = $pagesplit->getPageSql();
$pagelink = $pagesplit->display();
$smarty->assign($params['page'],$pagelink);
}*/

$res = $db->query($sql);
$smarty->assign($var,$res);

unset($res);
}

db.jpg ( 9.03 KB 下载：3 次 )