Pagination

Parkie02 · December 10, 2013

Can somebody maybe help me to display 10 records and then there must be like a button or so that shows next or like 2,3,4

Here is my code. I tried to use the webpages explaining it but struggled

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml"><head>
  <title>Search</title>
  <meta name="description" content="">
  <meta name="keywords" content="">
  <meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
  <link href="css/style.css" rel="stylesheet" type="text/css">
</head>
<body>
<div class="main">
<div class="page">
<div class="header">
<div class="header-img">
<h1>Who Didn't Pay</h1>
<p> </p>
</div>
<div class="menu">
<ul>
  <li><a href="index.php">Home</a></li>
  <li><a href="registration.php">Register</a></li>
  <li><a href="complaint.php">Complaint</a></li>
  <li><a href="search.php">Search</a></li>
  <li><a href="#">Contact Us</a></li>
  <li><a href="login.php">Login</a></li>
  <li><a href="logout.php">Logout</a></li>
  
</ul>
</div>
</div>
<div class="content">
<div class="left-panel">
<div class="left-panel-in">
<h2 class="title">All Companies:</h2>

<p> </p>
<p>

</p>
<p>
 <form  method="post" action="allcompanies.php?go"  id="showallform">  
        <p> </p>
		<p> </p>
		  
		<table width="600" border="1" cellpadding="1" cellspacing="1">
		<tr>

		<th>Company Name</th>
		<th>Email</th>
		<th>Companies not Paid</th>
		<th>Amount not Paid</th>
		<tr>
		  
 </form>


 </p>


</body></html>


 <?php

//connect to the database
$db=mysql_connect ("localhost", "root", "mj2015") or die ('I cannot connect to the database because: ' . mysql_error()); 

//-select the database to use
$mydb=mysql_select_db("whodidntpay");

//-query the database table

$sql="SELECT d_name,email,companies_not_paid,amount_not_paid FROM debtor ORDER BY d_name";

//-run the query against the mysql query function
$result=mysql_query($sql);

//-count results

$numrows=mysql_num_rows($result);

echo "<p>" .$numrows . " results found "; 


while($debtor=mysql_fetch_array($result))
{
	echo "<tr>";
	
	echo "<td>".$debtor['d_name']."</td>";
	
	echo "<td>".$debtor['email']."</td>";
	
	echo "<td>".$debtor['companies_not_paid']."</td>";
	
	echo "<td>".$debtor['amount_not_paid']."</td>";
       
}
mysql_close($db);


?>

Thank you

mac_gyver · December 11, 2013

if all you are doing is posting your existing code, without showing your attempt at accomplishing the stated goal, we cannot help you because you haven't provided any information about what you tried and what errors or symptoms you got when you tried, so we don't have a clue what to help you with.

if you are having trouble finding example code or understanding the code you have found, you would need to ask specific questions to get help, because again, without specific information from you we don't have a clue what to help you with, because we are not here to find or to write code for you.

grissom · December 11, 2013

how about changing your mysql command a bit, something like :

$startingpoint = $_GET['page']*10;

$sql = "SELECT d_name,email,companies_not_paid,amount_not_paid FROM debtor ORDER BY d_name LIMIT $startingpoint, 10";

This will extract 10 records starting at the record = 10 * your page number

Then have a "next button" on your page onClick = "document.location = where_we_are_now.php?page='.($_GET['page'] + 1).'"

OK that's a little bit "pseudocode", and I have not tested it !! ... but hope its enough for you to get the general idea

Sign In

Pagination

Recommended Posts

Parkie02

Link to comment

Share on other sites

mac_gyver

Link to comment

Share on other sites

grissom

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information