<?php
include 'ttkc_inc/config.inc.php';

include 'ttkc_inc/page.Class.php';

define('PAGESIZE',30);

$page = intval($_GET['page']);

$keyword = safe_str($_GET['keyword']);

if(!$page)$page = 1;

$sqlwhere = empty($keyword) ? "" : " where title like '%".$keyword."%'";

$url = empty($keyword) ? "music_{page}.html" : "music-{$keyword}_{page}.html";

$sql  = "select id,title,team,pubtime,kbps from `-table-music` " . $sqlwhere;

$num_rows = $mysql -> num_rows($mysql -> query($sql));

$pages = new PageClass($num_rows,PAGESIZE,$page,$url);

$sql .= " order by pubtime desc limit ".$pages -> page_limit.",".$pages -> ttkc_size;

$result = $mysql -> query($sql);

?><!doctype html>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<meta http-equiv="Cache-Control" content="no-transform" /> 
<meta http-equiv="Cache-Control" content="no-siteapp" />
<meta http-equiv="X-UA-Compatible" content="IE=edge,chrome=1">
<title><?=$keyword?>广场舞歌曲下载</title>
<meta name="description" content="<?=$keyword?>广场舞歌曲下载">
<meta name="keywords" content="<?=$keyword?>广场舞歌曲下载" />
<script type="text/javascript" src="js/jquery.min.js"></script>
<link rel="stylesheet" href="images/style.css" />
</head>
	<body>
<?php include 'header.php'; ?>
		
		<div class="content">
			<div class="filters">
				<div class="tools">
					<div class="logo"><a href="http://www.gcwgq.com/">广场舞歌曲免费下载</a></div>
					<div class="searchcontent">
					 <form src="#" onSubmit="return go2search();">
						<input type="text" id="keyword" name="keyword" placeholder="输入要搜索的舞曲 ..." value=""/>
						<input name="submit" id="submit" class="submit" value="搜索一下" type="submit"> 
					</form>
					</div>
					<div class="clearfix"></div>
					
					<div class="result">
						<div class="result-left">
							<div class="tips">为您找到<?=$num_rows?>条关于<h1><?=$keyword?></h1>的广场舞歌曲</div>

							<ul class="list">
<div class="mp3_top">
<span class="mp3_top_num">序号</span>
<span class="mp3_top_title">歌曲名称</span>
<span class="mp3_top_team">所属舞队</span>
<span class="mp3_top_time">日期</span>
<span class="mp3_top_kbps">音质</span>
</div>
<?php
$i = 0;
while($row = $mysql -> fetch_array($result)){
	$i++;
	$pubtime = date('m-d',$row["pubtime"]);
	echo("<li><span class=\"mp3_num\">{$i}.</span><span class=\"mp3_title\"><a href=\"play-{$row["id"]}.html\" target='_blank'>{$row["title"]}</a></span><span class=\"mp3_team\"><a href=\"team-{$row["team"]}.html\"  target='_blank'>{$row["team"]}</a></span><span class=\"mp3_time\">{$pubtime}</span><span class=\"mp3_kbps\">{$row["kbps"]} Kbps</span><span class=\"mp3_size\">{$row["size"]}</span></li>");
}
?>
							</ul>
							<div class="clearfix"></div>
							<div class="resultPage">
<?php echo $pages -> ttkc_write(); ?>
							</div>
							
						</div>	
						<div class="result-right">
							<div class="sharelink">
							<p class="relativetitle"><strong>免费下载广场舞歌曲</strong></p>
							<img src="images/weixin.jpg?t=2023" /><br />
							打开微信扫一扫，免费下载广场舞
							</div>

							<div class="downrelative">
								<p class="relativetitle">热门下载：</p>
								<ul class="morelinkcol1">
<?php
$sql  = "select id,title from `-table-music` order by downtime desc limit 0,20";
$result = $mysql -> query($sql);
while($row1 = $mysql -> fetch_array($result)){
    echo("<li>♫ <a href=\"play-{$row1["id"]}.html\" target='_blank'>{$row1["title"]}</a></li>");
}
?>
								</ul>
							</div>
						</div>	
						<div class="clearfix"></div>
					</div>
				</div>
				
			</div>
		</div>
<?php include 'footer.php'; ?>
	</body>
</html>