sitemap in php custom code

 

Here I’ll show you How to create multiple XML sitemap in PHP, As you know you can submit 50,000 URL’s per XML sitemap in google but IF you are working on any product base website and you have 10 lakh products url, And you want to submit al URL’s to google then this method will help you to create dynamic XML sitemap.
sitemap
You know submitting XML sitemap in google webmaster is quickest way to index your web pages in google search and tells google about each pages of your website. You can easily register laks of pages in just one week by this methods.

 

First read this article – How to create dynamic XML sitemap and submit to google web master for indexing

Now you have successfully create your dynamic XML site map and ready to create a file where you can link all your dynamic sitemap So that you could submit this single XML file in google web master and it’ll automatically pull all linked sitemaps.

As you have seen in the example you have books database and need to submit 10 lakh books pages in google web master but you can submit only 50,000 URL’s per sitemap, So in below code I’ll get count of books then break all sitemap in 25,000 urls on each sitemap See following example.

allsitemap.php

<?php
  header('Content-type: application/xml');
  $hostname = "localhost";
$username = "username";
$password = "password";
$dbname = "booksdb";
$con = mysqli_connect($hostname, $username, $password, $dbname);
 $query = "SELECT name, author, id FROM books WHERE  status=1";
    $result = mysqli_query($con, $query);
$count = mysqli_num_rows($result);
$output = "<?xml version='1.0' encoding='UTF-8'?>";
  $output .= "<sitemapindex xmlns='http://www.sitemaps.org/schemas/sitemap/0.9'>";
    for($i=0;$i<=$count;$i+=25000) {
  $output .= "<sitemap>";
  $output .=    "<loc>http://example.com/books/sitemap.php?limit=".$i."</loc>"; // location of sitemaps
  $output .= "</sitemap>";
  }
  echo $output .= "</sitemapindex>";
  exit;

Above code will create multiple sitemaps with 25,000 url’s each. Suppose you have 10 lakh books in database then it’ll create 40 sitemap like this.
OUTPUT:
http://example.com/books/sitemap.php?limit = 0;
http://example.com/books/sitemap.php?limit = 25000;
http://example.com/books/sitemap.php?limit = 50000;
http://example.com/books/sitemap.php?limit = 100000;
.. . . . . . . . . . . . . . .
… . . . . . . . . . . . . . .. . and so on
http://example.com/books/sitemap.php?limit = 900000;
http://example.com/books/sitemap.php?limit = 950000;

chandan

""

PHP Guide
sitemap in php custom code Here I’ll show you How to create multiple XML sitemap in PHP, As you know you can submit 50,000 URL’s per XML sitemap in google but IF you are working on any product base website and you have 10 lakh products url, And you want...