Learn VBA & Macros in 1 Week!

PHP - Pagination Needed

Full Excel VBA Course - Beginner to Expert

Pagination Needed	View Content

Hi

I needed pagination for this please help

Quote

<?php

$id = $_GET['id'];


$queryitem = "SELECT * FROM item WHERE idsub = '$id' ORDER BY name";
         $resultitem = mysql_query($queryitem);
         while($dataitem = mysql_fetch_assoc($resultitem)){
            ?>

Data
            <

            <?php
            }
         ?>

Full Excel VBA Course - Beginner to Expert

Pagination Needed For Existing Script

Similar Tutorials

View Content

Hello All!

I was hoping one of you phpFreaks could help me out

I have the following code that produces links from a database. Certain sets of results have over 3000 links. I can currently set the amount of links to display per page but that's it.

I would like to be able to truncate the links to all the pages using pagination.

Any help would be greatly appreciated!

Here is the code:

<?php

echo "Results<br><HR WIDTH=100% SIZE=1><br>";
mysql_connect("mysite.com", "mysite_mysite", "mysitepassword") or die(mysql_error());
mysql_select_db("user_database") or die(mysql_error());

if (isset($_GET['pagenum']))
{
  $pagenum = $_GET['pagenum'];
} else
{
  $pagenum = 1;
}

$rpg = $pagenum;
$data = mysql_query("SELECT * FROM mydb WHERE mfg='golf'") or die(mysql_error());
$rows = mysql_num_rows($data);
$page_rows = 80;

$last = ceil($rows/$page_rows);

if ($pagenum < 1)
  {
   $pagenum = 1;
  }
elseif ($pagenum > $last)
  {
   $pagenum = $last;
  }

$max = 'limit ' .($pagenum - 1) * $page_rows .',' .$page_rows;
$data_p = mysql_query("SELECT * FROM mydb WHERE mfg='golf' $max") or die(mysql_error());

while($info = mysql_fetch_array( $data_p ))
  {
   $page=$info['link'];
echo "<a href='$page' class='blue1'>". $info['title'] . "</a><br>";
  }
   echo "<p>";

if ($pagenum > $last)
  {$pagenum=1;}
else
{
  echo "<HR WIDTH=100% SIZE=1><br>";
  $pagenum = 1;
    while ($pagenum <= $last)
    {
       $next = $pagenum;
       echo " <a href='{$_SERVER['PHP_SELF']}?pagenum=$next' class='g5'>$pagenum</a> ";
       $pagenum = $pagenum+1;

    }
  Echo "<br><br>Page $rpg of $last <br>";
}

?>

Simple insertion of pagination would be GREAT! Thanks guys....

Similar Tutorials

View Content

Pagination

Similar Tutorials

View Content

Using the tutorial from php freaks i was able to get pagination working on my site. How ever there are a few changes id like to make. I would like to have it listed in 2 columns. The other problem that I'm having is when i attempt to add class="nav" to the next page link i get an error. Can a class be used in a php echo?

Here's what I have.

Code: [Select]
<?php  session_start();
$rank=$_SESSION['rank'];
$loggedinusername=$_SESSION['loggedinusername'];
$loggedinuseremail=$_SESSION['loggedinuseremail'];
?>
<!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>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Drink To The Credits</title>
<link href="mainstyle.css" rel="stylesheet" type="text/css" />
</head>

<body class="background">
<div id="header"> <?php include_once"header.php" ?></div>

<div id="content">

<?php

include"scripts/connect.php" ;

mysql_connect('localhost',$username,$password);
@mysql_select_db($database) or trigger_error("SQL", E_USER_ERROR);

$sql = "SELECT COUNT(*) FROM movies WHERE type LIKE 'movie'";
$result = mysql_query($sql) or trigger_error("SQL", E_USER_ERROR);
$r = mysql_fetch_row($result);
$numrows = $r[0];
$rowsperpage = 15;
$totalpages = ceil($numrows / $rowsperpage);

if (isset($_GET['currentpage']) && is_numeric($_GET['currentpage'])) {
   $currentpage = (int) $_GET['currentpage'];
} else {
   $currentpage = 1;
}
if ($currentpage > $totalpages) {
   $currentpage = $totalpages;
}
if ($currentpage < 1) {
   $currentpage = 1;
}

$offset = ($currentpage - 1) * $rowsperpage;
$sql = "SELECT title FROM movies ORDER BY title LIMIT $offset, $rowsperpage" ;
$result = mysql_query($sql) or trigger_error("SQL", E_USER_ERROR);

while ($list = mysql_fetch_assoc($result)) {
     ?>
<tr>
<td> <a class="nav" href=/rules.php?title=<?php echo urlencode($list['title']); ?>><?php echo $list['title']; ?></a> <br />
<?php
}
$range = 3;

if ($currentpage > 1) {
   echo " <a href='<?php {$_SERVER['PHP_SELF']}?currentpage=1'><<</a> ";
   $prevpage = $currentpage - 1;
   echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$prevpage'><</a> ";
}
for ($x = ($currentpage - $range); $x < (($currentpage + $range) + 1); $x++) {
   if (($x > 0) && ($x <= $totalpages)) {
      if ($x == $currentpage) {
         echo " [<b>$x</b>] ";
      } else {
         echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$x'>$x</a> ";
      }
   }
}

if ($currentpage != $totalpages) {
   $nextpage = $currentpage + 1;

   echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$nextpage'>></a> ";
   echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$totalpages'>>></a> ";
} // built with a tutorial from php freaks
?>
</div>

<div id="sidecontent"><?php include_once"newmovies.php" ?></div>
<div id="footer"> <?php include_once"footer.php" ?></div>
</body>
</html>

Thank you in advance

Pagination

Similar Tutorials

View Content

The problem here is my pagination. It works for the most part. The only part that does NOT work is that when I go to a page OTHER THAN the first page it WILL NOT allow me to click on the edit link and go to the edit matchtype form. It allows me to on the first page of list but not for any after that.

Code: [Select]
<?php

error_reporting(E_ALL);

// Include the database page
include ('../inc/dbconfig.php');

$query = "SELECT
    CONCAT_WS(' ', handlers.firstName, handlers.lastName) AS name,
    DATE_FORMAT(matchTypes.dateCreated, '%M %d, %Y') AS dateCreated,
    matchTypes.ID,
    matchTypes.matchType
FROM
    matchTypes
    INNER JOIN handlers
        ON matchTypes.creatorID = handlers.ID
WHERE
    matchTypes.enabled = '0'
ORDER BY
    matchTypes.matchType";
$result = mysqli_query ( $dbc, $query ); // Run The Query
$rows = mysqli_num_rows($result);

$itemsPerPage = 10;
$pages = ceil( $rows / $itemsPerPage );

?>

<script>
$(document).ready(function() {
$('a', $('div#addform')).click(function() {
$('#innerContent').load('forms/' + $(this).attr('id') + '.php?case=addnew');
});

// Add the table sorter and table paginator plugins
$('#matchTypesPageList').tablesorter()
.tablesorterPager({
container: $( '#matchTypesPageList .paginate' ),
cssPageLinks: 'a.pageLink'
});
$('.edit').click(function(){
var matchTypeID = $(this).attr('rel');
$('#innerContent').load('forms/matchtype.php?id=' + matchTypeID + '&case=edit');
});
$('.delete').click(function(){
var matchTypeID = $(this).attr('rel');
var dataString = 'matchTypeID=' + matchTypeID + '&deleteMatchType=True';
$.ajax({
type: "POST",
url: "processes/matchtype.php",
data: dataString,
});
var table = $(this).closest("table");
if (table.find("tr").length == 3) {
table.remove();
} else {
$(this).closest("tr").remove();
}
});
});
</script>


<div id="title" class="b2">
<h2>Match Types</h2>

<div id="titleActions">

<div class="listSearch actionBlock">
<div class="search">
<label for="search">Recherche</label>
<input type="text" name="search" id="search" class="text" />
</div>
<div class="submit">
<button type="submit" id="search-button" class="button"><strong><img src="img/icons/search_48.png" alt="comments" class="icon "/></strong></button>
</div>
</div>


<div id="addform" class="newPost actionBlock">
<a href="#" id="matchtype" class="button"><strong>Add New Match Type<img src="img/icons/add_48.png" alt="new post" class="icon "/></strong></a>
</div>

</div>

</div>


<div id="innerContent">

<div id="listHeader">
<p class="listInfos">
You have <?php echo $rows; ?> match types.
</p>
</div>


<?php if ($rows > 0) { ?>
<table cellspacing="0" class="listTable" id="matchTypesPageList">

<thead>
<tr>
<th class="first"><div><a href="#" title="Match Type Name">Match Type Name</a></div></th>
<th><a href="#" title="Creator">Creator</a></th>
<th><a href="#" title="Date Created">Date Created</a></th>
<th class="last">Edit/Delete</th>
</tr>
</thead>


<tfoot>
<tr>
<td colspan="4">
<div class="inner">
<div class="paginate">
<?php
if( $pages > 1 ) {
for( $i = 1; $i <= $pages; $i++ ) {
echo '<span style="padding-left: 5px; padding-right: 5px;"><a class="pageLink" href="#">' . $i . '</a></span>';
}
}
   ?>
</div>
</div>
</td>
</tr>
</tfoot>


<tbody>
<?php
        while ( $row = mysqli_fetch_array ( $result, MYSQL_ASSOC ) ) {
              echo '
              <tr>
       <td>' . $row['matchType'] . '</td>
       <td>' . $row['name'] . '</td>
       <td>' . $row['dateCreated'] . '</td>
                  <td style="text-align:center;"><img src="img/notepad.png" class="edit" rel="' . $row['ID'] . '"/><img src="img/Delete-icon.png" class="delete" rel="' . $row['ID'] . '"/></td>
  </tr>';
            }
            ?>
</tbody>

</table>
<?php
        }
        ?>

</div>

Pagination Help?

Similar Tutorials

View Content

I can't get my head around it, no matter how many tutorials I read..
So would anyone be able to put this code into a pagination of 3 per page?

Many Thanks

Code: [Select]
<?php
if(!$_GET['id']) {
$query = "SELECT * FROM news where published = '1' ORDER by id DESC";
$result = mysql_query($query) or die(mysql_error());
$news = mysql_fetch_assoc($result);
?>
<?php do { ?>
<table width="590" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="2"><h2><? echo $news['title']; ?></h2></td>
</tr>
<tr>
<td width="398"><? echo $news['story']; ?></td>
<td width="192"><img src="<? echo $news['image']; ?>" alt="<? echo $news['shortstory']; ?>" width="192" height="108" /></td>
</tr>
<tr>
<td colspan="2"><i><br />
Posted by <? echo $news['author']; ?> on <? echo $news['date']; ?></i></td>
</tr>
</table><br />
<?php } while ($news = mysql_fetch_assoc($result));
}
?>

Php Pagination Help

Similar Tutorials

View Content

Similar Tutorials

View Content

I'm working on a flat file database that I can search.
I got most of it done, but wondering how I can paginate the results..

<?php
ini_set('display_errors', "On");
$count = 0;
$time_start = microtime(true);
$handle = fopen('/var/txtdb/links.txt', "r");
if ($handle) {
   while (!feof($handle) && $count < 15) {
        $line = fgets($handle, "4096");
        $pos = strpos($line, "keyword");
if ($pos == true) {
preg_match('~\[desc = ([^\]]*)\]~is', $line, $desc);
echo "$desc[1]<br>";
$count++;
}

   }
   fclose($handle);

}

$time_end = microtime(true);
$time = $time_end - $time_start;

echo '<br>Script took '.$time.' seconds to execute';
?>

So I want to display 15 results per page.. I know I could just loop through all the results each page just start from the last result +15 more. but.. that would take too long considering the amount of data I have.
So is there a way to start the loop at a specific line? That way I won't have to loop through them all and waste time and slow things down..