[[!Rowboat? &table=`modx_formit_forms` &columns=`{"values":""}` &where=`{"form":"Doodle"}` ]]
Array ( [values] => {"name":"Mayer","date1":"0","date2":"1"} [_idx] => 0 [_alt] => 0 [_first] => 1 ) Array ( [values] => {"name":"Oscar","date1":"1","date2":"1"} [_idx] => 1 [_alt] => 1 [_last] => 1 ) Array ( [values] => {"name":"Marc","date1":"1","date2":"1"} [_idx] => 1 [_alt] => 1 [_last] => 1 ) Array ( [values] => {"name":"Carmen","date1":"0","date0":"1"} [_idx] => 1 [_alt] => 1 [_last] => 1 ) Array ( [values] => {"name":"Peter","date1":"1","date2":"0"} [_idx] => 1 [_alt] => 1 [_last] => 1 )
$input = json_decode($input); return $input->{'name'};
{"name":"Mayer","date1":"0","date2":"1"}
This question has been answered by krischel. See the first response.
preg_match_all('/{(.*?)}/', $input, $matches); foreach ($matches[1] as $a ){ $output[] = $output."{".$a."}"; } #echo $output[0]; #$count = count($output); $output = json_decode($output[0]); return $output->{'name'};