PHP integer type getting lost on function call

Question

I have some code that pulls database primary keys and iterates through them by calling a function.

When I get the key from the database and do a is_int($key) it returns true.

I then call a function: thisfunction($key)

In the calling function, I made it so that you could pass in the $key and that function loads the row for that key or you can pass the row as an object. At the beginning of the called function, it checks to see if $key is_int. It is returning false when I am calling it with an integer value.

Rok Kralj · Accepted Answer · 2011-09-05 16:18:47Z

1

Everything you get from database is string.

That means, even if you have database with INTs for columns, you are going to get them like:

id, name, age
array("43", "Rok", "19");

answered Sep 5, 2011 at 16:18

Rok Kralj

49k10 gold badges75 silver badges80 bronze badges

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

3 Comments

Mel Over a year ago

I am working in the Yii framework and assumed that the model would convert the string from the database to integer. I changed the check to an is_numeric() and that stopped the error.

ajreal Over a year ago

+1 if you can proof Everything you get from database is string.

Rok Kralj Over a year ago

@ajreal, that was with mysql&PHP in mind (I can't say that for all the databases), and also apparent that OP is using a database that converts that.

mpratt · Accepted Answer · 2011-09-05 16:25:09Z

0

Since everything you fetch from the database is a type string, you could try using is_numeric() instead of is_int().

answered Sep 5, 2011 at 16:25

mpratt

1,60813 silver badges21 bronze badges

Comments

Dachande663 · Accepted Answer · 2011-09-05 16:24:41Z

0

Perhaps try the ctype_digit() function.

answered Sep 5, 2011 at 16:24

Dachande663

5031 gold badge6 silver badges16 bronze badges

Collectives™ on Stack Overflow

PHP integer type getting lost on function call

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related