Paged Recordset - PHP Class

[furious5]

Next question, I downloaded a PHP Class from PHPClasses today to enable me to present paged recordsets.

Now I've never used a PHP Class and was wondering how I go about inserting this in to the code?

Do I just use an include to add this to the page or should I be copying and pasting the code?

I guess this is a fairly fundamental question, generally most of the stuff I have done to date I have been able to handle myself but it seems pointless me working through how to do paged recordsets if someone has already provided readily available code to do this.

[eoghain]

You will need to include() the code of the class. Then you will need to instantiate the class and use it. Since I don't know what class you have I can only give you a generalized overview:

<?php
   inlcude('/path/to/new/pager/class.php');

   $pager = new Pager();

   $pager->run();
?>

[furious5]

Ok great.

I will try this when I get home this evening and let you know how I go on.

[furious5]

Ok I had another look at this, this evening and I am still struggling.

Here are the instructions in the datapager info:

the constructor:

$datapager->datapager($dbconnection, $query, $pagesize, $querytousetocountrecords);

the main function - executes the query and returns a mysql result id or 0 if it fails

$datapager->execute($pagesize, $pagenumber);

Now the code I am using is:

include("datapager.php");

$datapager->datapager($connection, $sql_result, $pagesize, $querytousetocountrecords);
$datapager->execute($pagesize, $pagenumber);

BUT I am getting the following error:

Fatal error: Call to a member function on a non-object in d:\apache\apache\htdocs\result.php on line 60

Can anyone advise me what I am doing wrong?

[ahundiak]

Looks like you need to create an object.

$datapager =& new datapager($connection, $sql_result, $pagesize, $querytousetocountrecords);

Of course, all of the arguments will need to have values.

Understand that without actually seeing datapager.php that this is only a guess.

[eoghain]

Your code should probably look like this:

<?php
   include("datapager.php"); 

   $datapager = new datapager($connection,
                              $sql_result,
                              $pagesize,
                              $querytousetocountrecords); 

   $datapager->execute($pagesize, $pagenumber); 
?>

You need to instantiate the datapager object. That is taken care of with the new key word, and you need to assign that object to a variable before you can use it. Once that is done then you can use the -> operator to call a method on the object. You didn't instantiate the object so you were trying to call a method on something that didn't exist, that is what the PHP error means.

[furious5]

Ok thats solved that error.

Now I'm not getting any errors but it doesn't seem to do anything. I have added this further code.

I have changed the page size to 1 record, and tested it with a query where I know there are two results.

Any more ideas, you guys were quick off the mark on the last one.

$datapager = new datapager($connection, $sql_result, $pagesize, $querytousetocountrecords);
$datapager->execute($pagesize, $pagenumber);
$datapager->loadquery($query, $pagesize, $querytousetocountrecords); // called internally by creator function
$str = $datapager->nextpage($html, $althtml = "");
$str = $datapager->prevpage($html, $althtml = "");
$datapager->pagelinks($linkhtml, $currenthtml = "%page%", $separator = " | ");

[ahundiak]

1. Roll up your sleeves.
2. Make a backup of datapager.php
3. Fire up your editor
4. Take a deep breath
5. Start scrolling.

With luck, the developer of the class has added some sort of trace system. If not, add a
$debug =1;
statement to the top of the file then pick a function and start adding some
global $debug;
if ($debug)
{
echo 'Got here with data ' . whatever;
}

[eoghain]

I don't know if it's that drastic.

Is there a print(), or output() method in the datapager class?

From what I can tell the datapager class looks like it runs your query and then builds the proper HTML with html that you supply, but I doubt that it automatically outputs that HTML to the browser. So look for some type of output() method in the class that you will call to get the formatted HTML back out for display.

Something like:

<?php
   include ("datapager.php");

   $datapager = new datapager($connection, $sql_result, $pagesize, $querytousetocountrecords); 
   $datapager->execute($pagesize, $pagenumber); 

   $str = $datapager->nextpage($html, $althtml = ""); 
   $str = $datapager->prevpage($html, $althtml = ""); 
   $datapager->pagelinks($linkhtml, $currenthtml = "%page%", $separator = " | ");

   echo $datapager->output();
?>

[furious5]

Ok I looked through the datapager but cannot find any print() or output functions.

Having read through the code comments the only thing I can find that I haven't done is this:

get a string containing links to all possible pages

	$datapager->pagelinks($linkhtml, $currenthtml = "%page%", $separator = " | ");

where $linkhtml is something like <a href='thispage.php?page=%page%'>%page%</a>
and $currenthtml is used for the current page, ie "%page%"
and $separator is what to separate each pagenumber with


the following variables are available once a query has been executed:

$datapager->page	// the current page
$datapager->pagesize	// number of records per page
$datapager->recordcount	// total number of records available
$datapager->pagecount	// total number of pages of records using this page size

So is it simply a case of adding some code to the result page similar to:

$linkhtml = echo "<a href='thispage.php?page=%page%'>%page%</a>";

Or am I totally missing the point.

What I have done is attached a copy of the datapager class in a text file if you wish to have a look at it, I could have missed something totally obvious.

Once again guys, thanks for taking the time to answer my q's and baring with me.

[furious5]

Just bumping this back up to the top.

Has anyone got any further ideas on this, I'm really stuck.

[eoghain]

Ok, from looking at the datapager class here is what it does.

When you give it a query, a page size (read number of records you want on each page), and a page number it will return adjust your query and run it returning to you a valid MySQL resource handle that you can use to display the data.

The execute() method is the one that processes your query and gives you back the results to work with. You then can do whatever you want with the results.

<?php
   include ("datapager.php");
   $connection = mysql_connect("localhost", "user", "pass");
   mysql_select_db("myDB", $connection);

   $query = "SELECT *
               FROM users"

   $pagesize = 10;

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

   $datapager = new datapager($connection, $query, $pagesize); 
   $result =  $datapager->execute($pagenumber, $pagesize); 

   while ($row = mysql_fetch_array($result, MYSQL_NUM)) {
      printf ("ID: %s  Name: %s", $row[0], $row[1]);  

   }
?>

[ahundiak]

You might try taking the example file from the phpclasses site and using it as a starting point.
testdatapager.php