Docs For Class OCSP_CURSOR

Description

handels mySQL database cursor

author: Peter Krebs (pk) <pitlinz@users.sourceforge.net>
version: pk-07-06-15 renamed from mySQL_CURSOR to OCSP_CURSOR_mySQL
version: pk-06-07-26 parent object DB_CURSOR added
todo: currently most function only work with select rights for public to any table if different db users are used table rights has to be set manualy
project: Open CSP-Management
license: GNU Public License

OCSP_CURSOR
   |
   --OCSP_CURSOR_mySQL

Variable Summary

bool $buffered

mysqlconection $myConnId

mysqlcursor $myCursor

Method Summary

bool OCSP_CURSOR_mySQL (mysqlconection $aConnId, string $aQuery, [bool $autoClose = TRUE], [bool $useBuffer = TRUE], [debug $debug = FALSE])

void fetchArray ()

array fetchArrayFld ([boolean $ucase = FALSE], boolean $debug)

mixed fetchArrayNum ([int $pos = -1], [boolean $debug = FALSE])

void free ()

void numOfRows ()

Variables

bool $buffered = TRUE (line 47)

mysqlconection $myConnId = FALSE (line 43)

mysqlcursor $myCursor = FALSE (line 39)

Inherited from OCSP_CURSOR

OCSP_CURSOR::$myAutoClose
OCSP_CURSOR::$myQuery
OCSP_CURSOR::$rowNr

Methods

Constructor OCSP_CURSOR_mySQL (line 61)

calls mysql_query or mysql_unbufferd_query to get a resultset

bool OCSP_CURSOR_mySQL (mysqlconection $aConnId, string $aQuery, [bool $autoClose = TRUE], [bool $useBuffer = TRUE], [debug $debug = FALSE])

fetchArray (line 199)

void fetchArray ()

fetchArrayFld (line 151)

returns an array of a database row

array fetchArrayFld ([boolean $ucase = FALSE], boolean $debug)

fetchArrayNum (line 94)

mixed fetchArrayNum ([int $pos = -1], [boolean $debug = FALSE])

free (line 239)

free the cursor with @mysql_free_result

void free ()

numOfRows (line 247)

void numOfRows ()