} } 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); }