3v4l.org

run code in 300+ PHP versions simultaneously
<?php $itemNames = [ 'MINI PACKLÅDA BRUN', 'BRUN S', 'BRUN M', 'BRUN L', 'BOOZT S', 'BOOZT M', 'BOOZT L', 'LILLA KOSMETIK', 'STORA KOSMETIK', '', 'EC 54', 'HÖGA CONTAINER - BOOZT', '', '125L TRANS SOPSÄCK', '240L BLACK SOPSÄCK', '125L BLACK SOPSÄCK', '', 'BOOZT MEDIUM', 'BOOZT LARGE', 'BOOZTLET MEDIUM', 'BOOZTLET LARGE', '', 'HANDSTRÄCKFILM Svart', 'Sträckfilm till maskin', 'PVC TEJP TRANS', 'PVC BOOZT', 'PPA Booztlet', '', 'PÅSE 22X36', 'PÅSE 30X48', 'PÅSE 40X60', 'PÅSE 50X80', 'PÅSE 18X25', 'PÅSE 60X100', '', 'SKOLÅDA 285X150X100', 'SKOLÅDA 350X200X120', 'SKOLÅDA 325X285X110', 'SKOLÅDA 530X330X110', '', 'TRANSPORTLABEL', 'ETIKETT 70X30', 'BRANDFARLIGT ETIKETT', 'Fragile etikett', '', 'ENGÅNGSPALL', 'PALL ÖVERDRAG PLAST', 'Silkespapper', 'Papper till Paperjet', 'A4 PAPPER', '', 'UTFYLLNAD KUDDAR', 'BUBBEL PLAST', 'Jiffy Bag 0 (135x229)', 'Jiffy Bag 1 (165x280)', 'Jiffy Bag 2 (195x280)', 'Sumo bag 145 x 215 mm', 'Sumo bag 175 x 265 mm', 'Sumo bag 215 x 265 mm', 'Fanfold', 'Fanfold Rulle', '', 'Royal Run Bag', 'Airbag Laptop 10 195x295x35 mm', 'Airbag Laptop 15 410x335x55 mm', 'Airbag Tonerbag 5 240x140x340 mm', 'Airbag Tonerbag 3 180x80x300 mm', 'Airbag Single bottle 110x80x320 mm', 'Airbag Half bottle 110x90x240 mm', 'Combined bag Small', 'Combined bag Medium', 'Combined bag Large', 'Maillite bag 150x210 mm', 'Maillite bag 180x260 mm', 'Maillite bag 220x260 mm', 'NYA LÅDA M', 'NYA LÅDA L', 'HÖGA CONTAINER - BRUN', 'Flex box M', 'Flex box L', 'Mini - Kuvertbotten', 'XS - Kuvertbotten', 'S - Kuvertbotten,', 'Packsize - small', 'Packsize - medium', 'Packsize - large', 'HÄNGETIKETT 100x40', 'Plastband - Manuell bandmaskin', 'Label UN 3480', 'Label UN 3481', 'Overpack Label', 'Label UN 3090', 'Label UN 3091', 'Lim - Lådresare', 'Plastband - Automatisk bandmaskin', 'PÅSE 60X160', 'Höga container - DAO', 'Ryggskiva', 'Packsedelskuvert', "Boozt S bag", "Boozt M bag", "Boozt L bag" ]; $eanStart = '1112223330000'; $count = 0; $arrayEan = []; foreach ($itemNames as $itemName) { if ($itemName !== '') { $encoding = mb_detect_encoding($itemName); $itemName = mb_convert_encoding($itemName, 'UTF-8', $encoding); $ean = $eanStart + $count++; echo 'name:'. $itemName . ' | system_id: PM-' . strtolower(str_replace([' ', '(', ')'], ['', '', ''], $itemName)) . ' | EAN: ' . $ean; // echo 'name:'. $itemName . ' | EAN: ' . $eanStart + $count++; echo PHP_EOL; $arrayEan[] = $ean; } else { echo PHP_EOL; } } $sql = 'SELECT i.id, i.ean, i.system_id, i.description FROM item i WHERE catid IN (' . implode(',', $arrayEan) . ')'; print_r($sql); // $count = 0; // foreach ($itemNames as $itemName) // { // if ($itemName !== '') { // echo "'" . $eanStart + $count++ . "'"; // echo PHP_EOL; // } // }
Output for 8.3.0 - 8.3.30, 8.4.1 - 8.4.18, 8.5.0 - 8.5.3
name:MINI PACKLÅDA BRUN | system_id: PM-minipacklÅdabrun | EAN: 1112223330000 name:BRUN S | system_id: PM-bruns | EAN: 1112223330001 name:BRUN M | system_id: PM-brunm | EAN: 1112223330002 name:BRUN L | system_id: PM-brunl | EAN: 1112223330003 name:BOOZT S | system_id: PM-boozts | EAN: 1112223330004 name:BOOZT M | system_id: PM-booztm | EAN: 1112223330005 name:BOOZT L | system_id: PM-booztl | EAN: 1112223330006 name:LILLA KOSMETIK | system_id: PM-lillakosmetik | EAN: 1112223330007 name:STORA KOSMETIK | system_id: PM-storakosmetik | EAN: 1112223330008 name:EC 54 | system_id: PM-ec54 | EAN: 1112223330009 name:HÖGA CONTAINER - BOOZT | system_id: PM-hÖgacontainer-boozt | EAN: 1112223330010 name:125L TRANS SOPSÄCK | system_id: PM-125ltranssopsÄck | EAN: 1112223330011 name:240L BLACK SOPSÄCK | system_id: PM-240lblacksopsÄck | EAN: 1112223330012 name:125L BLACK SOPSÄCK | system_id: PM-125lblacksopsÄck | EAN: 1112223330013 name:BOOZT MEDIUM | system_id: PM-booztmedium | EAN: 1112223330014 name:BOOZT LARGE | system_id: PM-booztlarge | EAN: 1112223330015 name:BOOZTLET MEDIUM | system_id: PM-booztletmedium | EAN: 1112223330016 name:BOOZTLET LARGE | system_id: PM-booztletlarge | EAN: 1112223330017 name:HANDSTRÄCKFILM Svart | system_id: PM-handstrÄckfilmsvart | EAN: 1112223330018 name:Sträckfilm till maskin | system_id: PM-sträckfilmtillmaskin | EAN: 1112223330019 name:PVC TEJP TRANS | system_id: PM-pvctejptrans | EAN: 1112223330020 name:PVC BOOZT | system_id: PM-pvcboozt | EAN: 1112223330021 name:PPA Booztlet | system_id: PM-ppabooztlet | EAN: 1112223330022 name:PÅSE 22X36 | system_id: PM-pÅse22x36 | EAN: 1112223330023 name:PÅSE 30X48 | system_id: PM-pÅse30x48 | EAN: 1112223330024 name:PÅSE 40X60 | system_id: PM-pÅse40x60 | EAN: 1112223330025 name:PÅSE 50X80 | system_id: PM-pÅse50x80 | EAN: 1112223330026 name:PÅSE 18X25 | system_id: PM-pÅse18x25 | EAN: 1112223330027 name:PÅSE 60X100 | system_id: PM-pÅse60x100 | EAN: 1112223330028 name:SKOLÅDA 285X150X100 | system_id: PM-skolÅda285x150x100 | EAN: 1112223330029 name:SKOLÅDA 350X200X120 | system_id: PM-skolÅda350x200x120 | EAN: 1112223330030 name:SKOLÅDA 325X285X110 | system_id: PM-skolÅda325x285x110 | EAN: 1112223330031 name:SKOLÅDA 530X330X110 | system_id: PM-skolÅda530x330x110 | EAN: 1112223330032 name:TRANSPORTLABEL | system_id: PM-transportlabel | EAN: 1112223330033 name:ETIKETT 70X30 | system_id: PM-etikett70x30 | EAN: 1112223330034 name:BRANDFARLIGT ETIKETT | system_id: PM-brandfarligtetikett | EAN: 1112223330035 name:Fragile etikett | system_id: PM-fragileetikett | EAN: 1112223330036 name:ENGÅNGSPALL | system_id: PM-engÅngspall | EAN: 1112223330037 name:PALL ÖVERDRAG PLAST | system_id: PM-pallÖverdragplast | EAN: 1112223330038 name:Silkespapper | system_id: PM-silkespapper | EAN: 1112223330039 name:Papper till Paperjet | system_id: PM-pappertillpaperjet | EAN: 1112223330040 name:A4 PAPPER | system_id: PM-a4papper | EAN: 1112223330041 name:UTFYLLNAD KUDDAR | system_id: PM-utfyllnadkuddar | EAN: 1112223330042 name:BUBBEL PLAST | system_id: PM-bubbelplast | EAN: 1112223330043 name:Jiffy Bag 0 (135x229) | system_id: PM-jiffybag0135x229 | EAN: 1112223330044 name:Jiffy Bag 1 (165x280) | system_id: PM-jiffybag1165x280 | EAN: 1112223330045 name:Jiffy Bag 2 (195x280) | system_id: PM-jiffybag2195x280 | EAN: 1112223330046 name:Sumo bag 145 x 215 mm | system_id: PM-sumobag145x215mm | EAN: 1112223330047 name:Sumo bag 175 x 265 mm | system_id: PM-sumobag175x265mm | EAN: 1112223330048 name:Sumo bag 215 x 265 mm | system_id: PM-sumobag215x265mm | EAN: 1112223330049 name:Fanfold | system_id: PM-fanfold | EAN: 1112223330050 name:Fanfold Rulle | system_id: PM-fanfoldrulle | EAN: 1112223330051 name:Royal Run Bag | system_id: PM-royalrunbag | EAN: 1112223330052 name:Airbag Laptop 10 195x295x35 mm | system_id: PM-airbaglaptop10195x295x35mm | EAN: 1112223330053 name:Airbag Laptop 15 410x335x55 mm | system_id: PM-airbaglaptop15410x335x55mm | EAN: 1112223330054 name:Airbag Tonerbag 5 240x140x340 mm | system_id: PM-airbagtonerbag5240x140x340mm | EAN: 1112223330055 name:Airbag Tonerbag 3 180x80x300 mm | system_id: PM-airbagtonerbag3180x80x300mm | EAN: 1112223330056 name:Airbag Single bottle 110x80x320 mm | system_id: PM-airbagsinglebottle110x80x320mm | EAN: 1112223330057 name:Airbag Half bottle 110x90x240 mm | system_id: PM-airbaghalfbottle110x90x240mm | EAN: 1112223330058 name:Combined bag Small | system_id: PM-combinedbagsmall | EAN: 1112223330059 name:Combined bag Medium | system_id: PM-combinedbagmedium | EAN: 1112223330060 name:Combined bag Large | system_id: PM-combinedbaglarge | EAN: 1112223330061 name:Maillite bag 150x210 mm | system_id: PM-maillitebag150x210mm | EAN: 1112223330062 name:Maillite bag 180x260 mm | system_id: PM-maillitebag180x260mm | EAN: 1112223330063 name:Maillite bag 220x260 mm | system_id: PM-maillitebag220x260mm | EAN: 1112223330064 name:NYA LÅDA M | system_id: PM-nyalÅdam | EAN: 1112223330065 name:NYA LÅDA L | system_id: PM-nyalÅdal | EAN: 1112223330066 name:HÖGA CONTAINER - BRUN | system_id: PM-hÖgacontainer-brun | EAN: 1112223330067 name:Flex box M | system_id: PM-flexboxm | EAN: 1112223330068 name:Flex box L | system_id: PM-flexboxl | EAN: 1112223330069 name:Mini - Kuvertbotten | system_id: PM-mini-kuvertbotten | EAN: 1112223330070 name:XS - Kuvertbotten | system_id: PM-xs-kuvertbotten | EAN: 1112223330071 name:S - Kuvertbotten, | system_id: PM-s-kuvertbotten, | EAN: 1112223330072 name:Packsize - small | system_id: PM-packsize-small | EAN: 1112223330073 name:Packsize - medium | system_id: PM-packsize-medium | EAN: 1112223330074 name:Packsize - large | system_id: PM-packsize-large | EAN: 1112223330075 name:HÄNGETIKETT 100x40 | system_id: PM-hÄngetikett100x40 | EAN: 1112223330076 name:Plastband - Manuell bandmaskin | system_id: PM-plastband-manuellbandmaskin | EAN: 1112223330077 name:Label UN 3480 | system_id: PM-labelun3480 | EAN: 1112223330078 name:Label UN 3481 | system_id: PM-labelun3481 | EAN: 1112223330079 name:Overpack Label | system_id: PM-overpacklabel | EAN: 1112223330080 name:Label UN 3090 | system_id: PM-labelun3090 | EAN: 1112223330081 name:Label UN 3091 | system_id: PM-labelun3091 | EAN: 1112223330082 name:Lim - Lådresare | system_id: PM-lim-lådresare | EAN: 1112223330083 name:Plastband - Automatisk bandmaskin | system_id: PM-plastband-automatiskbandmaskin | EAN: 1112223330084 name:PÅSE 60X160 | system_id: PM-pÅse60x160 | EAN: 1112223330085 name:Höga container - DAO | system_id: PM-högacontainer-dao | EAN: 1112223330086 name:Ryggskiva | system_id: PM-ryggskiva | EAN: 1112223330087 name:Packsedelskuvert | system_id: PM-packsedelskuvert | EAN: 1112223330088 name:Boozt S bag | system_id: PM-booztsbag | EAN: 1112223330089 name:Boozt M bag | system_id: PM-booztmbag | EAN: 1112223330090 name:Boozt L bag | system_id: PM-booztlbag | EAN: 1112223330091 SELECT i.id, i.ean, i.system_id, i.description FROM item i WHERE catid IN (1112223330000,1112223330001,1112223330002,1112223330003,1112223330004,1112223330005,1112223330006,1112223330007,1112223330008,1112223330009,1112223330010,1112223330011,1112223330012,1112223330013,1112223330014,1112223330015,1112223330016,1112223330017,1112223330018,1112223330019,1112223330020,1112223330021,1112223330022,1112223330023,1112223330024,1112223330025,1112223330026,1112223330027,1112223330028,1112223330029,1112223330030,1112223330031,1112223330032,1112223330033,1112223330034,1112223330035,1112223330036,1112223330037,1112223330038,1112223330039,1112223330040,1112223330041,1112223330042,1112223330043,1112223330044,1112223330045,1112223330046,1112223330047,1112223330048,1112223330049,1112223330050,1112223330051,1112223330052,1112223330053,1112223330054,1112223330055,1112223330056,1112223330057,1112223330058,1112223330059,1112223330060,1112223330061,1112223330062,1112223330063,1112223330064,1112223330065,1112223330066,1112223330067,1112223330068,1112223330069,1112223330070,1112223330071,1112223330072,1112223330073,1112223330074,1112223330075,1112223330076,1112223330077,1112223330078,1112223330079,1112223330080,1112223330081,1112223330082,1112223330083,1112223330084,1112223330085,1112223330086,1112223330087,1112223330088,1112223330089,1112223330090,1112223330091)
preferences:
62.3 ms | 1389 KiB | 4 Q