Created
December 15, 2009 14:23
-
-
Save seanho/256970 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> | |
| <html xmlns="http://www.w3.org/1999/xhtml"> | |
| <head> | |
| <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> | |
| <title>Untitled Document</title> | |
| <style type="text/css"> | |
| <!-- | |
| body { | |
| background-color: #FCF8E0; | |
| margin-left: 10px; | |
| margin-top: 0px; | |
| margin-right: 0px; | |
| margin-bottom: 0px; | |
| } | |
| --> | |
| </style> | |
| <link href="style.css" rel="stylesheet" type="text/css" /> | |
| <style type="text/css"> | |
| <!-- | |
| --> | |
| </style> | |
| </head> | |
| <body> | |
| <br /><table width="100%" border="0" cellspacing="0" cellpadding="0"> | |
| <tr> | |
| <td width="60%" valign="top"> | |
| <!--<a href="hkba.pls" target="_blank" class="Archives_link"><img src="http://www.hkba.hk/cn/ph/doc/newba_hearings_banner_c.jpg"><br>直播新界區公聽會</a><br><br>--> | |
| <?php | |
| $latest_date; | |
| try | |
| { | |
| $db = new PDO("sqlite:talkonly.sqlite"); | |
| $sql = "SELECT MAX(list_id) AS latest_id FROM play_items"; | |
| foreach ($db->query($sql) as $row) | |
| { | |
| $latest_date = $row['latest_id']; | |
| } | |
| $db = null; | |
| } | |
| catch (PDOException $e) | |
| { | |
| // | |
| } | |
| $year = substr($latest_date, 0, 4); | |
| $month = substr($latest_date, 4, 2); | |
| $day = substr($latest_date, 6, 2); | |
| ?> | |
| <strong class="Archives_text"><?=$year."-".$month."-".$day ?> 講台 talkonly</strong><br> | |
| <!--<a href="http://listen.talkonly.net/TALKONLY/TALK-20060331/podcast_talkonly.060331.mp3" class="Archives_link"><font color=red>推介精華版：Area 89(31/3)</font></a><br>--> | |
| <br> | |
| <?php | |
| try | |
| { | |
| $db = new PDO("sqlite:talkonly.sqlite"); | |
| $sql = "SELECT * FROM play_items WHERE list_id=$latest_date ORDER BY list_id DESC, item_id ASC"; | |
| foreach ($db->query($sql) as $row) | |
| { | |
| echo "<a href='".$row['url']."' class='Archives_link'>".$row['caption']."</a><br>"; | |
| } | |
| $db = null; | |
| } | |
| catch (PDOException $e) | |
| { | |
| // | |
| } | |
| ?> | |
| <select onChange="var opt=this.options[selectedIndex].value; if(opt!='0') location.href=opt" class="blackone"> | |
| <option value="http://listen.talkonly.net/download.php?get=">其他重溫</option> | |
| <option value="http://listen.talkonly.net/download.php?get=">-------------------------------------------------</option> | |
| <?php | |
| try | |
| { | |
| $db = new PDO("sqlite:talkonly.sqlite"); | |
| $sql = "SELECT * FROM play_items WHERE list_id<$latest_date ORDER BY list_id DESC, item_id ASC"; | |
| foreach ($db->query($sql) as $row) | |
| { | |
| $year = substr($row['list_id'], 2, 2); | |
| $month = substr($row['list_id'], 4, 2); | |
| $day = substr($row['list_id'], 6, 2); | |
| echo "<option value='".$row['url']."'>".$year."/".$month."/".$day." - ".$row['caption']."</option>"; | |
| } | |
| $db = null; | |
| } | |
| catch (PDOException $e) | |
| { | |
| // | |
| } | |
| ?> | |
| </select> | |
| </td> | |
| <td width="40%" valign="top"><script type="text/javascript"><!-- | |
| google_ad_client = "pub-8100739972808816"; | |
| google_ad_width = 120; | |
| google_ad_height = 240; | |
| google_ad_format = "120x240_as"; | |
| google_ad_type = "text_image"; | |
| google_ad_channel ="9894415569"; | |
| google_color_border = "000000"; | |
| google_color_bg = "FFFFFF"; | |
| google_color_link = "0000FF"; | |
| google_color_text = "000000"; | |
| google_color_url = "008000"; | |
| //--></script> | |
| <script type="text/javascript" | |
| src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> | |
| </script></td> | |
| </tr> | |
| </table> | |
| </body> | |
| </html> |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment