THE END IS NEAR 🙂
For a real-world situation, you should consider, some other things:
Security: You should add an users table and ask for username and password to allow a client app to do anything.
Parse Parameters: The parameters must be parsed: Meaning that (ie) the spaces must be encoded as %20 or ampersands, as %26. This is an easy thing, using StrTran() Harbour function. This is required only in HMG sample (JMG does not required that, since jQuery takes care).
More info here: http://www.w3schools.com/tags/ref_urlencode.asp
Note: Maybe HBTIP includes some function/method to handle this without using StrTran(), if so, please, let me know, Thanks!
Development Machine Setup: As mentioned in the first post, you should install XAMPP bundle (Apache, PHP, MySql and a lot of other things) and JMG in your development machine.
These are the links:
SQL Tables Creation: The tables required for the samples, could be created using the definitions contained in ‘data’ sub-folder of JMG distribution. You only must start ‘PhpMyAdmin’ this way: 127.0.0.1/phpmyadmin select the ‘test’ database, then import and the ‘people.sql’ file in the JMG ‘data’ folder. There is more info in JMG docs.
JMG Demo Sources: Are in JMG distribution. The code related with this tutorial is in AJAX demo section. You should add the ‘echo “ok”;’ at the end of each PHP procedure to match the HMG demo behavior shown in the tutorial.
HMG Demo Sources:
Download “hmg_web_data_demo.7z” From here
Android App!: You can easily convert any JMG app (ie: the main demo) into an Android app, using this utility: https://sourceforge.net/projects/website2apk/ (Thanks Claudio!).
Errata: In the first post, I’ve suggested that the data handling scheme shown in this tutorial, could be good for new apps, since you are not dependent on dbf files, but, in fact, you could convert your dbf files (in the case you are using it) to SQL easily, so, you could upgrade your legacy apps, to this scheme easily. You could look at HMG MySql samples for more about this.
You can discuss about this post on the HMG SourceForge forum Here