paginationerror...image only in rows n not in columns

angelicdevil

i m trying to display the result images in table format or rows and columns but the cod i wrote displays them only in rows....someone plz help

Expand|Select|Wrap|Line Numbers

  
<?php
 
// generating a array with image paths
 
$query_images = "SELECT image_path,image_name FROM userfolders" ;

$result_images = mysql_query($query_images);

confirm_query($result_images);
 
while ($record_images = mysql_fetch_assoc($result_images)) {

          $file = $record_images['image_name'] ;

          $dirname = $record_images['image_path'] ;
 
// generating a thumbnail

$thumb_height = 100;

$filename = $dirname."/".$file;

$filename_array[] = $filename ;

list($width, $height) = getimagesize($filename);

        $ratio = ($height/$width);

        $ratio_array[] = $ratio;

        $newheight = $thumb_height;

        $newheight_array[] = $newheight;

        $newwidth = ($thumb_height/$ratio);

        $newwidth_array[] = $newwidth;
 
$page = empty($_GET['page']) ? 1 : $_GET['page'];

$num_per_page = 4;

$total_pages = ceil(count($filename_array)/$num_per_page);
 
}
 
?>
 
<?php

for($i = ($page - 1) * $num_per_page; $i < $page * $num_per_page; $i++)

{?><li><a href="<?php echo $filename_array[$i]; ?>">

<img src="<?php echo $filename_array[$i]; ?>" width="<?php echo $newwidth_array[$i]; ?>" height="<?php echo $thumb_height_array[$i]; ?>" align="top"

alt="<?php echo $filename_array[$i]; ?>" /></a></li>

<?php

}

?>
 
<?php

echo "</ul>";

$pages = array();

for($i = 1; $i <= $total_pages; $i++) {

$pages[] = "<a href=\"".$_SERVER['PHP_SELF']."?page=".$i."\">".$i."</a>";

}

echo "Page: ".implode(" ", $pages);
 
?>

prabirchoudhury

1. ok, you need make a table and run your forloop inside that table
2. when you run for loop then after a selected no of <td> you need to make a new <tr> to make another row.

3. we geting all say 100 images in one row. how can we make it so that every 10th (could change this no, you want) image ends the row, and starts a new one? could use the Modulus arithmetic operand to calculate that. The operand sign is the percent sign (%). So you set up our if() statement thusly:

Expand|Select|Wrap|Line Numbers

  
<table align=center border=0 >

<tbody>

<tr>

for ($i=1; $i<= $total_pages; $i++)

{
 
$pages = "<a href=\"".$_SERVER['PHP_SELF']."?page=".$i."\">".$i."</a>";

  echo('<TD align=top>');

  echo $pages; 

  echo('</TD>');

  if($i % 10 == 0)

        {

          echo '</tr>

          <tr>';

        }
 
}
 
</TBODY>

</TABLE>

:))

angelicdevil

well i did wat u told me its still not working.

Expand|Select|Wrap|Line Numbers

 
<?php
 
// generating a array with image paths
 
$query_images = "SELECT image_path,image_name FROM userfolders" ;

$result_images = mysql_query($query_images);

confirm_query($result_images);
 
while ($record_images = mysql_fetch_assoc($result_images)) {

          $file = $record_images['image_name'] ;

          $dirname = $record_images['image_path'] ;
 
// generating a thumbnail

$thumb_height = 100;

$filename = $dirname."/".$file;

$filename_array[] = $filename ;

list($width, $height) = getimagesize($filename);

        $ratio = ($height/$width);

        $ratio_array[] = $ratio;

        $newheight = $thumb_height;

        $newheight_array[] = $newheight;

        $newwidth = ($thumb_height/$ratio);

        $newwidth_array[] = $newwidth;
 
$page = empty($_GET['page']) ? 1 : $_GET['page'];

$num_per_page = 4;

$total_pages = ceil(count($filename_array)/$num_per_page);
 
}
 
?>
 
<?php

for($i = ($page - 1) * $num_per_page; $i < $page * $num_per_page; $i++)

{?><li><a href="<?php echo $filename_array[$i]; ?>">

<img src="<?php echo $filename_array[$i]; ?>" width="<?php echo $newwidth_array[$i]; ?>" height="<?php echo $thumb_height_array[$i]; ?>" align="top"

alt="<?php echo $filename_array[$i]; ?>" /></a></li>

<?php

}

?>
 
<?php

echo "</ul>";

$pages = array();

?>

<table align=center border=0 >

<tbody>

<tr>

<?php
 
for ($i=1; $i<= $total_pages; $i++)

{
 
$pages = "<a href=\"".$_SERVER['PHP_SELF']."?page=".$i."\">".$i."</a>";

  echo('<TD align=top>');

  echo $pages; 

  echo('</TD>');

  if($i % 10 == 0)

        {

          echo '</tr>

          <tr>';

        }
 
}

?>
 
</TBODY>

</TABLE>

paginationerror...image only in rows n not in columns

re: paginationerror...image only in rows n not in columns

re: paginationerror...image only in rows n not in columns

Similar PHP bytes

/bytes/development

/bytes/it

/bytes/other

/bytes/about