Dynadot

Remote posting to WP via XML-RPC

Spaceship Spaceship
Watch
Hey everyone

I am struggling to add tags and an Excerpt to my remotely published posts. The script is working fine, except it doesn't add these. Does anyone have any suggestions?

Here is my code so far:

PHP:
<?php
$user = "root";
$pass = "";
$host = "localhost";
$dbname = "dbname";
mysql_connect("$host", "$user", "$pass") or die(mysql_error()); 
mysql_select_db("$dbname") or die(mysql_error());
$query = "SELECT * FROM table where id='1'";
$result = mysql_query($query) or die(mysql_error());

$rpcurl = "http://localhost/wp/xmlrpc.php";

while($get = mysql_fetch_array($result)){
$title = $get['name'];
$body = $get['article'];
$excerpt = $get['summary'];
$tags = $get['keywords'];
$username = "username";
$password = "pass";
$categories = "4";

$XML = "<title>$title</title>".
"<category>$categories</category>".
"<mt_excerpt>$excerpt</mt_excerpt>".
"<mt_keywords>$tags</mt_keywords>".
$body;

$params = array('','',$username,$password,$XML,1);
$request = xmlrpc_encode_request('blogger.newPost',$params);

$ch = curl_init();
curl_setopt($ch, CURLOPT_POSTFIELDS, $request);
curl_setopt($ch, CURLOPT_URL, $rpcurl);
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
curl_setopt($ch, CURLOPT_TIMEOUT, 1);
curl_exec($ch);
curl_close($ch);
}
?>

Cheers
 
0
•••
The views expressed on this page by users and staff are their own, not those of NamePros.
Back