exporting a table to a csv using mysqli and array

3/12/2016 12:32 pm | #1 Christopher WestCommunity Expert

Hi there, I an attempting to export a field name from a table to a .csv file, however I get the following error inside the .csv file:

Fatal error: Call to a member function atEnd() on array in C:\xampp\htdocs\armadillo\admin\newsletter-export.php on line 18 

here is my code:

php:

<?php require_once('../Connections/ecartdb.php'); ?>

<?php require_once('../webassist/mysqli/rsobj.php'); ?>

<?php

$rsNewsletter = new WA_MySQLi_RS("rsNewsletter",$ecartdb,1);

$rsNewsletter->setQuery("SELECT NewsLetterEmail FROM newsletter WHERE NewsLetterOptIn = 1");

$rsNewsletter->execute();



$rsNewsletter = array();

?>

<?php



$filename = "emails.csv";

$fp = fopen('php://output', 'w');



    

header('Content-type: application/csv');

header('Content-Disposition: attachment; filename='.$filename);

while(!$rsNewsletter->atEnd()) {

    fputcsv($fp, $rsNewsletter[0]);

 $rsNewsletter->moveNext();

}

$rsNewsletter->moveFirst(); //return RS to first record

exit;

?>

Chris

3/14/2016 12:37 pm | #2 Ray BorduinWebAssist

It is because you are naming your Array the same thing as your recordset and effectively overwriting it. You will want to use unique names for your recordset and array.

3/14/2016 6:50 pm | #3 Christopher WestCommunity Expert

Hmm ok, just learning more about this. I actually got this code working (not using webassist code) However I would like to convert to your mysqli server behaviours for code consistency throughout my project (I know I know if it aint broke why fix it). But its a good learning curve.

from the following working code, I cannot just simply replace the mysqli_query with a webassist recordset. And I cannot replace the while loop with a webassist version. Any pointers?

I was think since in the working code there is a $row = mysqli_fetch_assoc (without looking it up on Google this is basically an array counter) So therefore to get a webassist version working I could use: $row = array($rows);

php:

<?php require_once('../Connections/ecartdb.php'); ?>

<?php

header('Content-Type: text/csv; charset=utf-8');

header('Content-Disposition: attachment; filename=emails.csv');



$output = fopen('php://output', 'w');



$rows = mysqli_query($ecartdb, 'SELECT NewsLetterEmail FROM newsletter');



while ($row = mysqli_fetch_assoc($rows)) {

fputcsv($output, $row);

}

fclose($output);

    

?>

ok I got it working, is this the logical way of coding it:

php:

<?php require_once('../Connections/ecartdb.php'); ?>

<?php require_once('../webassist/mysqli/rsobj.php'); ?>

<?php

header('Content-Type: text/csv; charset=utf-8');

header('Content-Disposition: attachment; filename=emails.csv');



$output = fopen('php://output', 'w');



$rows = new WA_MySQLi_RS("rows",$ecartdb,0);

$rows->setQuery("SELECT NewsLetterEmail FROM newsletter");

$rows->execute();



while(!$rows->atEnd()) {

    

    $row = array($rows->getColumnVal("NewsLetterEmail"));





fputcsv($output, $row);



$rows->moveNext();

}

$rows->moveFirst(); //return RS to first record

?>

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

exporting a table to a csv using mysqli and array

3/12/2016 12:32 pm | #1 Christopher WestCommunity Expert