wordpress 制作Sitemap一些思路

小小优化师 anny

于 2023-06-21 16:21:45 发布

阅读量230

点赞数

文章标签：数学建模

本文链接：https://blog.csdn.net/q28000/article/details/131330181

版权

一些思路

<?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>'
?>