USING A STANDARD WEB SERVER FOR DATA ACCESS WITH HMG AND JMG APPS (PART V/V)

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:

  1. XAMPP: https://www.apachefriends.org/index.html
  2. JMG: https://sourceforge.net/projects/jmg/

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

Advertisements
This entry was posted in Uncategorized. Bookmark the permalink.

5 Responses to USING A STANDARD WEB SERVER FOR DATA ACCESS WITH HMG AND JMG APPS (PART V/V)

  1. bpd2000bpd says:

    unable to download source, any other download link, please

    Like

  2. hmgthinking says:

    The link is working properly. Please, try again. Thanks!

    Like

  3. bpd2000 says:

    My OS is windows server 2003 32 bit, I had installed XAMPP bundle application but receiving error as “Not a Valid Win32 Application”, Kindly guide me

    Like

  4. hmgthinking says:

    Maybe 2003 is not supported by latests XAMPP version?

    Please check that on XAMPP docs.

    Moreover, I’m moving this blog discussions the here: https://sourceforge.net/p/hmg/forum/

    Like

  5. esgici says:

    Thanks Maestro 😀

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s