Haal data uit DB en vervorm deze (vDorp)

<?php
//query for funplate results
global $wpdb;
$resultaten = $wpdb->get_results('
SELECT * FROM wp_woocommerce_order_itemmeta
INNER JOIN wp_woocommerce_order_items ON wp_woocommerce_order_itemmeta.order_item_id = wp_woocommerce_order_items.order_item_id
WHERE wp_woocommerce_order_itemmeta.meta_key = "fpd_data"
AND wp_woocommerce_order_items.order_id = '.$order->id.'' , ARRAY_N );
?>

// BEGIN get artikelnummer from image name
$laatste_result = preg_split('/({")/i', $resultaten[0][3]);
$reverse = array_reverse( $laatste_result );
$z = $reverse[3];
$artikelurl = strstr($z, '","parameters"', true);
$artnr = strstr($artikelurl, 'https://www.vandorp.nl/', false);
$artnr1 = substr("$artnr", 53);
$artikelnummervd = substr("$artnr1", 0, 5);
// END

// BEGIN get kleurnummer and convert to name
$kleur_result = preg_split('/(currentColor)/i', $resultaten[0][3]);
$kleurend = end($kleur_result);
$kleurstring = substr("$kleurend", 3);
$kleurcode = substr("$kleurstring", 0, 7);
$kleurcode_oud = array(":{s:11:", "#2e2282", "#000000", "#ffffff", "#f61800", "#ffff00", "#38b04", "#cc9900", "#808080");
$kleurnaam_nieuw = array("Zwart", "Blauw", "Zwart", "Wit", "Rood", "Geel", "Groen", "Goud", "Zilver");
$kleurnaam = str_replace($kleurcode_oud, $kleurnaam_nieuw, $kleurcode);
// END