/**
*
* @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/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();
?>
*
* @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/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
table class="toutm" width="768" align="center" cellpadding="0" cellspacing="0">
tr>
td height="25" class="tdbc">总共有歌曲font color="#FF0000">$total}>font>首
tr>
td height="25" class="tdbc">总共有歌曲font color="#FF0000">$total}>font>首
td>
tr>
tr>
td width="768" class="line">
tr>
tr>
td width="768" class="line">
td>
tr>
tr>
td>
table>
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=" target=_blank>$musicArr[secF][secS].name}>《$musicArr[secF][secS].songer}>》A>
td>
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=" target=_blank>$musicArr[secF][secS].name}>《$musicArr[secF][secS].songer}>》A>
td>
section}>
tr>
section}>
table>
section}>
table>
td>
tr>
table>
td>
tr>
tr>
td width="768" class="line">td>
tr>
table>
td>
tr>
tr>
td width="768" class="line">td>
tr>
table>
更简单的方法：
