Report: Show MySQL results in pages updated using AJAX

 

Please run testData.sql against a database and change the example files to point to that database to view the examples.


 

1 CONSTRUCTION


call __Construct($query,$interval) to create the report with the query you want and the number of records on a page

or __Construct($query) with all records on the page

or __Construct($query,"",$order,$direction)
   __Construct($query,$interval,$order,$direction) to order your report by default on a column


$query is the mysql query the class will use to generate your report
$order is the name of a column in the database you want to order by
$direction can be ASC or DESC

 

 

2 ADDING FIELDS TO THE REPORT


2.1 adding a normal field


call

addDisplayField($name,$display,$sizeOfField)

or addDisplayField($name,$display)


$name is the name of the field in the databases and must be in the query you constructed with

$display is the heading of the field displayed to the user

$sizeOfField is the minimum width or the table column for this field


 

2.2 adding a special field


here you can create a field with special attributes, eg. a link field or running javascripts on the field


call

addSpecialDisplayField($name,$display,$text,$sizeOfField=50)

or addSpecialDisplayField($name,$display,$text,$sizeOfField=50)


$name is the name of the field in the database. this is only used for sorting purposes. if the user sorts on this field this field in the database will be used.

$display is the heading of the field displayed to the user

$text this is the special text that will be used as the field, anything in {} will be replaced by a field in the database eg. if name is a field in the database use <a href="javascript:alert('you clicked on {name}')">{name}</a>

$sizeOfField is the minimum width or the table column for this field


 

 

 

3 ENABLING AJAX


This allows the report to refreshes its data, when a link is clicked on the navigation bar, or when sorting on a column, without refreshing the entire page.

(Not recommended for pages that requires search engine friendliness)


call enableAjax($database_host,$database_user,$database_password,$database_name)


the database details is required when data is refreshed


4 SETTING THE LOOK AND FEEL


all the following methods are optional


 

enableNavigationalNumbers($variance)

call to show page numbers on the navigation that can be used as links

$variance is the number of pages shown from the current page in both directions



setAjaxLoadingText($text)
The text that displays while data is refreshed with ajax





getNumberOfResultsSelectorGoLink($text)
getNumberOfResultsPerPageSelector($interval,$maximum)

these should be used together
getNumberOfResultsSelectorGoLink gets a selector for the user to select the number of records he wants per page
getNumberOfResultsPerPageSelector gets a link to click to refresh the data according to the above selection

$text will be displayed as the link
$interval in the selection every <$interval>the number will be displayed eg $interval=10 then 10,20,30 will be the options
$maximum the maximum number of records the user can choose from.




setLeftImage($loc)

Call to set an image to be used as the "previous page" link


setRightImage($loc)

Call to set an image to be used as the "next page" link


setLeftJumpImage($loc)

Call to set an image to be used as the "first page" link


setRightJumpImage($loc)

Call to set an image to be used as the "last page" link


 

setLeftText($text)

Call to set text to be used as the "previous page" link


setRightText($text)

Call to set text to be used as the "next page" link


function setLeftJumpText($text)

Call to set text to be used as the "first page" link


setRightJumpText($text)

Call to set text to be used as the "last page" link


 

setSortASCPicture($loc)

Call to set an image displayed with a column heading when that column is sorted ascending


setSortDESCPicture($loc)

Call to set an image displayed with a column heading when that column is sorted descending


 

setTableClassName($name)

sets the css-class of the table that contains the data


setNavigationTableClassName($name)

sets the css-class of the table that contains the navigation links


setSortLinkClassName($name)

sets the css-class of a link that orders the data on a column


setNavigationLinkClass($name)

sets the css-class of the navigation links