en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en en nl en en en ru en en en en en en en en en en en en en de en en en en en nl en en en en en en en en en en en en nl en en en en en en en en en en en en en en nl en zh en en en en en en en de en en en fr en en en en en en en en en pt en en en en en en
By logging into your account, you agree to our Privacy Policy, personal data processing and storage practices as described therein.
Forgot password or user name?
Search in titles only Search in Programming the Internet only
You are not logged in. You can browse in the PowerBASIC Community, but you must click Login (top right) before you can post. If this is your first visit, check out the FAQ or Sign Up.
Interfacing with MySQL on a website
All Time Today Last Week Last Month
All Discussions only Photos only Videos only Links only Polls only Events only
Join Date: Dec 2004
Interfacing with MySQL on a website
1 Sep 2009, 12:26 PM
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!
Join Date: Jan 2004
1 Sep 2009, 02:37 PM
Use LibMySQL.DLL from your PB program to access MySQL (Search here for 'libmysql')?
LOCAL MyEMail AS STRING
MyEmail = STRREVERSE$("53pmohtj") & CHR$(64) & STRREVERSE$("liamg") & CHR$(46) & STRREVERSE$("moc")
Join Date: Dec 2004
1 Sep 2009, 05:59 PM
Well that's exactly what I wanted and didn't know what to look for.
2 hours work with the fabulous help of Mike Trader's header files and I have a working test app that allows me to retrieve a table and parse out the data I need.
Join Date: Jan 2004
1 Sep 2009, 08:08 PM
Cool Glad it helped.
LOCAL MyEMail AS STRING
MyEmail = STRREVERSE$("53pmohtj") & CHR$(64) & STRREVERSE$("liamg") & CHR$(46) & STRREVERSE$("moc")
Copyright © 1998-2022 PowerBASIC Tools, LLC - All Rights Reserved.
Powered by vBulletin® Version 5.7.0
Copyright © 2022 vBulletin Solutions, Inc. All rights reserved.
All times are GMT-5. This page was generated at 04:49 AM.
We process personal data about users of our site, through the use of cookies and other technologies, to deliver our services, and to analyze site activity. For additional details, refer to our Privacy Policy.
By clicking "I AGREE" below, you agree to our Privacy Policy and our personal data processing and cookie practices as described therein. You also acknowledge that this forum may be hosted outside your country and you consent to the collection, storage, and processing of your data in the country where this forum is hosted.