[原创]php 程序实现一个一维数组及在smarty中的应用[2007-10-12]
程序代码如下[code]
function spriceslist()
{
global $tpl,$db;
$sql = "SELECT * FROM info_shuiia_data WHERE sstate = '1' ORDER BY suptime DESC ";
$query = $db -> query($sql);
while ($row = $db->fields($query))
{
//$sop[]= $row;
$sql1 = "SELECT slei FROM info_shuiia_lei WHERE id = '$row[stype]'";
$query1=$db -> query($sql1);
$row1 = $db->fields($query1);
//$rownew1 = array("test1")
$rowtmp1 = array_merge($row,$row1);
$sql2 = "SELECT area FROM area WHERE id = '$row[did]'";
$query2=$db -> query($sql2);
$row2 = $db->fields($query2);
$rowtmp2 = array_merge($rowtmp1,$row2);
$sop[] = $rowtmp2;
}
//dbg($sop);
//exit;
$tpl->assign("sop", $sop);
$tpl->assign("lei", $lei);
$tpl->assign("di", $di);
$tpl->display("spriceslist.html");
}
[/code]
模版代码如下
[code]
{include file = 'header.html' }
<div style="width:100%;">
<table style="font-size:12px;" width="100%" border="0" cellpadding="3" cellspacing="1" bgcolor="#98caef">
<tr bgcolor="#dceaf6" height="26" >
<td width="21%" align="center" background="img/titlebg.gif" >水价时间</td>
<td width="10%" align="center" background="img/titlebg.gif" >水价地点</td>
<td width="11%" align="center" background="img/titlebg.gif" >水价类型</td>
<td width="12%" align="center" background="img/titlebg.gif" >水价状态</td>
<td width="11%" align="center" background="img/titlebg.gif" >水价提交人</td>
<td width="22%" align="center" background="img/titlebg.gif" >水价提交时间</td>
<td width="13%" align="center" background="img/titlebg.gif" >管理</td>
</tr>
{section name=sec loop=$sop}
<tr bgcolor="#ffffff" class=row onmouseover="this.className='row1'" onmouseout="this.className='row'" >
<td>
{$sop[sec].stime|date_format:"%Y-%m"}</td>
<td>
{$sop[sec].area}
</td>
<td align="center" >
{$sop[sec].slei}
</td>
<td align="center" >
{if $sop[sec].sstate==1}
<font color="#00FF00">已经审核</font>
{else}
<font color="#FF0000">未经审核</font>
{/if}
</td>
<td align="center" >{$sop[sec].suer}</td>
<td align="center" >{$sop[sec].suptime|date_format:"%Y-%m-%d %T"}</td>
<td align="center" ><a href="?act=edit&id={$sop[sec].id}" ><img src="img/edit.gif" border="0" alt="编辑" ></a>
<a href="?act=deltitle&id={$sop[sec].id}" onClick="return confirm('确定要删除 {$sop[sec].title} ?');" ><img src="img/del.gif" border="0" alt="删除" ></a></td>
</tr>
{/section}
</table>
</div>
</body>
</html>
[/code] 在看完这帖子以后，我没有立即回复，因为我生怕我庸俗不堪的回复会玷污了这网上少有的帖子 平淡中显示出不凡的文学功底，可谓是字字珠玑，句句经典 广告一下：专业网站建设、网站美工、falsh制作，QQ：875994
页:
[1]