"Schnellwechsler", 3 => "Baggerlöffel", 4 => "Radladerschaufel", 5 => "Tieflöffel", 6 => "Grabenräumlöffel", 7 => "Drehmotor", 8 => "Sonderanbaugerät Bagger", 9 => "Sonderanbaugerät Radlader", 10 => "Greiferadapter", 11 => "Baggerspaten", 12 => "Palettengabel", 13 => "Roderechen", 14 => "Reißzahn", 15 => "Reißlöffel", 16 => "Gitterlöffel", 17 => "Collecting Unit", 18 => "Steinverlegelöffel", 19 => "Grabentrapezlöffel", 20 => "Hammerplatte/Umbauplatte/Löffeldach", 21 => "Sensor Control", ]; $sql = "SELECT uid, pi_flexform FROM tx_products_domain_model_product WHERE deleted = 0"; $products = mysqli_query($sqlLink, $sql); $products = mysqli_fetch_all($products, MYSQLI_ASSOC); foreach ($products as $product) { $newFlexform = $product["pi_flexform"]; foreach ($propertyGroupIndex as $propertyId => $propertyName) { $oldSheet = ''; if (strpos($product["pi_flexform"], $oldSheet) !== false) { $newSheet = ''; $newFlexform = str_replace($oldSheet, $newSheet, $newFlexform); } } if ($newFlexform !== $product["pi_flexform"]) { $sqlUpdate = "UPDATE tx_products_domain_model_product SET pi_flexform = '" . $newFlexform . "' WHERE uid = '" . $product["uid"] ."'"; var_dump(mysqli_query($sqlLink, $sqlUpdate)); } }