Time to write another XML file with php. Google site map. Google needs a sitemap to complete a more efficient index of your website now. – there is no longer an “add URL” button. Now there is “submit a site map”. It doesn’t respond straight away – but it does register the links contained in a formatted XML file.

Watch your $DBH = new PDO($hostDb, $user, $password);

date_default_timezone_set(‘America/New_York’);

But anyway: the format of the file is then this :

<?xml version="1.0" encoding="UTF-8"?>
  <urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">

  <loc>http://www.weedbox.net</loc>
  <lastmod>2019-05-22</lastmod>
  <changefreq>monthly</changefreq>
  <priority>0.8</priority>
</url>

<url>
<loc>http://weedbox.net/ads/wordpress/wordpress/index.php/2019/05/18/how-to-pray-to-the-son-of-god</loc>
<lastmod>2019-05-18T23:22:52-04:00</lastmod>
<changefreq>weekly</changefreq>
</url>

Create the time format once more:

echo date(‘c’, strtotime($result [“post_modified”]));

‘c’ prints a lot of things, but this as well as ‘c’

2019-05-18T23:22:52-04:00 is directly from the MySQL entry. – ideal. but no different than someone else’s problems.

$ids = array();
while($row = $PTH->fetch()) {                 
$ids[] = $row;     }     
foreach ($ids as list($a)) {  
       /// whatever           
}

If you make any mistakes … I wouldn’t be sure what to look for when selecting a plugin – because they have more complexity than functionality.

To view the full working example try: view-source:http://www.weedbox.net/site.html