PHP -- Convert string to bigint

Question

I have the following string which i need to convert to integer or bigint.

$test="99999977706";

I tried:

echo (int)$test;
echo (integer)$test;
echo intval($test);

But they are all returning me 2147483647.

How do i convert the above string to a number or bigint?

Many many thanks for all suggestions.

Does it need to be an int or just a number? Because (platform dependent) casting to (float) may work. — DaveRandom
– DaveRandom, Commented Jan 23, 2012 at 15:27
What do you want to achieve with that number? A usual integer cannot be larger than that value, and BigInt is not built in into PHP — Nico Haase
– Nico Haase, Commented Jan 27, 2021 at 9:00

Treffynnon · Accepted Answer · 2012-01-23 15:35:25Z

2

MySQL isn't going to know the difference. Just feed the string into your query as though it is a number without first type casting it in PHP.

For example:

$SQL = "SELECT * FROM table WHERE id = $test";

answered Jan 23, 2012 at 15:35

Treffynnon

21.6k6 gold badges68 silver badges99 bronze badges

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

3 Comments

Cauliturtle Over a year ago

Hello @Treffynnon, How it I have to pre process the bigint before the SQL. Let's say I have to use select ... where ... in ( some bigint values ) ?

Treffynnon Over a year ago

@Cauliturtle I have no idea what you are asking, but I suggest that you ask your own question on StackOverflow as comments aren't really designed for this kind of discussion.

Nico Haase Over a year ago

Can you share more details about this? There is no connection to MySQL in the question, and whatever you want to do with the given ` $SQL` variable, you should not use it to run a query

Manoj Prajapat · Accepted Answer · 2018-09-01 05:25:11Z

2

working solution :

<?php
   $str = "99999977706";
   $bigInt = gmp_init($str);
   $bigIntVal = gmp_intval($bigInt);
   echo $bigIntVal;
   ?>

It will return : 99999977706

answered Sep 1, 2018 at 5:25

Manoj Prajapat

1,1571 gold badge14 silver badges27 bronze badges

Comments

Avatar · Accepted Answer · 2021-01-27 08:31:37Z

1

You can treat the string as string without converting it.

Just use a regex to leave only numbers:

$test = "99999977706";
$test = preg_replace('/[^0-9]/', '', $test);

answered Jan 27, 2021 at 8:31

Avatar

15.4k12 gold badges139 silver badges219 bronze badges

Comments

Michael Dillon · Accepted Answer · 2012-01-23 15:27:17Z

0

In your snippet $test is already a number, more specifically a float. PHP will convert the contents of $test to the correct type when you use it as a number or a string, because the language is loosely typed.

answered Jan 23, 2012 at 15:27

Michael Dillon

1,0376 silver badges16 bronze badges

2 Comments

Kim Over a year ago

Sorry,i modified it. $test is in fact a string and i need it to be a number for comparison purposes

Michael Dillon Over a year ago

If you cast it to a float you should be good to go. Mysql has no knowledge of php types so you should be fine casting it to a float and then using it accordingly.

Markus Malkusch · Accepted Answer · 2014-03-04 03:35:12Z

0

For arbitrary length integers use GMP.

answered Mar 4, 2014 at 3:35

Markus Malkusch

7,9382 gold badges40 silver badges71 bronze badges

1 Comment

Milan Over a year ago

...probably the best solution but it should be pointed out that the GMP extension has to be installed or your gmp_init, gmp_intval etc. calls will fail!

ShivarajRH · Accepted Answer · 2013-02-07 10:57:14Z

-1

It can help you,

$token=  sprintf("%.0f",$appdata['access_token'] );

you can refer with this link

answered Feb 7, 2013 at 10:57

ShivarajRH

94014 silver badges24 bronze badges

1 Comment

Nico Haase Over a year ago

"Help" to achieve what? sprintf will never return a BigInt, but always a string

Collectives™ on Stack Overflow

PHP -- Convert string to bigint

6 Answers 6

3 Comments

Comments

Comments

2 Comments

1 Comment

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

3 Comments

Comments

Comments

2 Comments

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related