Display data dynamically in Matrix format using PHP with pagination

<?php
$per_page = 6;
$display_columns = 3;
$page = isset($_GET[‘page’]) ? (int) $_GET[‘page’] : 1;
$pages = implode(mysql_fetch_assoc(mysql_query(“SELECT COUNT(*) FROM projects”)));
//$pages= $pages/$display_columns;
$pages = ceil($pages / $per_page);
$querystring = “”;
foreach ($_GET as $key => $value) {
if ($key != “page”) $querystring .= “$key=$value&amp;”;
}
echo “Pages: “;
for ($i = 1; $i <= $pages; $i++) {
echo “<a ” . ($i == $page ? “class=\”selected\” ” : “”);
echo “href=\”?{$querystring}page=$i”;
echo “\”>$i</a> “;
}
$i=””;

$sqlm=”select * from projects LIMIT ” . (($page – 1) * $per_page) . “, $per_page”;
$rsm=mysql_query($sqlm) or die(“Database Error”.mysql_error());
$count = mysql_num_rows($rsm);
$padding = ($display_columns-1)-(($count-1)%$display_columns);
echo ‘<table cellpadding=10>’;
while($row=mysql_fetch_array($rsm))
{

if($i%$display_columns == 0)
echo ‘<tr>’;
echo ‘<td>’;

$id=$row[“id”];
$in_sql=”select * from projects where id=$id”;
$r=mysql_query($in_sql) or die(“Database Error”.mysql_error());
if($rw=mysql_fetch_array($r))
{
$image=$rw[‘img’];
}

?>
<td>
<img src=”admin/pages/Upload/<?=$image; ?>” width=”160″ height=”160″ style=”border:#999;border:double”><br />
<h4><a href=”projects_view.php?id=<?=$id?>”><?=$rw[‘title’];?></a></h4><h4 align=”center”><?=$rw[‘cat_id’];?></h4>
</td>
<?
echo ‘</td>’;

if($i%$display_columns == $display_columns-1)
echo ‘</tr>’;
$i++;
}
if($padding!=0)
{
for($i=0;$i<$padding;$i++)
echo ‘<td></td>’;
echo ‘</tr>’;
}
echo ‘</table>’;

?>


Comments

One response to “Display data dynamically in Matrix format using PHP with pagination”

  1. Really very very help full this code….thank you very much……
    I love this code….

Leave a Reply

Your email address will not be published. Required fields are marked *