How can I export raw SQLite databases using PHP?

Hello,

I need to be able to export a raw SQLite database into a file using PHP. This is so that I can download this file from the server and use it with other applications.

I'm experienced in PHP and SQL, I know how to create and manage databases, but I can't figure out how to export in the raw database format. It always seems to want to export as SQL statements, which is not what I want, I need the raw format.

Thanks,
Steve
LVL 1
flashjordanAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
NerdsOfTechConnect With a Mentor Technology ScientistCommented:
use: sqlite_factory()
http://us2.php.net/manual/en/function.sqlite-factory.php
<?php
$dbhandle = sqlite_factory('sqlitedb');
$dbhandle->query('SELECT user_id, username FROM users');
 
/* functionally equivalent to: */
 
$dbhandle = new SQLiteDatabase('sqlitedb');
$dbhandle->query('SELECT user_id, username FROM users');
 
?>

Open in new window

0
 
NerdsOfTechTechnology ScientistCommented:
A SQLiteDatabase object is returned rather than a resource :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.