limit displayed photos within index to tag selection
[phpfspot.git] / phpfspot.class.php
index 379ad98f5c8b28354cc5a95b48549a443e0d5eff..168d08134fc5b3461a24b23d222dc47bca7802de 100644 (file)
@@ -186,6 +186,40 @@ class PHPFSPOT {
 
    } // 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()
+   {
+
+      foreach($this->getAllTagPhotos() as $photo)
+      {
+         print "<img src=\"phpfspot_img.php?idx=". $photo ."&amp;width=". $this->cfg->thumb_width ."\" /><br />\n";
+      }
+
+   } // showPhotoIndex()
+
 }
 
 ?>