How to create an XML Sitemap from MYSQL? Multi XML Sitemap

How to create an XML Sitemap from MYSQL? Multi XML Sitemap
It is very important to submit xml site map to google search console. Create a file like sitemap.php and add following codes inside. <?php header("Content-Type: application/xml; charset=utf-8"); echo '<?xml version="1.0" encoding="UTF-8" ?>' . PHP_EOL; ?> <?php echo'<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">'; ?> <?php $conn=mysqli_connect("localhost","Username","Password","Database"); ?> <?php $perpage = 4999; if(isset($_GET["page"])){ $page = intval($_GET["page"]); } else { $page = 1; } $calc = $perpage * $page; $start = $calc - $perpage; $result = mysqli_query($conn, "select * from code Limit $start, $perpage"); $rows = mysqli_num_rows($result); if($rows){ $i = 0; while($post = mysqli_fetch_assoc($result)) { $stite=$post['title']; $stitle=strtolower("$stite"); $stitle=str_replace(" ","-","$stitle"); $stitle=str_replace("<","","$stitle"); $stitle=str_replace(">","","$stitle"); $stitle=str_replace("&","","$stitle"); ?> <url><loc>https://yourdomain.com/slug/<?php echo $post["id"]; ?>-<?php echo $stitle; ?></loc></url> <?php } } ?> </urlset> Then create a file like sitemaps.php and add following codes inside file. <?php $conn=mysqli_connect("localhost","Userman","Password","Database"); ?> <?php $perpage = 4999; if(isset($_GET["page"])){ $page = intval($_GET["page"]); } else { $page = 1; } $calc = $perpage * $page; $start = $calc - $perpage; $result = mysqli_query($conn, "select * from code Limit $start, $perpage"); $rows = mysqli_num_rows($result); if($rows){ $i = 0; while($post = mysqli_fetch_assoc($result)) { ?> <?php } } ?> <?php header("Content-Type: application/xml; charset=utf-8"); echo '<?xml version="1.0" encoding="UTF-8" ?>' . PHP_EOL; ?> <?php echo'<sitemapindex xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">'; ?> <?php if(isset($page)) { $result = mysqli_query($conn,"select Count(*) As Total from code"); $rows = mysqli_num_rows($result); if($rows) { $rs = mysqli_fetch_assoc($result); $total = $rs["Total"]; } $totalPages = ceil($total / $perpage); if($page <=1 ){ } else { $j = $page - 1; } for($i=1; $i <= $totalPages; $i++) { if($i<>$page) { echo "<sitemap><loc>https://yourdomain.com/sitemap-$i.xml</loc></sitemap> "; } else { echo "<sitemap><loc>https://yourdomain.com/sitemap-$i.xml</loc></sitemap> "; } } if($page == $totalPages ) { } else { $j = $page + 1; } } ?> <?php echo'</sitemapindex>'; ?> Edit your .htaccess file. Add following codes inside file RewriteEngine On RewriteBase / RewriteRule ^sitemaps.xml$ sitemaps.php RewriteRule ^sitemap-(.+).xml$ sitemap.php?page=$1

How to create an XML Sitemap from MYSQL? Multi XML Sitemap

It is very important to submit xml site map to google search console.

Create a file like sitemap.php and add following codes inside.

<?php
header("Content-Type: application/xml; charset=utf-8");
echo '<?xml version="1.0" encoding="UTF-8" ?>' . PHP_EOL;
?>
<?php echo'<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">';
?>
<?php
$conn=mysqli_connect("localhost","Username","Password","Database");
?>
<?php
$perpage = 4999;
if(isset($_GET["page"])){
$page = intval($_GET["page"]);
}
else {
$page = 1;
}
$calc = $perpage * $page;
$start = $calc - $perpage;
$result = mysqli_query($conn, "select * from code Limit $start, $perpage");
$rows = mysqli_num_rows($result);
if($rows){
$i = 0;
while($post = mysqli_fetch_assoc($result)) {
$stite=$post['title'];
$stitle=strtolower("$stite");
$stitle=str_replace(" ","-","$stitle");
$stitle=str_replace("<","","$stitle");
$stitle=str_replace(">","","$stitle");
$stitle=str_replace("&","","$stitle");
?>
<url><loc>https://yourdomain.com/slug/<?php echo $post["id"]; ?>-<?php echo $stitle; ?></loc></url>
<?php
}
}
?>
</urlset>

Then create a file like sitemaps.php and add following codes inside file.

<?php
$conn=mysqli_connect("localhost","Userman","Password","Database");
?>
<?php
$perpage = 4999;
if(isset($_GET["page"])){
$page = intval($_GET["page"]);
}
else {
$page = 1;
}
$calc = $perpage * $page;
$start = $calc - $perpage;
$result = mysqli_query($conn, "select * from code Limit $start, $perpage");
$rows = mysqli_num_rows($result);
if($rows){
$i = 0;
while($post = mysqli_fetch_assoc($result)) {
?>
<?php
}
}
?>
<?php
header("Content-Type: application/xml; charset=utf-8");
echo '<?xml version="1.0" encoding="UTF-8" ?>' . PHP_EOL;
?>
<?php echo'<sitemapindex xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">'; ?>
<?php
if(isset($page))
{
$result = mysqli_query($conn,"select Count(*) As Total from code");
$rows = mysqli_num_rows($result);
if($rows)
{
$rs = mysqli_fetch_assoc($result);
$total = $rs["Total"];
}
$totalPages = ceil($total / $perpage);
if($page <=1 ){
}
else
{
$j = $page - 1;
}
for($i=1; $i <= $totalPages; $i++)
{
if($i<>$page)
{
echo "<sitemap><loc>https://yourdomain.com/sitemap-$i.xml</loc></sitemap>
";
}
else
{
echo "<sitemap><loc>https://yourdomain.com/sitemap-$i.xml</loc></sitemap>
";
}
}
if($page == $totalPages )
{
}
else
{
$j = $page + 1;
}
}
?>
<?php echo'</sitemapindex>'; ?>

Edit your .htaccess file. Add following codes inside file

RewriteEngine On
RewriteBase /
RewriteRule ^sitemaps.xml$ sitemaps.php
RewriteRule ^sitemap-(.+).xml$ sitemap.php?page=$1

Published:	November 15, 2022
Author:	admin
Category:	Full Tutorials
Views:	28

Leave a Reply Cancel reply