|
-
Jul 18th, 2016, 06:51 AM
#1
Thread Starter
New Member
Information from remotely hosted SQL database
Hello.
I’m trying to retrieve data using WinHttpRequest from a database. I’m displaying the results from the GET in a text box and I can see the HTML code displayed, but I can’t figure out how to get specific information without displaying the entire html.
Example:
I send my id request like this…
strUrl = "http://mysubdomain.mydomain.com/ admin/admin_login.php?"
xobj.Open "POST", strUrl, False
xobj.SetRequestHeader "User-Agent", "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)"
xobj.SetRequestHeader "Content-Type", "application/x-www-form-urlencoded"
xobj.Send "username=manager&password=mypassword"
I get the results like this…
strUrl = "http://mysubdomain.mydomain.com/ admin/customer_details.php?"
xobj.Open "GET", strUrl, False
The returned body.innerHtml display is…
<B>/homepages/26/dataserver/htdocs/admin/customer_details.php</B> on line <B>39</B><BR><LINK rel=stylesheet type=text/css href="styles/customer_details.css">
<DIV class=page>
<DIV class=top></DIV>
<DIV class=text>Customer Details - ID: 2
<P><A title="Back to the Index" href="about:index.php">Back to the Index</A> - <A href="about:product_list.php">List Customers</A></P>
<DIV class=details>
<TABLE cellPadding=5 width=960 bgColor=#ffffff border=1>
<TBODY>
<TR>
<TD vAlign=middle width=130 align=right>Username:</TD>
<TD width=581>manager2</TD></TR>
<TR>
<TD vAlign=middle align=right>Password:</TD>
<TD>myPa$$word</TD></TR>
<TR>
<TD vAlign=middle align=right>:</TD>
<TD>07 Jul, 2016</TD></TR></TBODY></TABLE></DIV><BR><BR></DIV></DIV>
Question: How can I get the username and password into a string variable?
Thank you.
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|