Proper JSON format with PHP
First change your query to
SELECT title_hu,content,created_at FROM `events`
And for creating JSON use
$rows = array();// define array$events = array();// define arraywhile ($row = $result->fetch_assoc()) { $events[] = $row;// assign table data to array }$rows['events'] = $events;// assign your table data and array to an empty arrayecho json_encode($rows, JSON_PRETTY_PRINT);// your final JSON
<?phpheader('Content-Type: application/json');$mysqli = new mysqli("localhost", "root", "", "civitas");if (!$mysqli->set_charset("utf8")) { printf("Error loading character set utf8: %s\n", $mysqli->error); exit();}$events = array('events'=>array());if ($result = $mysqli->query("SELECT title_hu, content, created_at FROM `events`")) { while ($row = $result->fetch_assoc()) { $events['events'][] = $row; } echo json_encode($events, JSON_PRETTY_PRINT);}$result->close();$mysqli->close();
This should do the trick.