Create Json code from MySQL database with php

Create Json code  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/";

 echo "<pre>";

while($row = mysqli_fetch_array($result))

{

   $row = json_encode($row);

   echo ($row);

   echo "<br/>";

}

?>

 output:

{"0":"json-dynamic-dependent-dropdown-list-using-jquery-and-ajax","page_url":"json-dynamic-dependent-dropdown-list-using-jquery-and-ajax"}
{"0":"live-table-data-edit-delete-using-tabledit-plugin-in-php","page_url":"live-table-data-edit-delete-using-tabledit-plugin-in-php"}
{"0":"create-treeview-with-bootstrap-treeview-ajax-jquery-in-php","page_url":"create-treeview-with-bootstrap-treeview-ajax-jquery-in-php"}
{"0":"bootstrap-multiselect-dropdown-with-checkboxes-using-jquery-in-php","page_url":"bootstrap-multiselect-dropdown-with-checkboxes-using-jquery-in-php"}
{"0":"facebook-style-popup-notification-using-php-ajax-bootstrap","page_url":"facebook-style-popup-notification-using-php-ajax-bootstrap"}
{"0":"modal-with-dynamic-previous-next-data-button-by-ajax-php","page_url":"modal-with-dynamic-previous-next-data-button-by-ajax-php"}
{"0":"how-to-use-bootstrap-select-plugin-with-ajax-jquery-php","page_url":"how-to-use-bootstrap-select-plugin-with-ajax-jquery-php"}
{"0":"how-to-load-csv-file-data-into-html-table-using-ajax-jquery","page_url":"how-to-load-csv-file-data-into-html-table-using-ajax-jquery"}
{"0":"autocomplete-textbox-using-typeahead-with-ajax-php-bootstrap","page_url":"autocomplete-textbox-using-typeahead-with-ajax-php-bootstrap"}
{"0":"export-data-to-excel-in-codeigniter-using-phpexcel","page_url":"export-data-to-excel-in-codeigniter-using-phpexcel"}