php_csv_sqlite

php sqlite csv

$db = new SQLite3('test.db');

sqlite3 -header -csv c:/sqlite/chinook.db "select * from tracks;" > tracks.csv


you have a file named query.sql that contains the script to query data, you can execute the statements in the file and export data to a CSV file.
sqlite3 -header -csv c:/sqlite/chinook.db "select * from tracks;

>sqlite3 -header -csv c:/sqlite/chinook.db < query.sql > data.csv


QNH is a table

SQL Script (save as import.sql)

CREATE TABLE IF NOT EXISTS QNH(id INTEGER PRIMARY KEY,unixtimeutc INTEGER,stationqnh TEXT);
      .separator ,
      .mode csv
      .import output.csv QNH

PHP Script (adjust path names as needed)

exec("sqlite3 yourdb.sqlite < import.sql")