mysql 函数 --ROUND(X) ROUND(X,D)

• ROUND(X) ROUND(X,D) 

返回参数X, 其值接近于最近似的整数。在有两个参数的情况下，返回 X ，其值保留到小数点后D位，而第D位的保留 方式为四舍五入。若要接保留X值小数点左边的D 位，可将 D 设为负值。 

select jl.id, jl.name, jl.type, jl.latitude, jl.longitude, jl.uni_url, ( 6371 * acos( cos( radians('%s') ) * cos( radians( latitude ) ) * cos( radians( longitude ) - radians('%s') ) + sin( radians('%s') ) * sin( radians( latitude ) ) ) ) AS distance from jd_level jl where jl.latitude != '' and jl.is_hot = 1 and jl.type=5 having distance < '%s' order by distance limit %s

/***********

过滤HTML数据

***********/

function filter_html($string='', $length='', $encoding='GBK') {

    $to_encoding = 'UTF-8';

    $from_encoding = 'GBK';

    if($encoding == 'UTF-8')

        $string = iconv($to_encoding, $from_encoding, $string);

    if(!empty($string)) {

        $string = nl2br(strip_tags($string));

        $string = mb_convert_encoding($string, $to_encoding, $from_encoding);

        $str = mb_convert_encoding("　", $to_encoding, $from_encoding);

        $string = mb_eregi_replace($str, " ", $string);

        $string = mb_convert_encoding($string, $from_encoding, $to_encoding);

        $string = trim($string);

        if(!empty($length) && $length > 0) {

            $string = getSubString($string, $length);

        }

    }

    return $string;

}