-
Notifications
You must be signed in to change notification settings - Fork 1
/
indexrss.php
35 lines (28 loc) · 1.08 KB
/
indexrss.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
<?php header("Content-type: text/xml"); ?>
<?php echo "<?xml version=\"1.0\" encoding=\"UTF-8\" ?>"?>
<?
require_once("./birdwalker.php");
// Sat, 07 Sep 2002 00:00:01 GMT
$numberOfTrips = 10;
$latestTrips = performQuery("Find latest trips", "select *, date_format(Date, '%a, %d %b %Y %T GMT') AS niceDate from trip order by Date desc limit " . $numberOfTrips);
?>
<rss version="2.0">
<channel>
<title>birdWalker</title>
<link>http://sven.spflrc.org/~walker/index.php</link>
<description>Mary and Bill's birding field notes and photos</description>
<language>en-US</language>
<generator>birdWalker</generator>
<? for ($index = 0; $index < $numberOfTrips; $index++)
{
$info = mysql_fetch_array($latestTrips); ?>
<item>
<pubDate><?= $info["niceDate"] ?></pubDate>
<title><?= $info["name"] ?></title>
<category>trip</category>
<link>http://sven.spflrc.org/~walker/tripdetail.php?tripid=<?=$info["id"]?></link>
<description><?= htmlentities($info["notes"]) ?></description>
</item>
<? } ?>
</channel>
</rss>