MX Kollection Forum :: Show next and previous links

Hello,

Can someone explain to me better how to go about this.

I just created a picture gallery grouped by albums and the full sized image is show like this url parameter:

show_picture.php?album_id=x&picture_id=y

I want to be able to show next and previous links on this page (ie the page with the full sized image), but restricted to only images that belong to the current album. but because I don't have any repeat regions on the page, I can't figure how to make this work.

Those of u who use facebook would understand what I'm trying to achieve, (though not with the ajax effect, but would love it if i can get something like that too.

2. Apart from that can someone guide me on how I can easily select one of the uploaded pictures in an album to be it's album cover or something like that?

Well an easy way will be to have the photos number correctly then you could put something like at the top

$next = $GET_['y'];

and then make the next link wu=ith the params

&y=<? php echo $next; ?>

sorry I made a topo!

$next = $_GET['y'] + 1;

Thanks jde

However, this solution would not work. The images are placed in one table and referenced with the album_id.

Therefore, if i use this method, +1 to the image id, I might get a non existent image (last record, or deleted record) or recordset not found error because the album_id might be wrong. Eg, even though image_id=7 might exist, it might belong to album_id=3
 and so the recordset would be wrong. Hope u understand what i mean.

Thanks for trying to help though. If u or any one else have other suggestions, please let me know for I'm lost

It's not that hard.

All you need to do is create a recordset to get the correct pictures than apply the "show thumbnail" server behaviour making sure to tick the box to enable the navigation.

Put everything inside a horisontal looper and away you go.

Here is an example of exactly that.
http://stefanocomini.ch/foto.php

In this example I use the same concept except that I added some AJAX display and navigation.
http://smitty.exelwebs.com

The script for this type of display is freely available on the internet and you can even save one f the pages on my example site and look at the source to see how to implement it.

The application of a bit of lateral thinking solves all! You have a table with an SQL which uses the 2 parameters album_id and picture. have 2 other tables one of which says (pseudo code) "where the album_is = xxx and the picture is less than xxx". That will give you the previous. Reverse it and you will get the next.

Hi Fred.

Thanks for the links to the sites you built.

Can you share more light on how to implement such a site like http://smitty.exelwebs.com using Kollection.

I've taken a look at your src code and I see you've used third party scripts. Can you show me what to download and how to integrate this into my current set up?

You can get the script and instructions on how to do it here: http://www.justinbarkhuff.com/lab/lightbox_slideshow/

After you created your thumbnail without the popup change your code like this:

<a href="uploads/<?php echo $row_rs_photos['file']; ?>" rel="lightbox[27 Oct 2007]" title="<?php echo $row_rs_photos['description'];?> - <?php echo $row_rs_photos['date']; ?>"><img src="<?php echo $objDynamicThumb1->Execute(); ?>" alt="<?php echo $row_rs_photos['description']; ?>  " border="0"></a>

Good luck!

Thanks very much Fred.

That was great! After a few minutes, I was up and running. Great code. I wonder what else you have hiding up you sleeve. Thanks.

Thanks also JDE. I'll love to implement your idea on how to move forward and backwards in detail pages. I saw an extension that did not require building extra tables. If there is a way of achieving that pls let me know.

Thanks to you too JDE for helping.

You are welcome Phil,

The answer to everything lies between these three websites:

1. http://www.php.net/
2. http://www.mysql.com/
3. http://www.google.com/

All that MXKollection does is it makes coding repetitive things easier and a lot faster to accomplish.
Anything other than basic lists and insert transactions you need to code yourself or learn to modify  the created code to suit your needs.

MXKollection is very powerful and with a little bit of effort much can be accomplished but without at least a basic understanding of how php and mysql interacts you will forever be stuck with little more than a basic website.

Do yourself a favour and get yourself a book going by the name of "Web Database applications with php and mysql" by O'Reily.
Learn how to use google properly and soon you will be able to code a custom CMS or be able to do something like this http://property.freelancerweb.co.uk/  (still under development) This site is 90% done with Kollection with a little bit of hand coding to get the counters working and calculate the expiry dates on the ads as well as a couple of other odds and ends.