Tweet
Hi all ..
I am looking for some general guidance on what approach to take to build an interface between my program suite and a web page.
In brief, my principle project in PowerBasic (originally in TurboBasic, then PB for DOS, now mostly in CC but some in PBWin) is a suite of programs for managing an event involving around 100 teams of 4 to 7 members.
We would like to create near real time links between my bespoke database and a web page that will allow users to view some status of the event, and to update some data which will be fed back to the event database.
We have someone with skills in PHP / MySQL required to do the dynamic web pages, the area I need to explore is how to pass updates from the website back end MySQL DB to my PB DB, and vice versa.
The volume of data is small -- total DB is some 100kb, and we only need to copy a subset of this -- and the update frequency dosnt need to be more than once a minute .. in fact once in 5 minutes would be acceptable.
I have considered the following:
1) ftp files between local and web, but this gives rise to issues of data integrity and overwriting updates.
2) build a "hidden" http: page with a form that my program can populate and get MySQL to make the updates to its DB.. I could also "read" a web page of data to be downloaded. However I dont know how to approach this in PB - direct or using a browser? I have used POP before but this is somewhat different.
3) Any other approaches??
Many thanks for your time in considering this request!
Andy Upton
I am looking for some general guidance on what approach to take to build an interface between my program suite and a web page.
In brief, my principle project in PowerBasic (originally in TurboBasic, then PB for DOS, now mostly in CC but some in PBWin) is a suite of programs for managing an event involving around 100 teams of 4 to 7 members.
We would like to create near real time links between my bespoke database and a web page that will allow users to view some status of the event, and to update some data which will be fed back to the event database.
We have someone with skills in PHP / MySQL required to do the dynamic web pages, the area I need to explore is how to pass updates from the website back end MySQL DB to my PB DB, and vice versa.
The volume of data is small -- total DB is some 100kb, and we only need to copy a subset of this -- and the update frequency dosnt need to be more than once a minute .. in fact once in 5 minutes would be acceptable.
I have considered the following:
1) ftp files between local and web, but this gives rise to issues of data integrity and overwriting updates.
2) build a "hidden" http: page with a form that my program can populate and get MySQL to make the updates to its DB.. I could also "read" a web page of data to be downloaded. However I dont know how to approach this in PB - direct or using a browser? I have used POP before but this is somewhat different.
3) Any other approaches??
Many thanks for your time in considering this request!
Andy Upton
Glad it helped.
Comment