<?php
$string = <<<EOL
"Invoice Date","Invoice ID","Advertiser ID","Advertiser Name","Advertiser Paid Date","Advertiser Authorization Date","Commissions Earned","Commissions Held","Commissions Carried Forward","Commission Denied","Net Bonus","Bonus Notes",CPC/CPM,VAT/GST,"Invoice Amount","Invoice Currency","Payment Status"
01/05/2017,1655133,24359,"L'Occitane UK",25/06/2017,05/06/2017,"71,74","0,00","0,00","0,00","0,00",,"0,00","14,35","86,09",GBP,Paid
01/05/2017,1654982,35352,"Oliver Bonas Ltd",25/06/2017,06/06/2017,"56,31","0,00","0,00","0,00","0,00",,"0,00","11,26","67,57",GBP,Paid
01/05/2017,1654909,35269,"Cult Beauty Ltd.",29/06/2017,13/06/2017,"42,13","0,00","0,00","0,00","0,00",,"0,00","8,43","50,56",GBP,Paid
01/05/2017,1654898,35290,"THE OUTNET.COM (UK)",26/06/2017,02/06/2017,"204,73","0,00","0,00","0,00","0,00",,"0,00","40,95","245,68",GBP,Paid
01/05/2017,1654596,38998,Clippings,25/06/2017,05/06/2017,"25,79","0,00","0,00","0,00","0,00",,"0,00","5,16","30,95",GBP,Paid
01/05/2017,1654014,35205,"Sweaty Betty",25/06/2017,02/06/2017,"100,61","0,00","0,00","0,00","0,00",,"0,00","20,12","120,73",GBP,Paid
01/05/2017,1653892,40593,"Mahabis UK",29/06/2017,12/06/2017,"4,48","0,00","0,00","0,00","0,00",,"0,00","0,90","5,38",GBP,Paid
01/05/2017,1653006,41462,"Dr Martens UK",27/06/2017,02/06/2017,"37,88","0,00","0,00","0,00","0,00",,"0,00","7,58","45,46",GBP,Paid
01/05/2017,1652704,42152,"Virgin Atlantic",25/06/2017,02/06/2017,"294,56","0,00","0,00","0,00","0,00",,"0,00","0,00","294,56",GBP,Paid
01/04/2017,1650947,40562,"Bobbi Brown UK",28/06/2017,02/05/2017,"69,48","0,00","0,00","0,00","0,00",,"0,00","13,90","83,38",GBP,Paid
01/04/2017,1650708,40012,"Vivienne Westwood",25/06/2017,22/05/2017,"9,75","0,00","0,00","0,00","0,00",,"0,00","1,95","11,70",GBP,Paid
01/04/2017,1650704,38628,"Butterfly Twists Ltd",29/06/2017,01/06/2017,"5,19","0,00","0,00","0,00","0,00",,"0,00","1,04","6,23",GBP,Paid
01/04/2017,1650579,38701,"BIRCHBOX UK",28/06/2017,01/06/2017,"116,55","0,00","0,00","0,00","0,00",,"0,00","23,31","139,86",GBP,Paid
01/04/2017,1650510,39454,"Biscuiteers Baking Company",25/06/2017,01/06/2017,"14,99","0,00","0,00","0,00","0,00",,"0,00","3,00","17,99",GBP,Paid
01/04/2017,1649587,24865,Lipsy,26/06/2017,01/06/2017,"1,86","0,00","0,00","0,00","0,00",,"0,00","0,37","2,23",GBP,Paid
01/04/2017,1649359,36350,"Dune London - EU Affiliate Programme",26/06/2017,01/06/2017,"136,86","0,00","0,00","0,00","1.790,00","Easy Fundraising: Silver Package (£895)
RAN Override = £268.50
IO: IO3943
Easy Fundraising: Silver Package (£895)
RAN Override = £268.50
IO: IO3921","0,00","385,37","2.312,23",GBP,Paid
01/04/2017,1649074,36027,Notonthehighstreet.com,26/06/2017,01/06/2017,"2.321,11","0,00","0,00","0,00","0,00",,"0,00","464,22","2.785,33",GBP,Paid
01/04/2017,1648981,41404,"Joseph Joseph",25/06/2017,01/06/2017,"12,72","0,00","0,00","0,00","0,00",,"0,00","2,54","15,26",GBP,Paid
01/04/2017,1648437,36586,"Mr Porter UK",26/06/2017,04/05/2017,"102,35","0,00","0,00","0,00","0,00",,"0,00","20,47","122,82",GBP,Paid
01/04/2017,1648320,36266,"Oxygen Boutique",26/06/2017,01/06/2017,"13,33","0,00","0,00","0,00","0,00",,"0,00","2,67","16,00",GBP,Paid
01/03/2017,1647341,38999,"Lavish Alice",27/06/2017,01/05/2017,"15,12","0,00","0,00","0,00","0,00",,"0,00","3,02","18,14",GBP,Paid
01/03/2017,1647073,35158,"Designers Guild Ltd.",28/06/2017,01/05/2017,"18,69","0,00","0,00","0,00","0,00",,"0,00","3,74","22,43",GBP,Paid
01/03/2017,1645821,39816,Easirent,26/06/2017,01/05/2017,"20,46","0,00","0,00","0,00","0,00",,"0,00","4,09","24,55",GBP,Paid
01/03/2017,1645098,36350,"Dune London - EU Affiliate Programme",26/06/2017,01/05/2017,"148,19","0,00","0,00","0,00","0,00",,"0,00","29,64","177,83",GBP,Paid
01/03/2017,1644596,41462,"Dr Martens UK",28/06/2017,03/04/2017,"93,68","0,00","0,00","0,00","0,00",,"0,00","18,74","112,42",GBP,Paid
01/03/2017,1644578,41404,"Joseph Joseph",25/06/2017,01/05/2017,"21,60","0,00","0,00","0,00","0,00",,"0,00","4,32","25,92",GBP,Paid
01/02/2017,1641113,36350,"Dune London - EU Affiliate Programme",26/06/2017,01/04/2017,"13,44","0,00","0,00","0,00","0,00",,"0,00","2,69","16,13",GBP,Paid
01/02/2017,1641106,36382,"Pretty Green Ltd",27/06/2017,01/04/2017,"61,88","0,00","0,00","0,00","0,00",,"0,00","12,38","74,26",GBP,Paid
01/01/2017,1640390,39654,"Harvey Nichols & Co Ltd",28/06/2017,01/03/2017,"17,12","0,00","0,00","0,00","0,00",,"0,00","3,42","20,54",GBP,Paid
01/01/2017,1639036,37257,"Anthropologie (UK)",26/06/2017,14/02/2017,"6,28","0,00","0,00","0,00","0,00",,"0,00","1,26","7,54",GBP,Paid
01/01/2017,1637601,36382,"Pretty Green Ltd",27/06/2017,01/03/2017,"45,86","0,00","0,00","0,00","0,00",,"0,00","9,17","55,03",GBP,Paid
EOL;
var_dump(str_getcsv($string, "\n", "\""));
- Output for 5.6.0 - 5.6.40, 7.0.0 - 7.0.33, 7.1.0 - 7.1.33, 7.2.0 - 7.2.33, 7.3.0 - 7.3.33, 7.4.0 - 7.4.33, 8.0.0 - 8.0.30, 8.1.0 - 8.1.28, 8.2.0 - 8.2.18, 8.3.0 - 8.3.4, 8.3.6
- array(37) {
[0]=>
string(299) "Invoice Date,"Invoice ID","Advertiser ID","Advertiser Name","Advertiser Paid Date","Advertiser Authorization Date","Commissions Earned","Commissions Held","Commissions Carried Forward","Commission Denied","Net Bonus","Bonus Notes",CPC/CPM,VAT/GST,"Invoice Amount","Invoice Currency","Payment Status""
[1]=>
string(131) "01/05/2017,1655133,24359,"L'Occitane UK",25/06/2017,05/06/2017,"71,74","0,00","0,00","0,00","0,00",,"0,00","14,35","86,09",GBP,Paid"
[2]=>
string(134) "01/05/2017,1654982,35352,"Oliver Bonas Ltd",25/06/2017,06/06/2017,"56,31","0,00","0,00","0,00","0,00",,"0,00","11,26","67,57",GBP,Paid"
[3]=>
string(133) "01/05/2017,1654909,35269,"Cult Beauty Ltd.",29/06/2017,13/06/2017,"42,13","0,00","0,00","0,00","0,00",,"0,00","8,43","50,56",GBP,Paid"
[4]=>
string(139) "01/05/2017,1654898,35290,"THE OUTNET.COM (UK)",26/06/2017,02/06/2017,"204,73","0,00","0,00","0,00","0,00",,"0,00","40,95","245,68",GBP,Paid"
[5]=>
string(124) "01/05/2017,1654596,38998,Clippings,25/06/2017,05/06/2017,"25,79","0,00","0,00","0,00","0,00",,"0,00","5,16","30,95",GBP,Paid"
[6]=>
string(132) "01/05/2017,1654014,35205,"Sweaty Betty",25/06/2017,02/06/2017,"100,61","0,00","0,00","0,00","0,00",,"0,00","20,12","120,73",GBP,Paid"
[7]=>
string(125) "01/05/2017,1653892,40593,"Mahabis UK",29/06/2017,12/06/2017,"4,48","0,00","0,00","0,00","0,00",,"0,00","0,90","5,38",GBP,Paid"
[8]=>
string(130) "01/05/2017,1653006,41462,"Dr Martens UK",27/06/2017,02/06/2017,"37,88","0,00","0,00","0,00","0,00",,"0,00","7,58","45,46",GBP,Paid"
[9]=>
string(134) "01/05/2017,1652704,42152,"Virgin Atlantic",25/06/2017,02/06/2017,"294,56","0,00","0,00","0,00","0,00",,"0,00","0,00","294,56",GBP,Paid"
[10]=>
string(132) "01/04/2017,1650947,40562,"Bobbi Brown UK",28/06/2017,02/05/2017,"69,48","0,00","0,00","0,00","0,00",,"0,00","13,90","83,38",GBP,Paid"
[11]=>
string(133) "01/04/2017,1650708,40012,"Vivienne Westwood",25/06/2017,22/05/2017,"9,75","0,00","0,00","0,00","0,00",,"0,00","1,95","11,70",GBP,Paid"
[12]=>
string(135) "01/04/2017,1650704,38628,"Butterfly Twists Ltd",29/06/2017,01/06/2017,"5,19","0,00","0,00","0,00","0,00",,"0,00","1,04","6,23",GBP,Paid"
[13]=>
string(131) "01/04/2017,1650579,38701,"BIRCHBOX UK",28/06/2017,01/06/2017,"116,55","0,00","0,00","0,00","0,00",,"0,00","23,31","139,86",GBP,Paid"
[14]=>
string(143) "01/04/2017,1650510,39454,"Biscuiteers Baking Company",25/06/2017,01/06/2017,"14,99","0,00","0,00","0,00","0,00",,"0,00","3,00","17,99",GBP,Paid"
[15]=>
string(118) "01/04/2017,1649587,24865,Lipsy,26/06/2017,01/06/2017,"1,86","0,00","0,00","0,00","0,00",,"0,00","0,37","2,23",GBP,Paid"
[16]=>
string(170) "01/04/2017,1649359,36350,"Dune London - EU Affiliate Programme",26/06/2017,01/06/2017,"136,86","0,00","0,00","0,00","1.790,00","Easy Fundraising: Silver Package (£895)"
[17]=>
string(25) "RAN Override = £268.50"
[18]=>
string(10) "IO: IO3943"
[19]=>
string(42) "Easy Fundraising: Silver Package (£895)"
[20]=>
string(25) "RAN Override = £268.50"
[21]=>
string(47) "IO: IO3921","0,00","385,37","2.312,23",GBP,Paid"
[22]=>
string(145) "01/04/2017,1649074,36027,Notonthehighstreet.com,26/06/2017,01/06/2017,"2.321,11","0,00","0,00","0,00","0,00",,"0,00","464,22","2.785,33",GBP,Paid"
[23]=>
string(130) "01/04/2017,1648981,41404,"Joseph Joseph",25/06/2017,01/06/2017,"12,72","0,00","0,00","0,00","0,00",,"0,00","2,54","15,26",GBP,Paid"
[24]=>
string(132) "01/04/2017,1648437,36586,"Mr Porter UK",26/06/2017,04/05/2017,"102,35","0,00","0,00","0,00","0,00",,"0,00","20,47","122,82",GBP,Paid"
[25]=>
string(132) "01/04/2017,1648320,36266,"Oxygen Boutique",26/06/2017,01/06/2017,"13,33","0,00","0,00","0,00","0,00",,"0,00","2,67","16,00",GBP,Paid"
[26]=>
string(129) "01/03/2017,1647341,38999,"Lavish Alice",27/06/2017,01/05/2017,"15,12","0,00","0,00","0,00","0,00",,"0,00","3,02","18,14",GBP,Paid"
[27]=>
string(137) "01/03/2017,1647073,35158,"Designers Guild Ltd.",28/06/2017,01/05/2017,"18,69","0,00","0,00","0,00","0,00",,"0,00","3,74","22,43",GBP,Paid"
[28]=>
string(123) "01/03/2017,1645821,39816,Easirent,26/06/2017,01/05/2017,"20,46","0,00","0,00","0,00","0,00",,"0,00","4,09","24,55",GBP,Paid"
[29]=>
string(156) "01/03/2017,1645098,36350,"Dune London - EU Affiliate Programme",26/06/2017,01/05/2017,"148,19","0,00","0,00","0,00","0,00",,"0,00","29,64","177,83",GBP,Paid"
[30]=>
string(132) "01/03/2017,1644596,41462,"Dr Martens UK",28/06/2017,03/04/2017,"93,68","0,00","0,00","0,00","0,00",,"0,00","18,74","112,42",GBP,Paid"
[31]=>
string(130) "01/03/2017,1644578,41404,"Joseph Joseph",25/06/2017,01/05/2017,"21,60","0,00","0,00","0,00","0,00",,"0,00","4,32","25,92",GBP,Paid"
[32]=>
string(153) "01/02/2017,1641113,36350,"Dune London - EU Affiliate Programme",26/06/2017,01/04/2017,"13,44","0,00","0,00","0,00","0,00",,"0,00","2,69","16,13",GBP,Paid"
[33]=>
string(134) "01/02/2017,1641106,36382,"Pretty Green Ltd",27/06/2017,01/04/2017,"61,88","0,00","0,00","0,00","0,00",,"0,00","12,38","74,26",GBP,Paid"
[34]=>
string(140) "01/01/2017,1640390,39654,"Harvey Nichols & Co Ltd",28/06/2017,01/03/2017,"17,12","0,00","0,00","0,00","0,00",,"0,00","3,42","20,54",GBP,Paid"
[35]=>
string(133) "01/01/2017,1639036,37257,"Anthropologie (UK)",26/06/2017,14/02/2017,"6,28","0,00","0,00","0,00","0,00",,"0,00","1,26","7,54",GBP,Paid"
[36]=>
string(133) "01/01/2017,1637601,36382,"Pretty Green Ltd",27/06/2017,01/03/2017,"45,86","0,00","0,00","0,00","0,00",,"0,00","9,17","55,03",GBP,Paid"
}
- Output for 8.3.5
- Warning: PHP Startup: Unable to load dynamic library 'sodium.so' (tried: /usr/lib/php/8.3.5/modules/sodium.so (libsodium.so.23: cannot open shared object file: No such file or directory), /usr/lib/php/8.3.5/modules/sodium.so.so (/usr/lib/php/8.3.5/modules/sodium.so.so: cannot open shared object file: No such file or directory)) in Unknown on line 0
array(37) {
[0]=>
string(299) "Invoice Date,"Invoice ID","Advertiser ID","Advertiser Name","Advertiser Paid Date","Advertiser Authorization Date","Commissions Earned","Commissions Held","Commissions Carried Forward","Commission Denied","Net Bonus","Bonus Notes",CPC/CPM,VAT/GST,"Invoice Amount","Invoice Currency","Payment Status""
[1]=>
string(131) "01/05/2017,1655133,24359,"L'Occitane UK",25/06/2017,05/06/2017,"71,74","0,00","0,00","0,00","0,00",,"0,00","14,35","86,09",GBP,Paid"
[2]=>
string(134) "01/05/2017,1654982,35352,"Oliver Bonas Ltd",25/06/2017,06/06/2017,"56,31","0,00","0,00","0,00","0,00",,"0,00","11,26","67,57",GBP,Paid"
[3]=>
string(133) "01/05/2017,1654909,35269,"Cult Beauty Ltd.",29/06/2017,13/06/2017,"42,13","0,00","0,00","0,00","0,00",,"0,00","8,43","50,56",GBP,Paid"
[4]=>
string(139) "01/05/2017,1654898,35290,"THE OUTNET.COM (UK)",26/06/2017,02/06/2017,"204,73","0,00","0,00","0,00","0,00",,"0,00","40,95","245,68",GBP,Paid"
[5]=>
string(124) "01/05/2017,1654596,38998,Clippings,25/06/2017,05/06/2017,"25,79","0,00","0,00","0,00","0,00",,"0,00","5,16","30,95",GBP,Paid"
[6]=>
string(132) "01/05/2017,1654014,35205,"Sweaty Betty",25/06/2017,02/06/2017,"100,61","0,00","0,00","0,00","0,00",,"0,00","20,12","120,73",GBP,Paid"
[7]=>
string(125) "01/05/2017,1653892,40593,"Mahabis UK",29/06/2017,12/06/2017,"4,48","0,00","0,00","0,00","0,00",,"0,00","0,90","5,38",GBP,Paid"
[8]=>
string(130) "01/05/2017,1653006,41462,"Dr Martens UK",27/06/2017,02/06/2017,"37,88","0,00","0,00","0,00","0,00",,"0,00","7,58","45,46",GBP,Paid"
[9]=>
string(134) "01/05/2017,1652704,42152,"Virgin Atlantic",25/06/2017,02/06/2017,"294,56","0,00","0,00","0,00","0,00",,"0,00","0,00","294,56",GBP,Paid"
[10]=>
string(132) "01/04/2017,1650947,40562,"Bobbi Brown UK",28/06/2017,02/05/2017,"69,48","0,00","0,00","0,00","0,00",,"0,00","13,90","83,38",GBP,Paid"
[11]=>
string(133) "01/04/2017,1650708,40012,"Vivienne Westwood",25/06/2017,22/05/2017,"9,75","0,00","0,00","0,00","0,00",,"0,00","1,95","11,70",GBP,Paid"
[12]=>
string(135) "01/04/2017,1650704,38628,"Butterfly Twists Ltd",29/06/2017,01/06/2017,"5,19","0,00","0,00","0,00","0,00",,"0,00","1,04","6,23",GBP,Paid"
[13]=>
string(131) "01/04/2017,1650579,38701,"BIRCHBOX UK",28/06/2017,01/06/2017,"116,55","0,00","0,00","0,00","0,00",,"0,00","23,31","139,86",GBP,Paid"
[14]=>
string(143) "01/04/2017,1650510,39454,"Biscuiteers Baking Company",25/06/2017,01/06/2017,"14,99","0,00","0,00","0,00","0,00",,"0,00","3,00","17,99",GBP,Paid"
[15]=>
string(118) "01/04/2017,1649587,24865,Lipsy,26/06/2017,01/06/2017,"1,86","0,00","0,00","0,00","0,00",,"0,00","0,37","2,23",GBP,Paid"
[16]=>
string(170) "01/04/2017,1649359,36350,"Dune London - EU Affiliate Programme",26/06/2017,01/06/2017,"136,86","0,00","0,00","0,00","1.790,00","Easy Fundraising: Silver Package (£895)"
[17]=>
string(25) "RAN Override = £268.50"
[18]=>
string(10) "IO: IO3943"
[19]=>
string(42) "Easy Fundraising: Silver Package (£895)"
[20]=>
string(25) "RAN Override = £268.50"
[21]=>
string(47) "IO: IO3921","0,00","385,37","2.312,23",GBP,Paid"
[22]=>
string(145) "01/04/2017,1649074,36027,Notonthehighstreet.com,26/06/2017,01/06/2017,"2.321,11","0,00","0,00","0,00","0,00",,"0,00","464,22","2.785,33",GBP,Paid"
[23]=>
string(130) "01/04/2017,1648981,41404,"Joseph Joseph",25/06/2017,01/06/2017,"12,72","0,00","0,00","0,00","0,00",,"0,00","2,54","15,26",GBP,Paid"
[24]=>
string(132) "01/04/2017,1648437,36586,"Mr Porter UK",26/06/2017,04/05/2017,"102,35","0,00","0,00","0,00","0,00",,"0,00","20,47","122,82",GBP,Paid"
[25]=>
string(132) "01/04/2017,1648320,36266,"Oxygen Boutique",26/06/2017,01/06/2017,"13,33","0,00","0,00","0,00","0,00",,"0,00","2,67","16,00",GBP,Paid"
[26]=>
string(129) "01/03/2017,1647341,38999,"Lavish Alice",27/06/2017,01/05/2017,"15,12","0,00","0,00","0,00","0,00",,"0,00","3,02","18,14",GBP,Paid"
[27]=>
string(137) "01/03/2017,1647073,35158,"Designers Guild Ltd.",28/06/2017,01/05/2017,"18,69","0,00","0,00","0,00","0,00",,"0,00","3,74","22,43",GBP,Paid"
[28]=>
string(123) "01/03/2017,1645821,39816,Easirent,26/06/2017,01/05/2017,"20,46","0,00","0,00","0,00","0,00",,"0,00","4,09","24,55",GBP,Paid"
[29]=>
string(156) "01/03/2017,1645098,36350,"Dune London - EU Affiliate Programme",26/06/2017,01/05/2017,"148,19","0,00","0,00","0,00","0,00",,"0,00","29,64","177,83",GBP,Paid"
[30]=>
string(132) "01/03/2017,1644596,41462,"Dr Martens UK",28/06/2017,03/04/2017,"93,68","0,00","0,00","0,00","0,00",,"0,00","18,74","112,42",GBP,Paid"
[31]=>
string(130) "01/03/2017,1644578,41404,"Joseph Joseph",25/06/2017,01/05/2017,"21,60","0,00","0,00","0,00","0,00",,"0,00","4,32","25,92",GBP,Paid"
[32]=>
string(153) "01/02/2017,1641113,36350,"Dune London - EU Affiliate Programme",26/06/2017,01/04/2017,"13,44","0,00","0,00","0,00","0,00",,"0,00","2,69","16,13",GBP,Paid"
[33]=>
string(134) "01/02/2017,1641106,36382,"Pretty Green Ltd",27/06/2017,01/04/2017,"61,88","0,00","0,00","0,00","0,00",,"0,00","12,38","74,26",GBP,Paid"
[34]=>
string(140) "01/01/2017,1640390,39654,"Harvey Nichols & Co Ltd",28/06/2017,01/03/2017,"17,12","0,00","0,00","0,00","0,00",,"0,00","3,42","20,54",GBP,Paid"
[35]=>
string(133) "01/01/2017,1639036,37257,"Anthropologie (UK)",26/06/2017,14/02/2017,"6,28","0,00","0,00","0,00","0,00",,"0,00","1,26","7,54",GBP,Paid"
[36]=>
string(133) "01/01/2017,1637601,36382,"Pretty Green Ltd",27/06/2017,01/03/2017,"45,86","0,00","0,00","0,00","0,00",,"0,00","9,17","55,03",GBP,Paid"
}
preferences:
265.54 ms | 413 KiB | 291 Q