Pagination

[boliches]

I am attempting to add script to limit the number of images displayed per page. The images to be displayed in 2 columns. The script I have used I obtained from searching "PHP Pagination" via Google, it seemed to work fine until I tried to added the code to put the images diplayed into 2 columns. Each set of code worked OK on its own! Any help would be appreciated.

<?php
 
$Host="mysql1.namesco.net";
$User="usedcarsgbco";
$Password="031255";
$DBName = "usedcarsgbco";
$TableName = "VehicleStock";
$TablePhoto = "cpg140_pictures";
$Link = mysql_connect ($Host, $User, $Password);
$Query =  "SELECT * FROM VehicleStock LEFT JOIN cpg140_pictures ON VehicleStock.RegNo = cpg140_pictures.title ORDER BY CarID DESC";
$Result = mysql_db_query ($DBName, $Query, $Link);
 
$max = 4;
$p = $_GET['p'];
if(empty($p))
{
$p = 1;
}
$limits = ($p - 1) * $max;
//view the news article!
if(isset($_GET['act']) && $_GET['act'] == "view")
{
$id = $_GET['RegNo'];
$sql = mysql_query("SELECT * FROM VehicleStock");
while($r = mysql_fetch_array($sql))
{
$RegNo = $r['RegNo'];
$Price = $r['Price'];
 
echo "<div><p>$RegNo</p><p>$Price</p></div>";
}
 
}else{
 
 
$sql = mysql_query("SELECT * FROM VehicleStock LIMIT ".$limits.",$max") or die(mysql_error());
$totalres = mysql_result(mysql_query("SELECT COUNT(RegNo) AS tot FROM VehicleStock"),0); 
$totalpages = ceil($totalres / $max);
 
echo "<table align=center><tr><td>Reg No</td><td>Retail Price</td></tr><tr>";
$_counter = -1; 
$_cols = 2;
 
{
$id = $r['RegNo'];
$RegNo = $r['RegNo'];
$Price = $r['Price'];
//(NEXT 28 LINES OF SCRIPT DISPLAY IMAGES IN 2 COLUMNS)
$_pos = ( ++$_counter % $_cols );
        if( $_pos === 0 )
{
        echo '
        <tr>';
    }
echo "<tr><td><a href='VehicleDetail.php?act=view&RegNo=$id&Price=$Price'>
        <img border='0'alt='Click for car details' src=gallery/albums/userpics/10001/$RegNo.jpg></a></td><td>£$Price</td>";
}
echo "</tr></table>";
if( $_pos === $_cols - 1 )
    {
        echo '
        </tr>';
    }
}
 
if( $_counter % $_cols !== $_cols - 1 )
{
    do
    {
        echo '
            <td style="visibility: hidden">&nbsp;</td>';
    }
    while( ++$_counter % $_cols !== $_cols - 1 );
 
    echo '
        </tr>';
//END OF IMAGE DISPLAY SCRIPT
}
for($i = 1; $i <= $totalpages; $i++){
 
echo "<a href='StockTest.php?p=$i'>$i</a>|";
}
 
 
?>
</body>
</html>
 
 
 

[Markus]

Let me get this right, you're wanting to display images in two columns?

i.e:

img1 - img2
img3 - img4
img5 - img6
 
// etc..
 

Also, please remeber to use code tags properly when posting code.

[boliches]

Yes thats correct!
Also I did notice I missed a "]" , but it was too late to amend.

Have been playing with my code and so far am unable to display just 4 images per page. But do have the links appearing to offer further pages! I feel I am close but that some of the code is in the wrong place. Your help would really be appreciated.

<?php
 
$Host="mysql1.namesco.net";
$User="usedcarsgbco";
$Password="031255";
$DBName = "usedcarsgbco";
$TableName = "VehicleStock";
$TablePhoto = "cpg140_pictures";
$Link = mysql_connect ($Host, $User, $Password);
$Query =  "SELECT * FROM VehicleStock LEFT JOIN cpg140_pictures ON VehicleStock.RegNo = cpg140_pictures.title ORDER BY CarID DESC"; 
$Result = mysql_db_query ($DBName, $Query, $Link);
$max = 4;
$p = $_GET['p'];
if(empty($p))
{
$p = 1;
}
$limits = ($p - 1) * $max;
 
if(isset($_GET['act']) && $_GET['act'] == "view")
{
$id = $_GET['RegNo'];
$sql = mysql_query("SELECT * FROM VehicleStock");
while($r = mysql_fetch_array($sql))
{
$RegNo = $r['RegNo'];
$Price = $r['Price'];
}
}else{
$sql = mysql_query("SELECT * FROM VehicleStock LIMIT ".$limits.",$max") or die(mysql_error());
$totalres = mysql_result(mysql_query("SELECT COUNT(RegNo) AS tot FROM VehicleStock"),0); 
$totalpages = ceil($totalres / $max);
}
 
 
 
echo "<div><p>$RegNo</p><p>$Price</p></div>";
 
 
for($i = 1; $i <= $totalpages; $i++){
 
echo "<a href='StockTestAll1.php?p=$i'>$i</a>|";
}
 
echo '
<table align=center>';
 
$_counter = -1;  // We start 'outside' the Matrix.  Unlike Neo.
$_cols = 2; // 3 columns.  Of the Ionic variety.
while( $__row = mysql_fetch_assoc($Result) )
{
    // Advance the counter and determine our 'position';
    $_pos = ( ++$_counter % $_cols );
 
    // Should we output a '<tr>'?
    if( $_pos === 0 )
{
        echo '
        <tr>';
    }
 
        echo "
 
<td><table>
    <tr><td colspan=3 class='SLMakeModel'><b> &nbsp;{$__row['Make']}&nbsp;{$__row['Spec']}</b></td></tr>
 
    <tr><td><a href='VehicleDetail.php?RegNo=$__row[RegNo]&Price=$__row[Price]'>
        <img border='0'alt='Click for details' src=gallery/albums/$__row[filepath]$__row[filename] width='225' height='175'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</a> 
    <td valign='top'class='SLTransmissionText'><b>Registered:</b><br>{$__row['RegDate']}<br>&nbsp;<br>
    <b>Transmission:</b>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br>{$__row['Box']}<br>&nbsp;<br>
    <b>Mileage:</b><br>{$__row['Mileage']}<br>&nbsp;<br>
    <b>Price:</b><br>£{$__row['Price']}
    </tr> </td>
 
    <Tr><td  colspan=3 class='SLMakeModel'><a href='VehicleDetail.php?RegNo=$__row[RegNo]&Price=$__row[Price]'><img border='0' alt='Click for Details'src=Images/details.gif> </a></td></tr>
 
 
 
<tr> <td>
 
 
</td></tr></table>         </td>";
 
 
 
    // Should we output a '</tr>'?
    if( $_pos === $_cols - 1 )
    {
        echo '
        </tr>';
    }
}
 
 
 
if( $_counter % $_cols !== $_cols - 1 )
{
    do
    {
        echo '
            <td style="visibility: hidden">&nbsp;</td>';
    }
    while( ++$_counter % $_cols !== $_cols - 1 );
 
    echo '
        </tr>';
}
 
echo '
</table>';
?>
 
 

[Markus]

Yes thats correct!
Also I did notice I missed a "]" , but it was too late to amend.

Have been playing with my code and so far am unable to display just 4 images per page. But do have the links appearing to offer further pages! I feel I am close but that some of the code is in the wrong place. Your help would really be appreciated.

In fact, a few months back I had the same problem. Pbmods came up with a great solution. I'll just have to search the archives and find it!

2 mins.

[Markus]

Here you go

Hope it helps!

[boliches]

Thanks for that, this is where I got my code from to limit the images per page. My problem from there was to create the links to the next 4 images etc. When I inserted the code to paginate I ended up with the links OK but lost the 4 images per page and got the whole array.

The code (I think) is all there but must be in the wrong order. Any ideas?