gallery - ?(yes, i am a woman!)

taya

ok i accept the fact i'm a woman
about what my dad kept telling me until
i moved out of the house.

but still i think i can make this gallery
- i want photos of members
to be in my gallery.

I 'm pulling out the URL's stored in My SQL database
and then insert into <IMG SRC> tag

but i fail.

and also - i don't want each photo to be in a separate row,
i want them to be 3 or 4 in a row,
is it possible?

here's part of the code


<?
require ("page.inc");

$content="";

class GalleryPage extends Page

{  function Display()
 {
    echo "<html>\n<head>\n";
    $this -> DisplayTitle();
    $this -> DisplayKeywords();
	$this -> DisplayContentdescription();
    $this -> DisplayStyles();
    echo "</head>\n<body cellspacing=0 cellpadding=0 leftmargin=0 rightmargin=0 topmargin=0 marginheight=0 marginwidth=0>\n";
    $this -> DisplayHeader();
    $this -> DisplayMenu($this->buttons);

echo $this->content;
$this -> DisplayFooter();
echo "</body>\n</html>\n";
  }
}

  $con = mysql_connect("localhost","db","passw")or die(mysql_error()); 
                           mysql_select_db("db",$con)or die(mysql_error()); 

$query="SELECT * from members, photos
WHERE members.memberid=photos.memberid AND
small='y'
order by members.memberid";


$result=mysql_query($query)
   or die(mysql_error());

$n = 1 ;
while ($row = mysql_fetch_array($result) ) {


if ( $n>$start_num and $n<=$end_num)
{

 $content .= '
        </td></tr>
		<tr><td>


					<br><table width="90%" border="0" 
cellspacing="5" cellpadding="5">
  <tr align="left" width="40%">
    <td align="center"><br>&nbsp;&nbsp;
	<img src="' . $row['photo'] . '" border="0" 
alt="' . $row['FirstName'] . '">
	<br><b>&nbsp;&nbsp;'.$row['FirstName'].'
	<A href="profile.php?personalID='.$row['memberid'].'">About Me Page</A><br>

<hr size=1 width=100%>
</td>


</table>




';



}
else
{
echo("") ;
}

$n = $n + 1 ;

}



$gallery = new GalleryPage();



 $gallery -> SetContent($content);   

    $gallery->Display();


   ?>

thank to anyone who can help!!!!

archangel_617b

What does this script generate for output? Is there a page where it is available that we can see it?

What you may want to try doing is wrapping that image table outside the while loop such that you can organize images several to a row and as many rows as you need.

If you do that, then when $n is 3 or 4 as appropriate, you close the current row and open a new one.

I know. A bit general, but just ask where you need what help and I'll try.

p0pb0b

I am a newbie to php
what does
$echo -> mean
why not echo ""?
Thanks

dalecosp

Originally posted by p0pb0b
I am a newbie to php
what does
$echo -> mean
why not echo ""?
Thanks

Take a look in the manual at "Classes & Objects." 🙂

Frederick

I think this is what you are looking for.
This will show 5 images in each row and then starts a new row if it exceeds 5 images.

<?php
$a = '0';
?>
<table width="100" border="0" cellspacing="0" cellpadding="10">
<?php
$sql = mysql_query("select * from test",$db);
while ($img = mysql_fetch_array($sql)) {
if ($a == '0') {echo "<tr>";}
if ($a == '5') {echo "<tr>";}
if ($a == '10') {echo "<tr>";}
if ($a == '15') {echo "<tr>";}
if ($a == '20') {echo "<tr>";}
if ($a == '25') {echo "<tr>";}
if ($a == '30') {echo "<tr>";}
if ($a == '35') {echo "<tr>";}
?>
<td><img src="<?php echo "gallery/".$img["im"].""?>" width="100" border="0"></td>
<?php
$a = $a + 1;
}
?>
</table>

dalecosp

That may work, but we can give that a bath...

This:

if ($a == '0') {echo "<tr>";} 
if ($a == '5') {echo "<tr>";} 
if ($a == '10') {echo "<tr>";} 
if ($a == '15') {echo "<tr>";} 
if ($a == '20') {echo "<tr>";} 
if ($a == '25') {echo "<tr>";} 
if ($a == '30') {echo "<tr>";} 
if ($a == '35') {echo "<tr>";}

can become this:

if (($a==0)||($a%5)==0) {echo "<tr>"; }

and will then support any multiple of five; that what the modulus operator is for.

And "$a=$a+1;" is just "$a++;" ...

Ravenous

Of course, keeping in mind that the tag wold actually be </tr> since she's trying to close that row. Perhaps you could echo </tr><tr> to take care of closing and starting rows at the same time, but this all minor details. 😃

taya

Thank you so much for your support, guys!

I did as you recommended - it dioesn't work now yet

but i'm very sleepy and tomorrow i have to leave for some
time(family things)

but i will to look through it a gain in a few days!

Here's my code again (just in case)


<?
require ("page.inc");

$content="";

class GalleryPage extends Page

{  function Display()
 {
    echo "<html>\n<head>\n";
    $this -> DisplayTitle();
    $this -> DisplayKeywords();
	$this -> DisplayContentdescription();
    $this -> DisplayStyles();
    echo "</head>\n<body cellspacing=0 cellpadding=0 
leftmargin=0 rightmargin=0 topmargin=0 marginheight=0 marginwidth=0>\n";
    $this -> DisplayHeader();
    $this -> DisplayMenu($this->buttons);

echo $this->content;
$this -> DisplayFooter();
echo "</body>\n</html>\n";
  }
}

$a = "0" ;
 $content .= '<table width="100%" border="0" cellspacing="5" 
cellpadding="5">';

  $con = mysql_connect("localhost","db","passw")or die(mysql_error()); 
                           mysql_select_db("members",$con)or die(mysql_error()); 

$query="SELECT photo from members, photos
WHERE members.memberid=photos.memberid AND small='y' ";


$result=mysql_query($query)
   or die(mysql_error());

while ($row = mysql_fetch_array($result) ) {


if (($a==0)||($a%5)==0) {$content='</tr><tr>'; }

 $content .= '<td><img src=" '.$row['photo'].'" 
border=0></td> ';

$a = $a +1; 
}


$content='</table> ';



$gallery = new GalleryPage();



 $gallery -> SetContent($content);   

    $gallery->Display();
    ?>

thank you again, i love this ofrum and all of you!
🙂

HalfaBee

Originally posted by dalecosp
if (($a==0)||($a%5)==0) {echo "<tr>"; }
and will then support any multiple of five; that what the modulus operator is for.
[/B]

Why the extra test for 0?

0%5 = 0

HalfaBee

taya

OK i'm in LA now,
i downloaded a nice TCWWebCoder from
www.download.com,

and tried to check the code today,

it works fine, all i needed to do to put dots after $content

so it looks like

$content.='</table> ';

f (($a==0)||($a%4)==0) {$content.='<tr>'; }

love all of you and have a greaT august....!

dalecosp

Originally posted by Ravenous
Of course, keeping in mind that the tag wold actually be </tr> since she's trying to close that row. Perhaps you could echo </tr><tr> to take care of closing and starting rows at the same time, but this all minor details. 😃

LOL at that avatar ... I can't hardly believe you'd use it, though ....

"Arguing on the Internet is like ... " 😃 😃