php database - is_int returns false always

Question

I have written a simple sql query and is_int() returns alway false. why?

mysql query

$sql = "SELECT id, username FROM users WHERE email = '[email protected]' LIMIT 1"; 
$data = $db->query($sql); 
# output: php array like $data[0]['id'];

php if

if( is_int($data[0]['id'] ){
  print 1;
}else{
  print 0;
}

// edit var_dump print this:

array(2) { ["id"]=> string(1) "1" ["username"]=> string(6) "admin" }

Why is 'id' a string and not a integer?

how we fetch the data from database i mean a single row,a array or an object???? — Saty
– Saty, Commented Apr 25, 2015 at 11:28
I'm pretty sure that everything you get back from a database, are strings, but I cannot find any references. What database API are you using, PDO, mysqli, etc.? By the way, you could use is_numeric instead. — jeroen
– jeroen, Commented Apr 25, 2015 at 11:31

FirePanther · Accepted Answer · 2015-04-25 11:32:58Z

2

How can an "id" be not an integer?

If you want to check the value:

<?php
function is_int_val($val) {
    return $val == (string)((int)$val);
}
echo (is_int_val(33) ? "true" : "false")."\n"; // returns true
echo (is_int_val("33") ? "true" : "false")."\n"; // returns true
echo (is_int_val("33.0") ? "true" : "false")."\n"; // returns true
echo (is_int_val("a33") ? "true" : "false")."\n"; // returns false
echo (is_int_val("33a") ? "true" : "false")."\n"; // returns false

answered Apr 25, 2015 at 11:32

FirePanther

3551 silver badge8 bronze badges

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

Comments

jogesh_pi · Accepted Answer · 2015-04-25 11:33:28Z

0

In case of string value is_int() always return false.

is_int('23') = bool(false)

and according to comments you have ID as string

array(2) { 
    ["id"]=> string(1) "1" 
    ["username"]=> string(6) "admin" 
}

So its always return false

Do it like :

if( is_array($data) && $data[0]['id'] > 0 ) {
    print 1;
} 
else print 0;

answered Apr 25, 2015 at 11:33

jogesh_pi

9,7745 gold badges40 silver badges65 bronze badges

Comments

Community · Accepted Answer · 2023-11-17 19:32:19Z

0

I guess that the type of your variable is string. In your case is a good idea to use is_numeric()

If you expect to have some float values you may use is_float() as well:

if( is_numeric($data[0]['id']) && !is_float($data[0]['id']) ){
  print 1;
}else{
  print 0;
}

edited Nov 17, 2023 at 19:32

CommunityBot

11 silver badge

answered Apr 25, 2015 at 11:31

Samuil Banti

1,8351 gold badge16 silver badges31 bronze badges

1 Comment

FirePanther Over a year ago

Floats are numeric, too

Collectives™ on Stack Overflow

php database - is_int returns false always

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related