一些思路
<?php
// include_once ($_SERVER['DOCUMENT_ROOT']."/cj-includes/cj-config.php");
//include_once ("./cj-includes/url.php");
//
$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');
?>
<?php
$host="https://".$_SERVER['HTTP_HOST'] ;
$sqlc = "select count(*) from `wp_posts`";
$count =mysqli_fetch_array( mysqli_query($link,$sqlc));
//echo $count[0];
$pageSize=2000;
$j=ceil($count[0]/$pageSize) ;
for($i=0;$i<$j;$i++){
$limit= $i*$pageSize;
//生成总的网站地图
$content='<?xml version="1.0" encoding="utf-8"?><sitemapindex xmlns="http://www.sitemaps.org/schemas/sitemap/0.9"><urlset>';
$fp1=fopen("sitemap.xml",'w+'); fwrite($fp1,"$content");
for($ii=0;$ii<$j;$ii++) {
$urls= "<sitemap><loc>".$host."/"."sitemap".$ii.".xml"."</loc></sitemap>\n" ;
fwrite($fp1,"$urls");
} //for
fwrite($fp1,"</urlset>\n</sitemapindex>"); echo "sitemapindex ok \n";
fclose($fp1);
//地图
$sql = "SELECT * FROM `wp_posts` WHERE `post_status` = \"publish\" LIMIT $limit ,$pageSize ";
//SELECT * FROM `wp_posts` WHERE `post_status` = "publish"
$row =mysqli_fetch_array(mysqli_query($link,$sql)) ;
//echo $row[0] ;
$result = mysqli_query($link,$sql);
$intime=@date("Y-m-d" ); //echo $intime;
///xml 头部
$content1='<?xml version="1.0" encoding="UTF-8"?><urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">
';
$fp=fopen("sitemap".$i.".xml",'w+');
fwrite($fp,"$content1"); //写入头部
while($row = mysqli_fetch_array($result)) {
$urls= "<url>
<loc>".$host."/".$row["post_name"] // <loc>".$host."/?p=".$row["ID"]
. "</loc>"
.'<lastmod>'.$intime.'</lastmod>
<changefreq>monthly</changefreq>
<priority>0.8</priority>
</url>
' ;
fwrite($fp,"$urls");
}
fwrite($fp,"</urlset>"); echo "<hr>all map ok\n";
fclose($fp);
} //for
// fwrite($fp,"</urlset>");
// fclose($fp);
echo '<br/><a href="/sitemap.xml">sitemap</a>'
?>