File: testdptemplate.php

Recommend this page to a friend!
  Classes of Sam  >  datapager  >  testdptemplate.php  >  Download  
File: testdptemplate.php
Role: ???
Content type: text/plain
Description: example of using the class
Class: datapager
classes for 'paging' through database query result
Author: By
Last change:
Date: 18 years ago
Size: 1,478 bytes


Class file image Download


// connect to some database

$conn = mysql_connect();

// the name of the table to get all results from in this example

// the sql statement to query

$sql = "SELECT field1, field2, anotherfield FROM sometable";

// create a new datapager passing it the connection and the sql

$dp = new dptemplate($conn, $sql);

// check to see if the page variable has been set

if( !isset( $page ) ){
	$page = 1;

// set the number of results to get for each page

$pagesize = 50;

// define the templates

$header = "
<html>\n<head><title>Datapager Example</title></head>\n<body>
<h4>Viewing page <:page> of <:pagecount></h4>
<tr><th>Field 1 Title</th><th>Field 2 Title</th><th>Some Other Field Title</th></tr>

$template = "
<:row><tr><td bgcolor=yellow><:field1></td><td bgcolor=yellow><:field2></td><td bgcolor=yellow><:someotherfield></td></tr></:row>
<:row><tr><td bgcolor=green><:field1></td><td bgcolor=green><:field2></td><td bgcolor=green><:someotherfield></td></tr></:row>

$footer = "
<td align=left><:prev>Previous</:prev></td>
<td align=center><:pagelinks></td>
<td align=right><:next>Next</:next></td>

// execute the query with the current page and page size and return a mysql result

if( $dp->execute($page, $template, $header, $footer, $pagesize) < 1 ) echo "<h4>An error occurred.</h4>";


For more information send a message to info at phpclasses dot org.