free wifi hotspot database, how ?

[jalle007]

The idea is to create database app that holds all wifi hotspots that have free access or some shared password

Planned app features are:

* use osmDroid map to add markers of free wifi hotspots.
* enable user to upload added markers to remote DB
* enable user to download markers added by other users
* retrieve all markers and show it on the map even if there is no internet connection


The problem I face is app logic in general:

* hotspot should not be maliciously modified
for this I plan to allow only registered users to change wifi details
* database should be two-way synchronized with remote DB
still did not find any sample how to do this. (eg. SQLite <> MSSQL)


similar app can be found here
https://play.google.com/store/apps/details?id=com.jiwire.android.finder


All comments are welcome :sign0089:
and please sry for my bad english

 

[Mark Read]

Hello jalle007,

the database is not difficult. You will need a server somewhere with MySQL and PHP. This will hold the database. Two tables would be required:

1. Marker information.
2. Username and password.

Allow the user to login and then you can update (or synch) the info using a timer.

Showing the markers on a map without internet access, I am not sure about. Do you mean using the Maps app? Never tried that but I am sure the forum or Erel can help.

This is all very similar to my chat app, which I am developing for my children. If it will help, I will give you all the files, including the PHP. My app is not finished yet but it is working.

Best regards
Mark

 

[jalle007]

Hi Mark

Many thanks for comments and suggestions.
I would really like to see your app code specially part which handles database synchronization.

 

[Mark Read]

No problem.

Here is the code and the php files which I am using. The database is on a local server (I have removed the IP as it is possible to reach it externally as well).

Password protection is not yet implemented.

Libraries: Core, Dialogs, HTTP, JSON, Network, Phone, StringUtils

Hope this helps.
Regards
Mark

 

[jalle007]

@Mark
Just found time to go through the code and
I must it looks very good. It is very well formatted and clean.

Keep running and I hope you finish your app soon :sign0137: