Subject |
Http: Response into my local software |
From |
Michael <michael@abstractservices.com.au> |
Date |
Sun, 17 Sep 2017 03:54:41 -0400 |
Newsgroups |
dbase.getting-started |
Hi Guys,
I have been looking for an easy way to send and retrieve data from a hosted server mysql table and process locally. I have been studying running an Mysql database but I see too many steps and parameters to make it functional for my software.
Recently I discovered the OLEautoclient(ADODB.stream) used by google to retrieve images through dbase.
// Google API Call -- don't change this address:
cURL = "https://chart.googleapis.com/chart" // POST do not use ?
// max size is 520?
cPar = "chs="+nSize+"x"+nSize+"&cht=qr&chl=" + cStr // image format 520x520
objHttp = new OleAutoClient("Msxml2.XMLHTTP")
objHttp.open("POST",cURL,false)
objHttp.setRequestHeader("Content-Type", "application/x-www- form-urlencoded")
objHttp.send(cPar)
if not empty(objHttp.responseText)
objStream = new OleAutoClient("ADODB.Stream")
objStream.Open()
objStream.Type = 1 // adTypeBinary
objStream.Write(objHttp.responseBody)
objStream.SaveToFile(cImg,2) //adSaveCreateOverWrite = 2
objStream.Close()
else
*? "Login Failed! " + datetime()+cImg
endif
I already have a database driven website and scripts in php for a portal I have set up for my clients. I just want to update and recieve some data when I run my local software.
I can pass parameters up to the server, so have no problems to run php pages that can create and insert records. The problem I have is how can I retrieve data from an executed script/webpage back down that I can read from my software. I can read the physical page but not the executed result.
Does anyone know how I can receive the results?
The ADODB.Stream is great for receiving graphical binary data but what commands and or does anyone have any source to show how I can receive the results of my executed sql query on the web.
Please help!
Regards,
Michael.
|
|