电影搜索

最新推荐文章于 2019-03-02 19:42:33 发布

Carlos__z

最新推荐文章于 2019-03-02 19:42:33 发布

阅读量2.4k

点赞数

本文链接：https://blog.csdn.net/Carlos__z/article/details/41151181

版权

<?php
//包含common.ini
require_once(dirname(__FILE__)."/../include/common.inc.php");
//************************取出电影子栏目**************************************//
$sql = "select id,typename from dede_arctype where reid=2";
$dsql->Execute(me,$sql);
while($row=$dsql->getArray()){
	//构建这样的一个数组，array(栏目的id=>栏目的名称,11=>爱情,12=>武侠,14=>恐怖)
	$moviechannel[$row['id']]=$row['typename'];
}
/**************************导航栏**************************************/
$sql = "SELECT id,typename,typedir,isdefault,ispart,defaultname,namerule2,moresite,siteurl,sitepath From dede_arctype WHERE reid=0 order by sortrank asc";
$dsql->Execute(me,$sql);
while($row=$dsql->getArray()){
	$row['typelink'] = GetOneTypeUrlA($row);
	$channel[]=$row;
}
/**************************列出搜索条件字段******************************************/
//年代字段
$sql="select niandai from dede_addonmovie group by niandai order by niandai desc";
$dsql->Execute(me,$sql);
while($row=$dsql->getArray()){
	
	$niandai_field[]=$row;
}
//地区字段
$sql="select diqu from dede_addonmovie group by diqu";
$dsql->Execute(me,$sql);
while($row=$dsql->getArray()){
	
	$diqu_field[]=$row;
}
//类型字段
$sql="select id,typename from dede_arctype where reid=2";
$dsql->Execute(me,$sql);
while($row=$dsql->getArray()){
	
	$leixing_field[]=$row;
}
/**************************搜索条件***************************************/
//定义接收搜索条件的变量
$where="";
//保存当前的搜索条件
$search = array();
//年代的条件
if(!empty($_GET['niandai'])){
	$niandai = $_GET['niandai'];
$where .= " and addf.niandai='{$niandai}'";
$search[] = array('niandai',$_GET['niandai']);
}
//地区的条件
if(!empty($_GET['diqu'])){
	$diqu = $_GET['diqu'];
$where .= " and addf.diqu='{$diqu}'";
$search[] = array('diqu',$_GET['diqu']);
}
//类型的条件
if(!empty($_GET['typeid'])){
	$typeid = $_GET['typeid'];
$where .= " and addf.typeid='{$typeid}'";
$search[] = array('typeid',$moviechannel[$_GET['typeid']]);
}




/*************************搜索页完成分页***************************************/
//1得到总记录数
$sql="select count(*) count from dede_archives arc left join dede_addonmovie addf on addf.aid=arc.id where arc.channel=17".$where;
$dsql->Execute(me,$sql);
$count=$dsql->getArray()["count"];




//2确定每页分页数量
$length = 10;
//3求得总页数
$pages = ceil($count/$length);
//4得到当前页数
$page = isset($_GET['page'])?max(1,min($pages,$_GET['page'])):1;
//5构造limit语句
$offset = ($page-1)*$length;
$limit = "limit {$offset},{$length}";
//搜索页需要litpic，yuyan，title,pfz,arcurl的数据


$sql="select arc.*,addf.yuyan,addf.pfz,tp.typedir,tp.typename,tp.corank,tp.isdefault,tp.defaultname,tp.namerule,tp.namerule2,tp.ispart,tp.moresite,tp.siteurl,tp.sitepath from dede_archives arc left join dede_arctype tp on arc.typeid=tp.id left join dede_addonmovie addf on addf.aid = arc.id where arc.channel=17 {$where}{$limit}";
$data = array();//保存获得的数据
$dsql->Execute(me,$sql);
while($row=$dsql->getArray()){
	 $row['arcurl'] = GetFileUrl($row['id'],$row['typeid'],$row['senddate'],$row['title'],$row['ismake'],
                $row['arcrank'],$row['namerule'],$row['typedir'],$row['money'],$row['filename'],$row['moresite'],$row['siteurl'],$row['sitepath']);
	 $data[]=$row;
}


//制作处理uri的函数目的是防止?page=1&niandai=2012&niandai=2013&niandai=2014
//$key 是niandai/diqu/typeid等等
function delURI($key){
	//得到根目录后面的uri：/plus/mysearch.php?page=3&diqu=大陆&niandai=2012
	$query_str =$_SERVER["QUERY_STRING"];
	$patt ="/".$key."=[^&]*&*/";
	$newURI =preg_replace($patt,"",$query_str);
	if(empty($newURI)){
		return "";
	}
	return trim($newURI,"&")."&";
}



include '../templets/a67/search.htm';

下面是模板

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>最新动作片下载_好看的动作片下载_经典动作片下载 - A67手机电影</title>
<meta name="Description" content="A67手机电影提供最新动作片下载、好看的动作片下载、经典动作片下载，地域更是辐射至美国动作片、欧美动作片、香港动作片、内地动作片等。让您在手机上也一样能看高清电影。" /> 
<link href="<?php echo $cfg_templets_skin?>/css/style.css" type="text/css"  rel="stylesheet"/>
<link href="<?php echo $cfg_templets_skin?>/css/list.css" type="text/css"  rel="stylesheet"/>
</head>
<body>
<div id="header">
	<div id="menu"> 
		<div class="top">
			<div class="logn">3GP/MP4手机电影第一门户网！<a href="#" target="_blank">请登录</a><a href="#" target="_blank">注册会员</a></div>
			<div class="txt">
				<ul>
				<li><a href="www.a67.com/view/" target="_blank">提提建议</a></li>
				<li><a href="www.a67.com/maps.html" target="_blank">网站地图</a></li>
				<li><a href="javascript:;"  οnclick="return addFavor('A67手机电影', 'www.a67.com/movie/')">加入收藏</a></li> 
				<li><a href="javascript:;"  οnclick="return setHome(this, 'www.a67.com');">设为首页</a></li>
				</ul>
			</div>
		</div>
	</div>
	<div class="menu">
		<div class="menu_wrap">
			<div class="logo"><a href="www.a67.com/" target="_blank"><img src="<?php echo $cfg_templets_skin?>/images/logo.gif" alt="A67手机电影" border="0" /></a></div>
			<div class="search"> 
				<div class="searcher_wrap"> 
					<div class="searcher_tet"> 
					<form action="so.a67.com/so" method="get" name="q" target="_blank" id="search" > 
					<input type="text" name="q" class="focus" value="" /> 
					<input type="image" name="s" class="searchbutton" id="button" src="<?php echo $cfg_templets_skin?>/images/searcher.jpg" align="absmiddle" /> 
					</form> 
					</div> 
					<div class="hot_search_box"> 
					<div class="hotkeywords">
						一周热搜：
						<a href="so.a67.com/so?q=%E4%B8%80%E8%B5%B7%E5%8F%88%E7%9C%8B%E6%B5%81%E6%98%9F%E9%9B%A8&t=movie" target="_blank">一起又看流星雨</a> 
						<a href="so.a67.com/so?q=%E6%B3%A1%E6%B2%AB%E4%B9%8B%E5%A4%8F&t=movie" target="_blank">泡沫之夏</a> 
						<a href="so.a67.com/so?q=%E6%88%90%E9%BE%99&t=movie" target="_blank">成龙</a> 
						<a href="so.a67.com/so?q=%E6%B5%B7%E6%B4%BE%E7%94%9C%E5%BF%83&t=movie" target="_blank">海派甜心</a> 
						<a href="so.a67.com/so?q=%E5%91%A8%E6%98%9F%E9%A9%B0&t=movie" target="_blank">周星驰</a> 
						<a href="so.a67.com/so?q=%E5%98%BB%E6%B8%B8%E8%AE%B0&t=movie" target="_blank">嘻游记</a> 
						<a href="so.a67.com/so?q=%E5%94%90%E5%B1%B1%E5%A4%A7%E5%9C%B0%E9%9C%87&t=movie" target="_blank">唐山大地震</a> 
						<a href="so.a67.com/so?q=%E6%95%A2%E6%AD%BB%E9%98%9F&t=movie" target="_blank">敢死队</a> 
					</div> 
				</div> 
			</div> 
			</div>
		</div>
		<div class="banner"><img src="<?php echo $cfg_templets_skin?>/images/banner.gif" alt="新红楼梦" border="0" /></div>
		<div class="nav"> 
			<ul>
				<li><a href="http://www.dede.com" >首页</a></li> 
				<?php foreach($channel as $k=>$v):?>
				<li><a href="<?php echo $v['typelink'];?>" ><?php echo $v['typename'];?></a></li> 
				<?php endforeach;?>
			</ul>
			<div class="ico_new"></div>
	  </div>
	</div>
</div>
<div id="main">
	<div class="banner980"><img src="<?php echo $cfg_templets_skin?>/images/banner980.jpg" width="980" height="60" /></div>
	<div class="left">
		<div class="crtegories_top"></div>
		<div class="paihang">
			<div class="paihang_top">手机电影下载排行</div>
			<div class="paihang_u">
				<ul>
					<li class="hover"><span>1</span><a href="/movie/7036" title="金瓶双艳3GP MP4下载" target="_blank">金瓶双艳</a></li> 
					<li class="hover"><span>2</span><a href="/movie/7238" title="生化危机4：来生3GP MP4下载" target="_blank">生化危机4：来生</a></li> 
					<li class="hover"><span>3</span><a href="/movie/7623" title="钻石狗3GP MP4下载" target="_blank">钻石狗</a></li> 
					<li><span>4</span><a href="/movie/7634" title="世界大战3GP MP4下载" target="_blank">世界大战</a></li> 
					<li><span>5</span><a href="/movie/7583" title="女教师日记3GP MP4下载" target="_blank">女教师日记</a></li> 
					<li><span>6</span><a href="/movie/7676" title="子曰：食色性也3GP MP4下载" target="_blank">子曰：食色性也</a></li> 
					<li><span>7</span><a href="/movie/7566" title="在床上3GP MP4下载" target="_blank">在床上</a></li> 
					<li><span>8</span><a href="/movie/5727" title="2012末日预言3GP MP4下载" target="_blank">2012末日预言</a></li> 
					<li><span>9</span><a href="/movie/7602" title="顶层公寓3GP MP4下载" target="_blank">顶层公寓</a></li> 
					<li><span>10</span><a href="/movie/5335" title="海云台3GP MP4下载" target="_blank">海云台</a></li> 
					<li class="none"><a href="#" target="_blank">Top50>></a></li>
				</ul>
				
			</div>
		</div>
		<div class="paihang">
			<div class="paihang_top">手机电影评分最高</div>
			<div class="paihang_u">
				<ul>
					<li class="hover"><span>1</span><a href="/movie/7036" title="金瓶双艳3GP MP4下载" target="_blank">金瓶双艳</a></li> 
					<li class="hover"><span>2</span><a href="/movie/7238" title="生化危机4：来生3GP MP4下载" target="_blank">生化危机4：来生</a></li> 
					<li class="hover"><span>3</span><a href="/movie/7623" title="钻石狗3GP MP4下载" target="_blank">钻石狗</a></li> 
					<li><span>4</span><a href="/movie/7634" title="世界大战3GP MP4下载" target="_blank">世界大战</a></li> 
					<li><span>5</span><a href="/movie/7583" title="女教师日记3GP MP4下载" target="_blank">女教师日记</a></li> 
					<li><span>6</span><a href="/movie/7676" title="子曰：食色性也3GP MP4下载" target="_blank">子曰：食色性也</a></li> 
					<li><span>7</span><a href="/movie/7566" title="在床上3GP MP4下载" target="_blank">在床上</a></li> 
					<li><span>8</span><a href="/movie/5727" title="2012末日预言3GP MP4下载" target="_blank">2012末日预言</a></li> 
					<li><span>9</span><a href="/movie/7602" title="顶层公寓3GP MP4下载" target="_blank">顶层公寓</a></li> 
					<li><span>10</span><a href="/movie/5335" title="海云台3GP MP4下载" target="_blank">海云台</a></li> 
					<li class="none"><a href="#" target="_blank">Top50>></a></li>
				</ul>
			</div>
		</div>
	</div>

	<div class="c_con">
		<div class="bord"><a name="tag"></a>
			<div class="r_lis"><span>手机电影</span>  <i>|</i>  <b>检索条件：
			<?php foreach($search as $k=>$v):?>
			<?php echo $v[1];?><a href='<?php echo "?".trim(delURI($v[0]),"&");?>' target="_blank"><img src="<?php echo $cfg_templets_skin?>/images/c_close.jpg" /></a>
			<?php endforeach;?>
			</b></div>
			<ul class="r_lis_con">
				<!-- 按类型搜索-->
				<li class="masted"><b>按类型</b>  <a href="?<?php echo trim(delURI('typeid'),'&').'#tag';?>"
				<?php
					if(empty($_GET['typeid'])){
						echo 'class="all"';
					}
				
				?>
				>全部</a>
				<?php foreach($leixing_field as  $k=>$v):?>
				| <a href="?<?php echo delURI('typeid').'typeid='.$v['id'].'#tag';?>" 
				<?php
					if(!empty($_GET['typeid'])&&$_GET['typeid']==$v['id']){
						echo 'class="all"';
					}
				?>
				><?php echo $v['typename'];?></a> 
				<?php endforeach;?>
				</li>
				<!-- 按地区搜索-->
				<li class="masted"><b>按地区</b>  <a href="?<?php echo trim(delURI('diqu'),'&').'#tag';?>"
				<?php
					if(empty($_GET['diqu'])){
						echo 'class="all"';
					}
				
				?>
				>全部</a>
				<?php foreach($diqu_field as  $k=>$v):?>
				| <a href="?<?php echo delURI('diqu').'diqu='.$v['diqu'].'#tag';?>" 
				<?php
					if(!empty($_GET['diqu'])&&$_GET['diqu']==$v['diqu']){
						echo 'class="all"';
					}
				?>
				><?php echo $v['diqu'];?></a> 
				<?php endforeach;?>
				</li>
				<!-- 按时间搜索 -->
				<li class="masted"><b>按时间</b>  <a href="?<?php echo trim(delURI('niandai'),'&').'#tag';?>"
				<?php
					if(empty($_GET['niandai'])){
						echo 'class="all"';
					}
				
				?>
				>全部</a>
				<?php foreach($niandai_field as  $k=>$v):?>
				| <a href="?<?php echo delURI('niandai').'niandai='.$v['niandai'].'#tag';?>" 
				<?php
					if(!empty($_GET['niandai'])&&$_GET['niandai']==$v['niandai']){
						echo 'class="all"';
					}
				?>
				><?php echo $v['niandai'];?></a> 
				<?php endforeach;?>
				</li>
			</ul>		
		</div>
		<ul class="c_con_list">
		<?php foreach($data as $k=>$v):?>
			<li class="x<?php echo $k+1?>">
				<a href="<?php echo $v['arcurl'];?>" ><img src="<?php echo $v['litpic'];?>" /></a>
				<p><?php echo $v['yuyan'];?></p>
				<div><a href="<?php echo $v['arcurl'];?>" ><?php echo $v['title'];?></a> <img src="<?php echo $cfg_templets_skin?>/images/1.jpg" /> <em><?php echo $v['pfz'];?></em></div>
			</li>
			
			<?php endforeach;?>
		</ul>
		<!--page-->
		<div class="pages">
			<p>共 <?php echo $count;?> 部手机电影，共 <?php echo $pages;?> 页，当前页为第 <?php echo $page;?> 页</p>
			<div><span><a href="?<?php echo delURI('page').'page='.max(1,$page-1);?>">上一页</a></span>
			<span><a href="?<?php echo delURI('page').'page='.min($pages,$page+1);?>">下一页</a></span></div>   
		</div>
	</div>
</div>
<div id="bottom">
	<div class="bottom_so">
		<div class="bottom_so_wrap">
			<div class="bottom_searcher_tet"> 
			<form action="so.a67.com/so" method="get" name="q" target="_blank" id="search" > 
			<input type="text" name="q" class="bottom_focus" value="" /> 
			<input type="image" name="s" class="bottom_searchbutton" id="button" src="<?php echo $cfg_templets_skin?>/images/botto_searcher.gif" align="absmiddle" /> 
			</form> 
			</div>
			<div class="bottom_keywords">
			<a href="so.a67.com/so?q=%E5%91%A8%E6%98%9F%E9%A9%B0&t=movie" target="_blank">周星驰</a>
			<a href="so.a67.com/so?q=%E5%98%BB%E6%B8%B8%E8%AE%B0&t=movie" target="_blank">嘻游记</a>
			<a href="so.a67.com/so?q=%E5%94%90%E5%B1%B1%E5%A4%A7%E5%9C%B0%E9%9C%87&t=movie" target="_blank">唐山大地震</a>
			<a href="so.a67.com/so?q=%E6%95%A2%E6%AD%BB%E9%98%9F&t=movie" target="_blank">敢死队</a> | 
			<a href="www.a67.com/zuixin/" target="_blank">最新电影</a>
			<a href="www.a67.com/paihang/" target="_blank">电影排行榜</a>
			</div>
		</div>
	</div>
	<div class="copyright"> 
		<p>Copyright © 2010 <a href="www.a67.com/">A67.COM</a> <a href="www.a67.com/">遛机网</a> All Rights Reserved  鲁ICP备05010054号</p> 
		<p>本站所有手机资源均为会员制作上传，本站仅提供存储空间，如侵犯到您的权益，请及时联系本站删除，本站不负任何法律责任！</p> 
</div>
</div>
</body>
</html>

Carlos__z

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
电影搜索

//包含common.inirequire_once(dirname(__FILE__)."/../include/common.inc.php");//************************取出电影子栏目**************************************//$sql = "select id,typename from dede_arctype w
复制链接

扫一扫