Exporting data from database to csv file using php

Question

I am able to export database to csv but my code somehow imports twice the data to my csv file. I.e same column twice side by side.this is my code. I think my problem is with the implode statment. Any help would be appreciated.

<?php

$db = new sqlite3('I:\preethi\webbs.db');

$headers = array

('Id','CompanyId','DateTime','Serial','DeviceId','AgentAId','GpsAddress','Targa','CommonRoadDescription'

,'RoadCivicNumber','VehicleBrandDescription','VehicleModelDescription' ,'VerbaliVehicleTypeDescription','CommonColorVehicleDescription','VerbaliRuleOneCode','VerbaliRuleOneDes

cription','VerbaliRuleOnePoints'  

    ,'VerbaliClosedNoteDescription','Points','VerbaliMissedNotificationDescription 

','MissedNotificationNote','StatementNote');

    $results = $db->query('select'.implode (',',$headers).'from VerbaliData');

    //$results = $db->query( 'select 
Id   ,CompanyId  ,DateTime  ,Serial  ,DeviceId  ,AgentAId  

,GpsAddress  ,Targa  ,CommonRoadDescription  ,RoadCivicNumber  ,VehicleBrandDescription  

,VehicleModelDescription  ,VerbaliVehicleTypeDescription  ,CommonColorVehicleDescription  

,VerbaliRuleOneCode  ,VerbaliRuleOneDescription  ,VerbaliRuleOnePoints  ,VerbaliClosedNoteDescription  

,Points  ,VerbaliMissedNotificationDescription  ,MissedNotificationNote  ,StatementNote  from 

VerbaliData');


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

    fputcsv($fp,$headers);

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

    fclose($fp);

    ?>

"imports twice the data to my csv file" or "imports twice the data to my db"? — Jenson M John
– Jenson M John, Commented Jan 20, 2014 at 9:33
exporting data from sqlite 3 to csv.. but instead it exports twice like ('Id','ID','CompanyId', 'comapnayID','DateTime','datetime','serial','Serial' — preethi
– preethi, Commented Jan 20, 2014 at 9:38
done. titles sql to csv. headers appearing once but data twice. — preethi
– preethi, Commented Jan 20, 2014 at 9:54

Jenson M John · Accepted Answer · 2014-01-20 09:54:30Z

1

Just try with :

while($row = $results->fetchArray(SQLITE3_NUM)) {

Or

while($row = $results->fetchArray(SQLITE3_ASSOC)) {

More Details: http://php.net/manual/en/sqlite3result.fetcharray.php

answered Jan 20, 2014 at 9:54

Jenson M John

5,7195 gold badges32 silver badges48 bronze badges

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

5 Comments

Jenson M John Over a year ago

@preethi Ok I'll check. It would be better if you could provide CSV pastebin URL.

Jenson M John Over a year ago

With SQLITE3_NUM or SQLITE_ASSOC It should have worked. If that still didn't work, Just use array_unique($row) before fputcsv($fp, $row);

preethi Over a year ago

2 errors :Warning: SQLite3::query(): Unable to prepare statement: 1, near "selectId": syntax error in C:\xampp\htdocs\download.php on line 11 Fatal error: Call to a member function fetchArray() on a non-object in C:\xampp\htdocs\download.php on line 18

Jenson M John Over a year ago

@preethi Can you provide table dump & full code. I'll have a look on it.

Jenson M John Over a year ago

let us continue this discussion in chat

Gaurav Joseph · Accepted Answer · 2014-01-20 09:55:16Z

0

You have a slight prob in your code fetchArray() returns two array sets one associative and one is numbered, use fetchArray(SQLITE3_NUM) or fetchArray(SQLITE3_ASSOC).

answered Jan 20, 2014 at 9:55

Gaurav Joseph

94616 silver badges27 bronze badges

Collectives™ on Stack Overflow

Exporting data from database to csv file using php

2 Answers 2

5 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related