PHP格式化MYSQL返回float类型的方法

PHP 中获取mysql的float字段，echo 输出后，小数部分为包含多个0.文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/24494.html

可使用 floatval($num) 将0舍去。文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/24494.html

如要保留小数位，可使用 number_format($num, 2);文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/24494.html

number_format函数对超过指定位数的值，进行了四舍五入。文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/24494.html

如不想四舍五入，而保留所有小数。可使用如下方法：文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/24494.html

// 如仅想保留两位小数可用 number_format($num, 2);文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/24494.html

echo f('1001.334534', 2) . '<br data-filtered="filtered">'; // 1001.334534文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/24494.html

echo f('-1001.000', 2) . '<br data-filtered="filtered">'; // -1001.00文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/24494.html

echo f('1001.3', 5) . '<br data-filtered="filtered">'; // 1001.30000文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/24494.html

echo f('1001.33') . '<br data-filtered="filtered">'; // 1001.33文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/24494.html

echo f('1001.000') . '<br data-filtered="filtered">'; // 1001文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/24494.html

// 格式化小数，但不四舍五入，如有小数则全保留，无小数则添加0；文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/24494.html

function f($num, $v = 0)文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/24494.html

{文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/24494.html

$num = floatval($num);文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/24494.html

if ($v > 0)文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/24494.html

{文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/24494.html

$num = '' . $num;文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/24494.html

$arr = explode('.', $num);文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/24494.html

if (count($arr) === 1)文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/24494.html

{文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/24494.html

$num .= '.' . str_repeat('0', $v);文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/24494.html

}文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/24494.html

else文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/24494.html

{文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/24494.html

$v -= strlen($arr[1]);文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/24494.html

if ($v > 0)文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/24494.html

//www.phpfensi.com文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/24494.html

$num .= str_repeat('0', $v);文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/24494.html

}文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/24494.html

}文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/24494.html

return $num;文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/24494.html

}文章源自菜鸟学院-https://www.cainiaoxueyuan.com/bc/24494.html