view index.php @ 86:a0fdf2cf1d53

add "selection" feature to life_calendar; fix minor typos in deer_crash
author paulo
date Sat, 17 Sep 2016 00:11:41 -0700
parents 6d959c2ed416
children
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 ORDER BY LastMod DESC';
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 if (($row['LastMod'] != '') && ($row['LastMod'] != $row['FirstMod']))
41 echo 'Last modified: '.$row['LastMod'];
42 echo '</DIV>';
43 echo '</DD>'."\n";
44 }
46 mysql_free_result($results);
47 mysql_close($link);
48 ?>
50 </DL>
52 <DIV CLASS="email">
53 <P><A HREF="mailto:pbba13@gmail.com">pbba13@gmail.com</A></P>
54 </DIV>
56 </DIV>
58 <!-- html code generated by txt2tags 2.4 (http://txt2tags.sf.net) -->
59 <!-- cmdline: txt2tags index.t2t -->
60 </BODY></HTML>