Remote posting to WP via XML-RPC

Discussion in 'PHP' started by asgsoft, May 22, 2011.

  1. #1
    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);
    }
    ?>
    PHP:
    Cheers
     
    asgsoft, May 22, 2011 IP
  2. jazzcho

    jazzcho Peon

    Messages:
    326
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    0
    #2
    There was a good PHP library for handling almost everything remotely for WP (paid). I don't remember the name, do a Google search.
     
    jazzcho, May 22, 2011 IP
  3. asgsoft

    asgsoft Well-Known Member

    Messages:
    1,737
    Likes Received:
    34
    Best Answers:
    0
    Trophy Points:
    160
    #3
    I'm sorry but that doesnt help at all!
     
    asgsoft, May 22, 2011 IP