This repository was archived by the owner on Jan 6, 2024. It is now read-only.
-
Notifications
You must be signed in to change notification settings - Fork 24
Documentation
entomb edited this page Dec 11, 2012
·
2 revisions
This is the main wrapper class, this class holds the basic interaction with the database, allowing you to generate and execute safe queries in a simple and straight forward way
To start a OBJ_mysql instance you must provide a configuration array holding the connect parameters (hostname,username,password and database)
-
Connection handling
- public OBJ_mysql::__construct;
- public OBJ_mysql::connect
- public OBJ_mysql::set_charset
- public OBJ_mysql::reconnect
- public OBJ_mysql::is_ready
- public OBJ_mysql::close
-
Query execution
- public OBJ_mysql::query
- public OBJ_mysql::insert
- public OBJ_mysql::replace
- public OBJ_mysql::update
- public OBJ_mysql::delete
-
Query result handlers
- public OBJ_mysql::insert_id
- public OBJ_mysql::affected_rows
-
Error and logging
- public OBJ_mysql::log
- public OBJ_mysql::errors
- public OBJ_mysql::lastError
-
security and sanitizing
- public OBJ_mysql::secure
- public OBJ_mysql::escape
-
Private internal methods
- private _parseArrayPair
- private _parseQueryParams
- private _logQuery
- private _displayError
- private _loadConfig
- public __destruct
This is the class to use to wrap the result from any SELECT or any other type of query that returns a resultset. this class offers methods to iterate and retrieve the data as well as some meta information about the data.
-
Resultset manipulation
- public OBJ_mysql_result::__construct
- public OBJ_mysql_result::__destruct
- public OBJ_mysql_result::is_empty
- public OBJ_mysql_result::reset
- public OBJ_mysql_result::free
-
Retrieving data
- public OBJ_mysql_result::fetch
- public OBJ_mysql_result::fetchObject
- public OBJ_mysql_result::fetchArray
- public OBJ_mysql_result::fetchAll
- public OBJ_mysql_result::fetchAllObject
- public OBJ_mysql_result::fetchAllArray
- public OBJ_mysql_result::fetchColumn
- public OBJ_mysql_result::fetchArrayPair
- public OBJ_mysql_result::json