How to add multiple SQL rows to an PHP array

Question

I have $view_data['auth_info'] which is populated with a query row, that works fine. But i need to add an additional row to this array. How is this possible? All the variables are unique, so theres no change i will have to identical definitions.

I tried following:

$view_data['auth_info'] = $myFirstSQLRow
array_push($view_data['auth_info'],$mySecondSQLRow);

But it failed:

Message: array_push() [function.array-push]: First argument should be an array

But isnt the first var an array or have i misunderstood something?

$view_data['auth_info'] = array($myFirstSQLRow, $mySecondSQLRow)? — gen_Eric
– gen_Eric, Commented Sep 25, 2012 at 19:58
I want to merge the two variables into one spot. If you understand. — JavaCake
– JavaCake, Commented Sep 25, 2012 at 20:00
Very hard to understand what you mean by 'merge'. Can you give an example? — Noam
– Noam, Commented Sep 25, 2012 at 20:03
@Aust, tried to give an example on this merging, which is exactly what i need. — JavaCake
– JavaCake, Commented Sep 25, 2012 at 20:52

Aust · Accepted Answer · 2012-09-25 20:02:45Z

2

You are looking for array_merge. Use it like this:

$view_data['auth_info'] = $myFirstSQLRow;
$view_data['auth_info'] = array_merge($view_data['auth_info'], $mySecondSQLRow);

As it says in the documentation, you may need to type-cast (by putting (array) in front of your variables.)

answered Sep 25, 2012 at 20:02

Aust

11.6k13 gold badges48 silver badges75 bronze badges

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

7 Comments

JavaCake Over a year ago

I tried this, also by typecasting both vars to (array), but when i try to print the variables $view_data['auth_info']->name i get Message: Undefined offset: 1 and Trying to get property of non-object

Aust Over a year ago

@JavaCake - Try this instead: $view_data['auth_info']['name']

JavaCake Over a year ago

Works like a charm. But isnt there a workaround so i still can use the objects rather than typecasting to array?

Aust Over a year ago

@JavaCake - I dunno. Sorry, I've never had to do that. But out of curiosity, why do you need to do that?

JavaCake Over a year ago

Im querying data from two tables and returning them as rows. I wanted to merge the two rows somehow.

|

Collectives™ on Stack Overflow

How to add multiple SQL rows to an PHP array

1 Answer 1

7 Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Related