I need to implement this functionality:
1 - user creates HTML file and uploads it to the webserver to
i.e. ../HtmlHome/UserFiles/User_3342/Mydocument3.html OR eventually creates the document (live) on the server
2. User opens my PHP App which uses SQLite and enters a Filename (the path is fixed - see above)
3 - I need to grab that HTML file along with the database, download it to the device and be able to list the documents. when I click on his record it will open appropriate HTML file on Android device. The HTML files will contain links to images only (no external location) but I would like to store images in some separate from HTML folder. No editing on device and no bi-directional updates.
I plan to have a simple UPDATE button which will download and replace existing database (based on the file date).
QUESTIONS:
what is best approach ?
- to store the HTML/IMG files within the database (i.e special field for html code), OR store just reference to the HTML documents.
Another alternative to this is that user will create HTML document local and then upload everything (along with the images) to the server. The problem is that users would only use some super simple tools for creating HTML files (i.e MSWORD, OPEN OFFICE etc.)
The part of this project (PHP App) is implemented on Joomla App so I could use some of its functionality but the data is stored in MySQL so there will be a need for data export/conversion - not sure if it is worth the time..
one more thing....
what would be recommended image files size (kb) to not to overkill the database and Application size ?
I would like to see your views of implementing it - Arthur
1 - user creates HTML file and uploads it to the webserver to
i.e. ../HtmlHome/UserFiles/User_3342/Mydocument3.html OR eventually creates the document (live) on the server
2. User opens my PHP App which uses SQLite and enters a Filename (the path is fixed - see above)
3 - I need to grab that HTML file along with the database, download it to the device and be able to list the documents. when I click on his record it will open appropriate HTML file on Android device. The HTML files will contain links to images only (no external location) but I would like to store images in some separate from HTML folder. No editing on device and no bi-directional updates.
I plan to have a simple UPDATE button which will download and replace existing database (based on the file date).
QUESTIONS:
what is best approach ?
- to store the HTML/IMG files within the database (i.e special field for html code), OR store just reference to the HTML documents.
Another alternative to this is that user will create HTML document local and then upload everything (along with the images) to the server. The problem is that users would only use some super simple tools for creating HTML files (i.e MSWORD, OPEN OFFICE etc.)
The part of this project (PHP App) is implemented on Joomla App so I could use some of its functionality but the data is stored in MySQL so there will be a need for data export/conversion - not sure if it is worth the time..
one more thing....
what would be recommended image files size (kb) to not to overkill the database and Application size ?
I would like to see your views of implementing it - Arthur
