<?php
$json = '[{
"id": 1,
"de": "German text",
"en": "English text",
"name": "question"
},
{
"id": 2,
"de": "German text",
"en": "English text",
"name": "error"
},
{
"id": 3,
"de": "German text",
"en": "English text",
"name": "success"
}]';
$dbTexts = json_decode($json, true);
$texts = array_column($dbTexts, 'de', 'name');
print_r($texts);
preferences:
129.51 ms | 406 KiB | 5 Q