accessing JSON database field with xpdo

5 Posts

boludst Reply #1, 13 years, 4 months ago

I have a database field with JSON arrays in it and when I read it only the first value is retrieved.
The map.inc.php section looks like this
'config' =>
array (
'dbtype' => 'text',
'phptype' => 'json',
'null' => false,
'default' => '',
)
and the data stored in this field is a simple JSON array like this:
["value1","value2","value3"]
I access the field this way:
$object->get('config')
and this returns an array with one entry max.

Can anybody help me with this?

This question has been answered by Bruno17. See the first response.

discuss.answer

5,888 Posts

Bruno17 Reply #2, 13 years, 4 months ago

this is working for me.
with

if ($object = $modx->getObject('myGallery',13)){
    $ext = $object->get('extended');
}

print_r($ext);

I get

Array ( [0] => value1 [1] => value2 [2] => value3 )

-------------------------------

you can buy me a beer, if you like MIGX

http://webcmsolutions.de/migx.html

Thanks!

5 Posts

boludst Reply #3, 13 years, 3 months ago

Thanks Bruno17

the $modx->getObject did the trick

Answered accessing JSON database field with xpdo