dede 新建页面执行原生sql

php页面

<?php
/**
* 专家团队
*/
require_once(dirname(__FILE__)."/../include/common.inc.php");
//require_once(DEDEINC.'/arc.archives.class.php');
include_once(DEDEINC.'/datalistcp.class.php');

//获取专家团队列表

$dlist = new DataListCP();
$sql = "SELECT * FROM `#@__addonexpert`";
$dsql->Execute('me',$sql);
while($arr = $dsql->GetArray('me'))
{
$spfx[] = $arr;
}

//获取推荐资讯
$sql = "SELECT id,title,flag FROM `#@__archives` WHERE flag LIKE '%c%' ORDER BY id DESC LIMIT 0,10";
$dsql->Execute('mess',$sql);
while($arrs = $dsql->GetArray('mess'))
{
$info[] = $arrs;
}
$dlist->SetTemplate(DEDETEMPLATE.'/plus/zj_list.htm');

$dlist->Display();

 

 

模板中调用

<?php

if(!empty($info)){

foreach($info as $k=>$v){

?>

<li style="width:228px"><img src="../templets/default/images/xxicon.png" class="left"><a style="width:210px;" class="left nowarp"

href="view.php?aid=<?php echo $v['id'];?>"><?php echo $v['title'];?></a>

</li>

<?php

}

}

?>