- Impact
- 9
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:
Cheers
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