PHP formats MYSQL to return float type method, phpmysql returns float_PHP tutorial

PHP formats MYSQL to return float type, phpmysql returns float

This article describes the example of PHP formatting MYSQL to return float type. Share it with everyone for your reference, the details are as follows:

Get the float field of mysql in PHP. After echo output, the decimal part contains multiple 0.

You can use floatval($num) to round off 0.

If you want to retain decimal places, you can use number_format($num, 2);

The number_format function rounds values ​​that exceed the specified number of digits.

If you don’t want to round, keep all decimals. You can use the following methods:

// 如仅想保留两位小数可用 number_format($num, 2);
echo f('1001.334534', 2) . '<br>'; // 1001.334534
echo f('-1001.000', 2) . '<br>'; // -1001.00
echo f('1001.3', 5) . '<br>'; // 1001.30000
echo f('1001.33') . '<br>'; // 1001.33
echo f('1001.000') . '<br>'; // 1001
// 格式化小数，但不四舍五入，如有小数则全保留，无小数则添加0；
function f($num, $v = 0)
{
  $num = floatval($num);
  if ($v > 0)
  {
    $num = '' . $num;
    $arr = explode('.', $num);
    if (count($arr) === 1)
    {
      $num .= '.' . str_repeat('0', $v);
    }
    else
    {
      $v -= strlen($arr[1]);
      if ($v > 0)
        $num .= str_repeat('0', $v);
    }
  }
  return $num;
}

Readers who are interested in more PHP-related content can check out the special topics of this site: "Summary of PHP Network Programming Skills", "Introduction Tutorial on PHP Basic Grammar", "Summary of PHP Office Document Skills (including word, excel, access, ppt)", "php date and time usage summary", "php object-oriented programming introductory tutorial", "php string (string) usage summary", "php mysql database operation introductory tutorial" and "php common database operation skills summary" 》

I hope this article will be helpful to everyone in PHP programming.

Articles you may be interested in:

• How to convert PHP Mysql date and time (UNIX timestamp and formatted date)
• PHP gets the current date and time and formatting method Parameters
• PHP method to format phone number
• php implements formatting multi-line text into Js usable format
• PHP date function date method to format UNIX time
• Sharing of php formatting amount functions
• Summary of commonly used string formatting functions in PHP
• Collection of PHP file size formatting functions
• php formatting date and time Formatting example sharing