[RESOLVED] adding decimal to 8 digit number

boujii

What I have here is a mysql table containing a varchar text number of 6 digits. This number is actually a price but contains no decimal. Example of one is "005430". I need to convert this to a decimal of "0054.30" or add the decimal to the right 2 spaces to show "0054.30". The basic variable I will be using is $lastprice. I have tried many forms of number_format but end up with stuff like 2840 instead. Any help with this is greatly appreciated.

laserlight

Divide the number by 100, then use [man]sprintf/man or [man]str_pad/man to format.

boujii

OK now my problem seems to be the dividing. I am still ending up with that 28.4 rather then 54.30.

<?php
$price=005430;
$division = $price / 100;
$newprice = $division;
echo $newprice;
?>

Am i doing something wrong with this division?

EDIT: found that if $price=5430 the divide works. But these are all 6 digits and not all start with "00". Some price may be "054872" which would be "0548.72". If I was able to strip whatever 0's to the left then this could work. For instance,

<?php
$price=005430;
$strip = code to strip the 00 from $price
$division = $strip / 100;
$newprice = $division;
echo $newprice;
?>

EDIT: rather then trying to code a strip for this I changed my mysql table from varchar to numeric(6,0) and it seem to do the job as far as showing 5430.

I will follow up in a few once I get tables in sync again with PHP.

laserlight

I am still ending up with that 28.4 rather then 54.30.

That's because 05430 (octal) is 2840 (decimal).
Try:

<?php
$price = 5430;
$division = $price / 100;
$newprice = $division;
echo $newprice;
?>

or:

<?php
$price = '005430';
$division = $price / 100;
$newprice = $division;
echo $newprice;
?>

boujii

Thank you so much laserlight. I managed to work with the table format a bit which made it so i did not have to strip the 00 from 005430. That divide by 100 you stated worked like a charm 🙂

                                  Thanks,
                                  Jeff

bradgrafelman

Don't forget to mark this thread resolved.