php foreach loop to array in specific format

Question

I'm working with php_xlsxwriter, which takes php and outputs it to Excel.

Their sample code for "what gets output" is:

$data2 = array(
    array('2003','01','343.12'),
    array('2003','02','353.12'),
    array('2003','03','363.12'),
    array('2003','04','373.12'),
);

which of course outputs 4 lines to an Excel spreadsheet. For some reason ONLY an array written like this will output successfully. I've tried building arrays in other ways, but it causes the plugin to fail.

As such, I'm inputting data from an ajax call into this page, which contains my array of say... 50 elements, but I can't figure out how to write the foreach loop so that it builds a complete list. Right now, it's just outputting the LAST element in the array.

foreach ($xlString as &$c) {

  $s = $c[0];
  $p = $c[1];
  $l = $c[2];
  $a = $c[3]; 

  $data1 = array(

      array($s,$p,$l,$a),

  );

}

I understand WHY this is - because I'm overwriting $data1 each time I run the foreach loop - but I don't know how to change the code so that I don't do this.

dbinns66 · Accepted Answer · 2015-03-16 16:49:56Z

1

Declare $data outside the array, then add your results as a new element within the loop

$data = array()
foreach ($xlString as &$c) {

  $s = $c[0];
  $p = $c[1];
  $l = $c[2];
  $a = $c[3]; 

  $data1[] = array(

      array($s,$p,$l,$a),

  );

}

answered Mar 16, 2015 at 16:49

dbinns66

7916 silver badges7 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

php foreach loop to array in specific format

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related