VB to a PHP script

NZ_Kiwis

Hey All,

I want to send data from my VB6 application to my remote SQL database. I can not coonect because it's set up to connect to a local not via IP. So I was thinking of sending data to a PHP page and getting that to add it to my SQL DB.

Can this be done? if so how do I get the VB application to connect to the PHP script.

thorpe

This seems an overly complicated way of doing it. If you have the source code to the VB application (which you will need in order to make it send a request to a php script) then why not just modify the applcation to send to a remote database?

NZ_Kiwis

Because the server i'm on is not set up to allow remote sites to conect to it's MySQL database, only local requests work. This can not be changed for several reasons.

Kardall

Then my friend, what you need to do, is figure out how to first:

1) Propogate an HTML send request for use in a website
2) Learn how to connect to a website via Inet or something along those lines.
3) Make sure that whatever you are sending to the internet via php script does NOT need to have any feedback. That is really time consuming to code.

Though not really "in line" with the current website (note it's a php site not VB6) i'll help you out.

Add the inet control to your project, and name it something like well... inet 🙂

Sending the request:

inet.Execute "http://website.com/page.php", "POST", "TEST=TEST", "Content-Type: application/x-www-form-urlencoded"

replace the "http://website.com/page.php" with whatever you want to send... for example. http://website.com/page.php?idx=1&cat=4&format=3

should work 😉