Export database to CSV with columns PHP

Question

Here my php script to export database info to CSV file.

I dont arrive to put any structure to correctly tidy my infos in my CSV file.

For example, put all names in a name column, all emails in an email column... etc

include_once('conf.php');
include_once('BDD.php');

header('charset=UTF-8');
header("Content-Disposition: attachment; filename=file.csv");
header("Pragma: no-cache");
header("Expires: 0");


$bdd = new BDD($conf['bddhost'], $conf['bddport'], $conf['bddname'], $conf['bdduser'], $conf['bddpass']);
$sql = "SELECT * FROM user";
$qry = $bdd->prepare($sql);

// Execute the statement
$qry->execute();

$data = fopen('/tmp/db_user_export_".time().".csv', 'w');


while ($row = $qry->fetch(PDO::FETCH_ASSOC))
{
    // Export every row to a file
    fputcsv($data, $row);
    echo ''.$row['prenom'].' '
                .$row['nom'].' '
                .$row['email'].' '
                .$row['cp'].' '
                .$row['information'].'  
                ';
}
fclose($data);

What is your question? I realize there's a language barrier, but it's difficult to understand what you're asking or how your code doesn't work. — David
– David, Commented Oct 9, 2014 at 15:38
CSV - "comma separated values"...where's your commas? Where's your quotes? WHat is the question? — charlietfl
– charlietfl, Commented Oct 9, 2014 at 15:38
you may want to activate errors (error_reporting(E_ALL);ini_set('display_errors', 'On');) and check the output of fputcsv which should return the length of the string written. Maybe try to remove header()s functions to help debugging. Maybe it's a write permission on /tmp — Asenar
– Asenar, Commented Oct 9, 2014 at 15:39

cmorrissey · Accepted Answer · 2014-10-09 15:46:11Z

0

You don't want to use echo as you are creating the file with fputcsv

while ($row = $qry->fetch(PDO::FETCH_ASSOC))
{
    // Export every row to a file
    fputcsv($data, $row);
}

// reset the file pointer to the beginning of the file
rewind($data);

// dump the csv file and stop the script
fpassthru($data);
exit;

answered Oct 9, 2014 at 15:46

cmorrissey

8,5912 gold badges26 silver badges28 bronze badges

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

Comments

Marc B · Accepted Answer · 2014-10-09 15:50:19Z

0

Syntax errors:

$data = fopen('/tmp/db_user_export_".time().".csv', 'w');
              ^--                  ^--      ^--  ^---

You're mixing string quoting styles, so your filename is literally going to contain the characters ", ., t, etc... in it.

Try

$data = fopen('/tmp/db_user_export_' .time() .'.csv', 'w');
                                   ^----------^---

instead. Note the change from " -> '.

answered Oct 9, 2014 at 15:50

Marc B

362k44 gold badges433 silver badges508 bronze badges

Collectives™ on Stack Overflow

Export database to CSV with columns PHP

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related