Datatype integer?

Question

This is driving me crazy. For some weird reason, pdo's fetch style parameter's datatype is integer? It can't be integer, its more like a string without quotes around it.. Plus there is no numbers in it. I found it, when i was trying to make pdo function library, but it's not so important to this. Check this out:

echo gettype(PDO::FETCH_ASSOC); // returns 'integer'

What is this all about??

I think you have an error in your query and you get false or 0. Can you show us your query before? — René Höhle
– René Höhle, Commented Dec 30, 2013 at 14:02
No, the question is not about queries, its about fetch styles datatype. — aksu
– aksu, Commented Dec 30, 2013 at 14:03
The documentation states it's an integer (php.net/manual/en/pdo.constants.php), PDO::FETCH_ASSOC is a flag. See 3v4l.org/i6SFv for PDO constants and their values. — Anthony Sterling
– Anthony Sterling, Commented Dec 30, 2013 at 14:10

Nouphal.M · Accepted Answer · 2013-12-30 14:14:07Z

2

As per the PHP docs the fetch_style parameter is of type int, As per PHP docs

  fetch_style Controls how the next row will be returned to the caller. This value must be
 one of the PDO::FETCH_* constants, defaulting to value of PDO::ATTR_DEFAULT_FETCH_MODE 
(which defaults to PDO::FETCH_BOTH)

where PDO::FETCH_ASSOC is a constant whose value is 2. And the gettype function returns the type of variable.

answered Dec 30, 2013 at 14:14

Nouphal.M

6,3281 gold badge20 silver badges28 bronze badges

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

Comments

René Höhle · Accepted Answer · 2013-12-30 14:11:47Z

1

So you have edit your Question this is not a problem. PDO::FETCH_ASSOC is a constant in the PDO Class.

http://www.php.net/manual/en/pdo.constants.php

Here you can see all constants and you can see that the PDO:FETCH_ASSOC is an integer. This is only that you can use a defined value.

answered Dec 30, 2013 at 14:11

René Höhle

27.4k22 gold badges78 silver badges91 bronze badges

4 Comments

aksu Over a year ago

Yes but how this can be integer? Should it be something like flag or function parameter by its datatype?

deceze Over a year ago

@aksu Do you know what constants are? What's wrong with it being an integer?

René Höhle Over a year ago

@asku i don't see the problem look into the PDO Class there you can see all the constants that are defined in the class on top. You could write the integer value in the function but in most cases you don't know that 2 is for fetch assoc for example

aksu Over a year ago

Okayy!! So the pdo converts it to integer to match fetch style! clever!

Collectives™ on Stack Overflow

Datatype integer?

2 Answers 2

Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related