Made a route for MarkersController.php, which returns json, but when I go to the route, I get the following error:
The character encoding of the HTML document has not been declared. The document will be displayed with garbled text in some browser configurations if the document contains characters outside the US-ASCII range. The character encoding of the page must be declared in the document or in the transmission protocol.
My route is as follows:
$app->get('/markers/?', function () use ($app) { $controller = new UF\MarkersController($app); return $controller->getMarkersJSON(); });
MarkersController.php
<!DOCTYPE html> <html lang="en"> <head> {% include 'components/head.html' %} </head> <body> <?php include('DB_INFO.php'); function getMarkersJSON(){ // Opens a connection to a MySQL server. $connection = mysqli_connect($server, $username, $password); if (!$connection) { die('Not connected : ' . mysqli_error());} // Sets the active MySQL database. $db_selected = mysqli_select_db($database, $connection); if (!$db_selected) { die('Can\'t use db : ' . mysqli_error());} // Selects all the rows in the markers table. $query = "SELECT * FROM tester WHERE 1"; $result = mysqli_query($connection, $query); if (!$result) { die('Invalid query: '. mysqli_error()); } $markers = array(); while ($row = mysqli_fetch_assoc($result)) { //Assuming "lat" is column name in tester table. Please change it if required. $lat= $rows['lat']; //Assuming "lng" is column name in tester table. Please change it if required. $lng= $rows['lng']; $markers = array('lat' => $lat, 'lng' => $lng); } echo json_encode($markers); } ?> </body> </html>
source share