PHP format number from CSV file after upload

Question

I just successfully uploaded and read through on a csv file using PHP Codigniter. What I want to do now is to format the numbers for example:

6.06861E+11

to

606861000000

before inserting it to the database. How should I do this in PHP? Thank you.

Do you see that number in excel or where? Your column is set to a bigint as well? 606861000000 will exceed int. — chris85
– chris85, Commented Jul 28, 2015 at 2:16
is the number stored as "6.06861E+11" or just displayed as "6.06861E+11" — user557846
– user557846, Commented Jul 28, 2015 at 2:17
in the csv file the number is already formatted to "6.06861E+11" — Kentot
– Kentot, Commented Jul 28, 2015 at 2:28
How did it get to that format? I'd fix the issue at the point of creation. — chris85
– chris85, Commented Jul 28, 2015 at 2:29

jhegeman2 · Accepted Answer · 2015-07-28 02:24:18Z

1

PHP understands scientific notation, you just need to let it know that you want it formatted as a number. You can accomplish this by subtracting zero from it like so.

<?php
$x = '6.06861E+11';
echo $x - 0;
?>

Displays -> 606861000000

answered Jul 28, 2015 at 2:24

jhegeman2

596 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

jhegeman2 Over a year ago

No Problem. Good luck with your project!

ken lun · Accepted Answer · 2015-07-28 02:23:44Z

0

Use the following function to convert from exponential to the right number format:

     function easy_number_format($number, $dec_point, $thousands_sep)
       {
       $number = rtrim(sprintf('%f', $number), "0");
       if (fmod($nummer, 1) != 0) {                      
       $array_int_dec = explode('.', $number);
       } else { 
       $array_int_dec= array(strlen($nummer), 0);
       }
       (strlen($array_int_dec[1]) < 2) ? ($decimals = 2) : ($decimals =                             strlen($array_int_dec[1]));
      return number_format($number, $decimals, $dec_point,                  $thousands_sep);
        }

answered Jul 28, 2015 at 2:23

ken lun

224 bronze badges

1 Comment

user557846 Over a year ago

credit where credit is due: php.net/manual/en/function.number-format.php#103834

Collectives™ on Stack Overflow

PHP format number from CSV file after upload

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related