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

Popular posts from this blog

linux - Using a Cron Job to check if my mod_wsgi / apache server is running and restart -

actionscript 3 - TweenLite does not work with object -

jQuery Ajax Render Fragments OR Whole Page -