<?php
set_time_limit(0);
date_default_timezone_set("PRC");
//insert data sql
$hostdir= $_SERVER['DOCUMENT_ROOT']; //网站根目录
include_once ($hostdir."/wp-config.php");
//echo DB_HOST;
$link=mysqli_connect(DB_HOST,DB_USER,DB_PASSWORD) or die("database connect wrong".mysql_error());//自己设置
mysqli_select_db($link,DB_NAME) or die("database wrong".mysql_error());//自己设置
mysqli_set_charset($link,'utf8');
$datatitle=$title;
$postcontent=$content;
$id=mysqli_query($link,"select max(ID) from wp_posts");//得到当前最大信息id以免信息id重复
$posttitle = $title ;
//print_f( $id) ;
// while($t_result = mysqli_fetch_array($id) ){
// $testarr=$t_result;
// }
// $dataid=$testarr[0]+1;
$testarr = mysqli_fetch_array($id) ;
$dataid=$testarr[0]+1;
$postname = preg_replace("/^[\W]/i","",$url);//把开头为非[\W].替换成空'
$intime=date("Y-m-d H:i:s", time());
$fenlei="$cat_id"; //分类ID
// $dataid= $id + 1;
//$result =$datatitle. $postname. $postcontent . $id ."<hr>" .$intime .$fenlei ;
///////执行入库
$result=mysqli_query($link,"INSERT INTO `wp_posts` (`ID`, `post_author`, `post_date`, `post_date_gmt`, `post_content`, `post_title`, `post_excerpt`, `post_status`, `comment_status`, `ping_status`, `post_password`, `post_name`, `to_ping`, `pinged`, `post_modified`, `post_modified_gmt`, `post_content_filtered`, `post_parent`, `guid`, `menu_order`, `post_type`, `post_mime_type`, `comment_count`) VALUES ($dataid, 1, '$intime', '$intime', '$postcontent', '$posttitle', ' ', 'publish', 'open', 'open', '', '$postname', '', '', '$intime', '$intime', '', 0, '/?p=$dataid', 0, 'post', '', 1) ");
$result2=mysqli_query($link,"INSERT INTO `wp_term_relationships` (`object_id`, `term_taxonomy_id`) VALUES ($dataid, $fenlei) "); //分类
if($result){
//unlink('data.txt');
echo 'yes<br>';
}else{
echo 'error <br>';
}
mysqli_close($link);
?>
