smarty 分列显示:有些可以变得更简单

<?php
/**
*
* @author 风卷残云, <bighuang at 126 dot com>
* @copyright Copyright (c) 闲情网站, 2004-2005
* @since ~
*/
/*+++++++++++++++++++++++++
* Copyright (c) 2004,闲情网站
* All rights reserved
*
* 系统名称:闲情音乐
* 文件名称:diary.php
* 文件标识:见配置管理计划书
* 功        能:
* 摘        要:
*
* 当前版本:1.0
* 作        者:风卷残云
* 作者主页:http://freeday.512j.com
* 作者邮箱:bighuang@126.com
* 作者   QQ:121173553
* 完成日期:2005年4月3日
*
* 取代版本:1.0
* 原  作  者:风卷残云
* 完成日期:2005年4月3日
+++++++++++++++++++++++++*/
include “config/config.php”;
include
“config/dbclass.php”;
include
“include/FreeDayCodeChange.php”;
$my = new mydb();
$my->c_all($db_host,$db_user,$db_psw,$db_table);
//require(“include/sess.php”);

$my = new mydb();
$my->c_all($db_host,$db_user,$db_psw,$db_table);

require(
“include/header.php”);
require(
“config/Smarty_Freeday.php”);

$smarty = new Smarty_Freeday;

$query = “select count(*) from fd_music order by MC_id desc”;
$res =$my->query($query);
$total = $my->fetch_arr($res);
$total = $total[0];


$queryN = “select * from fd_music order by MC_id desc”;
$result =$my->query($queryN);
$i = “0”;
$j = “1”;
$musicArr = array();
if (
$result)
{
    while (
$n = $my->fetch_arr($result))
    {

        
$i ++;
        
$musicItem[$j1][name] = $n[MC_name];
        
$musicItem[$j1][songer] = $n[MC_songer];
        
$musicItem[$j1][url] = $n[MC_url];
        
$j ++;
        

        
        if(
$i==$total && $j%5!=0)
        {
            
$musicArr[] = $musicItem;
        }
            
        if(
$j%5 == 0)
        {
            
$musicArr[] = $musicItem;
            
$musicItem = “”;
            
$j = “1”;
        }
    }
}
else
{
echo
“<tr><td  align=center >连接数据库出错!</td></tr>”;
}


$smarty->assign(‘total’,$total);

$smarty->assign(‘musicArr’,$musicArr);

$my->close();
$smarty->display(‘music.htm’);
require(
“include/footer.php”);
exit();
?>
 
 
music.htm
<table class=“toutm” width=“768”  align=“center”  cellpadding=“0” cellspacing=“0”
  <
tr
    <
td height=“25” class=“tdbc”>总共有歌曲<font color=“#FF0000”><{$total}></font>   
    </td
  </
tr
  <
tr>
    <
td width=“768” class=“line”>
    </td>
  </
tr>

  <
tr>
    <
td>  
      <
table>
        <tr>
          <td>
            <table>
              <{
section name=secF loop=$musicArr}>
              <
tr>
                   <{
section name=secS loop=$musicArr[secF]}> 
                  <
td>
                       <
IMG  src=“images/11.gif” width=12><A title=“” onclick=“window.open(this.href,”,’top=0,left=0,width=550,height=370,scrollbars=yes,resizable=no’);return false;”  href=“http://freeday.512j.com/old/wj/sp.php?path=<{$musicArr[secF][secS].url}>” target=_blank><{$musicArr[secF][secS].name}><{$musicArr[secF][secS].songer}></A>
               
 </td>
                  <{/section}>
               </tr>
               <{/
section}> 
             </
table>
           </td>
         </tr>
       </table
     </
td
   </
tr
   <
tr
      <
td width=“768”  class=“line”></td
    </
tr>
</
table>
 
 
 
 
 
 
更简单的方法:
代码:

<table border=”1″ width=”599″ cellpadding=”0″ cellspacing=”0″ align=”center”>
    <tr>
    <{section name=mydata loop=$news}>
        <td width=”69%” align=”center”>
            <a href=”#?id=<{$news[mydata].news_id}>”><{$news[mydata].news_title}></a>
        </td>
    <{if $smarty.section.mydata.rownum is div by 3}>
    </tr>
    <tr>
    <{/if}>
    <{/section}>
    </tr>
</table>