}
}
echo '}';
}
}
$conn = myUtf8Db($db_servername, $db_username, $db_password, $db_name);
if (!$conn) {
header('X-Error: ' . 'Database connection error, ' . mysqli_connect_error());
http_response_code(500);
die;
}
$stmt = $conn->prepare('SELECT `id`, `from`, `fromAmount`, `fromCurrency`, `to`, `toAmount`, `toCurrency`, `text`, `location`, `date`, `reference` FROM `record` WHERE `date` >= ? AND `date` < ? ORDER BY `date` ASC, `createTime` ASC');
$stmt->bind_param('ss', $start_date, $end_date);
if (!$stmt->execute()) {
header('X-Error: ' . 'Query error, ' . $stmt->error);
http_response_code(500);
die;
}
$result = $stmt->get_result();
$first = true;
echo '[';
while ($data = $result->fetch_assoc()) {
if (!$first) {
echo ',';
} else {
$first = false;
}
printJsonObject($data['id'], $data);
}
echo ']';
$conn->close();
function doGET($conn, $id)
{
$data = getRecord($conn, $id);
printJsonObject($id, $data);
}
