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
Agency Business Process
Hi,
I don’t understand the process of the agency business in SAP.
In my
First root of a number
Hi,
I can't find any function in php to give me the first root of a number.
Is there any
Pagination
Okay here is the page in question: http://blenderteachings.000a.biz/tutorials.hamishhill.php
get multiple rows
Hi I want to get multiple rows from a db
I am using this for the db query
Code: public
Add weeks in a query?
I have a SQL that summarizes the quantity per week. The weeks that has no value does not exist in th
Appending GET data with form submition
Okay, what I'm trying to do is to use a form to append an already existing GET data string.
I
why isn't this PHP code working ???
it's suppose to find a name on the database.
<?php
$s = $_POST["lname&
Oracle Text CTX_DOC.snippet slow
I have a table (FILE_TABLE) that contains a blob column (ft_file) and I have created the following O
help with php
It's not displaying or pulling anything out of the database.
Code: <html><
Passing PHP variables from one page to another
Hello-
I'm having trouble figuring out how to transport a variable from one php file to anoth
