|
|
Posted by Phillip S. Baker on 01/21/05 04:17
Greetings all,
I have a class I use for MySQL connection and functions.
I also have a class that I use to create Paged Results.
The paged results class connects to a DB and uses allot of sql calls to make
this happen. I am noticing that it does allot that the MySQL class does.
What I would like to do is to Have the paged results extend the MySQL class
so it can use the functions within that class so I can keep them updated in
just one place. How would I go about doing that?? Is it as simple as
something like this (this is shortened for convience)??
class Mysql {
var $results;
var $dbcnx;
function Mysql($query, $cnx) { // Constructor function
$this->dbcnx = $cnx;
if (!$this->results = @mysql_query($query))
$this->_error("There was an error with executing your query. Try again
later.", $query);
}
}
class PageResultSet extends MySQL {
var $results;
function PageResultSet ($query,$pageSize,$resultpage,$cnx) {
$this->results = @mysql_query($query,$cnx) or $this->_error('Error Running
your search. Try back later.', $query);
$this->pageSize = $pageSize;
if ((int)$resultpage <= 0) $resultpage = 1;
if ($resultpage > $this->getNumPages())
$resultpage = $this->getNumPages();
$this->setPageNum($resultpage);
}
}
I would like to be able to pass the results from the MySQL class to the
PageResultSet class without have to do the query over and such.
How would I go about coding that? I am not clear on that.
Also can I extend a function in PageResultSet that is started in MySQL??
In MySQL I have
function fetchAssoc() {
if (!$this->results) return FALSE;
$this->row++;
return mysql_fetch_assoc($this->results);
}
In PageResultSet I have
function fetchAssoc() {
if (!$this->results) return FALSE;
if ($this->row >= $this->pageSize) return FALSE;
$this->row++;
return mysql_fetch_assoc($this->results);
}
Can I just write something like within PageResultSet
function fetchAssocPRS extends fetchAssoc () {
if ($this->row >= $this->pageSize) return FALSE;
}
Thanks for the help.
--
Blessed Be
Phillip
Navigation:
[Reply to this message]
|