php - loop array (columns) and save results on new array
one text
Solution:
You're constructing the strings too early. It's harder to parse and manipulate a string than to manipulate an array. You should first aggregate your data into an intermediate array format. Since the value are stored within a sub-array in the key, you can use array_merge to merge the values:
$valor2s = [];
$valor1historico = [];
foreach($airtable_response['records'] as $key => $record) {
array_merge($valor2s, $record['fields']['VALOR2'][0]);
array_merge($valor1historicos, '"' . $record['fields']['VALOR1HISTORICO'][0] . '"');
}
If I read you correctly, you wants the unique values of VALOR2 and VALOR1HISTORICO. You can use array_unique to clean up the 2 arrays:
$valor2s_unique = array_unique($valor2s);
$valor1historicos_unique = array_unique($valor1historicos);
Then you can join the arrays to a string of comma separated list with implode:
$data = implode(', ', $valor2s_unique);
$labels = implode(', ', $valor1historicos_unique);
Given the data you demonstrated, you should get these variables:
15:10, 13:15
"1", "0"
Source