在DEDE上做一些修改,需要加几个表,现在是加了表之后想调这个表的信息. 用DEDE 标签源码 死活调不出数据来.这个问题几天都没搞出来. 兄弟姐妹们帮帮看看咋回事呢. 多加点分
新建标签源码
<?php
if(!defined('DEDEINC'))
{
exit("Request Error!");
}
require_once(DEDEINC.'/dedevote.class.php');
function lib_index_et(&$ctag,&$refObj)
{
global $dsql;
$attlist="etid|,row|4";
FillAttsDefault($ctag->CAttribute->Items,$attlist);
extract($ctag->CAttribute->Items, EXTR_SKIP); $innertext = trim($ctag->GetInnertext());
$revalue = '';
if(empty($etid)) $etid = 0;
$dsql->SetQuery('Select MarketId,Username,MarketClass,Infovalid,measure,Structure,category,Quote,
Storey,Floor,Address,AreaDescription,Cname,AddTime,IsOver,Rent,Price,AreaC,
Residential,Availability,SmallImg From dede_Fw_Market where MarketClass = '.$etid.' and (' . time() . '-AddTime) < Infovalid and IsOver = 0 order by AddTime desc limit 0,' . $row);
$dsql->Execute();
echo 'Select MarketId,Username,MarketClass,Infovalid,measure,Structure,category,Quote,
Storey,Floor,Address,AreaDescription,Cname,AddTime,IsOver,Rent,Price,AreaC,
Residential,Availability,SmallImg From dede_Fw_Market where MarketClass = '.$etid.' and (' . time() . '-AddTime) < Infovalid and IsOver = 0 order by AddTime desc limit 0,' . $row;
$ctp = new DedeTagParse();
$ctp->SetNameSpace("et","[","]");
$ctp->LoadSource($innertext);
while($row = $dsql->GetArray())
{
foreach($ctp->CTags as $tagid=>$ctag){
if(!empty($row[$ctag->GetName()])){ $ctp->Assign($tagid,$row[$ctag->GetName()]); }
}
$revalue .= $ctp->GetResult();
}
return $revalue;
}
?>模版内
{dede:index_et etid=0 row=4}
<tr>
<td><a href="/house/fw_Build/fw_et_show.php?MarketId=[et:MarketId/]" target="_blank">[et:Address function='cn_substr(@me,50)'/]</a></td>
<td width="60" align="center">[et:Structure/]</td>
<td width="60" align="center">[et:Quote/]万元</td>
</tr>
{/dede:index_et}
新建标签源码
<?php
if(!defined('DEDEINC'))
{
exit("Request Error!");
}
require_once(DEDEINC.'/dedevote.class.php');
function lib_index_et(&$ctag,&$refObj)
{
global $dsql;
$attlist="etid|,row|4";
FillAttsDefault($ctag->CAttribute->Items,$attlist);
extract($ctag->CAttribute->Items, EXTR_SKIP); $innertext = trim($ctag->GetInnertext());
$revalue = '';
if(empty($etid)) $etid = 0;
$dsql->SetQuery('Select MarketId,Username,MarketClass,Infovalid,measure,Structure,category,Quote,
Storey,Floor,Address,AreaDescription,Cname,AddTime,IsOver,Rent,Price,AreaC,
Residential,Availability,SmallImg From dede_Fw_Market where MarketClass = '.$etid.' and (' . time() . '-AddTime) < Infovalid and IsOver = 0 order by AddTime desc limit 0,' . $row);
$dsql->Execute();
echo 'Select MarketId,Username,MarketClass,Infovalid,measure,Structure,category,Quote,
Storey,Floor,Address,AreaDescription,Cname,AddTime,IsOver,Rent,Price,AreaC,
Residential,Availability,SmallImg From dede_Fw_Market where MarketClass = '.$etid.' and (' . time() . '-AddTime) < Infovalid and IsOver = 0 order by AddTime desc limit 0,' . $row;
$ctp = new DedeTagParse();
$ctp->SetNameSpace("et","[","]");
$ctp->LoadSource($innertext);
while($row = $dsql->GetArray())
{
foreach($ctp->CTags as $tagid=>$ctag){
if(!empty($row[$ctag->GetName()])){ $ctp->Assign($tagid,$row[$ctag->GetName()]); }
}
$revalue .= $ctp->GetResult();
}
return $revalue;
}
?>模版内
{dede:index_et etid=0 row=4}
<tr>
<td><a href="/house/fw_Build/fw_et_show.php?MarketId=[et:MarketId/]" target="_blank">[et:Address function='cn_substr(@me,50)'/]</a></td>
<td width="60" align="center">[et:Structure/]</td>
<td width="60" align="center">[et:Quote/]万元</td>
</tr>
{/dede:index_et}
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货