mysql result to array to write to csv file?

Question

So I have never wrote to a csv file before but always read from a csv file. Based on some example I have read this is what I have tried.

<?php
$newCsvData = array();
$getCats = "SELECT * FROM $termTax WHERE taxonomy = 'product_cat'";
$catresults = $wpdb->get_results($getCats);

foreach( $catresults as $catresult ) {
  $newCsvData[] = $catresult->term_id;
}
  $handle = fopen('export.csv', 'w');
  foreach ($newCsvData as $line) {
     fputcsv($handle, $line);
  }
  fclose($handle);
?>

I end up with errors saying fputcsv() expects parameter 2 to be array, string given in that is for this line

fputcsv($handle, $line);

If I var_dump($catresult); I get everything in the row as expected in an array... Example

object(stdClass)#401 (6) { ["term_taxonomy_id"]=> string(3) "224" ["term_id"]=> string(2) "37" ["taxonomy"]=> string(11) "product_cat" ["description"]=> string(0) "" ["parent"]=> string(1) "0" ["count"]=> string(1) "0" } object(stdClass)#402 (6) { ["term_taxonomy_id"]=> string(2) "35" ["term_id"]=> string(2) "35" ["taxonomy"]=> string(11) "product_cat" ["description"]=> string(0) "" ["parent"]=> string(1) "0" ["count"]=> string(1) "1" }

I just don't know how to write the array to the csv...

If I var_dump($line) I get string(2) "37" each string and its the correct value.

Am I on the right path? Thanks in advance.

UPDATE: So I created a blank php file in the root of my wordpress install and used this code and it works find... well some code someone below fixed... But the thing is it will not work from within my plugin I am working on.

It's clear from the code. It's array, each field contains $catresult->term_id as a string. — David Ferenczy Rogožan
– David Ferenczy Rogožan, Commented May 7, 2014 at 23:33

Machavity · Accepted Answer · 2014-05-07 23:28:00Z

2

The error message is telling you what is wrong.

fputcsv() expects parameter 2 to be array

And from your own admission (emphasis mine)

If I var_dump($line) I get string(2) "37" each string and its the correct value

Why not try this? You're building an array already.

foreach( $catresults as $catresult ) {
    $newCsvData[] = $catresult->term_id;
}
fputcsv($handle, $newCsvData);

answered May 7, 2014 at 23:28

Machavity♦

31.8k27 gold badges97 silver badges108 bronze badges

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

5 Comments

David Ferenczy Rogožan Over a year ago

Yep, I agree, that it's more than clear. But everyone has to start somehow :)

David Ferenczy Rogožan Over a year ago

This way he'll have his data in columns, not rows.

Bowenac Over a year ago

I tried that thanks. Maybe its just not writing for some reason... I no longer get those errors though. I was doing something similar earlier without errors but still was not writing to the csv file.

Machavity Over a year ago

I wasn't entirely sure how he wanted the CSV dumped out so I went with the simplest approach, mainly to demonstrate using the array vs strings

Bowenac Over a year ago

GRRRRR... the whole time it was working. But since it was inside of a plugin, the path ended up sending the file to wp-admin and not my plugin directory...

David Ferenczy Rogožan · Accepted Answer · 2014-05-07 23:57:41Z

1

The error messages are so clear that there is nothing better to say.

Simply create each line ($newCsvData array field) as array:

$newCsvData[] = array($catresult->term_id);

This way you will have each line in a CSV file with 1 column.

If you would like to have a CSV file with for example 3 columns, use this:

$newCsvData[] = array(
    $catresult->term_id,
    $catresult->another_filed,
    $catresult->yet_another_field
);

edited May 7, 2014 at 23:57

answered May 7, 2014 at 23:28

David Ferenczy Rogožan

25.7k12 gold badges88 silver badges73 bronze badges

3 Comments

Bowenac Over a year ago

Thanks for the suggestion but its not writing to the csv file.

David Ferenczy Rogožan Over a year ago

What is not writing to the CSV file?

David Ferenczy Rogožan Over a year ago

From manual: int fputcsv ( resource $handle , array $fields [, string $delimiter = "," [, string $enclosure = '"' ]] ) - it puts one line of fields of the $fields array (columns) to the CSV file. What does it mean "its not not writing"? And what is not writing? Paste your code. Post your errors.

Collectives™ on Stack Overflow

mysql result to array to write to csv file?

2 Answers 2

5 Comments

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related