Remote posting to WP via XML-RPC

[asgsoft]

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
$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