CODEWITHSUNDEEP
phpandroiddatabasesqlitedownload
njsmecho
njsmecho

Reputation: 45

Use database for Android App by downloading with php-script

I'm going nuts! Maybe someone can help me?! I have an sqlite-database on a running server, which I receive due to an php-script. (To make it clear: I'm calling an php-script which gives me the the database as a response). With the response I'm now trying to "parse" it to an regular *.db file which I later on use for my app.

the app works fine, while placing the *.db into the assets folder. But I need to get the updated database everytime when calling the app. Therefore I need to receive it somehow from the server.

Just for notice: I don't know why they use a php-script for that, but it works perfectly with the iOS-Version of the app. So I am 100% sure that the script does work.

Got any hints or a solution to that? Thanks!

EDIT: here is what I'm trying to do. private void copyDatabase() { InputStream myInputDB = null; OutputStream myOutputDB = null; HttpResponse response = null; // Path to the just created empty db String dbFilePath = DB_PATH + KeyConstants.DB_NAME;

     // Creating HTTP client
    HttpClient httpClient = new DefaultHttpClient();
    // Creating HTTP Post
    HttpPost httpPost = new HttpPost(
            "http://USERNAME:PASSWORD@ADRESS/u/db.php");


    try {
        response = httpClient.execute(httpPost);

        //Open your local db as the input stream
        myInputDB = response.getEntity().getContent();

        //Open the empty db as the output stream
        myOutputDB = new FileOutputStream(dbFilePath);



        //transfer bytes from the inputfile to the outputfile
        byte[] buffer = new byte[1024];
        int length;
        while ((length = myInputDB.read(buffer)) > 0){
            myOutputDB.write(buffer, 0, length);
        }

        //Close the streams
        myOutputDB.flush();
        myOutputDB.close();
        myInputDB.close();

    } catch (IOException ioEXC) {
        throw new Error("Problem copying database from resource file.");
    }

Upvotes: 0

Views: 339

Answers (1)

shadyyx
shadyyx

Reputation: 16055

What do You have the problem with? With the Android app or with the PHP script?

I don't understand why there is a whole DB file request-response and not just the data (and better in some lazy reading), but that's not matter of Your case.

If You need to "download" all the DB at every run You should call and implement some method to do so - in the very first Activity call this method within onCreate() method. You can create a simple method within this Activity or in better approach create a simple class for this that will be instanciated and its method called within the first activity's onCreate().

But maybe I just don't understand You question...

EDIT: try reading through this problem: Can I download an SQLite db on /sdcard and access it from my Android app?

Upvotes: 0

Related Questions