Advertisement
Guest User

xml to csv

a guest
Feb 17th, 2019
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.61 KB | None | 0 0
  1. <?php
  2. $csv2 = __DIR__ . '/output.csv';
  3. $xml2 = __DIR__ . '/input.xml';
  4.  
  5. $xml = file_get_contents($xml2);
  6. $priceListAsXml = SimpleXML_Load_String($xml);
  7.  
  8. // https://stackoverflow.com/a/20431742
  9. $priceListAsArray = json_decode(json_encode($priceListAsXml),TRUE);
  10.  
  11. $csvOutput[] = implode(';', array_keys($priceListAsArray['arak']['ar'][0]));
  12.  
  13. foreach($priceListAsArray['arak']['ar'] as $item)
  14. {
  15.     $item['listaar'] *= 1.1;
  16.  
  17.     $csvOutput[] = implode(';', $item);
  18. }
  19.  
  20. $fpw = fopen($csv2, 'w');
  21. if (!$fpw) trigger_error("UNABLE TO OPEN $csv2", E_USER_ERROR);
  22. file_put_contents($csv2,implode(PHP_EOL, $csvOutput));
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement