add array element to row returned from sql query

Question

I want to add an additional value into an array before passing it to json_encode function, but I can't get the syntax right.

 $result = db_query($query);

  // $row is a database query result resource
  while ($row = db_fetch_object($result)) {

  $stack[]  = $row; 
                // I am trying to 'inject' array element here
  $stack[]['x']  = "test";  
 }

echo json_encode($stack);

Matteo Riva · Accepted Answer · 2010-04-03 00:32:41Z

3

If it's an array you can directly add a value:

$row['x'] = 'test';
$stack[] = $row;

if it's an object you can add another property:

$row->x = 'test';
$stack[] = $row;

if you want to keep the object and the extra value separated:

$data = array($row, 'x' => 'test');
$stack[] = $data;

edited Apr 3, 2010 at 0:32

answered Apr 3, 2010 at 0:11

Matteo Riva

25.1k13 gold badges75 silver badges105 bronze badges

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

2 Comments

bert Over a year ago

that was my first inclination, but it gives "Cannot use object of type stdClass as array in" In mySQL the value returned would be an associative array of strings that corresponds to the fetched row. In Drupal's database abstraction layer, the value returned is a "database query result resource".

bert Over a year ago

bang on now. I'm using second option.

bert · Accepted Answer · 2010-04-03 00:32:35Z

0

but this does work.

$stack[]  = $row;       
$row->x = 'test';

answered Apr 3, 2010 at 0:32

bert

2876 silver badges14 bronze badges

Comments

dscher · Accepted Answer · 2010-04-03 00:39:57Z

0

How about something like:

$row['x'] = 'test';
$stack = $row;

answered Apr 3, 2010 at 0:39

dscher

1,5452 gold badges16 silver badges23 bronze badges

Collectives™ on Stack Overflow

add array element to row returned from sql query

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related