Opening Firefox 3 sqlite files

[Chuck Anderson]

Firefox 3 uses sqlite files for bookmarks, browse history, form
history, cookies, ......

When I execute :
$sqlite_db_file = 'cookies.sqlite ';
$db = sqlite_open($sq lite_db_file, 0666, $sqlite_error);

I get the following error:
Error: file is encrypted or is not a database.

(using Php5.2.5 on Windows XP)

Has anyone had any luck opening the Firefox sqlite files with the Php
sqlite library functions?

--
*************** **************
Chuck Anderson • Boulder, CO
http://www.CycleTourist.com
Nothing he's got he really needs
Twenty first century schizoid man.
*************** *************** *****

[Tim Streater]

In article <sl************ ********@abyss. ninehells.com>,
"Peter H. Coffin" <he*****@ninehe lls.comwrote:

On Fri, 11 Jul 2008 10:41:15 +0100, Tim Streater wrote:

In article <14************ ***********@fre email.ru>,
AnrDaemon <an*******@free mail.ruwrote:

Greetings, Tim Streater.
In reply to Your message dated Wednesday, July 9, 2008, 14:24:09,

I figured out how to get at my firefox sqlite files. I need to use the
PDO functions as they are in sqlite 3 format.

Anyway .... what I want to do now is the equivalent of SHOW COLUMNS (in
MySQL), so that I can open any table and see it's structure. I have
yet
to find a way. Does anyone know how to use PDO SQLite to display a
tables columns?

Try this code:

<?

Please DON'T use short open tags in examples. Even if you are using them
in
your code (I dunno - why?), don't do that when you are providing examples.

Why not?

They mix poorly with XML documents, which start '<?XML'. The PHP
processor doens't have a "Use short tags that aren't XML tags" setting.

Ah! A sensible reason. Thanks.