Insert to array new key/value php

Question

How

$arr = array ();
while ($obj = mysql_fetch_object($result)) 
       $arr[] = $obj;

// add new key/value in same index
$arr['key'] = 'value';

echo json_encode ($arr);

In this construction not be result like I need

{
    0 =     {
        author = 3;
        id = 3;
        reader = 3;
        review = 4;
    };
    key = "value";
}

I need:

{
    author = 3;
    id = 3;
    reader = 3;
    review = 4;
    key = "value";
}

You can only get the desired output if there is only 1 row.

AbraCadaver
– AbraCadaver

2014-06-26 19:06:36 +00:00
Commented Jun 26, 2014 at 19:06 — AbraCadaver
– AbraCadaver, Commented Jun 26, 2014 at 19:06

Kodlee Yin · Accepted Answer · 2014-06-26 19:06:25Z

1

It looks like your query is only returning 1 row, so you don't need the while loop.

First things first though, please don't use mysql_*. Look into MySQLi or PDO

This is what you want instead:

$db = new mysqli(/* host, user, pass, db */);
$result = $db->query("SELECT * FROM aTable LIMIT 1");

$arr = $result->fetch_assoc();
$arr['key'] = 'value';

Edit: Ima go ahead and force you to use mysqli...

answered Jun 26, 2014 at 19:06

Kodlee Yin

1,0895 silver badges10 bronze badges

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

Comments

raina77ow · Accepted Answer · 2014-06-26 19:06:40Z

1

Move the value-assigning code into the loop, if you need to add some key-value pair to each and every item of the resulting array:

$arr = array ();
while ($obj = mysql_fetch_object($result))
  $obj->key = 'value';
  $arr[] = $obj;
}

answered Jun 26, 2014 at 19:06

raina77ow

107k16 gold badges205 silver badges240 bronze badges

Collectives™ on Stack Overflow

Insert to array new key/value php

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related