PHP - Php Pagination Not Showing Css Styling

Hi guys,

I recently wrote a pagination script and it works fine, except from when trying to echo the navigation.

This is the Pagination.php Script
Code: [Select]
<?php

class Pagination 
{
/**
 * Current Page
 *
 * @var integer
 */
var $page;

/**
 * Size of the records per page
 *
 * @var integer
 */
var $size;

/**
 * Total records
 *
 * @var integer
 */
var $total_records;

/**
 * Link used to build navigation
 *
 * @var string
 */
var $link;

/**
 * Class Constructor
 *
 * @param integer $page
 * @param integer $size
 * @param integer $total_records
 */
function Pagination($page = null, $size = null, $total_records = null)
{
$this->page = $page;
$this->size = $size;
$this->total_records = $total_records;
}

/**
 * Set's the current page
 *
 * @param unknown_type $page
 */
function setPage($page)
{
$this->page = 0+$page;
}

/**
 * Set's the records per page
 *
 * @param integer $size
 */
function setSize($size)
{
$this->size = 0+$size;
}

/**
 * Set's total records
 *
 * @param integer $total
 */
function setTotalRecords($total)
{
$this->total_records = 0+$total;
}

/**
 * Sets the link url for navigation pages
 *
 * @param string $url
 */
function setLink($url)
{
$this->link = $url;
}

/**
 * Returns the LIMIT sql statement
 *
 * @return string
 */
function getLimitSql()
{
$sql = " WHERE school = 'ssb' ORDER BY orientation LIMIT " . $this->getLimit();
return $sql;
}

/**
 * Get the LIMIT statment
 *
 * @return string
 */
function getLimit()
{
if ($this->total_records == 0)
{
$lastpage = 0;
}
else 
{
$lastpage = ceil($this->total_records/$this->size);
}

$page = $this->page;

if ($this->page < 1)
{
$page = 1;
} 
else if ($this->page > $lastpage && $lastpage > 0)
{
$page = $lastpage;
}
else 
{
$page = $this->page;
}

$sql = ($page - 1) * $this->size . "," . $this->size;

return $sql;
}

/**
 * Creates page navigation links
 *
 * @return  string
 */
function create_links()
{
$totalItems = $this->total_records;
$perPage = $this->size;
$currentPage = $this->page;
$link = $this->link;

$totalPages = floor($totalItems / $perPage);
$totalPages += ($totalItems % $perPage != 0) ? 1 : 0;

if ($totalPages < 1 || $totalPages == 1){
return null;
}

$output = null;
//$output = '<span id="total_page">Page (' . $currentPage . '/' . $totalPages . ')</span>&nbsp;';

$loopStart = 1; 
$loopEnd = $totalPages;

if ($totalPages > 5)
{
if ($currentPage <= 3)
{
$loopStart = 1;
$loopEnd = 5;
}
else if ($currentPage >= $totalPages - 2)
{
$loopStart = $totalPages - 4;
$loopEnd = $totalPages;
}
else
{
$loopStart = $currentPage - 2;
$loopEnd = $currentPage + 2;
}
}

if ($loopStart != 1){
$output .= sprintf('<li class="disabledpage"><a href="' . $link . '">&#38;#171;</a></li>', '1');
}

if ($currentPage > 1){
$output .= sprintf('<li class="nextpage"><a href="' . $link . '">Previous</a></li>', $currentPage - 1);
}

for ($i = $loopStart; $i <= $loopEnd; $i++)
{
if ($i == $currentPage){
$output .= '<li class="currentpage">' . $i . '</li> ';
} else {
$output .= sprintf('<li><a href="' . $link . '">', $i) . $i . '</a></li> ';
}
}

if ($currentPage < $totalPages){
$output .= sprintf('<li class="nextpage"><a href="' . $link . '">Next</a></li>', $currentPage + 1);
}

if ($loopEnd != $totalPages){
$output .= sprintf('<li class="nextpage"><a href="' . $link . '">&#38;#187;</a></li>', $totalPages);
}



return "<div class='pagination'><ul>" . $output . "</ul></div>";
}
}

?>
And this is the actual page which needs paginating:

Code: [Select]
<?php

include('Pagination.php');

$page = 1;

// how many records per page
$size = 9;

// we get the current page from $_GET
if (isset($_GET['page'])){
    $page = (int) $_GET['page'];
}

// create the pagination class
$pagination = new Pagination();
$pagination->setLink("album.php?page=%s");
$pagination->setPage($page);
$pagination->setSize($size);
$pagination->setTotalRecords($total_records);

// now use this SQL statement to get records from your table
//$SQL = "SELECT * FROM mytable " . $pagination->getLimitSql();


$myServer = "********";  
$myUser = "*******";
$myPass = "*******";
$myDB = "*******";

//connection to the database
$dbhandle = mysql_connect($myServer, $myUser, $myPass)
  or die("Couldn't connect to SQL Server on $myServer"); 

//select a database to work with
$selected = mysql_select_db($myDB, $dbhandle)
  or die("Couldn't open database $myDB"); 



$album_query = "SELECT * FROM albums WHERE album_name = '" . $_REQUEST['album'] . "' ";

$album_result = mysql_query($album_query) or die('Error Getting Information Requested for album');

$album_row = mysql_fetch_array($album_result);




$album = $_REQUEST['album'] . " " . $album_row['school'];


$photo_query = "SELECT * FROM `" . $album . "` " . $pagination->getLimitSql();

//$photo_query = "SELECT * FROM `" . $album . "` WHERE school = 'ssb' ORDER BY orientation" . $pagination->getLimitSql();


$photo_result = mysql_query($photo_query) or die('Error Getting Information Requested for photos');

$photo_row = mysql_fetch_array($photo_result);

$photo_row_count = mysql_num_rows($photo_result);




$i = 0;
$cellcnt = 0;
while ($i < $photo_row_count) {

$thumb_selection = $_REQUEST['album'] . " " . $album_row['school'];
$photo_selection = $_REQUEST['album'] . " " . $album_row['school'];

if($thumb_selection == "nutcracker 2007 ssb")
$act_thumb = mysql_result($photo_result,$i,"thumbnail");
else
$act_thumb = mysql_result($photo_result,$i,"thumbnail") . "/" . mysql_result($photo_result,$i,"photo_id") . ".jpg";

if($photo_selection == "nutcracker 2007 ssb")
$act_photo = mysql_result($photo_result,$i,"photo_path");
else
$act_photo = mysql_result($photo_result,$i,"photo_path") . "/" . mysql_result($photo_result,$i,"photo_id") . ".jpg";

if (!(mysql_result($photo_result,$i,"photo_name") == ""))
$photo_name_font_tag = "<font style=' padding: 5px; background-color:grey; font-family: Vag Round, Vag Rounded; color: #C02777;'>";
else
$photo_name_font_tag = "<font style='font-family: Vag Round, Vag Rounded; color: #C02777;'>";

$f1 ="
<td align='center'>
<a class='grouped_elements' rel='group1' href='" . $act_photo . "'><img src='" . $act_thumb . "' />
<br />
" . mysql_result($photo_result,$i,"photo_name") . "</a>
</td></font>
";

echo "" .  $f1 ."";

$cellcnt++;
if ($cellcnt == 3) {
echo "</tr> <tr>";
$cellcnt = 0;
}

$i++;
}

?>
</table>
</td>
<td>
&nbsp;
</td>
<td>
&nbsp;
</td>
</tr>
<tr>
<td>
&nbsp;
</td>
<td>
<?php 

$navigav = $pagination->create_links();
//$navigav = $pagination -> create_links($output);
echo $navigav;

?>


Any help would be greatly appreciated!

Jacob.

i have built pages that paginate with 10 rows per page (some pages show more but for the moment i want to focus on this particular page)

//Define Some Options for Pagination
$num_rec_per_page=10;
if (isset($_GET["page"])) { $page  = $_GET["page"]; } else { $page=1; }; 
$start_from = ($page-1) * $num_rec_per_page;

$results = mysql_query("SELECT * FROM `ecmt_memberlist` WHERE toonCategory='Capital' AND oldMember = 0 ORDER BY CONCAT(MainToon, Name) LIMIT $start_from, $num_rec_per_page") or die(mysql_error());

	$results_array = array();
	while ($row = mysql_fetch_array($results)) {
    	$results_array[$row['characterID']] = $row;
}

The above sets the variables for the pagination and below the results are echo with 10 rows per page   then i show the pagination links:

<?php 
$sql = "SELECT * FROM `ecmt_memberlist` WHERE toonCategory='Capital' AND oldMember = 0 ORDER BY CONCAT(MainToon, Name)";

$rs_result = mysql_query($sql); //run the query
$total_records = mysql_num_rows($rs_result);  //count number of records
$total_pages = ceil($total_records / $num_rec_per_page); 
?>


      <table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr>
          <td align="center"><div style="width:100%; text-align:center;">
          <ul class="pagination">
    <li class="selected">
	<?php
echo "<a href='capitalmember.php?page=1'>".'«'."</a> ";?> 
</li>
<?
for ($i=1; $i<=$total_pages; $i++) { 
            echo "<li><a href='capitalmember.php?page=".$i."'>".$i."</a></li> "; 
};
?>
<li class="selected">
<? 
echo "<a href='capitalmember.php?page=$total_pages'>".'»'."</a> "; // Goto last page
?></li>
  </ul></div>
    <?php
  $pageNr = $page;   // Get Current Page Number
$from = $pageNr * $rowsPerPage;  // 3 * 10 = 30  // 3 * 10 = 30
$to = $from + $rowsPerPage;      // 30 + 10 = 40
echo $pageNr;
/* Result: From page 30 to 40 */
  ?></td>
        </tr>
      </table>

this works great and shows me 10 results per page,   what i need to work out and work on next is:   echo the number of results above the records (for example: "showing records 1 to 10" and then on page 2 "showing records 11 to 21" and page 3 "showing records 22 to 32"   how can i work out the maths for this echo?   i was thinking along the lines of;

    <?php
$pageNr = $page;   // Gets Current Page Number
$from = $pageNr * $rowsPerPage;  // 3 * 10 = 30  
$to = $from + $rowsPerPage;      // 30 + 10 = 40
// Now Show Results
echo $from; // Echo from
echo $to // Echo to
  ?>

but i'm still working on this..   then i need to look at shortening the amount of page links on the page if for example i have 500 records it shows me links 1 to 50 and eats up the page....   Appreciate any help and light onto my problems.   Many thanks
Edited by jacko_162, 11 January 2015 - 05:43 PM.

I am pretty new to PHP and am trying to create a simple (so I assumed) page to takes data from one html page(works fine) and updates a MYSQL Database.  I am getting no error message, but the connect string down to the end of the body section is showing up as plain text in my browser window.  I do not know how to correct this.  I have tried using two different types of connect strings and have verified my names from the HTML page are the same as listed within the php page.  Suggestions on what I need to look for to correct would be great.  I have looked online, but so far all I am getting is how to connect, or how to create a comment, so I thought I would try here. 
Thank you for any assistance I may get!!  - Amy -
 
Code: [Select]
<body><font color="006600">
 <div style="background-color:#f9f9dd;">
  <fieldset>
<h1>Asset Entry Results</h1>
<?php
  // create short variable names
  $tag=$_POST['tag'];
  $serial=$_POST['serial'];
  $category=$_POST['category'];
  $status=$_POST['status'];
  $branch=$_POST['branch'];
  $comments=$_POST['comments'];

  if (!$tag || !$serial || !$category || !$status || !$branch) {
     echo "You have not entered all the required details.<br />"
          ."Please go back and try again.";
     exit;
  }

  if (!get_magic_quotes_gpc()) {
    $tag = addslashes($tag);
    $serial = addslashes($serial);
    $category = addslashes($category);
    $status = addslashes($status);
    $branch = addslashes($branch);
    $comments = addslashes($comments);
  }

  //@ $db = new mysqli('localhost', 'id', 'pw', 'inventory');
  $db = DBI->connect("dbi:mysql:inventory:localhost","id","pw") or die("couldnt connect to database");

  $query = "insert into assets values
            ('".$serial."', '".$tag."', '".$branch."', '".$status."', '".$category."', '".$comments."')";
  $result = $db->query($query);

  if ($result) {
      echo  $db->affected_rows." asset inserted into Inventory.";
  } else {
     echo "An error has occurred.  The item was not added.";
  }

  $db->close();
?>
  </fieldset>
 </div>
</body>

I would like to style this echo in my css, how would I go about making it a div class or something to give it a ID.
Code: [Select]
die ("Sorry, No Results Match Your Search.");

Thank You