Information from MySQL db to PHP page.. help

**ThA_FiLeR** · July 5, 2003

Right, just got done creating my script that allows me and someone else to add a portfolio item to site, it allows u to upload pic from hd, then creates thumbnail also for it and makes thumbnail link to original image with a title above it.. it shows fine and everything, only problem is that I would like it to show 4 items across (columns) and then start a new row underneath, and so on.. now it keeps on making new columns or rows for it, and keeps going I can make it go across or down but it keeps going.. so I need it to show just 4 across then start new line, heres my code...

<html>
<head>
<title>Portfolio site</title>
</head>

<body>
<?php 
// Connect to the database 
$db = mysql_connect("localhost","****","****"); 
mysql_select_db ("****"); 
// Request info from Portfolio table
$result = mysql_query("SELECT * FROM portfolio"); 
// Start showing results
echo "<table border = '0' width = '780' align='center'><tr>"; 
while ($rows = mysql_fetch_row($result)) 
// keeps looping till all items from DB are shown
{ 
echo "<td>$rows[1]<BR><a href='$rows[2]'><img src=$rows[3]></a></td>"; 
} 
echo "</tr></table>"; 
?> 

</body>
</html>

**** = hidden 

rows[1] = title 
rows[2] = original image
rows[3] = thumbnail image

Script in action: http://www.toe-art.com/QualityCreations/portfolio.php

-the TF avater pic looks not right since it got resized b/c it was too small and it then got resized bigger instead..

Thanks for any help/suggestion..

**ThA_FiLeR** · July 6, 2003

Anyone?

**sedative** · July 6, 2003

Here's the index.php that a friend made for me for my images on ileet.net. Maybe this will help.

<?php

include('http://ileet.net/source/header.php');

// CONFIGURE THIS
$dir_name  = ""; 
$thumb_dir_name  = "thumbs/"; 
// AND THAT ONLY =)

$dir = opendir($thumb_dir_name); 

if (!$pg) { $pg = 1; }
$e = $pg * 15;
$pg--; 
$s = $pg * 15;
$i = 0;
$r = 0;

echo "<table cellspacing=1 cellpadding=5 align=center>";
while ($file_name = readdir($dir)){ 
      // if (ereg ("^[]+\.(jpg|gif|jpeg|png)$", $file_name)) {

      if (($file_name != "..") && ($file_name != ".") && ($file_name != "_vti_cnf")) {
      $fName = "$file_name"; 
      if (($i >= $s) && ($i < $e)) {
       if ($r == 5) { $r = 0; echo "</tr>"; }
       if (!$r) { echo "<tr>"; }

       $file = "$dir_name$fName";

       $size = @GetImageSize($file); $filesize = @filesize($file); $filesize = $filesize / 1024; $filesize = @round($filesize,0); $h = $size[1]; $w = $size[0];
       if (($w) && ($h)) { $size = "$w x $h, $filesize<b></b>kb"; }
       elseif ((!$w) || (!$h)) { $size = "n/a, $filesize<b></b>kb"; }

       echo "<td> <a href=\"$file\"><img src=\"$thumb_dir_name$fName\" alt=\"\" border=0></a></td>";       

       $r++;
      }
      $i++;
  } 
} 
if ($r != 5) echo "</tr>";
echo "</table>";
echo "<div align=\"center\">";
$total = $i;                  // Number of images in directory
$i = 1;                       // iiiiiiih!
$img_per_page = 15;           // Number of images per page. Change this any day =)
$cur_img = 1;
$total_pages = 1;
while ($i <= $total) {
      if ($cur_img == $img_per_page) {
         if ($_GET["pg"] != $total_pages) { echo "<a href=\"$PHP_SELF?pg=$total_pages\">$total_pages</a> "; }
         else { echo "$total_pages "; }
         if ($i < $total) { $total_pages++; }
         $cur_img = 0;
      }
      elseif ($i == $total) {
             $isdone = $total_pages * $img_per_page;
             if ($isdone > $total) {
                // BEEP! More pix!
                if ($_GET["pg"] != $total_pages) { echo "<a href=\"$PHP_SELF?pg=$total_pages\">$total_pages</a> "; }
                else { echo "$total_pages "; }
             }
      }
      $cur_img++;
      $i++;
}

/**
$pgs = $i / 15;
$pgs = round($pgs,0);

$c = $i % 15;
if ($c != 0) $pgs++;

$i = 1; $p = $pg + 1;
echo "<div align=\"center\">";
while ($i < $pgs) {

      if ($p == $i) echo "$i ";
      else echo "<a href=\"$PHP_SELF?pg=$i\">$i</a> ";

$i++;
}
**/
echo "</div>";
closedir($dir); 

include('http://ileet.net/source/footer.php');

?>

Sign In

Information from MySQL db to PHP page.. help

Recommended Posts

ThA_FiLeR

ThA_FiLeR

sedative

Create an account or sign in to comment

Create an account

Sign in

Recently Browsing 0 members

Activity

Browse