ζ 修 - Hugo -

在 Google 上面查，發現沒有人提到直接把自己想要的資料，透過自己寫的 PHP 介面直接寫入 Wordpress 資料庫今天就來分享一下囉，使用的方式很簡單，直接在要寫入的地方下：
writewordpressdb($d_subject, $description, $dbname);
$d_subject ← 標題
$description ← 內文
$dbname ← 你 Wordpress 資料庫名稱
下面是 function 的程式碼，找個地方貼上就ok囉，記得要改一下資料庫的設定喔

//寫入Wordpress 資料庫
function writewordpressdb($d_subject, $description, $dbname){

$hostname_conn3 = "你的wordpress資料庫主機位置";
$username_conn3 = "你的資料庫帳號";
$password_conn3 = "你的資料庫密碼";
$database_conn3 = $dbname;
$conn3 = mysql_pconnect($hostname_conn3, $username_conn3, $password_conn3) or trigger_error(mysql_error(),E_USER_ERROR);
mysql_query("SET NAMES 'utf8'");
mysql_select_db($database_conn3, $conn3);

$d_post_author = "1";
//$d_post_date = date("Y-m-d");
//$d_post_date_gmt = date("Y-m-d");
$d_post_content = $description;
$d_post_title = $d_subject;
$d_post_excerpt = cut_str($description,"100");
$d_post_status = "draft"; //設為發佈或草稿 publish or draft
//$d_comment_status = "open";
//$d_ping_status = "closed";
//$d_post_password = "";
$d_post_name = $d_subject;
//$d_to_ping = "";
//$d_pinged = "";
//$d_post_modified = date("Y-m-d");
//$d_post_modified_gmt = date("Y-m-d");
//$d_post_content_filtered = "";
//$d_post_parent = 0;
//$d_guid = "";
//$d_menu_order = 0;
$d_post_type = "post";
//$d_post_mime_type = "";
//$d_comment_count = 0;

$sql="insert into wp_posts(post_author, post_content, post_title, post_excerpt, post_status, post_name, post_type) values ('{$d_post_author}','{$d_post_content}','{$d_post_title}','{$d_post_excerpt}','{$d_post_status}','{$d_post_name}','{$d_post_type}')";

$do_sql = mysql_query($sql, $conn3) or die(mysql_error());
mysql_free_result($do_sql);

echo "文章：".$d_post_title."--寫入完成！預設為草稿，請至後台修改後發佈！
";

}

上面有一些變數被我 // 起來那些都是資料庫的欄位沒用到的，如果要使用在試試看囉。