<?php
header('Content-Type: application/json');
$servername = "localhost";
$username = "ripno281";
$password = "C4ibiC4B!bcp/Ncl";
$dbname = "ripno281";
$conn = mysqli_connect($servername, $username, $password, $dbname);
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
$sql = $sql = "SELECT * FROM NIMAX_entries ORDER BY tdDate ASC";
$result = mysqli_query($conn, $sql);
$dates = array();
$index = 0;
if ($result && mysqli_num_rows($result) > 0) {
while ($row = mysqli_fetch_assoc($result)) {
$dates[$index] = array(
"date" => $row["tdDate"],
"description" => $row["tdDescription"]
);
$index++;
}
}
echo json_encode($dates);
mysqli_close($conn);
?>