Jump to content


Photo

DW Photo Gallery


  • Please log in to reply
No replies to this topic

#1 tgavin

tgavin
  • Members
  • PipPipPip
  • Advanced Member
  • 176 posts
  • LocationNaples, FL

Posted 02 June 2005 - 03:58 AM

I've put together a very simple photo gallery. You can view a list of thumbnails, which when clicked will (duh) show you the larger picture, or you can select a gallery from a pulldown, which will then show you the first large picture in that category, complete with nex/prev pagination.

So photo category '1' has 3 images in it, each with their own id, which makes a total of 3 records in the table.

Okay, so when a user clicks on image 1 thumb, the large pic is displayed. When clicking on the next button, it should move to image 2, but it doesn't. It just refreshes image 1. This happens with any thumb that's clicked. If the user clicks on thumb 5, the large image 5 is displayed, but the pagination doesn't work.

I can't figure out how to get the page to know what record it's on and go from there!

Here's the code for the large pic page, with pagination
[!--PHP-Head--][div class=\'phptop\']PHP[/div][div class=\'phpmain\'][!--PHP-EHead--][span style=\"color:#0000BB\"]<?php [/span][span style=\"color:#007700\"]require_once([/span][span style=\"color:#DD0000\"]\'../Connections/cranes.php\'[/span][span style=\"color:#007700\"]); [/span][span style=\"color:#0000BB\"]?>
<?php
$currentPage [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$_SERVER[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\"PHP_SELF\"[/span][span style=\"color:#007700\"]];

[/span][span style=\"color:#0000BB\"]$maxRows_rs_photogal_imgs [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]1[/span][span style=\"color:#007700\"];
[/span][span style=\"color:#0000BB\"]$pageNum_rs_photogal_imgs [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]0[/span][span style=\"color:#007700\"];
if (isset([/span][span style=\"color:#0000BB\"]$_GET[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'pageNum_rs_photogal_imgs\'[/span][span style=\"color:#007700\"]])) {
  [/span][span style=\"color:#0000BB\"]$pageNum_rs_photogal_imgs [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$_GET[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'pageNum_rs_photogal_imgs\'[/span][span style=\"color:#007700\"]];
}
[/span][span style=\"color:#0000BB\"]$startRow_rs_photogal_imgs [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$pageNum_rs_photogal_imgs [/span][span style=\"color:#007700\"]* [/span][span style=\"color:#0000BB\"]$maxRows_rs_photogal_imgs[/span][span style=\"color:#007700\"];

[/span][span style=\"color:#0000BB\"]mysql_select_db[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$database_cranes[/span][span style=\"color:#007700\"], [/span][span style=\"color:#0000BB\"]$cranes[/span][span style=\"color:#007700\"]);
if (isset([/span][span style=\"color:#0000BB\"]$_GET[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'id\'[/span][span style=\"color:#007700\"]])) {
    [/span][span style=\"color:#0000BB\"]$id [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$_GET[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'id\'[/span][span style=\"color:#007700\"]];
}
[/span][span style=\"color:#0000BB\"]mysql_select_db[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$database_cranes[/span][span style=\"color:#007700\"], [/span][span style=\"color:#0000BB\"]$cranes[/span][span style=\"color:#007700\"]);
if (isset([/span][span style=\"color:#0000BB\"]$_GET[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'cat\'[/span][span style=\"color:#007700\"]])) {
    [/span][span style=\"color:#0000BB\"]$cat [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$_GET[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'cat\'[/span][span style=\"color:#007700\"]];
    [/span][span style=\"color:#0000BB\"]$query_rs_photogal_imgs [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#DD0000\"]\"SELECT * FROM photogal_imgs WHERE category = \'$cat\'\"[/span][span style=\"color:#007700\"];
} else {
    [/span][span style=\"color:#0000BB\"]$query_rs_photogal_imgs [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#DD0000\"]\"SELECT * FROM photogal_imgs WHERE id = \'$id\'\"[/span][span style=\"color:#007700\"];
}
[/span][span style=\"color:#0000BB\"]$query_limit_rs_photogal_imgs [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]sprintf[/span][span style=\"color:#007700\"]([/span][span style=\"color:#DD0000\"]\"%s LIMIT %d, %d\"[/span][span style=\"color:#007700\"], [/span][span style=\"color:#0000BB\"]$query_rs_photogal_imgs[/span][span style=\"color:#007700\"], [/span][span style=\"color:#0000BB\"]$startRow_rs_photogal_imgs[/span][span style=\"color:#007700\"], [/span][span style=\"color:#0000BB\"]$maxRows_rs_photogal_imgs[/span][span style=\"color:#007700\"]);
[/span][span style=\"color:#0000BB\"]$rs_photogal_imgs [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]mysql_query[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$query_limit_rs_photogal_imgs[/span][span style=\"color:#007700\"], [/span][span style=\"color:#0000BB\"]$cranes[/span][span style=\"color:#007700\"]) or die([/span][span style=\"color:#0000BB\"]mysql_error[/span][span style=\"color:#007700\"]());
[/span][span style=\"color:#0000BB\"]$row_rs_photogal_imgs [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]mysql_fetch_assoc[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$rs_photogal_imgs[/span][span style=\"color:#007700\"]);

if (isset([/span][span style=\"color:#0000BB\"]$_GET[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'totalRows_rs_photogal_imgs\'[/span][span style=\"color:#007700\"]])) {
  [/span][span style=\"color:#0000BB\"]$totalRows_rs_photogal_imgs [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]$_GET[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'totalRows_rs_photogal_imgs\'[/span][span style=\"color:#007700\"]];
} else {
  [/span][span style=\"color:#0000BB\"]$all_rs_photogal_imgs [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]mysql_query[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$query_rs_photogal_imgs[/span][span style=\"color:#007700\"]);
  [/span][span style=\"color:#0000BB\"]$totalRows_rs_photogal_imgs [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]mysql_num_rows[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$all_rs_photogal_imgs[/span][span style=\"color:#007700\"]);
}
[/span][span style=\"color:#0000BB\"]$totalPages_rs_photogal_imgs [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]ceil[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$totalRows_rs_photogal_imgs[/span][span style=\"color:#007700\"]/[/span][span style=\"color:#0000BB\"]$maxRows_rs_photogal_imgs[/span][span style=\"color:#007700\"])-[/span][span style=\"color:#0000BB\"]1[/span][span style=\"color:#007700\"];

[/span][span style=\"color:#0000BB\"]$queryString_rs_photogal_imgs [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#DD0000\"]\"\"[/span][span style=\"color:#007700\"];
if (&[/span][span style=\"color:#FF8000\"]#33;empty($_SERVER[\'QUERY_STRING\'])) {
  [/span][span style=\"color:#0000BB\"]$params [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]explode[/span][span style=\"color:#007700\"]([/span][span style=\"color:#DD0000\"]\"&\"[/span][span style=\"color:#007700\"], [/span][span style=\"color:#0000BB\"]$_SERVER[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'QUERY_STRING\'[/span][span style=\"color:#007700\"]]);
  [/span][span style=\"color:#0000BB\"]$newParams [/span][span style=\"color:#007700\"]= array();
  foreach ([/span][span style=\"color:#0000BB\"]$params [/span][span style=\"color:#007700\"]as [/span][span style=\"color:#0000BB\"]$param[/span][span style=\"color:#007700\"]) {
    if ([/span][span style=\"color:#0000BB\"]stristr[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$param[/span][span style=\"color:#007700\"], [/span][span style=\"color:#DD0000\"]\"pageNum_rs_photogal_imgs\"[/span][span style=\"color:#007700\"]) == [/span][span style=\"color:#0000BB\"]false [/span][span style=\"color:#007700\"]&&
        [/span][span style=\"color:#0000BB\"]stristr[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$param[/span][span style=\"color:#007700\"], [/span][span style=\"color:#DD0000\"]\"totalRows_rs_photogal_imgs\"[/span][span style=\"color:#007700\"]) == [/span][span style=\"color:#0000BB\"]false[/span][span style=\"color:#007700\"]) {
      [/span][span style=\"color:#0000BB\"]array_push[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$newParams[/span][span style=\"color:#007700\"], [/span][span style=\"color:#0000BB\"]$param[/span][span style=\"color:#007700\"]);
    }
  }
  if ([/span][span style=\"color:#0000BB\"]count[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$newParams[/span][span style=\"color:#007700\"]) &[/span][span style=\"color:#FF8000\"]#33;= 0) {
    [/span][span style=\"color:#0000BB\"]$queryString_rs_photogal_imgs [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#DD0000\"]\"&\" [/span][span style=\"color:#007700\"]. [/span][span style=\"color:#0000BB\"]htmlentities[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]implode[/span][span style=\"color:#007700\"]([/span][span style=\"color:#DD0000\"]\"&\"[/span][span style=\"color:#007700\"], [/span][span style=\"color:#0000BB\"]$newParams[/span][span style=\"color:#007700\"]));
  }
}
[/span][span style=\"color:#0000BB\"]$queryString_rs_photogal_imgs [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]sprintf[/span][span style=\"color:#007700\"]([/span][span style=\"color:#DD0000\"]\"&totalRows_rs_photogal_imgs=%d%s\"[/span][span style=\"color:#007700\"], [/span][span style=\"color:#0000BB\"]$totalRows_rs_photogal_imgs[/span][span style=\"color:#007700\"], [/span][span style=\"color:#0000BB\"]$queryString_rs_photogal_imgs[/span][span style=\"color:#007700\"]);
[/span][span style=\"color:#0000BB\"]?>
[/span]
<div id=\"photo\" style=\"position:absolute; width:370px; height:210px; z-index:5; left: 26px; top: 64px;\">
  [span style=\"color:#0000BB\"]<?php [/span][span style=\"color:#007700\"]do { [/span][span style=\"color:#0000BB\"]?>
[/span]  <img src=\"images/gallery/[span style=\"color:#0000BB\"]<?php [/span][span style=\"color:#007700\"]echo [/span][span style=\"color:#0000BB\"]$row_rs_photogal_imgs[/span][span style=\"color:#007700\"][[/span][span style=\"color:#DD0000\"]\'filename\'[/span][span style=\"color:#007700\"]]; [/span][span style=\"color:#0000BB\"]?>[/span]\" alt=\"\" width=\"370\" height=\"210\" border=\"0\" />
  [span style=\"color:#0000BB\"]<?php [/span][span style=\"color:#007700\"]} while ([/span][span style=\"color:#0000BB\"]$row_rs_photogal_imgs [/span][span style=\"color:#007700\"]= [/span][span style=\"color:#0000BB\"]mysql_fetch_assoc[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$rs_photogal_imgs[/span][span style=\"color:#007700\"])); [/span][span style=\"color:#0000BB\"]?>
[/span]</div>
<div id=\"bkndPhotoGal\" style=\"position:absolute; width:422px; height:322px; z-index:1; top: 0px; left: 0px;\"><img src=\"images/backgrounds/bknd_photo_gal_pic.jpg\" alt=\"photos\" width=\"422\" height=\"322\" border=\"0\" /></div>
<div id=\"prev\" style=\"position:absolute; z-index:5; left: 26px; top: 281px; width: 145px; height: 22px;\"><a href=\"[span style=\"color:#0000BB\"]<?php printf[/span][span style=\"color:#007700\"]([/span][span style=\"color:#DD0000\"]\"%s?pageNum_rs_photogal_imgs=%d%s\"[/span][span style=\"color:#007700\"], [/span][span style=\"color:#0000BB\"]$currentPage[/span][span style=\"color:#007700\"], [/span][span style=\"color:#0000BB\"]max[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]0[/span][span style=\"color:#007700\"], [/span][span style=\"color:#0000BB\"]$pageNum_rs_photogal_imgs [/span][span style=\"color:#007700\"]- [/span][span style=\"color:#0000BB\"]1[/span][span style=\"color:#007700\"]), [/span][span style=\"color:#0000BB\"]$queryString_rs_photogal_imgs[/span][span style=\"color:#007700\"]); [/span][span style=\"color:#0000BB\"]?>[/span]\"><img src=\"images/buttons/photo_gal_prev.gif\" alt=\"prev\" width=\"145\" height=\"22\" border=\"0\" /></a></div>
<div id=\"next\" style=\"position:absolute; width:146px; height:22px; z-index:5; left: 249px; top: 281px;\"><a href=\"[span style=\"color:#0000BB\"]<?php printf[/span][span style=\"color:#007700\"]([/span][span style=\"color:#DD0000\"]\"%s?pageNum_rs_photogal_imgs=%d%s\"[/span][span style=\"color:#007700\"], [/span][span style=\"color:#0000BB\"]$currentPage[/span][span style=\"color:#007700\"], [/span][span style=\"color:#0000BB\"]min[/span][span style=\"color:#007700\"]([/span][span style=\"color:#0000BB\"]$totalPages_rs_photogal_imgs[/span][span style=\"color:#007700\"], [/span][span style=\"color:#0000BB\"]$pageNum_rs_photogal_imgs [/span][span style=\"color:#007700\"]+ [/span][span style=\"color:#0000BB\"]1[/span][span style=\"color:#007700\"]), [/span][span style=\"color:#0000BB\"]$queryString_rs_photogal_imgs[/span][span style=\"color:#007700\"]); [/span][span style=\"color:#0000BB\"]?>[/span]\"><img src=\"images/buttons/photo_gal_next.gif\" alt=\"next\" width=\"146\" height=\"22\" border=\"0\" /></a></div>
<div id=\"countbknd\" style=\"position:absolute; width:74px; height:22px; z-index:5; left: 173px; top: 281px;\"><img src=\"images/buttons/photo_gal_count.gif\" alt=\" \" width=\"74\" height=\"22\" border=\"0\" /></div>
<div id=\"count\" style=\"position:absolute; width:74px; z-index:6; left: 173px; top: 286px;\">
  <div class=\"white\" align=\"center\">[span style=\"color:#0000BB\"]<?php [/span][span style=\"color:#007700\"]echo ([/span][span style=\"color:#0000BB\"]$pageNum_rs_photogal_imgs [/span][span style=\"color:#007700\"]+ [/span][span style=\"color:#0000BB\"]1[/span][span style=\"color:#007700\"]) [/span][span style=\"color:#0000BB\"]?>[/span] of [span style=\"color:#0000BB\"]<?php [/span][span style=\"color:#007700\"]echo [/span][span style=\"color:#0000BB\"]$totalRows_rs_photogal_imgs ?>[/span] </div>
</div>
<div id=\"r1\" style=\"position:absolute; width:171px; height:136px; z-index:2; left: 422px; top: 0px;\">
  [span style=\"color:#0000BB\"]<?php [/span][span style=\"color:#007700\"]require_once([/span][span style=\"color:#DD0000\"]\'content/pod_webres.php\'[/span][span style=\"color:#007700\"]); [/span][span style=\"color:#0000BB\"]?>
[/span]</div>
<div id=\"r2\" style=\"position:absolute; width:171px; height:186px; z-index:6; left: 422px; top: 136px;\">
  [span style=\"color:#0000BB\"]<?php [/span][span style=\"color:#007700\"]require_once([/span][span style=\"color:#DD0000\"]\'content/pod_event_updates.php\'[/span][span style=\"color:#007700\"]); [/span][span style=\"color:#0000BB\"]?>
[/span]</div>
<div id=\"pulldown\" style=\"position:absolute; z-index:15; left: 17px; top: 33px;\">
  [span style=\"color:#0000BB\"]<?php [/span][span style=\"color:#007700\"]require_once([/span][span style=\"color:#DD0000\"]\'includes/gallery_navmenu.php\'[/span][span style=\"color:#007700\"]); [/span][span style=\"color:#0000BB\"]?>
[/span]</div>
[/span][!--PHP-Foot--][/div][!--PHP-EFoot--]
Any suggestions?
A noble spirit embiggens the smallest man.
- Jebediah Springfield




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users