Android Question Download SQLite files using PHP

[LucaMs]

I searched everywhere (mostly on StackOverflow) without success.

Is there a way to download SQLite files using PHP from a classic free hosting space (Altervista, in my case)?


[I cannot use FTP because there is no way to protect files to be deleted]


Thank you

 

[sorex]

I don't see why it shouldn't work.

worst case you need to zip it as it might block the extention or because it has no extention at all.

 

[LucaMs]

I don't see why it shouldn't work.

worst case you need to zip it as it might block the extention or because it has no extention at all.

I'm trying. Now I can download the SQLite file (not zipped) but it seems to be corrupted (the orginale, on site, is ok, of course).

 

[sorex]

you'll need to force a binary header to make sure it doesn't corrupt.

header('Content-Transfer-Encoding: binary');

 

[LucaMs]

you'll need to force a binary header to make sure it doesn't corrupt.

header('Content-Transfer-Encoding: binary');

Done but same result

Thank you

 

[sorex]

zip it up then and extract in the app

 

[LucaMs]

zip it up then and extract in the app

Right now an italian member managed to get the correct file.
I suppose my php is wrong, probably the length set:

header('Content-Length: ' . filesize($File));

 

[sorex]

it should set it automatically. maybe you need an additional content type to make it work right.

 

[sorex]

by the way... if you store the file first on your server you can just use the header function to redirect to the url of the file which downloads the file without the misery of setting the right headers.

 

[LucaMs]

Now I can download a correct SQLite file; but why?

Now I moved the script file to the same folder where the file to download is.

But before, having that file (modified) in a different folder, the script found the file anyway, it was downloaded but it was corrupt!

I don't know

Now I have to create a b4a client; will I have other problems? SURE


Thank you.

 

[LucaMs]

Now I have to create a b4a client; will I have other problems? SURE

Done in 2 minutes and it works at first attempt!

Really incredible