Class RaxanPDO

Description
Description | Vars (details) | Methods (details) Constants

Raxan PDO Store Procedure Response

Located in /raxan.pdo.php (line 51) 

PDO
   |
   --RaxanPDO
Variable Summary
Description | Vars (details) | Methods (details) Constants
static mixed $_BadFieldNameChars
mixed $_lastRowsAffected
Method Summary
Description | Constants Vars (details) | Methods (details)
RaxanPDOProcResult execProc ( $name, [ $params = null], string $query, array $param)
mixed execQuery (string $query, [mixed $param = null])
int getLastRowsAffected ()
mixed table (string $name, [string $filterClause = null], [array $filterValues = null])
boolean tableDelete (string $name, [string $filterClause = null], [array $filterValues = null])
boolean tableInsert (string $name, array $data)
boolean tableUpdate (string $name, array $data, [string $filterClause = null], [array $filterValues = null])
void _cleanField ( $name)
Variables
Description | Vars (details) Constants | Methods (details)
static mixed $_BadFieldNameChars = array('\\','"',"'",";","\r","\n","\x00","\x1a") (line 54)
  • access: protected
mixed $_lastRowsAffected = 0 (line 53)
  • access: protected
Methods
Description | Vars (details) Constants Methods (details)
execProc (line 91)

Executes a stored procedure and returns a recordset

  • access: public
RaxanPDOProcResult execProc ( $name, [ $params = null], string $query, array $param)
  • string $query
  • array $param
  • $name
  • $params
execQuery (line 72)

Executes a query and returns a recordset

  • return: Array or false on error
  • access: public
  • example: example not found
mixed execQuery (string $query, [mixed $param = null])
  • string $query
  • mixed $param
getLastRowsAffected (line 61)

Last number of rows affected

  • access: public
int getLastRowsAffected ()
table (line 126)

Retrieve records from a database table

  • return: Array or false on error
  • access: public
  • example: example not found
mixed table (string $name, [string $filterClause = null], [array $filterValues = null])
  • string $name: Name of table. A comma separated list of field names can be retrieved from the table. Example: Customer fname, lname, address
  • string $filterClause: Optional SQL where clause. Supports ? and :name parameters
  • array $filterValues: Optional parameter values
tableDelete (line 224)

Deletes a record from a table

  • access: public
boolean tableDelete (string $name, [string $filterClause = null], [array $filterValues = null])
  • string $name: Table name
  • string $filterClause: Optional SQL where clause. Supports ? and :name parameters
  • array $filterValues: Optional parameter values
tableInsert (line 153)

Inserts a record into a table

  • access: public
boolean tableInsert (string $name, array $data)
  • string $name: Table name
  • array $data: An associative array containing data for a list of fields to be inserted
tableUpdate (line 180)

Updates a record within a table

  • access: public
boolean tableUpdate (string $name, array $data, [string $filterClause = null], [array $filterValues = null])
  • string $name: Table name
  • array $data: An associative array containing data for a list of fields to be updated
  • string $filterClause: Optional SQL where clause. Supports ? and :name parameters
  • array $filterValues: Optional parameter values
_cleanField (line 242)
  • access: protected
void _cleanField ( $name)
  • $name

Inherited Methods

Inherited From PDO (Internal Class)

constructor __construct ( $dsn, $username, $passwd, [$options = ] )
beginTransaction ( )
commit ( )
errorCode ( )
errorInfo ( )
exec ( $query )
getAttribute ( $attribute )
getAvailableDrivers ( )
lastInsertId ( [$seqname = ] )
prepare ( $statment, [$options = ] )
query ( )
quote ( $string, [$paramtype = ] )
rollBack ( )
setAttribute ( $attribute, $value )
__sleep ( )
__wakeup ( )
Class Constants
Description | Constants (details) Vars (details) | Methods (details)

Inherited Constants

Inherited from PDO (Internal Class)

ATTR_AUTOCOMMIT = 0
 ATTR_CASE = 8
 ATTR_CLIENT_VERSION = 5
 ATTR_CONNECTION_STATUS = 7
 ATTR_CURSOR = 10
 ATTR_CURSOR_NAME = 9
 ATTR_DEFAULT_FETCH_MODE = 19
 ATTR_DRIVER_NAME = 16
 ATTR_EMULATE_PREPARES = 20
 ATTR_ERRMODE = 3
 ATTR_FETCH_CATALOG_NAMES = 15
 ATTR_FETCH_TABLE_NAMES = 14
 ATTR_MAX_COLUMN_LEN = 18
 ATTR_ORACLE_NULLS = 11
 ATTR_PERSISTENT = 12
 ATTR_PREFETCH = 1
 ATTR_SERVER_INFO = 6
 ATTR_SERVER_VERSION = 4
 ATTR_STATEMENT_CLASS = 13
 ATTR_STRINGIFY_FETCHES = 17
 ATTR_TIMEOUT = 2
 CASE_LOWER = 2
 CASE_NATURAL = 0
 CASE_UPPER = 1
 CURSOR_FWDONLY = 0
 CURSOR_SCROLL = 1
 ERRMODE_EXCEPTION = 2
 ERRMODE_SILENT = 0
 ERRMODE_WARNING = 1
 ERR_NONE = '00000'
 FETCH_ASSOC = 2
 FETCH_BOTH = 4
 FETCH_BOUND = 6
 FETCH_CLASS = 8
 FETCH_CLASSTYPE = 262144
 FETCH_COLUMN = 7
 FETCH_FUNC = 10
 FETCH_GROUP = 65536
 FETCH_INTO = 9
 FETCH_KEY_PAIR = 12
 FETCH_LAZY = 1
 FETCH_NAMED = 11
 FETCH_NUM = 3
 FETCH_OBJ = 5
 FETCH_ORI_ABS = 4
 FETCH_ORI_FIRST = 2
 FETCH_ORI_LAST = 3
 FETCH_ORI_NEXT = 0
 FETCH_ORI_PRIOR = 1
 FETCH_ORI_REL = 5
 FETCH_PROPS_LATE = 1048576
 FETCH_SERIALIZE = 524288
 FETCH_UNIQUE = 196608
 MYSQL_ATTR_DIRECT_QUERY = 1002
 MYSQL_ATTR_FOUND_ROWS = 1003
 MYSQL_ATTR_IGNORE_SPACE = 1004
 MYSQL_ATTR_LOCAL_INFILE = 1001
 MYSQL_ATTR_USE_BUFFERED_QUERY = 1000
 NULL_EMPTY_STRING = 1
 NULL_NATURAL = 0
 NULL_TO_STRING = 2
 ODBC_ATTR_ASSUME_UTF8 = 1001
 ODBC_ATTR_USE_CURSOR_LIBRARY = 1000
 ODBC_SQL_USE_DRIVER = 2
 ODBC_SQL_USE_IF_NEEDED = 0
 ODBC_SQL_USE_ODBC = 1
 PARAM_BOOL = 5
 PARAM_EVT_ALLOC = 0
 PARAM_EVT_EXEC_POST = 3
 PARAM_EVT_EXEC_PRE = 2
 PARAM_EVT_FETCH_POST = 5
 PARAM_EVT_FETCH_PRE = 4
 PARAM_EVT_FREE = 1
 PARAM_EVT_NORMALIZE = 6
 PARAM_INPUT_OUTPUT = -2147483648
 PARAM_INT = 1
 PARAM_LOB = 3
 PARAM_NULL = 0
 PARAM_STMT = 4
 PARAM_STR = 2