limit displayed photos within index to tag selection

[phpfspot.git] / phpfspot.class.php

diff --git a/phpfspot.class.php b/phpfspot.class.php
index 20ab36d2c35bd4a1bf37f497f000dda7b5078edc..168d08134fc5b3461a24b23d222dc47bca7802de 100644 (file)
--- a/phpfspot.class.php
+++ b/phpfspot.class.php
@@ -186,10 +186,34 @@ class PHPFSPOT {
 
    } // resetTags()
 
 
    } // resetTags()
 

+   public function getAllTagPhotos()
+   {  
+      $selected = "";
+      foreach($_SESSION['selected_tags'] as $tag)
+         $selected.= $tag .",";
+      $selected = substr($selected, 0, strlen($selected)-1);
+
+      $tagged_photos = Array();
+
+      $result = $this->db->db_query("
+         SELECT DISTINCT photo_id
+         FROM photo_tags
+         WHERE tag_id IN (". $selected .")
+      ");
+
+      while($row = $this->db->db_fetch_object($result)) {
+         array_push($tagged_photos, $row['photo_id']);
+      }
+
+
+      return $tagged_photos;
+
+   } // getAllTagPhotos()
+

    public function showPhotoIndex()
    {
 
    public function showPhotoIndex()
    {
 

-      foreach($this->avail_photos as $photo)
+      foreach($this->getAllTagPhotos() as $photo)

       {
          print "<img src=\"phpfspot_img.php?idx=". $photo ."&amp;width=". $this->cfg->thumb_width ."\" /><br />\n";
       }
       {
          print "<img src=\"phpfspot_img.php?idx=". $photo ."&amp;width=". $this->cfg->thumb_width ."\" /><br />\n";
       }