Php sqlite command line access -
is there anyway access sqlite packaged php via command line?
from command-line, without using php executable execute php script, won't use sqlite extension that's bundled php.
sqlite databases created php standard sqlite databases (which stored in file), they can opened , manipulated existing sqlite client.
example, linux shell, can use :
$ sqlite3 -header -column /home/squale/.../db/krypton-lite-scores.db sqlite version 3.7.4 enter ".help" instructions enter sql statements terminated ";" sqlite> select * highscores; id name score latitude longitude timestamp ---------- ---------- ---------- ---------- ---------- ---------- 1 squale 20 45.7686 4.8128 1310533429 2 squale 63 45.7682 4.8131 1310579495 3 squale 42 45.7686 4.8127 1310586793 sqlite>
and allows me work sqlite database -- manipulated php scripts.
Comments
Post a Comment