Need help with sending HTTP strings from Access VBA.

[Charles Wilson]

Can someone point me to some good instructions on using the
WinInet.dll functions from VBA?

I need to interact with a MySQL database via HTTP strings.
We already have the database set up and a PHP script that can receive
commands via HTTP. The script receives the HTTP commands and performs
the database actions, then responds with XML.

This system already works when I test it from IE. I simply send it an
HTTP string similar to this:

http://www.myweb.com/tblAdvisories.php?username=UserNameHere&password=PwdHere&query=SELECT%20%2A%20FROM%20tblAdvisories%20WHERE%20contact_id%20%3D%2012

The PHP script executes the query and sends back the results in XML. I
just need to know how to set up the VBA code to send the requests. I
think I must use WinInet functions to do this. Am I correct, or is
there a simpler way to do it, perhaps using ADO?

More info is available if needed.

[Doug Robbins - Word MVP]

Maybe better to ask in one of the Access newsgroups, maybe
microsoft.public.access.internet, but that may not be the most appropriate.
I suggest that you browse through the Access newsgroups to try and determine
which would be the best one for your question or post to a number of the
most likely ones by inserting all of the addressess into the address control
of a single message.
--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

Post by Charles Wilson
Can someone point me to some good instructions on using the
WinInet.dll functions from VBA?
I need to interact with a MySQL database via HTTP strings.
We already have the database set up and a PHP script that can receive
commands via HTTP. The script receives the HTTP commands and performs
the database actions, then responds with XML.
This system already works when I test it from IE. I simply send it an
http://www.myweb.com/tblAdvisories.php?username=UserNameHere&password=PwdHere&query=SELECT%20%2A%20FROM%20tblAdvisories%20WHERE%20contact_id%20%3D%2012
The PHP script executes the query and sends back the results in XML. I
just need to know how to set up the VBA code to send the requests. I
think I must use WinInet functions to do this. Am I correct, or is
there a simpler way to do it, perhaps using ADO?
More info is available if needed.

[Jezebel]

It works the same way using the Inet control: use that entire string as the
'address', and you'll get back whatever the script at the end sends as the
page content.

Post by Charles Wilson
Can someone point me to some good instructions on using the
WinInet.dll functions from VBA?
I need to interact with a MySQL database via HTTP strings.
We already have the database set up and a PHP script that can receive
commands via HTTP. The script receives the HTTP commands and performs
the database actions, then responds with XML.
This system already works when I test it from IE. I simply send it an
http://www.myweb.com/tblAdvisories.php?username=UserNameHere&password=PwdHere&query=SELECT%20%2A%20FROM%20tblAdvisories%20WHERE%20contact_id%20%3D%2012
The PHP script executes the query and sends back the results in XML. I
just need to know how to set up the VBA code to send the requests. I
think I must use WinInet functions to do this. Am I correct, or is
there a simpler way to do it, perhaps using ADO?
More info is available if needed.