/**

*

* @author 风卷残云,

* @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[$j-1][name] = $n[MC_name];

$musicItem[$j-1][songer] = $n[MC_songer];

$musicItem[$j-1][url] = $n[MC_url];

$j ++;

if($i==$total && $j%5!=0)

{

$musicArr[] = $musicItem;

}

if($j%5 == 0)

{

$musicArr[] = $musicItem;

$musicItem = "";

$j = "1";

}

}

}

else

{

echo "连接数据库出错！";

}

$smarty->assign('total',$total);

$smarty->assign('musicArr',$musicArr);

$my->close();

$smarty->display('music.htm');

require("include/footer.php");

exit();

?>

music.htm

总共有歌曲<{$total}>首

<{section name=secF loop=$musicArr}> <{section name=secS loop=$musicArr[secF]}> <{/section}> <{/section}> <{$musicArr[secF][secS].name}>《<{$musicArr[secF][secS].songer}>》

更简单的方法：

代码: