-
$cache_dir
-
Using the cache directory
-
$cache_inserts
-
Insert queries into the cache
-
$cache_queries
-
Caching queries
-
$cache_timeout
-
The cache timeout in hours
-
$captured_errors
-
Captured errors
-
$col_info
-
The last column info
-
$connected
-
Whether the database connection is established, or not
-
catch_error
-
Hooks into PDO error system and reports it to user
-
connect
-
Try to connect to the database server in the DSN parameters
-
connect
-
Try to connect to Oracle database server
-
connect
-
Try to connect to PostgreSQL database server
-
connect
-
Try to connect to mssql database server
-
connect
-
Try to connect to sybase database server
-
connect
-
Try to connect to mySQL database server
-
connect
-
Try to connect to Oracle database server
-
ConvertMySqlToMSSql
-
Convert a Query From MySql Syntax to MS-Sql syntax Following conversions are made:
- The '`' character used for MySql queries is not supported -
the character is removed.
-
ConvertMySqlTosybase
-
Convert a Query From MySql Syntax to Sybase syntax Following conversions are made:
- The '`' character used for MySql queries is not supported - the
character is removed.
-
current
-
Returns the current row of the recordset as stdClass, which is the default mode, or as array as fieldname - fieldvalue.
-
ezSQL_codeigniter
-
-
escape
-
Format a mssql string correctly for safe mssql insert
-
escape
-
Format a Oracle string correctly for safe Oracle insert
-
escape
-
Format a sybase string correctly for safe sybase insert
-
escape
-
Format a Oracle string correctly for safe Oracle insert
-
escape
-
Escape a string with the PDO method
-
escape
-
Format a sql string correctly for safe insert
-
escape
-
Format a mySQL string correctly for safe mySQL insert (no matter if magic quotes are on or not)
-
escape
-
Format a mySQL string correctly for safe mySQL insert (no matter if magic quotes are on or not)
-
ezSQLcore
-
ezSQL Core module - database abstraction library to make it very easy to deal with databases. ezSQLcore can not be used by itself (it is designed for use by database specific modules).
-
ezSQL_codeigniter
-
ezSQL Database specific class - codeigniter Desc..: codeigniter component (part of ezSQL databse abstraction library)
-
ezSQL_fetch_assoc
-
Behaves like mysql_fetch_assoc. This method it to implement ezSQL easier in an existing system, that made us of mysql_fetch_assoc.
-
ezSQL_fetch_object
-
Behaves like mysql_fetch_object This method it to implement ezSQL easier in an existing system, that made us of mysql_fetch_object.
-
ezSQL_fetch_row
-
Behaves like mysql_fetch_row This method it to implement ezSQL easier in an existing system, that made us of mysql_fetch_row.
-
ezSQL_mssql
-
ezSQL Database specific class - mssql Microsoft Sql Server component (part of ezSQL databse abstraction library) - based on ezSql_mySql library class.
-
ezSQL_mysql
-
ezSQL Database specific class - mySQL Desc..: mySQL component (part of ezSQL databse abstraction library)
-
ezSQL_oracle8_9
-
ezSQL Database specific class - Oracle 8 and 9 Desc..: Oracle 8i/9i component (part of ezSQL databse abstraction library)
-
ezSQL_oracleTNS
-
ezSQL Database specific class with TNS connection Desc..: Oracle TNS component (part of ezSQL databse abstraction library)
-
ezSQL_pdo
-
ezSQL class - PDO Desc..: PDO component (part of ezSQL databse abstraction library)
-
ezSQL_postgresql
-
ezSQL Database specific class - PostgreSQL Desc..: PostgreSQL component (part of ezSQL databse abstraction library)
-
ezSQL_recordset
-
ezSQL Database specific class for working with query results Desc..: recordset component (part of ezSQL databse abstraction library)
-
ezSQL_sybase
-
ezSQL class - Sybase ASE Desc..: Sybase ASE component (part of ezSQL database abstraction library) - based on ezSql_mssql library class.
-
EZSQL_VERSION
-
Constant string ezSQL version information
-
ezSQL_mssql
-
-
ezSQL_mysql
-
-
ezSQL_oracle8_9
-
-
ezSQL_oracleTNS
-
-
ezSQL_pdo
-
-
ezSQL_postgresql
-
-
ezSQL
-
-
ezSQL_recordset
-
-
ezSQL_sybase
-
-
$ezSQL
-
ezSQL connection
-
$ezSQL
-
ezSQL connection
-
ezSQLcoreTest
-
Test class for ezSQLcore.
-
ezSQL_mssqlTest
-
Test class for ezSQL_mssql.
-
ezSQL_mysqlTest
-
Test class for ezSQL_mysql.
-
ezSQL_oracle8_9Test
-
Test class for ezSQL_oracle8_9.
-
ezSQL_oracleTNSTest
-
Test class for ezSQL_oracleTNS.
-
ezSQL_pdoTest
-
Test class for ezSQL_pdo.
-
ezSQL_postgresqlTest
-
Test class for ezSQL_postgresql.
-
ezSQL_recordsetTest
-
Test class for ezSQL_recordset.
-
ezSQL_recordsetTest2
-
Test class for ezSQL_recordset.
-
ezSQL_sybaseTest
-
Test class for ezSQL_sybase.
-
ezSQL_mssqlTest.php
-
-
ezSQL_mysqlTest.php
-
-
ezSQL_oracle8_9Test.php
-
-
ezSQL_oracleTNSTest_.php
-
-
ezSQL_pdoTest.php
-
-
ezSQL_postgresqlTest.php
-
-
ezSQLcoreTest.php
-
-
ezSQL_recordsetTest.php
-
-
ezSQL_recordsetTest_2.php
-
-
ezSQL_sybaseTest.php
-
-
getCharset
-
Returns the current connection charset
-
getDBHost
-
Returns the current database server host
-
getDBHost
-
Returns the current database server host
-
getDBHost
-
Returns the current database server host
-
getDBHost
-
Returns the current database server host
-
getDBName
-
Returns the current database name
-
getInsertId
-
Returns the last inserted autoincrement
-
getPort
-
Returns the current TCP/IP port
-
getShowErrors
-
Returns the current show error state
-
get_cache
-
Get the query cache of a query
-
get_col
-
Function to get 1 column from the cached result set based in X index see docs for usage and info
-
get_col_info
-
Function to get column meta data info pertaining to the last query See docs for more info and usage
-
get_results
-
Return the the query as a result set - see docs for more details
-
get_row
-
Get one row from the DB - see docs for more detail
-
get_set
-
Creates a SET nvp sql string from an associative array (and escapes all values)
-
get_var
-
Get one variable from the DB - see docs for more detail
-
query
-
Perform codignitor query and try to determine result value
-
query
-
Basic Query - see docs for more detail
-
query
-
Perform PostgreSQL query and try to detirmin result value
-
query
-
Perform sybase query and try to detirmin result value
-
query
-
Perform Oracle query and try to determine result value
-
query
-
Perform Oracle query and try to determine result value
-
query
-
Perform mySQL query and try to determine result value
-
query
-
Perform the mssql query and try to determine the result value
-
quick_connect
-
In the case of PostgreSQL quick_connect is not really needed because std.
-
quick_connect
-
Short hand way to connect to sybase database server and select a sybase database at the same time
-
quick_connect
-
Short hand way to connect to mssql database server and select a mssql database at the same time
-
quick_connect
-
With PDO it is only an alias for the connect method
-
quick_connect
-
Short hand way to connect to mssql database server and select a mssql database at the same time
-
quick_connect
-
In the case of Oracle quick_connect is not really needed because std.
-
quick_connect
-
In the case of Oracle quick_connect is not really needed because std.
-
$show_errors
-
Show errors
-
$show_errors
-
Show errors
-
$show_errors
-
Show errors
-
$show_errors
-
Show errors
-
$show_errors
-
Show errors
-
$show_errors
-
Show errors
-
$show_errors
-
Show errors
-
$show_errors
-
Show errors
-
$sql_log_file
-
Use a SQL log file
-
select
-
No real equivalent of mySQL select in Oracle, once again, function included for the sake of consistency
-
select
-
Try to select a mySQL database
-
select
-
No real equivalent of mySQL select in PostgreSQL once again, function included for the sake of consistency
-
select
-
Try to select a sybase database
-
select
-
With PDO it is only an alias for the connect method
-
select
-
No real equivalent of mySQL select in Oracle, once again, function included for the sake of consistency
-
select
-
Try to select a mssql database
-
showDatabases
-
Return all databases of the current server
-
showTables
-
Return PostgreSQL specific values: Return all tables of the current schema
-
show_errors
-
Turn error handling on, by default error handling is on
-
store_cache
-
Store the cache
-
sysdate
-
Return sybase specific system date syntax i.e. Oracle: SYSDATE sybase: getDate()
-
sysdate
-
Return PostgreSQL specific system date syntax i.e. Oracle: SYSDATE Mysql: NOW()
-
sysdate
-
Return mySQL specific system date syntax i.e. Oracle: SYSDATE Mysql: NOW()
-
sysdate
-
Return mssql specific system date syntax i.e. Oracle: SYSDATE mssql: NOW(), MS-SQL : getDate()
-
sysdate
-
Return SQLite specific system date syntax i.e. Oracle: SYSDATE Mysql: NOW()
-
sysdate
-
Return Oracle specific system date syntax i.e. Oracle: SYSDATE Mysql: NOW()
-
sysdate
-
Return Oracle specific system date syntax i.e. Oracle: SYSDATE Mysql: NOW()
-
setUp
-
Sets up the fixture, for example, opens a network connection.
-
setUp
-
Sets up the fixture, for example, opens a network connection.
-
setUp
-
Sets up the fixture, for example, opens a network connection.
-
setUp
-
Sets up the fixture, for example, opens a network connection.
-
setUp
-
Sets up the fixture, for example, opens a network connection.
-
setUp
-
Sets up the fixture, for example, opens a network connection.
-
setUp
-
Sets up the fixture, for example, opens a network connection.
-
setUp
-
Sets up the fixture, for example, opens a network connection.
-
setUp
-
Sets up the fixture, for example, opens a network connection.
-
setUp
-
Sets up the fixture, for example, opens a network connection.
-
$timers
-
Timers
-
$total_query_time
-
The total query time
-
$trace
-
same as $debug_all
-
$trace_log
-
The trace log
-
timer_elapsed
-
Returns the elapsed time of the given timer by name
-
timer_get_cur
-
Get current time
-
timer_start
-
Start a timer by name
-
timer_update_global
-
Update the global timer with an existing timer
-
tearDown
-
Tears down the fixture, for example, closes a network connection.
-
tearDown
-
Tears down the fixture, for example, closes a network connection.
-
tearDown
-
Tears down the fixture, for example, closes a network connection.
-
tearDown
-
Tears down the fixture, for example, closes a network connection.
-
tearDown
-
Tears down the fixture, for example, closes a network connection.
-
tearDown
-
Tears down the fixture, for example, closes a network connection.
-
tearDown
-
Tears down the fixture, for example, closes a network connection.
-
tearDown
-
Tears down the fixture, for example, closes a network connection.
-
tearDown
-
Tears down the fixture, for example, closes a network connection.
-
tearDown
-
Tears down the fixture, for example, closes a network connection.
-
testAffectedRows
-
-
testConnect
-
-
testConnect
-
-
testConnect
-
-
testConnect
-
-
testConnect
-
-
testConnect
-
-
testConvertMySqlToMSSql
-
-
testConvertMySqlTosybase
-
-
testCurrent
-
-
testCurrent
-
-
testDebug
-
-
testDescTable
-
-
testDisconnect
-
-
testDisconnect
-
-
testDisconnect
-
-
testDisconnect
-
-
testDisconnect
-
-
testDisconnect
-
-
testDonation
-
-
testDumpvar
-
The test echos HTML, it is just a test, that is still running
-
testEscape
-
-
testEscape
-
-
testEscape
-
-
testEscape
-
-
testEscape
-
-
testEscape
-
-
testEzSQL_fetch_assoc
-
-
testEzSQL_fetch_assoc
-
-
testEzSQL_fetch_object
-
-
testEzSQL_fetch_object
-
-
testEzSQL_fetch_row
-
-
testEzSQL_fetch_row
-
-
testFlush
-
-
testGetCharset
-
-
testGetDBHost
-
-
testGetDBHost
-
-
testGetDBHost
-
-
testGetDBHost
-
-
testGetDBName
-
-
testGetInsertId
-
-
testGetPort
-
-
testGet_cache
-
-
testGet_col
-
-
testGet_col_info
-
-
testGet_results
-
-
testGet_row
-
-
testGet_var
-
-
testHide_errors
-
-
testInsert_id
-
-
testInsert_id
-
-
testIs_equal_int
-
-
testIs_equal_int
-
-
testIs_equal_str
-
-
testIs_equal_str
-
-
testKey
-
-
testKey
-
-
testMySQLCatch_error
-
-
testMySQLConnect
-
-
testMySQLConnectWithOptions
-
-
testMySQLDisconnect
-
-
testMySQLEscape
-
-
testMySQLGet_set
-
-
testMySQLQuery
-
-
testMySQLQuick_connect
-
-
testMySQLSelect
-
-
testMySQLSysdate
-
-
testNext
-
-
testNext
-
-
testNextVal
-
-
testNextVal
-
-
testPConnect
-
To test connection pooling with oci_pconnect instead of oci_connect
-
testPosgreSQLCatch_error
-
-
testPosgreSQLConnect
-
-
testPosgreSQLDisconnect
-
-
testPosgreSQLEscape
-
-
testPosgreSQLQuery
-
-
testPosgreSQLQuick_connect
-
-
testPosgreSQLSelect
-
-
testPosgreSQLSysdate
-
-
testPostgreSQLGet_set
-
-
testPrevious
-
-
testPrevious
-
-
testQuery
-
-
testQuery
-
-
testQuery
-
-
testQuery
-
-
testQuery
-
-
testQueryInsert
-
-
testQuerySelect
-
-
testQuick_connect
-
-
testQuick_connect
-
-
testQuick_connect
-
-
testQuick_connect
-
-
testQuick_connect
-
-
testQuick_connect
-
-
testRegister_error
-
-
testRewind
-
-
testRewind
-
-
testSelect
-
-
testSelect
-
-
testSelect
-
-
testSelect
-
-
testSelect
-
-
testSelect
-
-
testShowDatabases
-
-
testShowTables
-
-
testShow_errors
-
-
testSQLiteCatch_error
-
-
testSQLiteConnect
-
-
testSQLiteDisconnect
-
-
testSQLiteEscape
-
-
testSQLiteGet_set
-
-
testSQLiteQuery
-
-
testSQLiteQuick_connect
-
-
testSQLiteSelect
-
-
testSQLiteSysdate
-
-
testStore_cache
-
-
testSysdate
-
-
testSysdate
-
-
testSysdate
-
-
testSysdate
-
-
testSysdate
-
-
testSysdate
-
-
testTimer_elapsed
-
-
testTimer_get_cur
-
-
testTimer_start
-
-
testTimer_update_global
-
-
testValid
-
-
testValid
-
-
testVardump
-
The test echos HTML, it is just a test, that is still running
-
TEST_DB_CHARSET
-
constant database connection charset
-
TEST_DB_CHARSET
-
constant database connection charset
-
TEST_DB_CHARSET
-
constant string database connection charset
-
TEST_DB_CHARSET
-
constant database connection charset
-
TEST_DB_HOST
-
constant database host
-
TEST_DB_HOST
-
constant database host
-
TEST_DB_HOST
-
constant string database host
-
TEST_DB_HOST
-
constant database host
-
TEST_DB_HOST
-
constant database host
-
TEST_DB_NAME
-
constant database name
-
TEST_DB_NAME
-
constant database name
-
TEST_DB_NAME
-
constant database name
-
TEST_DB_NAME
-
constant database name
-
TEST_DB_NAME
-
constant string database name
-
TEST_DB_PASSWORD
-
constant string password
-
TEST_DB_PASSWORD
-
constant string password
-
TEST_DB_PASSWORD
-
constant string password
-
TEST_DB_PASSWORD
-
constant string password
-
TEST_DB_PASSWORD
-
constant string password
-
TEST_DB_PORT
-
constant database port
-
TEST_DB_PORT
-
constant string database port
-
TEST_DB_USER
-
constant string user name
-
TEST_DB_USER
-
constant string user name
-
TEST_DB_USER
-
constant string user name
-
TEST_DB_USER
-
constant string user name
-
TEST_DB_USER
-
constant string user name
-
TEST_SQLITE_DB
-
constant string path and file name of the SQLite test database