Unable to get fieldparams as array or object Topic is solved

[chattago2002]

Hi everybody.

I would get Joomla custom fields values from a PHP script. I include all necessary files and I can read checkbox values from "fields" table, the "fieldparams" column.
If I execute this code

Code: Select all

$query = "select #__fields.fieldparams from   #__fields where  #__fields.id = 19";
$db->setQuery($query);
$result = $db->loadRowList();
foreach ($result as $value) {
	echo gettype($value); // 01
	echo $value[0]; // 02
	$var = json_encode($value[0]);
	echo gettype($var); // 03
}

the type of $value is "Array" (step 01), so if I access to $value[0] the result (step 02) is the global list (so I suppose this is an Array with 1 element)

Code: Select all

{
"options":{
        "options0":{"name":"type1","value":"1"},
        "options1":{"name":"type2","value":"2"},
        "options2":{"name":"type3","value":"3"},
        "options3":{"name":"type4","value":"4"},
        "options4":{"name":"type5","value":"5"}
    }
}

but when I try to use json_encode the result (step 03) is a string.
In this way I can't access to keys and relative values.

What's wrong?

[SharkyKZ]

Run json_decode(), not json_encode().

[chattago2002]

Thank you very much @SharkyKZ