'调用示例
Debug.Print WinInetGet("http://127.0.0.1/index.html")
Debug.Print WinInetPost("http://127.0.0.1/index.php", "UserName=admin")
'上面两个函数都是返回byte数组,如果出现乱码可以通过以下这个函数安指定编码转换一下就可以了。
'比如:
Debug.Print BytesToBstr(WinInetPost("http://127.0.0.1/index.php", "UserName=admin"), "UTF-8")
Public Function BytesToBstr(Bytes, Optional Charset As String)
Dim objstream As Object
Set objstream = CreateObject("ADODB.Stream")
With objstream
.Type = 1
.Mode = 3
.Open
.Write Bytes
.Position = 0
.Type = 2
.Charset = Charset
BytesToBstr = .ReadText
.Close
End With
End Function
Option Explicit
Private Const INTERNET_OPEN_TYPE_PRECONFIG = 0
Private Const INTERNET_OPEN_TYPE_DIRECT = 1
Private Const INTERNET_OPEN_TYPE_PROXY = 3
Private Const scUserAgent = "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1)"
Private Const INTERNET_FLAG_RELOAD = &H80000000
Private Declare Function InternetOpen Lib "wininet.dll" Alias "InternetOpenA" (ByVal sAgent As String, ByVal lAccessType As Long, ByVal sProxyName As String, ByVal sProxyBypass As String, ByVal lFlags As Long) As Long
Private Declare Function InternetOpenUrl Lib "wininet.dll" Alias "InternetOpenUrlA" (ByVal hOpen As Long, ByVal sURL As String, ByVal sHeaders As String, ByVal lLength As Long, ByVal lFlags As Long, ByVal lContext As Long) As Long
Private Declare Function InternetReadFileByte Lib "wininet.dll" Alias "InternetReadFile" (ByVal hFile As Long, ByRef sBuffer As Byte, ByVal lNumBytesToRead As Long, lNumberOfBytesRead As Long) As Integer
Private Declare Function InternetCloseHandle Lib "wininet.dll" (ByVal hInet As Long) As Integer
Private Declare Function HttpQueryInfo Lib "wininet.dll" Alias "HttpQueryInfoA" (ByVal hHttpRequest As Long, ByVal lInfoLevel As Long, ByVal sBuffer As Any, ByRef lBufferLength As Long, ByRef lIndex As Long) As Integer
Const HTTP_QUERY_CONTENT_LENGTH = 5
Const HTTP_QUERY_FLAG_NUMBER = &H20000000
Private Declare Function InternetReadFile Lib "wininet.dll" (ByVal hFile As Long, ByVal sBuffer As String, ByVal lNumBytesToRead As Long, lNumberOfBytesRead As Long) As Integer
Public Declare Sub CopyMemory Lib "kernel32" Alias "RtlMoveMemory" (Destination As Any, Source As Any, ByVal Length As Long)
Private Declare Function InternetConnect Lib "wininet.dll" Alias "InternetConnectA" (ByVal hInternetSession As Long, ByVal lpszServerName As String, ByVal nProxyWebPort As Integer, ByVal lpszUsername As String, ByVal lpszPassword As String, ByVal dwService As Long, ByVal dwFlags As Long, ByVal dwContext As Long) As Long
Private Declare Function HttpOpenRequest Lib "wininet.dll" Alias "HttpOpenRequestA" (ByVal hInternetSession As Long, ByVal lpszVerb As String, ByVal lpszObjectName As String, ByVal lpszVersion As String, ByVal lpszReferer As String, ByVal lpszAcceptTypes As Long, ByVal dwFlags As Long, ByVal dwContext As Long) As Long
Private Declare Function HttpSendRequest Lib "wininet.dll" Alias "HttpSendRequestA" (ByVal hHttpRequest As Long, ByVal sHeaders As String, ByVal lHeadersLength As Long, ByVal sOptional As String, ByVal lOptionalLength As Long) As Boolean
Private Declare Function HttpAddRequestHeaders Lib "wininet.dll" Alias "HttpAddRequestHeadersA" (ByVal hHttpRequest As Long, ByVal sHeaders As String, ByVal lHeadersLength As Long, ByVal lModifiers As Long) As Integer
Private Function IsNullBytes(ByRef sBytes() As Byte) As Boolean
On Error Resume Next
Dim N As Long
N = UBound(sBytes())
If Err Then
IsNullBytes = True
End If
End Function
'Get
Public Function WinInetGet(ByVal sURL As String, Optional ByVal lNewBufferSize As Long = 2048) As Byte()
Dim bBuffer() As Byte
Dim lBufferSize As Long
Dim retBytes() As Byte
Dim hOpen As Long
Dim hOpenUrl As Long
Dim hQuery As Long
Dim lFileSize As Long
Dim sQuery As String
Dim i As Long
Dim lBufferNumber As Long
Dim lRealFileLen As Long
Dim bDoLoop As Boolean
Dim lNumberOfBytesRead As Long
Dim BSize As Long
On Error GoTo FindErr
If lNewBufferSize <> 2048 Then
lBufferSize = lNewBufferSize
If lBufferSize < 1024 Then lBufferSize = 1024
Else
lBufferSize = lNewBufferSize
End If
ReDim bBuffer(lBufferSize - 1) As Byte
hOpen = InternetOpen(scUserAgent, INTERNET_OPEN_TYPE_PRECONFIG, vbNullString, vbNullString, 0)
hOpenUrl = InternetOpenUrl(hOpen, sURL, vbNullString, 0, INTERNET_FLAG_RELOAD, 0)
sQuery = String$(1024, " ")
hQuery = HttpQueryInfo(hOpenUrl, HTTP_QUERY_CONTENT_LENGTH, ByVal sQuery, Len(sQuery), 0)
If hQuery Then
lFileSize = CLng(Trim(sQuery))
Else
lFileSize = -1
End If
If lFileSize <> -1 Then
bDoLoop = True
lBufferNumber = Fix(lFileSize / lBufferSize)
If lFileSize Mod lBufferSize <> 0 Then lBufferNumber = lBufferNumber + 1
lRealFileLen = 0
For i = 1 To lBufferNumber
If i < lBufferNumber Then
bDoLoop = InternetReadFileByte(hOpenUrl, bBuffer(0), lBufferSize, lNumberOfBytesRead)
Else
lBufferSize = lFileSize - lBufferSize * (i - 1)
ReDim bBuffer(lBufferSize - 1) As Byte
bDoLoop = InternetReadFileByte(hOpenUrl, bBuffer(0), lBufferSize, lNumberOfBytesRead)
End If
If IsNullBytes(retBytes) Then
ReDim retBytes(UBound(bBuffer))
retBytes = bBuffer
Else
BSize = UBound(retBytes)
ReDim Preserve retBytes(BSize + UBound(bBuffer) + 1)
Call CopyMemory(retBytes(BSize + 1), bBuffer(0), UBound(bBuffer) + 1)
End If
lRealFileLen = lRealFileLen + lNumberOfBytesRead
If Not CBool(lNumberOfBytesRead) Then Exit For
VBA.DoEvents
Next i
Else
i = 0
Do
i = i + 1
bDoLoop = InternetReadFileByte(hOpenUrl, bBuffer(0), lBufferSize, lNumberOfBytesRead)
If lBufferSize <> lNumberOfBytesRead Then
If lNumberOfBytesRead = 0 Or bDoLoop = 0 Then
Exit Do
Else
lBufferSize = lNumberOfBytesRead
ReDim Preserve bBuffer(lBufferSize - 1) As Byte
End If
End If
If IsNullBytes(retBytes) Then
ReDim retBytes(UBound(bBuffer))
retBytes = bBuffer
Else
BSize = UBound(retBytes)
ReDim Preserve retBytes(BSize + UBound(bBuffer) + 1)
Call CopyMemory(retBytes(BSize + 1), bBuffer(0), UBound(bBuffer) + 1)
End If
lRealFileLen = lRealFileLen + lNumberOfBytesRead
VBA.DoEvents
Loop
End If
If hOpenUrl <> 0 Then InternetCloseHandle (hOpenUrl)
If hOpen <> 0 Then InternetCloseHandle (hOpen)
WinInetGet = retBytes
Exit Function
FindErr:
WinInetGet = VBA.vbNullChar
End Function
'Post
Public Function WinInetPost(sURL As String, PostData As String) As Byte()
On Error GoTo Over
Dim IntOpen As Long, IntConnect As Long, XHttpOpenRequest As Long, BRet As Boolean, ScriptName As String, lRealFileLen As Long
If LCase(Left(sURL, 7)) = "http://" Then sURL = Right(sURL, Len(sURL) - 7)
If InStr(sURL, "/") Then
ScriptName = Right(sURL, Len(sURL) - InStr(sURL, "/") + 1)
sURL = Left(sURL, InStr(sURL, "/") - 1)
Else
ScriptName = "/"
End If
lRealFileLen = 0
IntOpen = 0
IntConnect = 0
XHttpOpenRequest = 0
Const INTERNET_OPEN_TYPE_PRECONFIG = 0
IntOpen = InternetOpen(scUserAgent, INTERNET_OPEN_TYPE_PRECONFIG, vbNullString, vbNullString, 0)
If IntOpen <> 0 Then
Const INTERNET_SERVICE_HTTP = 3
Const INTERNET_DEFAULT_HTTP_WebPort = 80
IntConnect = InternetConnect(IntOpen, sURL, INTERNET_DEFAULT_HTTP_WebPort, vbNullString, "HTTP/1.0", INTERNET_SERVICE_HTTP, 0, 0)
If IntConnect <> 0 Then
Const INTERNET_FLAG_RELOAD = &H80000000
XHttpOpenRequest = HttpOpenRequest(IntConnect, "POST", ScriptName, "HTTP/1.0", vbNullString, 0, INTERNET_FLAG_RELOAD, 0)
If XHttpOpenRequest <> 0 Then
Dim HttpHeader As String
Const HTTP_ADDREQ_FLAG_ADD = &H20000000
Const HTTP_ADDREQ_FLAG_REPLACE = &H80000000
HttpHeader = "Content-Type: application/x-www-form-urlencoded" & vbCrLf
BRet = HttpAddRequestHeaders(XHttpOpenRequest, HttpHeader, Len(HttpHeader), HTTP_ADDREQ_FLAG_REPLACE Or HTTP_ADDREQ_FLAG_ADD)
BRet = HttpSendRequest(XHttpOpenRequest, vbNullString, 0, PostData, Len(PostData))
Dim TheLoop As Boolean, RBuffer As String * 2048, ByteNumberRead As Long, IBuffer As String
Dim bBuffer() As Byte, retBytes() As Byte, lBufferSize As Long, BSize As Long, i As Long, lNumberOfBytesRead As Long
lBufferSize = 2048
ReDim bBuffer(lBufferSize - 1) As Byte
i = 0
Do
i = i + 1
TheLoop = InternetReadFileByte(XHttpOpenRequest, bBuffer(0), lBufferSize, lNumberOfBytesRead)
If lBufferSize <> lNumberOfBytesRead Then
If lNumberOfBytesRead = 0 Or TheLoop = 0 Then
Exit Do
Else
lBufferSize = lNumberOfBytesRead
ReDim Preserve bBuffer(lBufferSize - 1) As Byte
End If
End If
If IsNullBytes(retBytes) Then
ReDim retBytes(UBound(bBuffer))
retBytes = bBuffer
Else
BSize = UBound(retBytes)
ReDim Preserve retBytes(BSize + UBound(bBuffer) + 1)
Call CopyMemory(retBytes(BSize + 1), bBuffer(0), UBound(bBuffer) + 1)
End If
lRealFileLen = lRealFileLen + lNumberOfBytesRead
VBA.DoEvents
Loop
WinInetPost = retBytes
BRet = InternetCloseHandle(XHttpOpenRequest)
End If
BRet = InternetCloseHandle(IntConnect)
End If
BRet = InternetCloseHandle(IntOpen)
End If
Exit Function
Over:
WinInetPost = VBA.vbNullChar
End Function