How i can get random photos from only one category?: PHPFusion 8 Support

Home
Search

Oh no! Where's the JavaScript?
Your Web browser does not have JavaScript enabled or does not support JavaScript. Please enable JavaScript on your Web browser to properly view this Web site, or upgrade to a Web browser that does support JavaScript.

I need a panel to show random photos for only one category. How i can do that?

0 replies

Quote

FlancitoW wrote:

I need a panel to show random photos for only one category. How i can do that?

Probably not, do you want to make it or will I make it?

0 replies

Create a new panel and add this into panel content...

Code Download source


// Set Album ID
$album_id = "1";

  $result = dbquery("SELECT photo_id, album_id, photo_title, photo_thumb1 FROM ".DB_PHOTOS." WHERE album_id = '".$album_id."' ORDER BY RAND() LIMIT 1");

   if (dbrows($result) != 0) { 
openside("Random Photo");
   echo "<div align='center'>";
     while($data = dbarray($result)) {
     
     $data_album = dbarray(dbquery("SELECT album_id, album_title FROM ".DB_PHOTO_ALBUMS." where album_id = ".$data['album_id'].""));

     $itemsubject = trimlink($data['photo_id'], 23);
     $itemdescription = trimlink($data['photo_title'], 30);
     $albumname = trimlink($data_album['album_title'], 30);
     echo "<center>".$new."<a href='".BASEDIR."photogallery.php?photo_id=".$data['photo_id']."' title='".$data['photo_title']."' class='side'>";
     echo "<img src='".BASEDIR."images/photoalbum/"."album_".$data['album_id']."/".$data['photo_thumb1']."' border='0' alt='' /><br />".$itemdescription."</a><br />";
     echo "<span class='small'><a href='".BASEDIR."photogallery.php?album_id=".$data['album_id']."' title='".$data_album['album_title']."' class='side'>".$albumname."</a></span></center>";
        }
     echo "</div>";
closeside();
         }

Set album id to suit

0 replies

Great that's it.

0 replies

— 8 months later —

Very good,i like it..but how is prevention some album id..exapmle: i want album id 1,2,3,5 dont want 4

Thanks..

EDIT: Ok! should be same this: AND $album_id!='4'

Now,how to add multiple id? Dou you have any idea about it?
Example:$album_id='1,2' or $album_id!='4,5,6'

Thank you..

Edited by HaYaLeT on 08-05-2012 05:43, 12 y

0 replies

The query needs to be changed. then seperate each album with comma and space in $album_id...

Code Download source

WHERE album_id IN (".$album_id.")

should work. I didn't try...

0 replies

Tyler,thank you for reply.. But how to use it in latest or random contents ?

Example: how to use $album_id='1,2,8' or $album_id!='4,5,6' in latest news,latest images codes?

my latest news codes:

[syntaxhighlighter brush=php,first-line=1,highlight=0,collapse=false,html-script=false]$cat_id1 = "1";
echo '<div class="duyuruarka">
<div id="duyuru">';
$result = dbquery("SELECT tn.*, tc.*, user_id, user_name FROM ".DB_NEWS." tn
LEFT JOIN ".DB_USERS." tu ON tn.news_name=tu.user_id
LEFT JOIN ".DB_NEWS_CATS." tc ON tn.news_cat=tc.news_cat_id
WHERE ".groupaccess('news_visibility'

."
AND (news_start='0'||news_start<=".time()."

AND (news_end='0'||news_end>=".time()."

AND news_draft='0'
AND news_cat_id='$cat_id1'
ORDER BY news_sticky DESC, news_datestamp DESC LIMIT 0,4"

;
if (dbrows($result)) {
while ($data = dbarray($result)) {
echo ' <div class="ic"><a class="haber" href="'.BASEDIR.'news_cats.php?cat_id='.$data['news_cat_id'].'" title="'.$data['news_subject'].'">'.trimlink(stripslashes($data['news_subject']),40).'</a></div>';

}}

echo '</div>
</div>';[/syntaxhighlighter]

0 replies

This is how you set multiple id's
$cat_id1 = "1, 3, 7";

my phone cuts off geshi coding so I couldnt just edit..

find

Code Download source

AND news_cat_id='$cat_id1'

change to

Code Download source

AND news_cat_id IN (".$cat_id1.")

0 replies

That's it,great..Thank you Tyler

dizaynegitim.com/images/smiley/bravo.gif

Can we prevention multiple cat id ?

$cat_id!='4,5,6' (prevention news cat id 4,5 and 6)

Latest news (all cats)

Code Download source

  $result = dbquery("SELECT photo_id, album_id, photo_title, photo_thumb1 FROM ".DB_PHOTOS." WHERE album_id = '".$album_id."' ORDER BY RAND() LIMIT 4");

    if (dbrows($result) != 0) { 
 openside("Random Photo");
    echo "<div align='center'>";
      while($data = dbarray($result)) {
      
      $data_album = dbarray(dbquery("SELECT album_id, album_title FROM ".DB_PHOTO_ALBUMS." where album_id = ".$data['album_id'].""));

      $itemsubject = trimlink($data['photo_id'], 23);
      $itemdescription = trimlink($data['photo_title'], 30);
      $albumname = trimlink($data_album['album_title'], 30);
      echo "<center>".$new."<a href='".BASEDIR."photogallery.php?photo_id=".$data['photo_id']."' title='".$data['photo_title']."' class='side'>";
      echo "<img src='".BASEDIR."images/photoalbum/"."album_".$data['album_id']."/".$data['photo_thumb1']."' border='0' alt='' /><br />".$itemdescription."</a><br />";
      echo "<span class='small'><a href='".BASEDIR."photogallery.php?album_id=".$data['album_id']."' title='".$data_album['album_title']."' class='side'>".$albumname."</a></span></center>";
         }
      echo "</div>";
 closeside();
          }

0 replies

you can simply use

Code Download source

AND news_cat_id NOT IN (".$cat_id1.")

0 replies

Oh, thank you very much..

0 replies

— 1 year later —

I realize this is a old thread but I could really use this for my website but when I paste the code in to panel content it messes up the hole website. Can this be adjusted to work with v7.02.06? and can the image size be set to a specific value?

Quote

HobbyMan wrote:

Create a new panel and add this into panel content...

Code Download source


// Set Album ID
$album_id = "1";

  $result = dbquery("SELECT photo_id, album_id, photo_title, photo_thumb1 FROM ".DB_PHOTOS." WHERE album_id = '".$album_id."' ORDER BY RAND() LIMIT 1");

   if (dbrows($result) != 0) { 
openside("Random Photo");
   echo "<div align='center'>";
     while($data = dbarray($result)) {
     
     $data_album = dbarray(dbquery("SELECT album_id, album_title FROM ".DB_PHOTO_ALBUMS." where album_id = ".$data['album_id'].""));

     $itemsubject = trimlink($data['photo_id'], 23);
     $itemdescription = trimlink($data['photo_title'], 30);
     $albumname = trimlink($data_album['album_title'], 30);
     echo "<center>".$new."<a href='".BASEDIR."photogallery.php?photo_id=".$data['photo_id']."' title='".$data['photo_title']."' class='side'>";
     echo "<img src='".BASEDIR."images/photoalbum/"."album_".$data['album_id']."/".$data['photo_thumb1']."' border='0' alt='' /><br />".$itemdescription."</a><br />";
     echo "<span class='small'><a href='".BASEDIR."photogallery.php?album_id=".$data['album_id']."' title='".$data_album['album_title']."' class='side'>".$albumname."</a></span></center>";
        }
     echo "</div>";
closeside();
         }

Set album id to suit

Edited by Ralph68 on 24-05-2013 06:09, 11 y

0 replies

Category Forum

Modifications and Requests - 8

Labels

None yet

Statistics

Views 0 views
Posts 11 posts
Votes 0 votes
Topic users 6 members

6 participants

Notifications

Track thread

You are not receiving notifications from this thread.

How i can get random photos from only one category?

11 posts

PHPFusion

Resources

Community

Development