PHP PDO fetch returns a array?

Question

$GetUid = $dbConnect->prepare("SELECT UID FROM users WHERE username = :username");
$GetUid->execute($RegisterData3);
$UserID = $GetUid->fetch();

why does it return array not a string ?

var_dump('$UserID') says

array
  'UID' => string '45' (length=2)
  0 => string '45' (length=2)

it should be

array
  'UID' => string '45' (length=2)

update* what about the 0 ? where does it came from ? thanks for the replies.

doru · Accepted Answer · 2014-06-04 11:23:44Z

14

You didn't specify a fetch_style parameter. It returns FETCH_BOTH by default, which is an array. Here are the options and how to specify it: http://php.net/manual/en/pdostatement.fetch.php

EDIT: Also, it will always return an array, even if there's only one column, because a row can contain multiple attributes. You can use FETCH_ASSOC and then specify your column name to get the data, or, if you just use fetch() like you did, the array is indexed by both the column name and the 0-indexed column number.

edited Jun 4, 2014 at 11:23

doru

9,1502 gold badges37 silver badges45 bronze badges

answered Jul 16, 2010 at 12:11

rownage

2,4023 gold badges23 silver badges31 bronze badges

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

3 Comments

Adam Ramadhan Over a year ago

what about the 0 thing ? where does it came from. thanks again.

rownage Over a year ago

Try doing your query again, except say SELECT * FROM users instead of SELECT UID FROM users. the result (say if you have two columns in your table) should be something like this: array 'UID' => string '45' (length=2) 0 => string '45' (length=2) OtherData1 => string '12' (length=3) 1 => string '12' (length=3) Where the third and fourth lines are the second column (the names and values are just made up by me) And there wouldn't be a StackOverflow if it weren't for newbie questions ;)

avolquez Over a year ago

Thanks a lot for your answer and thanks too for the link, now I know more options to be applied when necessary

Dennis Haarbrink · Accepted Answer · 2010-07-16 12:10:07Z

2

If you want to get just the column, you need the fetchColumn() method of PDOStatement.

answered Jul 16, 2010 at 12:10

Dennis Haarbrink

3,7401 gold badge30 silver badges54 bronze badges

Comments

F.X · Accepted Answer · 2010-07-16 12:11:59Z

2

The resultset is fetched line by line, even if the line contains a single column

answered Jul 16, 2010 at 12:11

F.X

873 bronze badges

Collectives™ on Stack Overflow

PHP PDO fetch returns a array?

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