php best practice programming example with globle keyword

Create  dynamic sitemap  from MySQL database with php  --
-- Database: `test`
--

-- --------------------------------------------------------

--
-- Table structure for table `page`
--

CREATE TABLE IF NOT EXISTS `page` (
  `page_id` int(11) NOT NULL,
  `page_title` text NOT NULL,
  `page_url` text NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `page`
--

INSERT INTO `page` (`page_id`, `page_title`, `page_url`) VALUES
(1, 'JSON - Dynamic Dependent Dropdown List using Jquery and Ajax', 'json-dynamic-dependent-dropdown-list-using-jquery-and-ajax'),
(2, 'Live Table Data Edit Delete using Tabledit Plugin in PHP', 'live-table-data-edit-delete-using-tabledit-plugin-in-php'),
(3, 'Create Treeview with Bootstrap Treeview Ajax JQuery in PHP\r\n', 'create-treeview-with-bootstrap-treeview-ajax-jquery-in-php'),
(4, 'Bootstrap Multiselect Dropdown with Checkboxes using Jquery in PHP\r\n', 'bootstrap-multiselect-dropdown-with-checkboxes-using-jquery-in-php'),
(5, 'Facebook Style Popup Notification using PHP Ajax Bootstrap\r\n', 'facebook-style-popup-notification-using-php-ajax-bootstrap'),
(6, 'Modal with Dynamic Previous & Next Data Button by Ajax PHP\r\n', 'modal-with-dynamic-previous-next-data-button-by-ajax-php'),
(7, 'How to Use Bootstrap Select Plugin with Ajax Jquery PHP\r\n', 'how-to-use-bootstrap-select-plugin-with-ajax-jquery-php'),
(8, 'How to Load CSV File data into HTML Table Using AJAX jQuery\r\n', 'how-to-load-csv-file-data-into-html-table-using-ajax-jquery'),
(9, 'Autocomplete Textbox using Typeahead with Ajax PHP Bootstrap\r\n', 'autocomplete-textbox-using-typeahead-with-ajax-php-bootstrap'),
(10, 'Export Data to Excel in Codeigniter using PHPExcel\r\n', 'export-data-to-excel-in-codeigniter-using-phpexcel'); 

php  code

<?php
//sitemap.php
$connect = mysqli_connect("localhost", "root", "", "test");

$query = "SELECT page_url FROM page";

$result = mysqli_query($connect, $query);

$base_url = "http://localhost/app/test/sitemap/";

header("Content-Type: application/xml; charset=utf-8");

echo '<?xml version="1.0" encoding="UTF-8"?>'.PHP_EOL;

echo '<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.sitemaps.org/schemas/sitemap/0.9 http://www.sitemaps.org/schemas/sitemap/0.9/sitemap.xsd">' . PHP_EOL;

while($row = mysqli_fetch_array($result))
{
 echo '<url>' . PHP_EOL;
 echo '<loc>'.$base_url. $row["page_url"] .'/</loc>' . PHP_EOL;
 echo '<changefreq>daily</changefreq>' . PHP_EOL;
 echo '</url>' . PHP_EOL;
}

echo '</urlset>' . PHP_EOL;

?>
output

This XML file does not appear to have any style information associated with it. The document tree is shown below.
<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://www.sitemaps.org/schemas/sitemap/0.9 http://www.sitemaps.org/schemas/sitemap/0.9/sitemap.xsd">
<url>
<loc>
http://localhost/app/test/sitemap/json-dynamic-dependent-dropdown-list-using-jquery-and-ajax/
</loc>
<changefreq>daily</changefreq>
</url>
<url>
<loc>
http://localhost/app/test/sitemap/live-table-data-edit-delete-using-tabledit-plugin-in-php/
</loc>
<changefreq>daily</changefreq>
</url>
<url>
<loc>
http://localhost/app/test/sitemap/create-treeview-with-bootstrap-treeview-ajax-jquery-in-php/
</loc>
<changefreq>daily</changefreq>
</url>
<url>
<loc>
http://localhost/app/test/sitemap/bootstrap-multiselect-dropdown-with-checkboxes-using-jquery-in-php/
</loc>
<changefreq>daily</changefreq>
</url>
<url>
<loc>
http://localhost/app/test/sitemap/facebook-style-popup-notification-using-php-ajax-bootstrap/
</loc>
<changefreq>daily</changefreq>
</url>
<url>
<loc>
http://localhost/app/test/sitemap/modal-with-dynamic-previous-next-data-button-by-ajax-php/
</loc>
<changefreq>daily</changefreq>
</url>
<url>
<loc>
http://localhost/app/test/sitemap/how-to-use-bootstrap-select-plugin-with-ajax-jquery-php/
</loc>
<changefreq>daily</changefreq>
</url>
<url>
<loc>
http://localhost/app/test/sitemap/how-to-load-csv-file-data-into-html-table-using-ajax-jquery/
</loc>
<changefreq>daily</changefreq>
</url>
<url>
<loc>
http://localhost/app/test/sitemap/autocomplete-textbox-using-typeahead-with-ajax-php-bootstrap/
</loc>
<changefreq>daily</changefreq>
</url>
<url>
<loc>
http://localhost/app/test/sitemap/export-data-to-excel-in-codeigniter-using-phpexcel/
</loc>
<changefreq>daily</changefreq>
</url>

</urlset>