×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

API to pass a record from foxpro cpanel mysql table

API to pass a record from foxpro cpanel mysql table

API to pass a record from foxpro cpanel mysql table

(OP)
Dear Experts,

Is there any methods(API) which pass/push/update a cpanel MySQL table a record from FoxPro
ie; when updating FoxPro form it is to send the record to a specific website's cpanel MySQL table.

Regards
MSiddeek.

RE: API to pass a record from foxpro cpanel mysql table

MSideek,

What specific cPanel API function do you want to call? WinHTTP.WinHTTPRequest or MSXML2.ServerXMLHTTP COM classes can be used to execute the call, and JSON libraries like nfJSON @ VFPX to help you parse the result.

If you want to perform CRUD operations on a MySQL database that you normally access via a cPanel installation, then the MySQL server must be accessible through an IP port to which you can set an ODBC connection.

RE: API to pass a record from foxpro cpanel mysql table

I second what Antonia (atlopes) said,

just, when the MySQL database allows remote connection you cannot only use some CRUD Rest API calls via HTTP, you can simply use SQL via an ODBC connection.

I haven't worked with Cpanel, as far as I know it's less than direct access to some webserver but more than FTP. If you can get to the MySQL console via cpanel you may be able to grant access to some user from anywhere or just a specific IP. Your hoster should have a FAQ about such things. It depends on how much control you have. If the MySQL Server is shared among several hosting customers, you likely can't change this, even with root access, as the MySQL service itself may be bound to IP address 127.0.0.1 (localhost).

So anything the MySQL Server executes has to come from localhost. Then you're in the situation you need a REST API. That's not part of MySQL itself, though. So you may need to look into options to establish such an API, which does SQL on the server-side and is used by HTTP Requests from the client-side.

Bye, Olaf.

Olaf Doschke Software Engineering
https://www.doschke.name

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close