21,887
社区成员
发帖
与我相关
我的任务
分享
//匹配工作地区
function locoyspider_jobs_district($str=NULL)
{
global $db,$locoyspider;
$sql = "select id,parentid,categoryname from ".table('category_district')." where id=".intval($locoyspider['jobs_district'])." LIMIT 1";
$info=$db->getone($sql);
$default=array("district"=>$info['parentid'],"sdistrict"=>$info['id'],"district_cn"=>$info['categoryname']);
if (empty($str))
{
return $default;
}
else
{
$sql = "select id,parentid,categoryname from ".table('category_district')." ";
$info=$db->getall($sql);
$return=locoyspider_search_str($info,$str,"categoryname");
if ($return)
{
return array("district"=>$return['parentid'],"sdistrict"=>$return['id'],"district_cn"=>$return['categoryname']);
}
else
{
return $default;
}
}
}
$district=locoyspider_jobs_district(trim($_POST['jobs_district']));
$jobssetsqlarr['district']=$district['district'];
$jobssetsqlarr['sdistrict']=$district['sdistrict'];
$jobssetsqlarr['district_cn']=$district['district_cn'];