view index.php @ 6:2be1a035d725

add myrss/step1.xsl
author paulo@twcdns.fastsearch.net
date Sat, 11 Sep 2010 02:49:56 -0700
parents
children 6d959c2ed416
line source
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>
10 <DIV CLASS="header" ID="header">
11 <H1>-[pauloang.com]-</H1>
12 </DIV>
14 <DIV CLASS="body" ID="body">
15 <DL>
17 <?php
19 include('../login.php');
20 $database = 'pauloang_index';
22 $link = mysql_connect('localhost', $username, $password);
23 if (!$link)
24 die('Could not connect to MySQL server: ' . mysql_error());
26 $db_selected = mysql_select_db($database, $link);
27 if (!$db_selected)
28 die('Could not select database: ' . mysql_error());
30 $query = 'SELECT * FROM Links';
31 $results = mysql_query($query);
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 }
45 mysql_free_result($results);
46 mysql_close($link);
47 ?>
49 </DL>
51 <DIV CLASS="email">
52 <P><A HREF="mailto:pbba13@gmail.com">pbba13@gmail.com</A></P>
53 </DIV>
55 </DIV>
57 <!-- html code generated by txt2tags 2.4 (http://txt2tags.sf.net) -->
58 <!-- cmdline: txt2tags index.t2t -->
59 </BODY></HTML>