Pagination

Posted on 16th Feb 2014 07:03 pm by admin

Hi All,

I think I'm finally getting somewhere with pagination!

I can now submit a query and get the correct number of records back with the correct number of pages.

My only problem is, when I press the page numbers or the next button the records disappear.

If anyone gets time, could you take a look at my code and tell me where I’m going wrong please?

Jamie

Code: [Select]<?php

require("conf.php");


//max displayed per page
$per_page = 2;

//get start variable
$start = $_GET['start'];

$udfin = $_POST['udf'];

//count records
$record_count = mysql_num_rows(mysql_query("SELECT * FROM cy_equ WHERE udf = $udfin"));

//count max pages
$max_pages = $record_count / $per_page; //may come out as decimal

if (!$start)
$start = 0;

//display data
$get = mysql_query("SELECT * FROM cy_equ WHERE udf = $udfin LIMIT $start, $per_page");
while ($row = mysql_fetch_assoc($get))
{
// get data
$id = $row['id'];
$ext = $row['ext'];
$equ = $row['equ'];

echo $id." (".$ext.") (".$equ.")<br />";

}

//setup prev and next variables
$prev = $start - $per_page;
$next = $start + $per_page;

//show prev button
if (!($start<=0))
echo "<a href='qqq.php?start=$prev'>Prev</a> ";

//show page numbers

//set variable for first page
$i=1;

for ($x=0;$x<$record_count;$x=$x+$per_page)
{
if ($start!=$x)
echo " <a href='qqq.php?start=$x'>$i</a> ";
else
echo " <a href='qqq.php?start=$x'><b>$i</b></a> ";
$i++;
}

//show next button
if (!($start>=$record_count-$per_page))
echo " <a href='qqq.php?start=$next'>Next</a>";

?>
<h3> UDF Query </h3>
<form name="form1" method="post" action="http://localhost/qqq.php">
<p> Input UDF: <input type="number" name="udf" value= "<?php echo $udfin; ?>" size="1" maxlength="4"/></p>



<p><input type="submit" name="submit" value="GET DATA"/></p>


</form>

Your Answer:

Login to answer

Other forums

Database 'Validation'
Hi everyone,
I'm trying to validate the password entered by the user with the password in the dat

Select question
Hi,

First I would like to say that php is pretty new for me..
so please don't shoot me if

upload control not working with update panel
Hi,

I am working with Asp.Net FileUpload control with ajax update panel,

if i use the

Whats wrong with my query?
I am trying to get this query to show the appropriate ticked vehicle roof height, unless no boxs are

Do While statement
hi guys,

This may sound trivial but im new to php and as part of an assignmenti have to const

Deleting pointers froms vector?
Hi. I have a vector filled with pointers and I want to delete the pointers. I could do a loop and do

CODE NOT WORKING
Code: [Select]<?php
//include shared codes

include '../lib/common.php';
include

rdns with php
I am trying to build a script that will show all of the different domains that are hosted on the sam

Problem with Sending Mail by PHP
hello all,
I m new to php, can u plz provide me the code to send mail by php having CAPTC

Undefined offset
The following script checks to see if the user answer matches the correct answer.

Form Fiel