Friday, August 10, 2012

Dbf Files on PHP by Roberto Lopez


Roberto Lopez roberbox@gmail.com
Aug 5 (5 days ago)

to harbour-users
Hi All,

I'm posting this here, because could be of interest for Harbour users.

I'm working in HMGSCRIPT. It is a JavaScript GUI library, created with the goal to allow the programmer use the same logic of desktop applications for web applications.

It handles MySql and dbf files via synchronous xmlhttprequest.

The support for dbf files via PHP scripts is intended for the following situation: Imagine that you have a Harbour based app running in a LAN and shared by various users, and you want to access the same files with a web client. The only thing that you need is to install an AMP server in the machine where the files are located and make the machine available via Internet, then HMGSCRIPT apps and LAN apps could share the same data.

IMPORTANT: I'VE NOT TESTED THE CLASS IN SUCH ENVIRONMENT YET, PLEASE CONSIDER THAT SOME ADJUSTMENTS COULD BE REQUIRED (SPECIALLY REGARDING SHARING AND LOCKING). THERE IS NO SECURITY IMPLEMENTED (YOU MUST DO IT FOR ANY REAL WORLD USE). USE FOR TEST ONLY AND REPORT ANY PROBLEM FOUND ON THIS THREAD. IDEAS AND CODE TO ENHANCE THE CLASS ARE WELCOME.

Since the dbf files support was dropped from PHP standard distributions, I've decided to code from the scratch a new class to do that.

Please, use carefully (specially to write operations) since the code is fully new and must be considered ALPHA.

Operations that set or get the field content handles all  original  dbf data types (character, numeric, logical and date) as strings (See the sample code for more info).


Regards,

Roberto.

No comments:

Post a Comment