Hi! Could we please enable some services and cookies to improve your experience and our website?
Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code
CREATE TABLE decimals (
`float` DECIMAL(5,2)
);
INSERT INTO decimals VALUES
(123.45),
(23.45),
(3.45),
(3.4),
(.4);
SELECT * FROM decimals
<?php
foreach ($mysqli->query('SELECT * FROM decimals') as ['float' => $f]) {
echo json_encode(
sscanf('%d%d%d.%d%d', str_pad($f, 6, '0', STR_PAD_LEFT))
) . "\n";
}