help with code design

[qnc]

I am trying to recreate pages like http://www.qnctv.com/simon/ on my site by calling images from a database.

Normally this would not be a problem but I want the thumbnail arranged in rows with only five thumb nails in each.

this is the code that I have thought might work but not sure is there anything obvious before I upload it?

have included comments and it is an include file itself so all the usual html will be in a picture display page that this file is called to

Here is the theory of the code.

//aim is to recreate [url]http://www.qnctv.com/simon/[/url] using images stored in database and PHP foreach function
// connect to database using @require('./database_connect.inc.php');
// connect to images_table @require('./images_table.inc.php');

//pass the images into an array
$_images_URLs()= mysql_query (SELECT images_URLs FROM image_table)
// should I sort in bathes of 5 here?

echo"<table align=\"center\">"; //start the table for the thumbnails

// make the rows with five thumbnails in each

$_Number_o_Rows() = "(count($_images_URLs))/5"

foreach($_Number_o_Rows as $value) //
{
echo "<TR value=\"[0]\">";

// populate the rows
foreach($_images_URLs[in batches of 5] as $value)
{
echo "<TD>
<A HREF=\"$_images_URLs[0]\"> // JavaScript mouseover action added as well left out for simplicty
<IMG SRC=\"$_images_URLs[0]\">
</A>
</td>";
 }

echo "</tr>"; // finnish the rows
}

// next row should have $_images_URLs[4]-[9]

[vornn]

What you need to do is set up a little loop, sticking the thumbs in a table cell for each line, don't bother with any math to work out the number of slides you have, etc...

Here's the theory:

counter = 0
loop starts

if counter = 0 then start row and open cell, insert picture close cell

if counter = 4 then open cell, insert picture close cell, close row

else open cell, insert picture and close cell

counter = counter + 1

loop ends

All you have to do now is sort the code. I'll help if you want. I don't like doing the code for people, we all have to learn the basics and working on this will be fun.

Hope this helps...

🙂

[qnc]

I am trying to understand when to use what? If that sounds confusing then believe me it is here is what another php programmer used I thing it is similar to wehat you proposed another said to use foreach and switch together.

is it just experience that tells you which code to use with which desired outcome or is there some logic that I am missing?

I saw this on another forum http://www.sitepoint.com/forums/showthread.php?p=1562151&posted=1#post1562151

// Create sql to get pictures from database
___$sql = 'SELECT ImageURLS FROM ImageTable');
___$result = mysql_query($sql) or die ('<br />Failed to execute ' . $sql . ' due to ' . mysql_error() . '<be />');
___
// change this number to determine how many images are placed per row
$items_per_row = 5;

$first_time = true;
___$i = 0;
___// table start
___$html = '<table border="1">';
___while ($row = mysql_fetch_assoc($result))
___{
_______// Do we want to start a new row
_____if (0 == ($i % $items_per_row))
_____{
_________// Have we output a row beofre
_______if (false == $first_time)
_______{
___________// yes - so close previous row
___________$html .= '</tr>';
_______}
___
_______// Start new row
_______$html .= '<tr>';
_______$first_time = false;
_____}
___
_______// print contents
_______$html .= '<td> Link to picture ' . $i . '</td>';
_______$i++;
___}
___
___// There might not be enough picure to fill the last row,
___// so put spaces in the remaining table cells
_while (0 != ($i % $items_per_row))
___{
_______$html .= '<td>&nbsp;</td>';
_____$i++;
___}
___
___// close last row
___$html .= '</tr>';
___
___// close table
___$html .= '</table>';
___
___// print table
___echo $html; 

[fugazzi007]

If you're using tables, you'll want to do something like vornn suggested.

count =1;


echo "<table>"; //begin your table
for ($i=0; $i<$limit; $i++) {
if (count == 1) {
echo"<tr><td> //image link here </td>"; 
count++;
}
elseif (count == 2) {
echo" <td> //image link here </td>":
count++;
}
...
...
elseif (count == 5) {
echo "<td> //image link here </td></tr>";
count=1;
}
}
echo "</table>";