Sitemap for php website

<?php 
header("Content-type: text/xml");
echo '<?xml version="1.0" encoding="UTF-8" ?>';
include 'includes/connectdb.php';
?>

<urlset xmlns="http://www.google.com/schemas/sitemap/0.84" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.google.com/schemas/sitemap/0.84 http://www.google.com/schemas/sitemap/0.84/sitemap.xsd">

    <url>
        <loc>http://www.DOMAIN.co.uk/</loc>
        <priority>1.00</priority>
    </url>

    <?php

    $sql = "SELECT * FROM pages WHERE onshow = 1 ORDER BY id ASC";
    $result = mysql_query($sql,$conn);      
    while($row = mysql_fetch_array($result))
    { 
    $filename = stripslashes($row['filename']);
    ?>
    <url>
        <loc>http://www.<?php echo "$domain"; ?>/<?php echo "$filename" ?></loc>
        <changefreq>monthly</changefreq>
        <priority>0.5</priority>
    </url>

 <?php } ?>

</urlset>

Source: stackoverflow.com

Similar codes

0 vote348 views1 answer
Wp wc php if cart page is empty redirect
PHP
1 vote220 views1 answer
Foreign key nullable in laravel
PHP Laravel
0 vote186 views1 answer
Show woocommerce products in the form of table
PHP
1 vote182 views2 answers
Wp cli generate plugin
PHP
14 votes186 views4 answers
Php get current domain
PHP
0 vote222 views1 answer
The Gentlemen -inurl:(htm|html|php|pls|txt) intitle:index.of “last modified” (mp4|wma|aac|avi)
PHP
0 vote176 views1 answer
Your Composer dependencies require a PHP version "><h1>HELLO THERE!</h1>
PHP
0 vote213 views1 answer
How to put external file in laravel listener class
PHP Laravel
5 votes215 views3 answers
Crrate model in laravel
PHP Laravel
1 vote191 views1 answer
Read pdf text php
PHP