Exporting SQLite table to Excel using PHP script

Question

I am working on a project and new to PHP and I need to know how to export the table data from SQLite to Excel.

I am able to do it from database but I do not know how to export to Excel using PHP.

<?php
$db = new sqlite3('I:\Preeti\explor\WebMobility.db');

$results = $db->query('SELECT * FROM VerbaliData');
while ($row = $results->fetchArray()) {
    var_dump($row);
}
?>

possible duplicate of SQL queries results write to Excel

tlenss
– tlenss

2014-01-15 10:42:40 +00:00
Commented Jan 15, 2014 at 10:42 — tlenss
– tlenss, Commented Jan 15, 2014 at 10:42

Beittil · Accepted Answer · 2014-01-15 10:40:56Z

1

The easiest method whould be to write your results into a CSV file which opens in Excel in a readable format.

See here for more information: http://php.net/fputcsv

$fp = fopen('file.csv', 'w');

while ($row = $results->fetchArray()) {
    fputcsv($fp, $row);
}
fclose($fp);

answered Jan 15, 2014 at 10:40

Beittil

11710 bronze badges

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

3 Comments

preethi Over a year ago

Thanks Beittil, It worked is it possible to add headers

Beittil Over a year ago

Yeah, sure. You could use the same method to write a line with the names of the columns. You can either take these from the resultset, or write an array with custom headers to the CSV file. In this case you need to make sure that the array matches the amount of columns from the db.

preethi Over a year ago

Hi Beittil I tried it but its not working what code should i add more.. while ($row = $results->fetchArray(sqlite3_BOTH); can you help me with this please

Collectives™ on Stack Overflow

Exporting SQLite table to Excel using PHP script

1 Answer 1

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related