[RESOLVED] Site Visitor Photo Gallery

lightningrod66

I have a website and I have a photo upload page that allows site visitors to upload a photo to display on a photo gallery. The information is stored in mysql database, but the actual image is stored in another folder with mysql just storing the image name/path as well as the visitor name and location. I am having trouble with the gallery display page in that all the images are just showing in one long column instead of like a normal gallery. I would like this page to display like this (excuse the bad formatting here):

| Location1 | Location2 | Location3 | Location4 | Location5 |

| Location6 | Location7 | Location8 | Location9 |Location10 |

5 across by ?? down

What I get now is this:

| PHOTO 1 |
| Name 1 |

|Location1 |

| PHOTO 2 |
| Name 2 |

|Location2 |

| PHOTO 3 |
| Name 3 |

|Location3 |

| PHOTO 4 |
| Name 4 |

|Location4 |

| PHOTO 5 |
| Name 5 |

|Location5 |

and so on... (only 1 per row because it apparently takes each row of info from db and creates a different display row for each db row of info)

Can anyone help with the display code? I just need to know what to add/change and where to put it within my current display code.

The display code is simple and just connects to and queries the database, then displays each db row of information, but I don't want each db row to be on its own display row (if you can understand what Iam saying there 🙂 ) I don't want another display row started untill it has displayed the info from 5 db rows.

Thanks 🙂

dagon

asked before, answered before:

http://www.phpbuilder.com/board/showthread.php?t=10368177

lightningrod66

I tried to use that info, but still don't know exactly how to set it up. I thought maybe I needed to post in the Newbie section to get a "better" answer for someone who has no clue like me. Take a look at my code below. I still only get one long column of stuff. It still puts each databse row in it's own row. I am very new to this and just don't get how to incorporate the counter/looping thing into my code. Please look and tell me why it doesn't work.

<html>
<head>
<title>PHOTO GALLERY</title>
</head>
<body bgcolor=black>
<font color=white>
<?php 
// Connects to your Database 
mysql_connect("localhost", "user", "pw") or die(mysql_error()) ; 
mysql_select_db("dbname") or die(mysql_error()) ; 
Echo "<h1>Visitor Photo Gallery</h1><br><hr>";
//Retrieves data from MySQL 
$data = mysql_query("SELECT * FROM visitorpics") or die(mysql_error());

//Puts it into an array 
Print "<table border=1 cellpadding=3 colspan=5>";
$count=1;
while($info = mysql_fetch_array( $data )) 
{ 

//Outputs the image and other data
Print "<tr>"; 
Print "<td align=center><img src=http://www.mydomain.com:120/images/visitorpics/".$info['photo'] ." width=200><br><font color=white>".$info['name'] . "</font></td>";

if ($count%5===0)
	{ 
		Print "</tr>";	 
	} 
$count++; 

}
Print "</table>"; 
?>
</font>
</body>
</html>

I messed with this for hours and got no different result - still one long column.

Basically, my db has only one table, and that table has three fields: id, photo, and name(person's name). The photo just has the name of the photo because the actual photo is in another folder. I want to display the photo and person's name, but have 5 of those sets per display row. I appreciate what help i have received so far, but I just don't know how to use it 🙁

toxic_brain

//Outputs the image and other data
Print "<tr>";

should be

//Outputs the image and other data
if ($count%5===1)
	{ 
		Print "<tr>";	 
	}

lightningrod66

Thanks for everyone's help with this. I found what the problem was:
The <table> and <tr> tags need to be outside the loop. The <td></td> tags are inside the loop where your displayed info goes. The loop counts each item, then if it reaches your predefined count it puts</tr><tr> to start another row and resets the count to 0. If not, then after the loop you close off the row with </tr></table>.

My problem was not knowing how to determine where the counter should be placed within my code, and how to use that to start another row.

I'm sure that this isn't the only way to achieve this, but it is one way that works.

Sometimes when you are new to programming and people try to help by giving you a snippet of code without really explaining where it goes and why, it gets confusing. I had several people respond by giving me a code snippet, but I couldn't figure out how to use it correctly.

See below for working code. The number of items to display per row can be easily changed to any number.
Again, it is a very simple thing, but if you have no clue how to use it correctly it can be very frustrating.

<html>
<head>
<title>PHOTO GALLERY</title>
</head>
<body bgcolor=black>
<font color=white>
<?php 
// Connects to your Database 
mysql_connect("localhost", "user", "pw") or die(mysql_error()) ; 
mysql_select_db("dbase") or die(mysql_error()) ; 
Echo "<center><h1>Visitor Photo Gallery</h1></center><br><hr>";
//Retrieves data from MySQL 
$data = mysql_query("SELECT * FROM visitorpics") or die(mysql_error());
?>

<table align=center border=0 cellpadding=5 cellspacing=5>
	<tr>
<?php
$x=0;

while($info = mysql_fetch_array( $data )) 
{ 

//Outputs the image and other data
print "<td align=center><img src=http://www.mydomain.com/images/visitorpics/".$info['photo'] ." width=150 height=150><br><font color=white>".$info['name'] . "</font></td>";

$x++;

if ($x == 5)
	{ 
		print "</tr><tr>";
		$x=0;	 
	} 

}
?>

</tr>
</table> 
</font>
</body>
</html>

Now I get a nicely formatted photo gallery that displays a photo and the submitter's name, showing 5 per row.

(Being a newbie really sux) 🙁