Wierd php array? after db query [duplicate]

Question

Possible Duplicate:
Output (echo/print) everything from a PHP Array

I have done a query from a database and the result is stored in a variable which is believe is an array. The output is only one row and column so i use:

echo result[0];

to output the result. However i get an error saying:

Notice: Array to string conversion in "C:/apache/htdocs...." array

I tried to dump the variable using

var_dump result[0];

I then get this

array(1) { [0]=> array(1) { ["var_datain"]=> string(4) "hai!" } }

So.... how do i get it to echo out the value hai! from that array?

In case it matters, here is my query

 $db = new PDO(DSN, DBUSER, DBPASS); $stmt = $db->prepare("CALL test(?)"); $parameter = 'hai!'; $stmt->bindValue(1, $parameter, PDO::PARAM_STR); $rs = $stmt->execute(); $result = $stmt->fetchAll(PDO::FETCH_ASSOC); var_dump($result);

Phius · Accepted Answer · 2012-08-07 01:33:18Z

2

It's a multidimensional array.

echo $result[0]['var_datain'];

It depends of the way you did your query (show us more code to explain you better) but it looks that in your case each line returned by your query is another array containing the columns that you selected. Even if you select only one col and only one row, it's still returned as a multidimensional array.

Got it?

edited Aug 7, 2012 at 1:33

answered Aug 7, 2012 at 1:24

Phius

7241 gold badge8 silver badges15 bronze badges

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

4 Comments

Krimson Over a year ago

awesome! but i should be also able to do $result[0][0] right? coz im refering to its indexes but i get an error: Notice: Undefined offset: 0

Michael Berkowski Over a year ago

@VidhuShresthBhatnagar You are doing an associative fetch via PDO::FETCH_ASSOC, so you will not receive numeric keys back, only the associative keys from column names. You must therefore use $result[0]['var_datain'].

Phius Over a year ago

Edit: If you want to use $result[0][0] put PDO::FETCH_NUM instead of PDO::FETCH_ASSOC. You can also use PDO::FETCH_BOTH that will return both $result[0][0] and $result[0]['var_datain']

Krimson Over a year ago

hi, i just did array_values($result), i could then do $result[0][0] but ill change over to using PDO::FETCH_NUM. Thanks Phius

Collectives™ on Stack Overflow

Wierd php array? after db query [duplicate]

1 Answer 1

4 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Linked

Related