How to add manual key and value to dynamically created array?

Question

Okay I need to ask

I'm building arrays in this way:

$qe = mysql_query("SELECT * FROM table");
while ($k = mysql_fetch_object($qe)) {
    $array1[] = $k;
}

and I want to add a manual key and value to $array1

I've tried $array1[]['admin']

and $array1['admin'][]

and array_push($array1['admin']=1)

and array_push($array1, 'admin' => 1)

and array_push($array1[], 'admin' => 1)

admin key is always going out of builded array

deceze · Accepted Answer · 2012-02-05 03:45:40Z

2

Just set a key to a value:

$array1['admin'] = 1;

Or:

$array1[] = $k + array('admin' => 1);

edited Feb 5, 2012 at 3:45

answered Feb 5, 2012 at 3:40

deceze♦

525k89 gold badges806 silver badges954 bronze badges

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

4 Comments

Ali Demirci Over a year ago

i tried this too. when i do like this it puts admin key outside of the arrays that builded with mysql before

deceze Over a year ago

Then you want to add the key to the $k arrays, not the $array1. See update.

Ali Demirci Over a year ago

oh god. you got that. i spend almost three hours on this and you did the trick in seconds $array1[] = $k + array('admin' => 1); this gave me errors: Object of class stdClass could not be converted to int and Unsupported operand types but i changed to $array1[] = (array)$k + array('admin' => 1); fixed it. thank you so so so much!

xdazz Over a year ago

@AliDemirci You are casting $k which is a object to array. If you want array, just use mysql_fetch_assoc but not mysql_fetch_object.

xdazz · Accepted Answer · 2012-02-05 03:51:13Z

2

You are using mysql_fetch_object which returns object not array.

So you should do:

$k->admin = 1;
$array1[] = $k;

answered Feb 5, 2012 at 3:51

xdazz

161k38 gold badges255 silver badges278 bronze badges

3 Comments

Ali Demirci Over a year ago

this explains everything. this works too. i marked other answer as accepted just before your answer. but could i ask, which solution is better for performance?

deceze Over a year ago

@Ali Don't worry about performance at this level. It'll make no difference you could detect without obsessive profiling. Rather, use what you think makes more sense. If you want to use objects, use objects. Otherwise, use arrays.

xdazz Over a year ago

@AliDemirci Usually array is fast than object, but not so much, which to use is depending on your needs.

CBusBus · Accepted Answer · 2012-02-05 03:38:57Z

1

You'll need to do the following if you intend on constructing your arrays in this manner.

$qe = mysql_query("SELECT * FROM table");
while ($k = mysql_fetch_object($qe)) {
    $array1[] = Array("admin" => $k);
}

answered Feb 5, 2012 at 3:38

CBusBus

2,3672 gold badges18 silver badges28 bronze badges

4 Comments

Ali Demirci Over a year ago

Sorry I forgot to mention. I also tried $array1[] = array($k, 'admin' => 1); it's not what I want. I want to push admin key into the mysql block

CBusBus Over a year ago

Could you provide an example of the array structure you're expecting?

CBusBus Over a year ago

Also are you possibly looking for mysql_fetch_assoc or mysql_fetch_row in place of mysql_fetch_object?

Ali Demirci Over a year ago

thank you guys deceze's answer is what i've been looking for. i'll up vote for taking your time:)

Collectives™ on Stack Overflow

How to add manual key and value to dynamically created array?

3 Answers 3

4 Comments

3 Comments

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

3 Comments

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related