I was building a database in WordPress but their table interface lacks completely and I dont want to spend 200 hours developing a backend for a once-off project.
I always used MsAccess for RAD blueprinting and I reckon you can build a better more flexible interface in 20 hours. With XHR MsAccess has some better internet capabilities these days, a nice simple XMLHttp library.
You can use it for any http rest api in the cloud.
Ajax for Access :) here’s the most basic wordpress xml-rpc call, sayHello.
-
Sub PutXML()
-
-
txtURL = "http://www.blog.com/xmlrpc.php"
-
txtUserName = "user"
-
txtPassword = "pwd"
-
-
Dim objSvrHTTP As ServerXMLHTTP
-
Dim strT As String
-
Set objSvrHTTP = New ServerXMLHTTP
-
-
objSvrHTTP.Open "POST", txtURL, False, CStr(txtUserName), _
-
CStr(txtPassword)
-
-
objSvrHTTP.setRequestHeader "Accept", "application/xml"
-
objSvrHTTP.setRequestHeader "Content-Type", "application/xml"
-
-
strT = ""
-
strT = strT & "<methodcall>"
-
strT = strT & "<methodname>demo.sayHello</methodname>"
-
strT = strT & "</methodcall>"
-
-
objSvrHTTP.send strT
-
-
MsgBox objSvrHTTP.responseText
-
-
End Sub
For pre-Vista you need the MSXML 6.0 library from microsoft, in Vista I already had it installed so you can add a reference to the library and off you go.
Does 5ubliminal have anything that you can use? He’s built some pretty extensive WordPress API’s.
http://blog.5ubliminal.com/topics/wordpress/xmlrpc-api/
Yeah, I know. He uses PHP, afaik, but since he moved the blog I haven’t seen what he’s been doing, I keep getting blank pages :)
I wouldn’t trust 5ubliminal’s coding too much.
Try adding a comment on his website using Firefox and you’ll see what I mean!
Juust, very informative site, thank dude!
I have a question regarding your postings on xmlrpc via vba:
I used your code from this post and from http://www.juust.org/index.php/more-vba-and-wordpress-xml-rpc/2009/10/ as the basis of a vba function to make posts to my wordpress blog from MS Office applications (using blogger_newpost), however I keep getting errors back from wp xlmrpc.
faultCode
-32700
faultString
parse error. not well formed
I assume the error relates to the formatting of my xml params structure.
Would you be able to do a post on a generic function to make a post from any office app to a wordpress blog.
Thanks
Ael
Hai Ael, I worked out a quick one using metaWeblog.newPost, WordPress supports it and it has more options (vba source is on the server).