comparison index.php @ 9:fbd8c30c465c

add more RSS feeds; normalize-space in step2.xsl and "a hrefs"; myrss_update.sh now outputs a more complete HTML document to stdout
author paulo@twcdns.fastsearch.net
date Sun, 12 Sep 2010 23:36:32 -0700
parents
children 6d959c2ed416
comparison
equal deleted inserted replaced
-1:000000000000 0:157f599474b5
1 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
2 <HTML>
3 <HEAD>
4 <META NAME="generator" CONTENT="http://txt2tags.sf.net">
5 <LINK REL="stylesheet" TYPE="text/css" HREF="index.css">
6 <TITLE>-[pauloang.com]-</TITLE>
7 </HEAD>
8 <BODY>
9
10 <DIV CLASS="header" ID="header">
11 <H1>-[pauloang.com]-</H1>
12 </DIV>
13
14 <DIV CLASS="body" ID="body">
15 <DL>
16
17 <?php
18
19 include('../login.php');
20 $database = 'pauloang_index';
21
22 $link = mysql_connect('localhost', $username, $password);
23 if (!$link)
24 die('Could not connect to MySQL server: ' . mysql_error());
25
26 $db_selected = mysql_select_db($database, $link);
27 if (!$db_selected)
28 die('Could not select database: ' . mysql_error());
29
30 $query = 'SELECT * FROM Links';
31 $results = mysql_query($query);
32
33 while ($row = mysql_fetch_assoc($results)) {
34 echo '<DT>';
35 echo '<A HREF="'.$row['URL'].'">'.$row['Title'].'</A>';
36 echo '</DT>'."\n";
37 echo '<DD>';
38 echo '<DIV CLASS="index_date">';
39 echo 'First added: '.$row['FirstMod'].' '.'<BR>';
40 echo 'Last modified: '.$row['LastMod'];
41 echo '</DIV>';
42 echo '</DD>'."\n";
43 }
44
45 mysql_free_result($results);
46 mysql_close($link);
47 ?>
48
49 </DL>
50
51 <DIV CLASS="email">
52 <P><A HREF="mailto:pbba13@gmail.com">pbba13@gmail.com</A></P>
53 </DIV>
54
55 </DIV>
56
57 <!-- html code generated by txt2tags 2.4 (http://txt2tags.sf.net) -->
58 <!-- cmdline: txt2tags index.t2t -->
59 </BODY></HTML>