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>
No comments posted yet
Your Answer:
Login to answer
55
36
Other forums
php calculate
this code echoes correctly the sum but the inserted result is 0??
Code: <?php
$TotalNum
Need Help with a query
Hello,
For some reason I am just not getting the right answer when I do this query and not quite
Include with Parameters
In a particular page I would like to include a file that requires $_GET parameters.
when I go
random generation
hi
i need help with generating this
numbers from 1-12
i want to generate in ran
Character Set Setup
Whats the best character set to use if you want every character to work, and also how do you make yo
Customizing message/behavior
Hi,I'm using the ASP.NET membership/authorization controls in my application. Some parts of my appli
PHP Captcha Error help - replace the "die" command
Hi All,
I am after a bit of help with a Captcha spam protection box.
The site gave me
php code generators
All
Whilst enjoying learning a new language i have come accross a number of free code generat
storing video files into mysql in php
hi
i have my video files in my folder ,
i have to store the path of the videos into db an
mysql timestamp manipulation
How could I use a timestamp (e.g 2009-10-30 13:20:35 ), and with php find out if it is:
from