search.php

这是matlab的一个小程序

<?php
require_once(dirname(__FILE__)."/config.php");
CheckRank(0,0);
require_once(DEDEINC."/enums.func.php");
require_once(DEDEINC."/datalistcp.class.php");

if( !file_exists(DEDEDATA.'/enums/area.php') )
{
	WriteAreaCache();
}
require_once(DEDEDATA.'/enums/area.php');

$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>99)
{
	$addsqls[] = " mp.place='$place' ";
}
else
{
	if($place!=0)
	{
		$minp = intval($place.'00') - 1;
		$maxp = intval(($place+1).'00');
		$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 And mb.mtype = '涓