www.gusucode.com > (自适应手机版)html5响应式影视文化公司源码 传播传媒企业通用类织梦模板(demo223) > (自适应手机版)html5响应式影视文化公司源码 传播传媒企业通用类织梦模板(demo223)/www2/member/search.php
<?php /** * 搜索 * * @version $Id: search.php 1 8:38 2010年7月9日Z tianya $ * @package DedeCMS.Member * @copyright Copyright (c) 2007 - 2010, DesDev, Inc. * @license http://help.dedecms.com/usersguide/license.html * @link http://www.dedecms.com */ require_once(dirname(__FILE__).'/config.php'); CheckRank(0,0); require_once(DEDEINC.'/enums.func.php'); require_once(DEDEINC.'/datalistcp.class.php'); $menutype = 'mydede'; //检查用户是否被禁言 CheckNotAllow(); $addsqls = array(); $province = empty($province) ? 0 : intval($province); $city = empty($city) ? 0 : intval($city); $minage = empty($minage) ? 0 : intval($minage); $maxage = empty($maxage) ? 0 : intval($maxage); if(empty($sex)) $sex = ''; if(empty($keyword)) $keyword = ''; $keyword = FilterSearch(stripslashes($keyword)); $keyword = addslashes(cn_substr($keyword,20)); if(!empty($keyword)) { $addsqls[] = " (mb.userid like '%$keyword%' Or mb.uname like '%$keyword%') "; } if(empty($city)) { $place = $province; } else { $place = $city; } if( $place%500 != 0 ) { $addsqls[] = " mp.place='$place' "; } else { if($place!=0) { $minp = $place - 1; $maxp = $place + 500; $addsqls[] = " mp.place>'$minp' And mp.place<'$maxp' "; } } if($sex!='') $addsqls[] = " mp.sex = '$sex' "; if($minage!=0) $addsqls[] = " YEAR(CURDATE())-YEAR(mp.birthday)>='$minage' "; if($maxage!=0) $addsqls[] = " YEAR(CURDATE())-YEAR(mp.birthday)<='$maxage' "; $addsqls_str = join(' And ',$addsqls); if($addsqls_str!='') { $addsqls_str = ' And '.$addsqls_str; } $addsql = " WHERE mb.spacesta > -1 ".$addsqls_str; $query = "SELECT mb.*,mp.place,YEAR(CURDATE())-YEAR(mp.birthday) AS age,mp.lovemsg,mp.birthday FROM `#@__member` mb LEFT JOIN `#@__member_person` mp ON mp.mid = mb.mid {$addsql} ORDER BY mb.logintime DESC"; $dlist = new DataListCP(); $dlist->pageSize = 8; $dlist->SetParameter('keyword',$keyword); $dlist->SetParameter('province',$province); $dlist->SetParameter('city',$city); $dlist->SetParameter('minage',$minage); $dlist->SetParameter('maxage',$maxage); $dlist->SetParameter('sex',$sex); $dlist->SetTemplate(DEDEMEMBER.'/templets/search.htm'); $dlist->SetSource($query); $dlist->Display();