PHP - Sorting Records With Pagination Problem!

Google Chrome Developer Tool causes an error when I run the following and there are not any records.  I keep getting errors when I try to change it.

 

<?php
$host = 'localhost';
$user = 'root';
$pass = '';
$database = 'ecommerce';

$options = array(
    PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
    PDO::ATTR_EMULATE_PREPARES => false
);

$keyword = $_GET['keyword'];

$dbo = new PDO("mysql:host=$host;dbname=$database", $user, $pass, $options);


$q1 = "SELECT * FROM products INNER JOIN keywords on keywords.keywordID = products.KeywordID  and keywords.KeyWord1  = \"$keyword\"  ";

$counter = 10;
$counter1 = 0;

foreach ($dbo->query($q1) as $row) {
  
  

 

Hi Everyone,

I have a page on my website that displays a list of products from a mysql database in a table. Currently when the column titles are clicked, the data is sorted in order with the highest first.


$sort = $_GET['sort'];

if ($sort == 'price')
{

$query = mysql_query("SELECT * FROM products ORDER BY price DESC");
}
else{
$query = mysql_query("SELECT * FROM products ORDER BY product");
}

...

echo "<a href='products.php?sort=price'>Price</a>";


Does anybody know how i would go about setting it up so that if the sort link is clicked a second time, the data is re ordered from descending to ascending? Then if the click is clicked again it would change back to descending, and so on.....?

Many thanks

I'm trying to figure out a way to incorporate multiple sorts on my php page. On the page of products, I want users to have three choices of links: one by date, one by price - low to high and one by price - high to low. I know how to perform ASC & DESC sorts in MySql but I'm not sure how to go about this sort with the three choices without creating more pages. I would really like it to stay with the same page. Is this even possible?? How would I go about it?

Here is the section of code :

 $get_items_sql = mysql_query("SELECT id, thumb, username, sub_id, title, ROUND(price,2) AS price, date FROM product WHERE  CURDATE() <= relist_date AND inactive IS NULL AND sold IS NULL AND cat_id = '1' ORDER BY date ")
or die(mysql_error());;

            if (mysql_num_rows($get_items_sql) < 1)
            {
                $content = "<p><em>Sorry, no items in this category.</em></p>\n";
            }
            else
            {
$col = 0;
                $content .= "<ul>\n";
                while ($items = mysql_fetch_array($get_items_sql))
                {
                    $item_url = "items3.php?id={$items['id']}&username={$items['username']}";
                    $item_title = stripslashes($items['title']);
                    $item_price = $items['price'];
                    $item_photo = $items['thumb'];
                $item_username = $items['username'];
                    $item_date = $items['date'];
                    $content .= "";

              list($width) = getimagesize("image_files/{$item_photo}");
  // set the maximum width of the image here
  $maxWidth = 100;
  if ($width > $maxWidth);
             
             
                   $content .= "<table width=\"693\" border=\"0\" class=anotherfont><tr><td width=\"101\">&nbsp;<a href=\"{$item_url}\">
                    <img alt=\"{$item_title}\" border=0 width=\"{$maxWidth}\" src=\"image_files/{$item_photo}\" /></a><td width=\"200\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href=\"{$item_url}\">{$item_title}</a></td>
                    <td width=\"109\">{$item_username}</td><td width=\"101\">&nbsp;{$item_date}</td><td width=\"99\">\${$item_price}&nbsp;USD </td></tr></table>";
                    $content .= "\n";

Hello all.

Please I need help to update customer table. I get the texboxes populated with select query no problem.
 I have html page with a search box and when the user enter their first name or last name and click search it will call up the search.php file here is the file:

This code below populate the textboxes to be updated:

Code: [Select]
<?php


     if(isset($_POST['submit'])){ 
     if(isset($_GET['go'])){ 
     if(preg_match("^/[A-Za-z]+/", $_POST['name'])){ 
      $name=$_POST['name']; 
     } 
     } 
     else{ 
     echo  "<p>Please enter a search query</p>"; 
     } 
   }
//connect  to the database 


$con = mysql_connect("localhost","dbusrn","dbpwd");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("mydb", $con);
$name = $_POST['name'];
$result = mysql_query ("select * from Customer_Registration where Firstname like '%$name%' or lastname like '%$name%' ");



$row = mysql_fetch_row($result);
$cf_uid = $row[0];
$Firstname = $row[6];
$lastname = $row[7];
$Address = $row[8];
$Postcode = $row[9];
$Phone = $row[10];
$Email = $row[11];
$Customer_Type = $row[12];
$Computer_type = $row[13];
$Computer_maker = $row[14];
$Model = $row[15];
$OS = $row[16];
$Appointment_date = $row[17];
$Problem = $row[18];
$Solution = $row[19];
$Comment = $row[20];
?>



 <form action="updatecus1.php" method="post">
     
      <table width="100%" border="2" cellspacing="0" cellpadding="8">
     
      <tr><td width="45%" class="FormText">Customer ID:</td>
<td width="55%"><?php echo $cf_uid;?></td></tr>
<tr><td width="45%" class="FormText">First name:</td>
<td width="55%"><input  name="Firstname" type="text" value="<?php echo $Firstname;?>"?> </td></tr>


<tr><td width="45%" class="FormText">Last name:</td>
<td width="55%"><input  name="lastname" type="text" value="<?php echo $lastname;?>"?> </td></tr>



<tr><td width="45%" class="FormText">Address:</td>
<td width="55%"><input  name="Address" type="text" value="<?php echo $Address; ?>"?> </td></tr>

 <tr><td width="45%" class="FormText">Postcode:</td>
<td width="55%"><input  name="Postcode" type="text" value="<?php echo $Postcode; ?>"?> </td></tr>


 <tr><td width="45%" class="FormText">Phone:</td>
<td width="55%"><input  name="Phone" type="text" value="<?php echo $Phone; ?>"?> </td></tr>

 <tr><td width="45%" class="FormText">Email:</td>
<td width="55%"><input  name="Email" type="text" value="<?php echo $Email; ?>"?> </td></tr>

 <tr><td width="45%" class="FormText">Customer:</td>
<td width="55%"><input  name="Customer_type" type="text" value="<?php echo $Customer_Type; ?>"?> </td></tr>

 <tr><td width="45%" class="FormText">Computer :</td>
<td width="55%"><input  name="Computer_type" type="text" value="<?php echo $Computer_type; ?>"?> </td></tr>

 <tr><td width="45%" class="FormText">Manufactural:</td>
<td width="55%"><input  name="Computer_maker" type="text" value="<?php echo $Computer_maker; ?>"?> </td></tr>

 <tr><td width="45%" class="FormText">Model:</td>
<td width="55%"><input  name="Model" type="text" value="<?php echo $Model; ?>"?> </td></tr>

 <tr><td width="45%" class="FormText">Operating System:</td>
<td width="55%"><input  name="First name" type="text" value="<?php echo $OS; ?>"?> </td></tr>

 <tr><td width="45%" class="FormText">Appointment:</td>
<td width="55%"><input  name="Operating System" type="text" value="<?php echo $Appointment_date; ?>"?> </td></tr>

  <tr><td width="45%" class="FormText">Problem:</td>
<td width="55%"><textarea name="Problem" rows="10" cols="20" ><?php echo $Problem; ?></textarea></td></tr>

 <tr><td width="45%" class="FormText">Solution:</td>
<td width="55%"><textarea name="Solution" rows="10" cols="20" ><?php echo $Solution; ?></textarea></td></tr>

 <tr><td width="45%" class="FormText">Comment:</td>
<td width="55%"><textarea name="Comment" rows="10" cols="20" ><?php echo $Comment; ?></textarea></td></tr>

 
 
<td width="55%"><input name="submit"  value="submit"  type="submit" <br> <input type="Submit" value="Cancel"</br></td>


 </form>
         <?php



--------------------------------------------------------------------------------------
The update.php file have the following code:

Code: [Select]
<?php
//connect  to the database 


$con = mysql_connect("localhost","dbusrn","dbpwd");
if (!$con)
  {
  die('Could not connect: ' . mysql_error());
  }

mysql_select_db("mydb", $con);

if (isset($_POST['submit']))  {

$cf_uid  = $_POST['cf_uid'];
$Firstname = $_POST['Firstname'];
$lastname = $_POST['lastname'];
$Address = $_POST['Address'];
$Postcode = $_POST['Postcode'];
$Phone = $_POST['Phone'];
$Email = $_POST['Email'];
$Customer_Type = $_POST['Customer_Type'];
$Computer_type = $_POST['Computer_type'];
$Computer_maker = $_POST['Computer_maker'];
$Model = $_POST['Model'];
$OS = $_POST['OS'];
$Appointment_date = $_POST['Appointment_date'];
$Problem = $_POST['Problem'];
$Solution = $_POST['Solution'];
$Comment = $_POST['Comment'];



$query = "UPDATE Customer SET  Firstname='$Firstname',lastname='$lastname',Address='$Address',Postcode='$Postcode',Phone='$Phone',Email='$Email',Customer_Type='$Customer_Type',Computer_type='$Computer_type',Computer_maker='$Computer_maker',Model='$Model',OS='$OS',
Appointment_date='$Appointment_date',Problem='$Problem',Solution='$Solution',Comment='$Comment' WHERE cf_uid='$cf_uid '";


mysql_query($query) or die(mysql_error());
mysql_close($con);
 
echo "<p>Congrats Record Updated</p>";
}
?>

     
I got congrats record updated but in actual fact no record are updated.

Please help

MOD EDIT: code tags added.

Hi guys, this is my first post so be nice!

I have an SQL select which returns the following

cat_id cat_name parent_id 1 cat 1 0 2 cat 2 0 3 cat 3 0 4 cat 4 0 5 cat 5 1 6 cat 6 1 7 cat 7 0
The above shows that category 1 has 2 children.

I have a script in place that basically filters the child entries into a new array, then I use two foreach loops to build a list of items with parent > child relationship.

My code works, but is a mess and doesn't 'feel' as concise as it should be.

What would be the best / most efficient way to build a child > parent list. (ideally i would want it to work on up to 4 tiers)

Any help would be greatly appreciated.

Cheers

Dave

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...

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.

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

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,

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...

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';?>

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>

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 know this problem comes up a lot but it can be for various reasons so after reading up I can't decide what might be wrong. I'm still learning!
I have a simple php registration form (first name, second name, email address) and every time a user submits an entry a second blank record is created in the MYSQL database after it.

Any help would be great. (php code in red)


Code: [Select]
[color=red]<?
$firstname=$_POST['firstname'];
$surname=$_POST['surname'];
$email=$_POST['email'];

mysql_connect(localhost,$username,$password);
@mysql_select_db($database) or die( "Unable to select database");

$query = "INSERT INTO register VALUES ('','$firstname','$surname','$email')";
mysql_query($query);

mysql_close();
?>[/color]



Here is the section on the html HTML page that submits the form

Code: [Select]
<form action="register.php" method="post" class="BagTitle">
        <table width="700" border="0" cellpadding="0" cellspacing="2">
  <tr>
    <td width="100">First Name: </td>
    <td width="594"><input name="firstname" type="text" size="50" /></td>
      </tr>
  <tr>
    <td>Last Name: </td>
    <td><input name="surname" type="text" size="50" /></td>
      </tr>
  <tr>
    <td>E-mail:</td>
    <td><input name="email" type="text" size="50" /></td>
      </tr>
  <tr>
    <td colspan="2">&nbsp;</td>
      </tr>
  <tr>
    <td colspan="2"><input type="Submit" value="Send" />
        <input name="Reset" type="reset" value="Reset Form" /></td>
      </tr>
    </table>
      </form></p>
Also I have no idea about securing this information. Are there any basic steps I can take?