<?php
class recordset
var $_connection=""; //this will set/get current database connection
var $_sql_string=""; //we send the sql string without limits and without "; "
var $_url = ""; //it's mandatory to send url with the rest of QUERY_STRING parameters; if there aren't other parameters you send this with ?. Ex: $myobj->_url = "mypage.php?"
var $_p_name = "page"; //if you don't send this, the default is page
var $_records_page = 25; //this will get/set the number of records on a page
var $_page = 1; // this will help you to set the current page
function get_no_pages()
// you use this for getting the total number of pages based on $_records_page and row count from mysql result
function get_str_pages()
// Gives you the string for navigation on pages
// 1 2 3 ... etc ...
function get_arr_rst($Paged=true)
/*
This is the method which gives you an array with your sql result
Is a key based array so you can acces it by the name of field alias $R[12]["id"] will return the value of ID for the 12 record in yoour result
*/
?>
|