annotate pics/common.php @ 142:2ed8cf5f36bf

myrss2: fix handling of null feed title or links; miscellaneous URL updates
author paulo
date Mon, 18 Dec 2023 20:10:27 +0000
parents 2ede1c948f35
children
rev   line source
paulo@0 1 <?php
paulo@0 2 $thumbs_dir = "thumbs/";
paulo@0 3 $browse_dir = "browse/";
paulo@0 4
paulo@0 5 function listThumbs($thumbs_dir) {
paulo@0 6 $dh = opendir($thumbs_dir);
paulo@0 7 if ($dh) {
paulo@0 8 while (($file = readdir($dh)) !== false) {
paulo@0 9 if (strncmp($file, ".", 1) != 0)
paulo@0 10 $files[] = $file;
paulo@0 11 }
paulo@0 12
paulo@0 13 sort($files, SORT_NUMERIC);
paulo@0 14 foreach ($files as $file)
paulo@5 15 echo '<A HREF="browse.php?id=' . $file . '" NAME="' . $file . '"><IMG SRC="' . $thumbs_dir . $file . '"></A> ' . "\n";
paulo@0 16
paulo@0 17 closedir($dh);
paulo@0 18 }
paulo@0 19 }
paulo@0 20
paulo@0 21 function browse($browse_dir, $thumbs_dir) {
paulo@0 22 include('../../../login.php');
paulo@0 23
paulo@0 24 $database = 'pauloang_pics';
paulo@0 25
paulo@0 26 $link = mysql_connect('localhost', $username, $password);
paulo@0 27 if (!$link)
paulo@0 28 die('Could not connect to MySQL server: ' . mysql_error());
paulo@0 29
paulo@0 30 $db_selected = mysql_select_db($database, $link);
paulo@0 31 if (!$db_selected)
paulo@0 32 die('Could not select database: ' . mysql_error());
paulo@0 33
paulo@0 34
paulo@0 35 foreach ($_GET as $getKey => $getValue) {
paulo@0 36 if ($getKey == "id" && !empty($_GET[$getKey])) {
paulo@0 37 $dh = opendir($browse_dir);
paulo@0 38 if ($dh) {
paulo@0 39 while (($file = readdir($dh)) !== false) {
paulo@0 40 if (strncmp($file, ".", 1) != 0)
paulo@0 41 $files[] = $file;
paulo@0 42 }
paulo@0 43 }
paulo@0 44 closedir($dh);
paulo@0 45
paulo@0 46 sort($files, SORT_NUMERIC);
paulo@0 47 for ($i = 0, $size = sizeof($files); $i < $size; $i++) {
paulo@0 48 if ($files[$i] == $getValue) {
paulo@0 49 if ($i > 0) {
paulo@25 50 echo '<A HREF="browse.php?id=' . $files[$i - 1] . '" ID="prev" accesskey="p">';
paulo@5 51 echo '<IMG SRC="' . $thumbs_dir . $files[$i - 1] . '">';
paulo@0 52 echo '</A>' . "\n";
paulo@0 53 }
paulo@0 54 if ($i < $size - 1) {
paulo@25 55 echo '<A HREF="browse.php?id=' . $files[$i + 1] . '" ID="next" accesskey="n">';
paulo@5 56 echo '<IMG SRC="' . $thumbs_dir . $files[$i + 1] . '">';
paulo@0 57 echo '</A>' . "\n";
paulo@0 58 }
paulo@0 59 echo '<br>' . "\n";
paulo@25 60 echo '<A HREF="./index.php#' . $files[$i] . '" ID="up" accesskey="u">';
paulo@0 61 echo '<IMG SRC="' . $browse_dir . $files[$i] . '"> ';
paulo@0 62 echo '</A>' . "\n";
paulo@0 63
paulo@0 64 $query = 'SELECT * FROM '. basename(getcwd()) . ' WHERE id = "' . $getValue . '"';
paulo@0 65 $results = mysql_query($query);
paulo@0 66
paulo@0 67 if ($results) {
paulo@0 68 $row = mysql_fetch_assoc($results);
paulo@0 69 $caption = $row['caption'];
paulo@0 70 echo '<P>' . $caption . '</P>' . "\n";
paulo@0 71 }
paulo@0 72
paulo@0 73 break;
paulo@0 74 }
paulo@0 75 }
paulo@0 76 break;
paulo@0 77 }
paulo@0 78 }
paulo@0 79 }
paulo@0 80 ?>