exporting a table to a csv using mysqli and array

3/12/2016 9:32 am | #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 9:37 am | #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.

Did this help? Tips are appreciated...

3/14/2016 3: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

?>

Email me with all replies to this thread

Title:

Public Message: (viewable by anyone reading this thread)
(do not cut and paste code into this field unless necessary, attach copies of your pages so they can be opened in Dreamweaver for debugging)

Type in the characters exactly as displayed below - if you don't complete the Captcha correctly you will get a blank page, so you may want to copy the text of your message before you submit!

Quote message in reply?

Private Message: (viewable only by you, the person you are replying to, and WebAssist employees)
(only put truly private information in this area such as ftp details and phone numbers. Keep as much of your post public as possible)

These attachments are private (viewable only by you, the person you are replying to, and WebAssist employees)

Manage Attachments

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

exporting a table to a csv using mysqli and array

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