wordpress 批量插入数据 关键字

-- phpMyAdmin SQL Dump
-- version phpStudy 2014
-- http://www.phpmyadmin.net
--
-- 主机: localhost
-- 生æˆæ—¥æœŸ: 2022 å¹?07 æœ?13 æ—?09:54
-- æœåŠ¡å™¨ç‰ˆæœ¬: 5.5.53
-- PHP 版本: 5.6.27

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- æ•°æ®åº“: `789wp.com`
--

-- --------------------------------------------------------

--
-- 表的结构 `ms_key`
--

CREATE TABLE IF NOT EXISTS `ms_key` (
  `Key_id` int(11) NOT NULL,
  `Key_words` varchar(255) NOT NULL DEFAULT '',
  `Posts_id` varchar(255) NOT NULL,
  `Key_uri` text NOT NULL,
  `Key_content` longtext NOT NULL,
  `Key_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`Key_id`),
  KEY `zbp_log_TPISC` (`Key_id`,`Key_time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

--
-- è½¬å­˜è¡¨ä¸­çš„æ•°æ® `ms_key`
--

INSERT INTO `ms_key` (`Key_id`, `Key_words`, `Posts_id`, `Key_uri`, `Key_content`, `Key_time`) VALUES
(1, '1', '1|2|3|4|5', '', 'pumps', '0000-00-00 00:00:00'),
(2, '2', '1|2|3|4|5', '', 'pumps', '0000-00-00 00:00:00');

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

<?php
 
 
//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="";
	$postcontent="";
    $id=mysqli_query($link,"select max(Key_id) from ms_key");//得到当前最大信息id以免信息id重复
    $t_result = mysqli_fetch_array($id) ;
    $dataid=$t_result[0]+1; // echo " $dataid";

   $wpidres=mysqli_query($link,"SELECT ID FROM `wp_posts` WHERE `post_status` LIKE 'publish' "); //得到wp 所有发布文章的ID
   $wpid= mysqli_fetch_all( $wpidres ,MYSQLI_ASSOC ) ; 

   // print_r($wpid ) ;


 
//插入关键字
 $keys=file_get_contents("key.txt");  
 $farry=explode("\n", "$keys") ; 
 //$keysc= count($farry)  ;
 

 for($i=0;$i<count($farry);$i++){ 
 $tag=$farry[$i] ;
     
//获取文章ID
  $wpidr=array_rand($wpid,5); //随机获取WP文章ID 
  $Posts_id= '' ;
  foreach ($wpidr as $idvalue) {
  	echo   $wpid [$idvalue][ID] ;
 	 $Posts_id.= $wpid [$idvalue][ID]."|" ;
 }
 //echo "$Posts_id";

  


 $result=mysqli_query($link, "INSERT INTO `ms_key` (`Key_id`, `Key_words`, `Posts_id`, `Key_uri`) VALUES ($dataid, $tag, '$Posts_id', ''); " );
 
 //INSERT INTO `789wp.com`.`ms_key` (`Key_id`, `Key_words`, `Posts_id`, `Key_uri`, `Key_content`, `Key_time`) VALUES ('2', '2', '1|2|3|4|5', '', 'pumps', '0000-00-00 00:00:00');

 echo "$dataid"."<br>" ; 
//echo "$SQL2"."<br>" ; 
  	
  	$dataid=$dataid+1 ;

	} //for
	 
 
  

 mysqli_close($link);
?>