金瓶双艳下载:电影搜索

<?php//包含common.inirequire_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';?>"<?phpif(empty($_GET['typeid'])){echo 'class="all"';}?>>全部</a><?php foreach($leixing_field as $k=>$v):?>| <a href="?<?php echo delURI('typeid').'typeid='.$v['id'].'#tag';?>" <?phpif(!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';?>"<?phpif(empty($_GET['diqu'])){echo 'class="all"';}?>>全部</a><?php foreach($diqu_field as $k=>$v):?>| <a href="?<?php echo delURI('diqu').'diqu='.$v['diqu'].'#tag';?>" <?phpif(!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';?>"<?phpif(empty($_GET['niandai'])){echo 'class="all"';}?>>全部</a><?php foreach($niandai_field as $k=>$v):?>| <a href="?<?php echo delURI('niandai').'niandai='.$v['niandai'].'#tag';?>" <?phpif(!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>

相关推荐

相关文章