PHP - Pagination Image Hyperlink Problem And Empty Images.

Hi again

probably a very simple code but not working.  I am trying to show a default image "fabric.jpg" if the recordset is empty.  If not empty it shows the recordset image at a size of 100X100.  This is the code I am using and have probably left something out, any ideas?

<img src="<?php if ($row_Recordset3['fabricpicture']==null); echo "<img src='graphics/fabric.jpg'>"; ?>" alt="" name="fabric" width="100" height="100" border="0" align="bottom" id="fabric" title="Selected Bottom Up Blind Fabric" />

I have tried switching the img scr both "" and ' ' but still no joy?

Hi All,

Need help. I'm strugling to figure out how to write the code to display default image if no image is available. I'm able to display image if data is available. Not able figure how to echo if/else statment.


Below is the code
Code: [Select]
<?php

function perDetails($var1, $result, $var2){
$dft_img = 'lib/images/name.png';
echo '<div class="desc">'.$var1.'</div>';
 
$color="1";
echo '<table align="center" cellpadding="2" cellspacing="1">';
while($row = mysql_fetch_array($result)){
$id = $row['pid'];
$name = $row['pname'];
$img = $row['pphoto_localurl'];
$poster = str_replace("./", "lib/", $img);
if($color==1){
echo '<tr bgcolor="#FFC600"><td><img src="'.$poster.'" width="32" height="42" alt="'.$name.'"</td><td><a href="persons.php?det='.$var2.'&perid='.$id.'"> '.$name.'" </a></td></tr>';
$color="2";
}
else {
echo '<tr bgcolor="#C6FF00"><td><img src="'.$poster.'" width="32" height="42" alt="'.$name.'"</td><td><a href="persons.php?det='.$var2.'&perid='.$id.'"> '.$name.'" </a></td></tr>';
$color="1";
}
}
echo '</table>';
}
?>

i've found a pagination script of the internet but the image comes up blank. I've stored it in a largeblob. When i check the html it says 'array[name]' as the image pz help me heres the code:

<?php

//connection stuff here

$page = 1;
if ( isset( $_GET['page'] ) ) {
$page = (int) $_GET['page'];
}

$query = mysql_query("SELECT COUNT(*) FROM `upload`",$link);
list( $total ) = mysql_fetch_row( $query );
$total = ceil( $total / $perPage );
$start = ( $perPage * ( $page - 1 ) );
$limit = '';
$show = true;
if ( $total > 1 ) {
$limit = " LIMIT {$start}, {$perPage}";
}
else {
$show = false;
}

$query = mysql_query("SELECT * FROM `upload` ORDER BY `id`{$limit}");
while( $row = mysql_fetch_assoc( $query ) ) {
echo "<img src=\"{$row['file_name']}\" alt=\"{$row['name']}\" title=\"{$row['name']}\" />";
}

if ( $show ) {
$prev = $page - 1;
$next = $page + 1;
if ( $prev > 0 ) {
echo "<a href=\"{$thispage}?page={$prev}\">[PREV]</a>";
}
if ( $next < $total ) {
echo "<a href=\"{$thispage}?page={$next}\">[NEXT]</a>";
}
}

?>

hi all

i have a problem here,

Iv got a form  that uploads images to a folder and updates the db with the name of that image, that work ok

but if one of the upload field are left blank then the script updates the db with empty values
how can i get it to only update the db with only submitted form field data????

here is the form
Code: [Select]
<?php

if (isset($_GET['id'])) {
$id = $_GET['id'];
}

?>

<form action="ud_image.php?id=<? echo "$id"?>" method="post" enctype="multipart/form-data" name="form1" id="form1">
<table class="udp">
  <tr>
    <th>Thumbnail:</th>
    <td><input type="hidden" name="MAX_FILE_SIZE" value="1029120" />
<input name="ufile[]" type="file" id="ufile[]" size="50" /></td>
</tr>
  <tr>
    <th>Image 1:</th>
    <td><input type="hidden" name="MAX_FILE_SIZE" value="1029120" />
<input name="ufile[]" type="file" id="ufile[]" size="50" /></td>
  </tr>
  <tr>
    <th>Image 2:</th>
    <td><input type="hidden" name="MAX_FILE_SIZE" value="1029120" />
<input name="ufile[]" type="file" id="ufile[]" size="50" /></td>
  </tr>
  <tr>
    <th>Image 3:</th>
    <td><input type="hidden" name="MAX_FILE_SIZE" value="1029120" />
<input name="ufile[]" type="file" id="ufile[]" size="50" /></td>
  </tr>
  <tr>
    <th>Image 4:</th>
    <td><input type="hidden" name="MAX_FILE_SIZE" value="1029120" />
<input name="ufile[]" type="file" id="ufile[]" size="50" /><input type="submit" name="Submit" value="Upload" /></td>
  </tr>
</table>
</form>



and here is the

processing page


<?php
include("protect/password_protect.php");

error_reporting(E_ALL);

include ("../includes/db_config.php");

$con = mysql_connect($db_hostname,$db_username,$db_password);
@mysql_select_db($db_database) or die( "Unable to select database");


$path1= "../thumbnails/".$_FILES['ufile']['name'][0];
$path2= "../images/".$_FILES['ufile']['name'][1];
$path3= "../images/".$_FILES['ufile']['name'][2];
$path4= "../images/".$_FILES['ufile']['name'][3];
$path5= "../images/".$_FILES['ufile']['name'][4];

//copy file to where you want to store file
copy($_FILES['ufile']['tmp_name'][0], $path1);
copy($_FILES['ufile']['tmp_name'][1], $path2);
copy($_FILES['ufile']['tmp_name'][2], $path3);
copy($_FILES['ufile']['tmp_name'][3], $path4);
copy($_FILES['ufile']['tmp_name'][4], $path5);
?>

<html>

<head>
<title>Update Project Images</title>
<link rel="stylesheet" type="text/css" href="../../project/backend/style.css" />
</head>
<body>
<table class="udip">
  <tr>
    <th><? echo "<img src=\"$path1\" width=\"150\" height=\"150\">";?></th>
    <th><? echo "<img src=\"$path2\" width=\"150\" height=\"150\">";?></th>
    <th><? echo "<img src=\"$path3\" width=\"150\" height=\"150\">";?></th>
    <th><? echo "<img src=\"$path4\" width=\"150\" height=\"150\">";?></th>
    <th><? echo "<img src=\"$path5\" width=\"150\" height=\"150\">";?></th>
  </tr>
  <tr>
    <td><? echo "File Name :".$_FILES['ufile']['name'][0]."<BR/>";?></td>
    <td><? echo "File Name :".$_FILES['ufile']['name'][1]."<BR/>";?></td>
    <td><? echo "File Name :".$_FILES['ufile']['name'][2]."<BR/>";?></td>
    <td><? echo "File Name :".$_FILES['ufile']['name'][3]."<BR/>";?></td>
    <td><? echo "File Name :".$_FILES['ufile']['name'][4]."<BR/>";?></td>
  </tr>
  <tr>
    <td><?echo "File Size :".$_FILES['ufile']['size'][0]."<BR/>";?></td>
    <td><?echo "File Size :".$_FILES['ufile']['size'][1]."<BR/>";?></td>
    <td><?echo "File Size :".$_FILES['ufile']['size'][2]."<BR/>";?></td>
    <td><?echo "File Size :".$_FILES['ufile']['size'][3]."<BR/>";?></td>
    <td><?echo "File Size :".$_FILES['ufile']['size'][4]."<BR/>";?></td>
  </tr>
  <tr>
    <td><? echo "File Type :".$_FILES['ufile']['type'][0]."<BR/>";?></td>
    <td><? echo "File Type :".$_FILES['ufile']['type'][1]."<BR/>";?></td>
    <td><? echo "File Type :".$_FILES['ufile']['type'][2]."<BR/>";?></td>
    <td><? echo "File Type :".$_FILES['ufile']['type'][3]."<BR/>";?></td>
    <td><? echo "File Type :".$_FILES['ufile']['type'][4]."<BR/>";?></td>
  </tr>
</table>
</body>
</html>
<?
$filesize1=$_FILES['ufile']['size'][0];
$filesize2=$_FILES['ufile']['size'][1];
$filesize3=$_FILES['ufile']['size'][2];
$filesize4=$_FILES['ufile']['size'][3];
$filesize5=$_FILES['ufile']['size'][4];

if($filesize1 && $filesize2 && $filesize3 && $filesize4 && $filesize5 != 0)

{
echo "We have recieved your files<p>";
}

else {
echo "Error in you images check and try again Database has been updated to blank images so no images will be shown on details page.";
}


$query = "UPDATE $db_table SET 
thumbnail = '".$_FILES['ufile']['name'][0]."', image1 = '".$_FILES['ufile']['name'][1]."', image2 = '".$_FILES['ufile']['name'][2]."', image3 = '".$_FILES['ufile']['name'][3]."', image4 = '".$_FILES['ufile']['name'][4]."' WHERE id = '".$_GET['id']."'";


if (!mysql_query($query,$con))
  {
  die('Error: ' . mysql_error());
  }
echo "1 record added";

mysql_close($con)


?>

When the form is summited it is supposed to check if the password field contained any text so that way it updates the password. so only if $password exists should it run that query. I tried all different ways of making that happen and it never works. I will summit the form without anything in the password field and it will still update the password to something encrypted in md5 anyways.
Code: [Select]
<?php
include ('header.php');

if(isset($_GET['sa'])) {
  switch ( $_GET['sa']) {

case 'edit':
edit();
break;

}

  }else{


echo "<div class='header'>Edit admins</div><div class='content'>";
$query = mysql_query("SELECT * FROM `admins`");
while($row = mysql_fetch_array($query)){
$username = clean_up($row['username']);
$id = clean_up($row['id']);
$email = clean_up($row['email']);
$website = clean_up($row['website']);
echo "$id $username $email $website | <a href='index.php?action=editadmins&sa=edit&id=$id'> Edit</a><br>"; 
}


echo "</div>";
}

function edit() {
$id = clean_up($_GET['id']);

if(isset($_POST['submit'])){
$username = clean_up($_POST['username']);
$password = md5(clean_up($_POST['password']));
$email = clean_up($_POST['email']);
$website = clean_up($_POST['website']);

if(isset($username)){
if(isset($password)){
mysql_query("UPDATE `admins` SET `password`='$password' WHERE `id`='$id'");
}

mysql_query("UPDATE `admins` SET `username`='$username', `email`='$email', `website`='$website' WHERE `id`='$id'");

echo "<b><font color=green>Information edited. Go <a href='index.php'>home</a>?</font></b><br>";

}else{
echo "please enter a username";
}

}else{

$query = mysql_query("SELECT * FROM `admins` WHERE `id`='$id'");
while($row = mysql_fetch_array($query)){
$username = clean_up($row['username']);
$email = clean_up($row['email']);
$website = clean_up($row['website']);

echo "<div class='header'>Edit $username</div><div class='content'><form action='index.php?action=editadmins&sa=edit&id=$id' method='post'>
<b>Username:</b> <input type='text' name='username' id='username' value='$username'><br>
<b>Password:</b>(leave blank to keep same) <input type='password' name='password' id='password' value=''><br>
<b>Email:</b> <input type='text' name='email' id='email' value='$email'><br>
<b>Website:</b> <input type='text' name='website' id='website' value='$website'><br>
<input type='submit' name='submit' id=submit' value='Edit $username'></form></div>";

}

}

}


include('footer.php'); ?>
   

Hello there,

Please have a look on the below given code:

Code: [Select]
<?php
function renderform($wardno, $demandno, $name)
{
include_once $_SERVER['DOCUMENT_ROOT'].'/header.php';
include_once $_SERVER['DOCUMENT_ROOT'].'/config/config.php';
include_once $_SERVER['DOCUMENT_ROOT'].'/functions/functions.php';
include_once $_SERVER['DOCUMENT_ROOT'].'/functions/connect-db.php';
extract($GLOBALS);
?>
<link rel=stylesheet HREF="/css/sp.css" type="text/css" media="screen">
<div id="content">
<div id="labelopt"></div>
<h2>okMZokj ukxfjdksa dh lwph</h2>
<div id="dp-sp">
<form name="spsearchform" action="" method="post">
<table border="1">
<tr>
<td id="labelmust" width="10%">fM- dz- %</td>
<td><input class="english" type="text" size="15%" name="demandno" maxlength="40" value="<?php echo $demandno; ?>" /></td>
<td id="labelmust" width="10%">okMZ dz- %</td>
<td><input class="english" size="20%" type="text" size="15%" name="wardno" maxlength="3" value="<?php echo $wardno; ?>"/></td>
<td id="labelmust" width="10%">uke %</td>
<td><input class="hindi" size="30%" type="text" name="name" maxlength="100" value="<?php echo $name; ?>"/></td>
<td><input type="submit" value="Search" name="btnsearch" /></td>
</tr>
</table>
</form>
<table border="1" cellpadding="2px">
<tr>
<td id="labelcenter">okMZ dz-</td>
<td id="labelcenter">fMeka.M dzekad</td>
<td id="labelcenter">uke</td>
<td id="labelcenter">irk</td>
<td id="labelcenter">Hkqxrku</td>
<td id="labelcenter">fu;kstu</td>
<td id="labelcenter">feVk;sa</td>
</tr>
<?php
if ($demandno == '' && $wardno == '' && $name == '') // all empty.
{
$result = mysql_query("SELECT * FROM sform order by wardno, id, demandno") or die(mysql_error());
}
if ($demandno != '' && $wardno != '' && $name != '') // all full.
{
$result = mysql_query("SELECT * FROM sform where demandno='$demandno' and wardno='$wardno' and (name like '%$name%') order by wardno, id, demandno") or die(mysql_error());
}
if ($demandno != '' && $wardno == '' && $name == '') // demand full else empty.
{
$result = mysql_query("SELECT * FROM sform where demandno='$demandno' order by wardno, id, demandno") or die(mysql_error());
}
if ($demandno != '' && $wardno != '' && $name == '') // demand and ward full else empty.
{
$result = mysql_query("SELECT * FROM sform where demandno='$demandno' and wardno='$wardno' order by wardno, id, demandno") or die(mysql_error());
}
if ($demandno == '' && $wardno != '' && $name == '') // ward full else empty.
{
$result = mysql_query("SELECT * FROM sform where wardno='$wardno' order by wardno, id, demandno") or die(mysql_error());
}
if ($demandno == '' && $wardno != '' && $name != '') // ward and name full else empty.
{
$result = mysql_query("SELECT * FROM sform where wardno='$wardno' and (name like '%$name%') order by wardno, id, demandno") or die(mysql_error());
}
if ($demandno == '' && $wardno == '' && $name != '') // name full else empty.
{
$result = mysql_query("SELECT * FROM sform where (name like '%$name%') order by wardno, id, demandno") or die(mysql_error());
}
if ($demandno != '' && $wardno == '' && $name != '') // demand and name full else empty.
{
$result = mysql_query("SELECT * FROM sform where demandno='$demandno' and (name like '%$name%') order by wardno, id, demandno") or die(mysql_error());
}
         $perpage = 20;
    $totalresults = mysql_num_rows($result);
    $totalpages = ceil($totalresults / $perpage);
    
        if (isset($_GET['page']) && is_numeric($_GET['page']))
        {
         $showpage=$_GET['page'];
        
if ($showpage > 0 && $showpage <= $totalpages)
{
$start = ($showpage - 1) * $perpage;
$end = $start + $perpage; 
}
else
{
// error - show first set of results
$start = 0;
$end = $perpage; 
}
        }
else
{
    // if page isn't set, show first set of results
    $start = 0;
    $end = $perpage; 
}

echo "<div id='labelmust'><blink>dqy ukxfjd% $totalresults</blink></div><div id='labelmust'></div>";
    echo "<div align='center' style='margin-right: 10px; color: darkgreen;'>";
        for ($i = 1; $i <= $totalpages; $i++)
        {
echo "<a href='splist.php?page=$i'>$i</a> ";
}
    echo "</div>";
   
    if ($totalresults > 0)
    {
     for($i=$start; $i<=$end; $i++)
     {
     if ($i == $totalresults) { break; }

echo "<tr>";
echo '<td width="10%"><center>' . mysql_result($result, $i, 'wardno') . '</center></td>';
echo '<td width="10%" id=\'labelenglish\'><center>' . mysql_result($result, $i, 'demandno') . '</center></td>';
echo '<td width="30%">' . mysql_result($result, $i, 'name') . '</td>';
echo '<td width="30%">' . mysql_result($result, $i, 'address') . '</td>';
echo '<td><center><a href="sppayment.php?demandno=' . mysql_result($result, $i, 'demandno') . '">Hkqxrku</center></a></td>';
echo '<td><center><a href="spedit.php?demandno=' . mysql_result($result, $i, 'demandno') . '">cnysa</center></a></td>';
    echo '<td><center><a href="spdelete.php?demandno=' . mysql_result($result, $i, 'demandno') . '">feVk;sa</center></a></td>';
     echo "</tr>"; 
}
}
else
{
echo "<tr>";
echo "<td colspan='7' align='center'><blink><strong>lwph miyC/k ugha gS A</strong></blink></td>";
echo "</tr>";
}
?>
</tr>
</table>
</div>
<?php
echo "<div align='center' style='margin-right: 10px; color: darkgreen;'>";
for ($i = 1; $i <= $totalpages; $i++)
{
echo "<a href='splist.php?page=$i'>$i</a> ";
}
echo "</div>";
?>
<div id="menu">
<table>
<tr>
<td>
<input type="button" name="btnprint" value="Print" />
<input type="button" value="New" name="btnnew" onclick="location.href='spnew.php';" />
<input type="button" value="Back" name="btnspback" onclick="location.href='../sp.php';" />
</td>
</tr>
</table>
</div>
</div>

<?php include_once $_SERVER['DOCUMENT_ROOT'].'/footer.php'; 
}
include_once $_SERVER['DOCUMENT_ROOT'].'/functions/connect-db.php';
include_once $_SERVER['DOCUMENT_ROOT'].'/functions/functions.php';
if(isset($_POST['btnsearch']))
{
$demandno = mysql_real_escape_string(htmlspecialchars($_POST['demandno']));
$wardno = mysql_real_escape_string(htmlspecialchars($_POST['wardno']));
$name = mysql_real_escape_string(htmlspecialchars($_POST['name']));

renderform($demandno, $wardno, $name);
}
else
{
renderform('', '', '');
}
?>

In the above code the pagination is working perfectly.
After entering any value in the textboxes and pressing the search button also gives me the correct results with pagination.

The problem occurs when we press the page links after any search. It shows the complete results again, rather than changing pages in the current search.

Please help...

I have included the php file I'm using. It is currently working on the internet, but doesn't work local. I'm not sure why. The last 2 lines of code call for the pagination and a footer of which neither show up on my local system.
Any help would be appreciated. This is the script working on my site on the internet.

http://vetstuf.com/jewelry/jewelry3_1.php

<?php

include 'form_j.php';

$tbl_name="images";
$search=$_POST["search"];
$con = mysql_connect("localhost", "root", "1910") or die ('Error connecting to mysql');
mysql_select_db("test") or die(mysql_error());

$query = "SELECT * FROM $tbl_name";

$result = mysql_query($query) or die("There was a problem with the SQL query: " . mysql_error());
if($result && mysql_num_rows($result) > 0)

//Place code to connect to your DB here.




// How many adjacent pages should be shown on each side?
$adjacents = 2;

/*
   First get total number of rows in data table.
   If you have a WHERE clause in your query, make sure you mirror it here.
*/
$query = "SELECT COUNT(*) as num FROM $tbl_name";
$total_pages = mysql_fetch_array(mysql_query($query));
$total_pages = $total_pages[num];

/* Setup vars for query. */
$targetpage = "image_test_2.php";  //your file name  (the name of this file)

$limit = 4;  //how many items to show per page

$page = $_GET['page'];
if($page)
$start = ($page - 1) * $limit;  //first item to display on this page
else
$start = 0; //if no page var is given, set start to 0

/* Get data. */
$sql = "SELECT * FROM $tbl_name LIMIT $start, $limit";
$result = mysql_query($sql);

/* Setup page vars for display. */
if ($page == 0) $page = 1; //if no page var is given, default to 1.
$prev = $page - 1; //previous page is page - 1
$next = $page + 1; //next page is page + 1
$lastpage = ceil($total_pages/$limit); //lastpage is = total pages / items per page, rounded up.
$lpm1 = $lastpage - 1; //last page minus 1

/*
Now we apply our rules and draw the pagination object.
We're actually saving the code to a variable in case we want to draw it more than once.
*/
$pagination = "";
if($lastpage > 1)
{
$pagination .= "<div class=\"pagination\">";
//previous button
if ($page > 1)
$pagination.= "<a href=\"$targetpage?page=$prev\">previous</a>";
else
$pagination.= "<span class=\"disabled\">previous</span>";

//pages
if ($lastpage < 7 + ($adjacents * 2)) //not enough pages to bother breaking it up
{
for ($counter = 1; $counter <= $lastpage; $counter++)
{
if ($counter == $page)
$pagination.= "<span class=\"current\">$counter</span>";
else
$pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>";
}
}
elseif($lastpage > 5 + ($adjacents * 2)) //enough pages to hide some
{
//close to beginning; only hide later pages
if($page < 1 + ($adjacents * 2))
{
for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++)
{
if ($counter == $page)
$pagination.= "<span class=\"current\">$counter</span>";
else
$pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>";
}
$pagination.= "...";
$pagination.= "<a href=\"$targetpage?page=$lpm1\">$lpm1</a>";
$pagination.= "<a href=\"$targetpage?page=$lastpage\">$lastpage</a>";
}
//in middle; hide some front and some back
elseif($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2))
{
$pagination.= "<a href=\"$targetpage?page=1\">1</a>";
$pagination.= "<a href=\"$targetpage?page=2\">2</a>";
$pagination.= "...";
for ($counter = $page - $adjacents; $counter <= $page + $adjacents; $counter++)
{
if ($counter == $page)
$pagination.= "<span class=\"current\">$counter</span>";
else
$pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>";
}
$pagination.= "...";
$pagination.= "<a href=\"$targetpage?page=$lpm1\">$lpm1</a>";
$pagination.= "<a href=\"$targetpage?page=$lastpage\">$lastpage</a>";
}
//close to end; only hide early pages
else
{
$pagination.= "<a href=\"$targetpage?page=1\">1</a>";
$pagination.= "<a href=\"$targetpage?page=2\">2</a>";
$pagination.= "...";
for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter <= $lastpage; $counter++)
{
if ($counter == $page)
$pagination.= "<span class=\"current\">$counter</span>";
else
$pagination.= "<a href=\"$targetpage?page=$counter\">$counter</a>";
}
}
}

//next button
if ($page < $counter - 1)
$pagination.= "<a href=\"$targetpage?page=$next\">next</a>";
else
$pagination.= "<span class=\"disabled\">next</span>";
$pagination.= "</div>\n";
}
?>
<?php
{
    $i = 0;
    $max_columns = 2;
echo "<br>";
    while($row = mysql_fetch_array($result))
   {
       // make the variables easy to deal with
       extract($row);

       // open row if counter is zero
       if($i == 0)

          echo "<tr>";

          echo "<td>";
          ?>
          <div>
               <a id="thumb1" href="images/<?php echo $image; ?>" class="highslide" onclick="return hs.expand(this)">
<img src="images/<?php echo $image; ?>" title="Click to enlarge" width = "300"/></a>
          <div class="highslide-caption"><?php echo $id; ?> <?php echo $caption; ?></div>



          <?php
          echo "</td>";

       // increment counter - if counter = max columns, reset counter and close row
       if(++$i == $max_columns)
       {
           echo "</tr>";
           $i=0;
       }  // end if
   } // end while
} // end if results

// clean up table - makes your code valid!
if($i > 0)
{
    for($j=$i; $j<$max_columns;$j++)
        echo "<td>&nbsp;</td>";
   echo "</tr>";
}
mysql_close($con);
?>
</table>
</body>
</html></br>
<?=$pagination?>
<? require 'footer_j.php';?>

The problem is this:

When I upload more images, it will create more pages. That works fine, however, It seems when an image get bumped to a new page, it doesn't create a link to that said page. For example, In my Nature/Animals category, I have 5 images in there in total. It should create three pages and links to each page. It created the pages, but only shows "Previous 1 2." There isn't a Next button to page three at all. I have it set to show 2 images per page. So now I need to figure out how to get it right...


This is my paging class
Code: [Select]
class paging {
   
    public function getPages($pages, $cid, $page_count) {
        global $db, $SK, $plang, $getURL;
       
        $this->pages = $pages;
        $this->cid = $cid;
        $this->page_count = $page_count;
       
       if(!isset($_GET['section'])) {
           $page = 1;
       } else {
           $page = $_GET['section'];
       }
       
       $prev = $page - 1;
       $next = $page + 1;
       
       $this->render = '';
       
       if($prev > 0){
       $this->render .= "<a href='{$getURL['site_url']}index/category/{$this->cid}/$prev'>Previous</a> ";
   }
       if($this->pages > 1){
       if($pages >= 1 && $page <= $this->pages){
           for($x=1; $x<=$this->pages; $x++)
           {
               $this->render .= " <a href='{$getURL['site_url']}index/category/{$this->cid}/$x'>$x</a> ";
           }
        }
       }
       
        if($page < ceil($this->pages/$this->page_count)){
        $this->render .= "<a href='{$getURL['site_url']}index/category/{$this->cid}/$next'>Next </a> ";
}
        return $this->render;
    }
   
    public function pageCount($table, $pid,  $field, $page_count) {
        global $db;
       
        $this->pid = $pid;
        $this->field = $field;
        $this->page_limit = $page_count;
       
        $this->count_query = $db->getCount("SELECT * FROM $table WHERE `$this->field`=$this->pid");
        $this->round_cr = ceil($this->count_query) / $this->page_limit;
       
        return $this->round_cr;
       
    }
   
}
And the bit of code that displays the images.
Code: [Select]
public function photoView(){
        global $db, $SK, $plang, $PG;
       
        $photoid = (int) $_GET['id'];
        $field = 'catid';
        $page_count = 2;
 
        $section = (isset($_GET['section']) AND (int)$_GET['section'] > 0) ? (int)$_GET['section'] : 1;

if($section) {
        $page_start = ($section - 1) * $page_count;
} else {
$page_start = 0;
       
}

        $start = $PG->pageCount('photos', $photoid, $field, $page_count);
       
        if(!empty($photoid))
        {
            $photo_query = $db->query("SELECT * FROM photos WHERE catid='$photoid' ORDER BY `id` DESC LIMIT $page_start, $page_count");
            $photo_result = $db->get();           
           
            if(count($photo_result) == '') {
                $this->render .= "No Images to display";
            } else {
                $columns = $this->setresult[0]['colsnum'];
                $colnum = 2;
               
                    $this->render .= $SK->photoHeader();
           
                foreach ($photo_result as $pkey => $pvalue) {
                if($colnum < $columns) {
                if($colnum == 0){
                        $this->render .= "<tr>";
                    }
                    $this->render .= $SK->photoRow($pvalue);
                } else {
                    $colnum = 0;
                    $this->render .= $SK->photoRow2($pvalue);
                   
                }
                $colnum++;
               
                }
                    $this->render .= $SK->photoFooter();


            $this->render .= "<div style=\"text-align: center;font-weight: bold;\">" . $PG->getPages($start, $pvalue['catid'], $page_count) . "</div>";
            }           
        } else {
         $this->render = "Error: You have chosen the wrong path";
        }
       
        return $this->render;
    }
You can go to my Nature and Animals category at my site to see the problem Here. You will see the links, but once you go to page 2 there isn't a page three. If you change the 2 to a 3 in the address bar , you will see another image. Like this. You will see that the page links one and two disappear and leaves the previous link...

So any idea on what the problem is? I need help -____-

I don't understand why this is happening. I use the same exact code (but different mysql table) and the pagination works fine.

Here's the code:

Code: [Select]
.....

<body id="set-database">
 <div class="wrapper">
<?php
 include("navigation.php");
?>
  <div class="full">

<?php
$make = $_POST["sel1"];
$model = $_POST["sel2"];
echo "$make - $model";

if ( $make == "--MAKES--" )
 {
  echo "<div class=\"red\">Please select a Make</div>";
 }
 else
 {

  echo "<center><font color=\"#3333FF\">$make</font> - <font color=\"#3333FF\">$model</font></center><br />";


$mysql_host = --
$mysql_database=  --
$mysql_user = --
$mysql_password = --

$conn = mysql_connect("$mysql_host","$mysql_user","$mysql_password") or trigger_error("SQL", E_USER_ERROR);
$db = mysql_select_db("$mysql_database",$conn) or trigger_error("SQL", E_USER_ERROR);

// find out how many rows are in the table 
$sql = "SELECT COUNT(*) FROM ACTIVE WHERE MODEL='$model'";
$result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);
$r = mysql_fetch_row($result);
$numrows = $r[0];

// number of rows to show per page
$rowsperpage = 5;
// find out total pages
$totalpages = ceil($numrows / $rowsperpage);

// get the current page or set a default
if (isset($_GET['currentpage']) && is_numeric($_GET['currentpage'])) {
   // cast var as int
   $currentpage = (int) $_GET['currentpage'];
} else {
   // default page num
   $currentpage = 1;
} // end if

// if current page is greater than total pages...
if ($currentpage > $totalpages) {
   // set current page to last page
   $currentpage = $totalpages;
} // end if
// if current page is less than first page...
if ($currentpage < 1) {
   // set current page to first page
   $currentpage = 1;
} // end if

// the offset of the list, based on current page 
$offset = ($currentpage - 1) * $rowsperpage;


$sql = "SELECT * FROM ACTIVE WHERE MODEL='$model' ORDER BY INDEX_ID DESC LIMIT $offset, $rowsperpage";
$result = mysql_query($sql, $conn) or die('Error: ' . mysql_error());

echo "
<table width=100% align=center border=1 class=\"mod\"><tr>
 <td align=center bgcolor=#00FFFF><b>Rating</b></td>
 <td align=center bgcolor=#00FFFF><b>Title</b></td>
 <td align=center bgcolor=#00FFFF><b>Make/Model</b></td>
 <td align=center bgcolor=#00FFFF><b>Type</b></td>
 <td align=center bgcolor=#00FFFF><b>Difficulty</b></td>
 <td align=center bgcolor=#00FFFF><b>Comments</b></td>
 <td align=center bgcolor=#00FFFF><b>Views</b></td>
</tr>"; 
   
     while ($row = mysql_fetch_assoc($result)) {
     { // Begin while
      $title = $row["TITLE"];
      $type = $row["TYPE"];
      $difficulty = $row["DIFFICULTY"];
      $comments = $row["COMMENT_TOTAL"];
      $id = $row['INDEX_ID'];
      $rating = $row["RATING_AVERAGE"];
      $make = $row["MAKE"];
      $model = $row["MODEL"];
      $views = $row["HITS"];

     echo "
     <tr>
      <td><div class=\"\">$rating/10</div></td>
      <td><div class=\"\"><a href=\"mod.php?id=$id\">$title</a></div></td>
      <td><div class=\"\">$make - $model</div></td>
      <td><div class=\"\">$type</div></td>
      <td><div class=\"\">$difficulty</div></td>
      <td><div class=\"\">$comments</div></td>
      <td><div class=\"\">$views</div></td>
     </tr>";
    }
   }
   echo "</table><br />"; 
    /******  build the pagination links ******/
echo "<center>";
// range of num links to show
$range = 3;
echo "<i>Page: </i>";
// if not on page 1, don't show back links
if ($currentpage > 1) {
   // get previous page num
   $prevpage = $currentpage - 1;
   // show < link to go back to 1 page
   echo " <a stylehref='{$_SERVER['PHP_SELF']}?currentpage=$prevpage'>Previous</a> - ";
} // end if 

// loop to show links to range of pages around current page
for ($x = ($currentpage - $range); $x < (($currentpage + $range) + 1); $x++) {
   // if it's a valid page number...
   if (($x > 0) && ($x <= $totalpages)) {
      // if we're on current page...
      if ($x == $currentpage) {
         // 'highlight' it but don't make a link
         echo " <b>$x</b> ";
      // if not current page...
      } else {
         // make it a link
         echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$x'>$x</a> ";
      } // end else
   } // end if 
} // end for
                 
// if not on last page, show forward and last page links        
if ($currentpage != $totalpages) {
   // get next page
   $nextpage = $currentpage + 1;
    // echo forward link for next page 
   echo " - <a href='{$_SERVER['PHP_SELF']}?currentpage=$nextpage'>Next</a> ";
} // end if
/****** end build pagination links ******/
mysql_close($conn);
}
echo "$pagination</center>";
?>
<br />
<FORM><INPUT TYPE="button" class="btn" VALUE="Back" onClick="history.go(-1);return true;"> </FORM>
   </div>
<?php
include("footer.html");
?>

When I click the link for the next page and goes to it, there is nothing in the table (so the information isn't there). So the links and everything bring you the correct page, but that page doesn't have any of the information. Like I said, I use the same exact code except it pulls different information and that works no problem.

Thanks!

Hi guys,

I'm having a little problem with a pagination code i'm using.
Its for an image gallery, and I want to show the total amount of pictures in a set, and then the current picture displayed. I've got the total number, however its the current photo that i'm stuck on.

Its linked into a mysql database, with two tables, one for the categories and the other for the photos.

Category 1:
Image ID 1, 2, 3 etc

Category 2:

Image ID 4, 5, 6 etc

Now, my code works fine if they are all in order like this, but obviously images are deleted and replaced. so it could turn out like this:

Category 1:
Image ID 1, 2, 5, 8 etc

Here is the code:


$result = mysql_query("SELECT COUNT(photo_id) FROM gallery_photos WHERE photo_category='".addslashes($cid)."' GROUP BY photo_category ") or die(mysql_error());
list($num_rows)=mysql_fetch_array($result);
mysql_free_result( $result );

$counting = mysql_query("SELECT photo_id FROM gallery_photos WHERE photo_category='".addslashes($cid)."' ");



$counter="1";





while($row = mysql_fetch_array($counting))
{
$id = $row['photo_id'];
if($id == $pid)
{
if ($counter <= "9")
{
echo "0";
echo $counter;
} else 
{
echo $counter;
} 
} else {
$counter++;
}

}
}
echo "/";
if ($num_rows <= "9"){
echo "0";
echo $num_rows;
} else {
echo $num_rows;
}
}


Any help would be hugely helpful as i'm really stuck on this!

Thanks

Edd

Hi guys,

well I'm trying to formulate pagination view of my results from a Mysql query in my database. The thing is that the query is not known beforehand, since the user of the database can enter several search terms in text fields of the webpage (text_search.php) and when he hits the "Submit" button, the new page (retrieve_text.php) looks about which text fields have been filled and appends the values in the mysql query like this:

Code: [Select]
$text_query = ...... WHERE [user-defined conditions]

Everything is OK until now. But I wanted to show the results more clear to the user, since it can have e.g 600 results so it's not so good to view them in a loooooooooong page. So I tried to paginate them.

Now comes the problem: the first page looks Ok, and brings only 25 results, which I want to be the limit of results to show per page. BUT, when I click on the "Next button", I see nothing. The reason? In pages 2,3...N, the $text_query is empty since there are no values submitted through the $_POST variable..., So, in the 1st page, if I print the SQL query I have something like that:

Code: [Select]
SELECT DISTINCT protein.protein_id, protein.protein_name FROM protein LEFT JOIN protein_reference ON protein_reference.prot_ref_protein_id = protein.protein_id LEFT JOIN reference ON reference.reference_id = protein_reference.prot_ref_reference_id LEFT JOIN families ON protein.protein_families_id = families.families_id WHERE protein.protein_name LIKE '%protein%' ORDER BY protein.protein_id LIMIT 0, 25

while in the 2nd page for example I get:

Code: [Select]
SELECT DISTINCT protein.protein_id, protein.protein_name, protein.protein_seq_len, protein.protein_organism, protein_ncbi FROM protein LEFT JOIN protein_reference ON protein_reference.prot_ref_protein_id = protein.protein_id LEFT JOIN reference ON reference.reference_id = protein_reference.prot_ref_reference_id LEFT JOIN families ON protein.protein_families_id = families.families_id WHERE ORDER BY protein.protein_id LIMIT 25, 25

The reason is, as I wrote before, that the where clause in the sql statement is written on-the-fly so the sql search is dynamic and not static. If it was static, like

Code: [Select]
SELECT * from protein WHERE name LIKE '%protein%';

things would be straight-forward.

What can I do? Should/Could I somehow "send" the sql query from page to page? I suppose this is BAD practice, but I don't really know how to proceed...

Hi, I new to php and I'm having problem with pagination. the problem is If I clicked next link or last page or any page link, it goes back to the home page and I've used PHP_SELF to establish the link. All I know something is wrong in my pagination link. May be there is pre defined value for PHP_SELF to be recorgnized or certain value is missing in my pagination link.
Here is  my code

Code: [Select]
include("conn.php");
if(($_POST["orga_name"]) && empty($_POST["title"])) {
$sql = "select * from client_info where Name LIKE '%".$_POST["orga_name"]."%'";
$result = mysql_query($sql);
$r = mysql_num_rows($result);
include("form_search.php");
if ($r == 0 ){
echo "No records found";
}
else {
//pagination inaanzia hapa
// how many rows to show per page
$rowsPerPage = 5;
// by default we show first page
$pageNum = 1;
// if $_GET['page'] defined, use it as page number
if(isset($_GET['page']))
{
$pageNum = $_GET['page'];
}
// how many pages we have when using paging
$maxPage = ceil($r/$rowsPerPage);
$offset = ($pageNum - 1) * $rowsPerPage;
//pagination inaishia hapa
$sql = "select * from client_info where Name LIKE '%".$_POST["orga_name"]."%' LIMIT $offset,$rowsPerPage";
$result = mysql_query($sql);   
//echo $r;
echo "<table>";
echo "<tr><td class='title'>"."Name"."</td><td>&nbsp;</td><td class='title'>"."Box No"."</td><td>&nbsp;</td><td class='title'>"."Town/City"."<td></td><td>&nbsp;</td><td class='title'>"."Phone Number"."</td><td>&nbsp;</td><td class='title'>"."Email"."</td><td>&nbsp;</td><td class='title'>"."Website"."</td><td>&nbsp;</td></tr>";         
       $i=1;
         
            while($row=mysql_fetch_array($result))
         {
         $name = $row["Name"];
         $address = $row["POBoxNo"];
         $town = $row["TownCity"];
         $phonenumber = $row["OfficePhoneNumber"];
         $email = $row["Email"];
         $web = $row["Web"];
         
   if($i%2){
         echo "<tr><td class='odd'>"."<br>".$name."<br>"."&nbsp"."</td><td>&nbsp;</td><td class='odd'>".$address."</td><td>&nbsp;</td><td class='odd'>".$town."<td></td><td>&nbsp;</td><td class='odd'>".$phonenumber."</td><td>&nbsp;</td><td class='odd'>".$email."</td><td>&nbsp</td><td class='odd'>".$web."</td></tr>";   
          }
        else{   
         echo "<tr><td class='even'>"."<br>".$name."<br>"."&nbsp"."</td><td>&nbsp;</td><td class='even'>".$address."</td><td>&nbsp;</td><td class='even'>".$town."<td></td><td>&nbsp;</td><td class='even'>".$phonenumber."</td><td>&nbsp;</td><td class='even'>".$email."</td><td>&nbsp</td><td class='even'>".$web."</td></tr>";
         }         
         $i++;
      }     
  echo "</table>";
  // print the link to access each page
$self = htmlentities($_SERVER['PHP_SELF']);
$nav = '';
for($page = 1; $page <= $maxPage; $page++)
{
if ($page == $pageNum)
{
$nav .= " $page "; // no need to create a link to current page
}
else
{
$nav .= " <a href=\"$self?page=$page\">$page</a> ";
}
}
// creating previous and next link
if ($pageNum > 1)
{
$page = $pageNum - 1;
$prev = " <a href=\"$self?page=$page\">[Prev]</a> ";
$first = " <a href=\"$self?page=1\">[First Page]</a> ";
}
else
{
$prev = ' '; // we're on page one, don't print previous link
$first = ' '; // nor the first page link
}
if ($pageNum < $maxPage)
{
$page = $pageNum + 1;
$next = " <a href=\"$self?page=$page\">[Next]</a> ";
$last = " <a href=\"$self?page=$maxPage\">[Last Page]</a> ";
}
else
{
$next = ' '; // we're on the last page, don't print next link
$last = ' '; // nor the last page link
}
//echo $nav . "<br />";
echo $next . "  " . $prev ; //"<br />";
echo $first . "  " . $last;
}

Any help will be highly appreciated.

MOD EDIT: [code] . . . [/code] BBCode tags added.

Hello everyone,

I have an ecommerce website and I'm trying to add pagination, but I'm stuck.  I'm sure this will be an easy fix for someone with more experience than me. The first page works fine, but I get an error when I click on Next. I'm at a loss as to why.  Can someone please help...?

The page that gives an error:

http://www.hopefloatsdesign.co.za/shopping/list.php?category=clothing&subcategory=hats

Here is my code:

// Connect to the MySQL database 
 include "storescripts/connect_to_mysql.php";
 $sql = mysql_query("SELECT * FROM products WHERE subcategory='$subcategory'");
 
// Adam's Pagination Logic
$nr = mysql_num_rows($sql); // Get total of Num rows from the database query
if (isset($_GET['pn'])) { // Get pn from URL vars if it is present
    $pn = preg_replace('#[^0-9]#i', '', $_GET['pn']); // filter everything but numbers
} else { // If the pn URL variable is not present force it to be value of page number 1
    $pn = 1;
}

//This is where we set how many database items to show on each page
$itemsPerPage = 6;

// Get the value of the last page in the pagination result set
$lastPage = ceil($nr / $itemsPerPage);
// Be sure URL variable $pn(page number) is no lower than page 1 and no higher than $lastpage
if ($pn < 1) { // If it is less than 1
    $pn = 1; // force if to be 1
} else if ($pn > $lastPage) { // if it is greater than $lastpage
    $pn = $lastPage; // force it to be $lastpage's value
}
// This creates the numbers to click in between the next and back buttons
// This section is explained well in the video that accompanies this script
$centerPages = "";
$sub1 = $pn - 1;
$sub2 = $pn - 2;
$add1 = $pn + 1;
$add2 = $pn + 2;
if ($pn == 1) {
    $centerPages .= '&nbsp; <span class="pagNumActive">' . $pn . '</span> &nbsp;';
    $centerPages .= '&nbsp; <a href="' . $_SERVER['PHP_SELF'] . '?pn=' . $add1 . '">' . $add1 . '</a> &nbsp;';
} else if ($pn == $lastPage) {
    $centerPages .= '&nbsp; <a href="' . $_SERVER['PHP_SELF'] . '?pn=' . $sub1 . '">' . $sub1 . '</a> &nbsp;';
    $centerPages .= '&nbsp; <span class="pagNumActive">' . $pn . '</span> &nbsp;';
} else if ($pn > 2 && $pn < ($lastPage - 1)) {
    $centerPages .= '&nbsp; <a href="' . $_SERVER['PHP_SELF'] . '?pn=' . $sub2 . '">' . $sub2 . '</a> &nbsp;';
    $centerPages .= '&nbsp; <a href="' . $_SERVER['PHP_SELF'] . '?pn=' . $sub1 . '">' . $sub1 . '</a> &nbsp;';
    $centerPages .= '&nbsp; <span class="pagNumActive">' . $pn . '</span> &nbsp;';
    $centerPages .= '&nbsp; <a href="' . $_SERVER['PHP_SELF'] . '?pn=' . $add1 . '">' . $add1 . '</a> &nbsp;';
    $centerPages .= '&nbsp; <a href="' . $_SERVER['PHP_SELF'] . '?pn=' . $add2 . '">' . $add2 . '</a> &nbsp;';
} else if ($pn > 1 && $pn < $lastPage) {
    $centerPages .= '&nbsp; <a href="' . $_SERVER['PHP_SELF'] . '?pn=' . $sub1 . '">' . $sub1 . '</a> &nbsp;';
    $centerPages .= '&nbsp; <span class="pagNumActive">' . $pn . '</span> &nbsp;';
    $centerPages .= '&nbsp; <a href="' . $_SERVER['PHP_SELF'] . '?pn=' . $add1 . '">' . $add1 . '</a> &nbsp;';
}
// This line sets the "LIMIT" range
$limit = 'LIMIT ' .($pn - 1) * $itemsPerPage .',' .$itemsPerPage;
// Now we are going to run the same query as above but this time add $limit onto the end of the SQL syntax
// $sql2 is what we will use to fuel our while loop statement below
$sql2 = mysql_query("SELECT * FROM products WHERE subcategory='$subcategory' $limit");
// END Adam's Pagination Logic
// Adam's Pagination Display Setup
$paginationDisplay = ""; // Initialize the pagination output variable
// This code runs only if the last page variable is not equal to 1
if ($lastPage != "1"){
// This shows the user what page they are on, and the total number of pages
    $paginationDisplay .= 'Page <strong>' . $pn . '</strong> of ' . $lastPage. '&nbsp;  &nbsp;  &nbsp; ';
// If we are not on page 1 we can place the Back button
    if ($pn != 1) {
        $previous = $pn - 1;
        $paginationDisplay .=  '&nbsp;  <a href="' . $_SERVER['PHP_SELF'] . '?pn=' . $previous . '"> Back</a> ';
    }
// Lay in the clickable numbers display here between the Back and Next links
    $paginationDisplay .= '<span class="paginationNumbers">' . $centerPages . '</span>';
    // If we are not on the very last page we can place the Next button
    if ($pn != $lastPage) {
        $nextPage = $pn + 1;
        $paginationDisplay .=  '&nbsp;  <a href="' . $_SERVER['PHP_SELF'] . '?pn=' . $nextPage . '"> Next</a> ';
    }
}
// END Adam's Pagination Display Setup
 
 $dynamicList = "";
 $productCount = mysql_num_rows($sql); // count the output amount
    if ($productCount > 0) {
  // get all the product details
  while($row = mysql_fetch_array($sql2)){
    $id = $row["id"];
    $product_name = $row["product_name"];
    $price = $row["price"];
    $details = $row["details"];
    $category = $row["category"];
    $subcategory = $row["subcategory"];
    $date_added = strftime("%b %d, %Y", strtotime($row["date_added"]));
         $dynamicList .= '<table style="float: left;" width="50%" border="0" cellspacing="0" cellpadding="6">
        <tr>
          <td width="17%" valign="top"><a href="product.php?id=' . $id . '"><img style="border:#666 1px solid;" src="inventory_images/' . $id . '.jpg" alt="' . $product_name . '" width="77" height="102" border="1" /></a></td>
          <td width="83%" valign="top">' . $product_name . '<br />
            R' . $price . '<br />
            <a href="product.php?id=' . $id . '">View Product Details</a></td>
        </tr>
      </table>';
    }
 }
} else {
 $dynamicList = "We have no products listed in our store yet";
}
?>

These are my divs:

<div class="box3">
 <h3><?php echo $category; ?> | <?php echo $subcategory; ?></h3>
 <br />
 <?php echo $dynamicList; ?><br />
    </div>
 
 <div class="box2">
 <?php echo $paginationDisplay; ?><br />
 <br />
 <h3>Total Items: <?php echo $nr; ?></h3>
 </div>