| core_db

# Element index for package core_db [ a ] [ b ] [ c ] [ d ] [ e ] [ f ] [ g ] [ h ] [ i ] [ l ] [ m ] [ n ] [ p ] [ q ] [ r ] [ s ] [ t ] [ u ] [ w ] [ _ ] ## _ $_bsDb in file Bs_ArrayDb.class.php, variable Bs_ArrayDb::$_bsDb the db object that is in use. $_currentlyOpenTransactionID in file Bs_Oci.class.php, variable Bs_Oci::$_currentlyOpenTransactionID Holds the 'transaction ID'. (If an trans. ID was set). $_currentlyOpenTransactionID in file Bs_MySql.class.php, variable Bs_MySql::$_currentlyOpenTransactionID Holds the 'transaction ID'. (If an trans. ID was set). $_currentlyOpenTransactionID in file Bs_MsSql.class.php, variable Bs_MsSql::$_currentlyOpenTransactionID Holds the 'transaction ID'. (If an trans. ID was set). $_dbh in file Bs_ResultSet.class.php, variable Bs_ResultSet::$_dbh db handler $_result in file Bs_ResultSet.class.php, variable Bs_ResultSet::$_result result set _dbErrorToBsError in file Bs_Odbc.class.php, method Bs_Odbc::_dbErrorToBsError() Maps error codes of the current dbms to bs-dbErrorCodes. _dbErrorToBsError in file Bs_MySql.class.php, method Bs_MySql::_dbErrorToBsError() Maps error codes of the current dbms to bs-dbErrorCodes. _dbErrorToBsError in file Bs_MsSql.class.php, method Bs_MsSql::_dbErrorToBsError() Maps error codes of the current dbms to bs-dbErrorCodes. _dbErrorToBsError in file Bs_Oci.class.php, method Bs_Oci::_dbErrorToBsError() Maps error codes of the current dbms to bs-dbErrorCodes. $_APP in file Bs_MySql_PhpUnit.class.php, variable Bs_Mysql_PhpUnit::$_APP (subpackage: phpunit) $_Bs_Db in file Bs_Db_PhpUnit.class.php, variable Bs_Db_PhpUnit::$_Bs_Db (subpackage: phpunit) $_Bs_MySql in file Bs_MySql_PhpUnit.class.php, variable Bs_Mysql_PhpUnit::$_Bs_MySql (subpackage: phpunit) $_dsn in file Bs_MySql_PhpUnit.class.php, variable Bs_Mysql_PhpUnit::$_dsn (subpackage: phpunit) $_field in file Bs_MySql_PhpUnit.class.php, variable Bs_Mysql_PhpUnit::$_field (subpackage: phpunit) $_res in file Bs_MySql_PhpUnit.class.php, variable Bs_Mysql_PhpUnit::$_res (subpackage: phpunit) __Bs_MySql_affectedRows in file Bs_MySql_PhpUnit.class.php, method Bs_Mysql_PhpUnit::__Bs_MySql_affectedRows() (subpackage: phpunit) this update matches 1 record, but mysql doesn't need to update the table, so we really expect 0. rtfm if you don't believe it. __Bs_MySql_affectedRows2 in file Bs_MySql_PhpUnit.class.php, method Bs_Mysql_PhpUnit::__Bs_MySql_affectedRows2() (subpackage: phpunit) this update matches 2 records, but mysql should only need to update one. __Bs_MySql_connect in file Bs_MySql_PhpUnit.class.php, method Bs_Mysql_PhpUnit::__Bs_MySql_connect() (subpackage: phpunit) test to open a nonpersistent connection. __Bs_MySql_connect2 in file Bs_MySql_PhpUnit.class.php, method Bs_Mysql_PhpUnit::__Bs_MySql_connect2() (subpackage: phpunit) test to open a persistent connection. __Bs_MySql_databaseExists in file Bs_MySql_PhpUnit.class.php, method Bs_Mysql_PhpUnit::__Bs_MySql_databaseExists() (subpackage: phpunit) __Bs_MySql_databaseName in file Bs_MySql_PhpUnit.class.php, method Bs_Mysql_PhpUnit::__Bs_MySql_databaseName() (subpackage: phpunit) this test is a bit buggy. we cannot know which databases will exist on the server, so we cannot know which one will be at which position. so we check for a string as return value. but while testing i got things back like '0' and '1' and '2' which were accepted as valid strings, when i expected to get an error... __Bs_MySql_disconnect in file Bs_MySql_PhpUnit.class.php, method Bs_Mysql_PhpUnit::__Bs_MySql_disconnect() (subpackage: phpunit) close the previously opened non-p connection __Bs_MySql_disconnect2 in file Bs_MySql_PhpUnit.class.php, method Bs_Mysql_PhpUnit::__Bs_MySql_disconnect2() (subpackage: phpunit) try to close the prev. opened p-connection, which is expected to fail and thus return false. __Bs_MySql_escapeString in file Bs_Db_PhpUnit.class.php, method Bs_Db_PhpUnit::__Bs_MySql_escapeString() (subpackage: phpunit) test to open a nonpersistent connection. __Bs_MySql_fetchDatabaseNames in file Bs_MySql_PhpUnit.class.php, method Bs_Mysql_PhpUnit::__Bs_MySql_fetchDatabaseNames() (subpackage: phpunit) __Bs_MySql_fetchField in file Bs_MySql_PhpUnit.class.php, method Bs_Mysql_PhpUnit::__Bs_MySql_fetchField() (subpackage: phpunit) there is no such field '100' __Bs_MySql_fetchField2 in file Bs_MySql_PhpUnit.class.php, method Bs_Mysql_PhpUnit::__Bs_MySql_fetchField2() (subpackage: phpunit) __Bs_MySql_fetchField3 in file Bs_MySql_PhpUnit.class.php, method Bs_Mysql_PhpUnit::__Bs_MySql_fetchField3() (subpackage: phpunit) let's check all values of our tinyint field. __Bs_MySql_fetchFieldNames in file Bs_MySql_PhpUnit.class.php, method Bs_Mysql_PhpUnit::__Bs_MySql_fetchFieldNames() (subpackage: phpunit) __Bs_MySql_fetchFieldNames2 in file Bs_MySql_PhpUnit.class.php, method Bs_Mysql_PhpUnit::__Bs_MySql_fetchFieldNames2() (subpackage: phpunit) __Bs_MySql_fetchRow in file Bs_MySql_PhpUnit.class.php, method Bs_Mysql_PhpUnit::__Bs_MySql_fetchRow() (subpackage: phpunit) __Bs_MySql_fetchTableNames in file Bs_MySql_PhpUnit.class.php, method Bs_Mysql_PhpUnit::__Bs_MySql_fetchTableNames() (subpackage: phpunit) __Bs_MySql_fieldExists in file Bs_MySql_PhpUnit.class.php, method Bs_Mysql_PhpUnit::__Bs_MySql_fieldExists() (subpackage: phpunit) __Bs_MySql_fieldFlags in file Bs_MySql_PhpUnit.class.php, method Bs_Mysql_PhpUnit::__Bs_MySql_fieldFlags() (subpackage: phpunit) __Bs_MySql_fieldFlags2 in file Bs_MySql_PhpUnit.class.php, method Bs_Mysql_PhpUnit::__Bs_MySql_fieldFlags2() (subpackage: phpunit) __Bs_MySql_fieldFlags3 in file Bs_MySql_PhpUnit.class.php, method Bs_Mysql_PhpUnit::__Bs_MySql_fieldFlags3() (subpackage: phpunit) __Bs_MySql_fieldLen in file Bs_MySql_PhpUnit.class.php, method Bs_Mysql_PhpUnit::__Bs_MySql_fieldLen() (subpackage: phpunit) __Bs_MySql_fieldName in file Bs_MySql_PhpUnit.class.php, method Bs_Mysql_PhpUnit::__Bs_MySql_fieldName() (subpackage: phpunit) no such field and invalid resource. __Bs_MySql_fieldName2 in file Bs_MySql_PhpUnit.class.php, method Bs_Mysql_PhpUnit::__Bs_MySql_fieldName2() (subpackage: phpunit) should work... __Bs_MySql_fieldName3 in file Bs_MySql_PhpUnit.class.php, method Bs_Mysql_PhpUnit::__Bs_MySql_fieldName3() (subpackage: phpunit) there are not 15 fields, only 4. __Bs_MySql_fieldName4 in file Bs_MySql_PhpUnit.class.php, method Bs_Mysql_PhpUnit::__Bs_MySql_fieldName4() (subpackage: phpunit) this gets a bit more complicated. in dos mysql, it looks like this: __Bs_MySql_fieldType in file Bs_MySql_PhpUnit.class.php, method Bs_Mysql_PhpUnit::__Bs_MySql_fieldType() (subpackage: phpunit) mysql_field_type() returns strange field types. and even 'unknown' for some. __Bs_MySql_getDbStructure in file Bs_MySql_PhpUnit.class.php, method Bs_Mysql_PhpUnit::__Bs_MySql_getDbStructure() (subpackage: phpunit) __Bs_MySql_getIniVar in file Bs_MySql_PhpUnit.class.php, method Bs_Mysql_PhpUnit::__Bs_MySql_getIniVar() (subpackage: phpunit) __Bs_MySql_getOpenTables in file Bs_MySql_PhpUnit.class.php, method Bs_Mysql_PhpUnit::__Bs_MySql_getOpenTables() (subpackage: phpunit) __Bs_MySql_getStatusVar in file Bs_MySql_PhpUnit.class.php, method Bs_Mysql_PhpUnit::__Bs_MySql_getStatusVar() (subpackage: phpunit) __Bs_MySql_getTableInfo in file Bs_MySql_PhpUnit.class.php, method Bs_Mysql_PhpUnit::__Bs_MySql_getTableInfo() (subpackage: phpunit) __Bs_MySql_getTableProperties in file Bs_MySql_PhpUnit.class.php, method Bs_Mysql_PhpUnit::__Bs_MySql_getTableProperties() (subpackage: phpunit) __Bs_MySql_hasFieldFlag in file Bs_MySql_PhpUnit.class.php, method Bs_Mysql_PhpUnit::__Bs_MySql_hasFieldFlag() (subpackage: phpunit) of course there's no such flag 'lalalala'. __Bs_MySql_hasFieldFlag2 in file Bs_MySql_PhpUnit.class.php, method Bs_Mysql_PhpUnit::__Bs_MySql_hasFieldFlag2() (subpackage: phpunit) __Bs_MySql_hasFieldFlag3 in file Bs_MySql_PhpUnit.class.php, method Bs_Mysql_PhpUnit::__Bs_MySql_hasFieldFlag3() (subpackage: phpunit) __Bs_MySql_insertId in file Bs_MySql_PhpUnit.class.php, method Bs_Mysql_PhpUnit::__Bs_MySql_insertId() (subpackage: phpunit) __Bs_MySql_isReservedWord in file Bs_MySql_PhpUnit.class.php, method Bs_Mysql_PhpUnit::__Bs_MySql_isReservedWord() (subpackage: phpunit) __Bs_MySql_listDatabases in file Bs_MySql_PhpUnit.class.php, method Bs_Mysql_PhpUnit::__Bs_MySql_listDatabases() (subpackage: phpunit) __Bs_MySql_listFields in file Bs_MySql_PhpUnit.class.php, method Bs_Mysql_PhpUnit::__Bs_MySql_listFields() (subpackage: phpunit) __Bs_MySql_listTables in file Bs_MySql_PhpUnit.class.php, method Bs_Mysql_PhpUnit::__Bs_MySql_listTables() (subpackage: phpunit) __Bs_MySql_numCols in file Bs_MySql_PhpUnit.class.php, method Bs_Mysql_PhpUnit::__Bs_MySql_numCols() (subpackage: phpunit) __Bs_MySql_numCols2 in file Bs_MySql_PhpUnit.class.php, method Bs_Mysql_PhpUnit::__Bs_MySql_numCols2() (subpackage: phpunit) __Bs_MySql_numRows in file Bs_MySql_PhpUnit.class.php, method Bs_Mysql_PhpUnit::__Bs_MySql_numRows() (subpackage: phpunit) __Bs_MySql_numRows2 in file Bs_MySql_PhpUnit.class.php, method Bs_Mysql_PhpUnit::__Bs_MySql_numRows2() (subpackage: phpunit) __Bs_MySql_read in file Bs_MySql_PhpUnit.class.php, method Bs_Mysql_PhpUnit::__Bs_MySql_read() (subpackage: phpunit) i know that this is not mysql related. but we need a resourse for the tests below, so why not... __Bs_MySql_selectDb in file Bs_MySql_PhpUnit.class.php, method Bs_Mysql_PhpUnit::__Bs_MySql_selectDb() (subpackage: phpunit) this db has been created before so it should exist. __Bs_MySql_selectDb2 in file Bs_MySql_PhpUnit.class.php, method Bs_Mysql_PhpUnit::__Bs_MySql_selectDb2() (subpackage: phpunit) this db should not exist. __Bs_MySql_subSelect in file Bs_MySql_PhpUnit.class.php, method Bs_Mysql_PhpUnit::__Bs_MySql_subSelect() (subpackage: phpunit) test to open a persistent connection. __Bs_MySql_tableExists in file Bs_MySql_PhpUnit.class.php, method Bs_Mysql_PhpUnit::__Bs_MySql_tableExists() (subpackage: phpunit) also windows should return true for this table, even if the table in real is called 'allfieldtypes' (lower case). __Bs_MySql_tableName in file Bs_MySql_PhpUnit.class.php, method Bs_Mysql_PhpUnit::__Bs_MySql_tableName() (subpackage: phpunit) __Bs_MySql_tableName2 in file Bs_MySql_PhpUnit.class.php, method Bs_Mysql_PhpUnit::__Bs_MySql_tableName2() (subpackage: phpunit) i hope no-one added something in there that adds another test table with a name that comes above/before 'allfieldtypes' !!! otherwise this test fails. top ## a affectedRows in file Bs_MySql.class.php, method Bs_MySql::affectedRows() Gets the number of rows affected by the data manipulation query. affectedRows in file Bs_Oci.class.php, method Bs_Oci::affectedRows() Gets the number of rows affected by the data manipulation query. affectedRows in file Bs_Db.class.php, method Bs_Db::affectedRows() Gets the number of rows affected by the last data manipulation query. affectedRows in file Bs_MsSql.class.php, method Bs_MsSql::affectedRows() Gets the number of rows affected by the data manipulation query. assertExtension in file Bs_Db.class.php, method Bs_Db::assertExtension() Load a PHP database extension if it is not loaded already. autoCommit in file Bs_MySql.class.php, method Bs_MySql::autoCommit() Turn autoCommit on or off autoCommit in file Bs_Db.class.php, method Bs_Db::autoCommit() Turn autoCommit on or off autoCommit in file Bs_MsSql.class.php, method Bs_MsSql::autoCommit() Turn autoCommit on or off top ## b $Bs_Date in file Bs_Db.class.php, variable Bs_Db::$Bs_Date reference to the globally used pseudostatic Bs_Date object. Bs_ArrayDb in file Bs_ArrayDb.class.php, method Bs_ArrayDb::Bs_ArrayDb() constructor. Bs_ArrayDb in file Bs_ArrayDb.class.php, class Bs_ArrayDb Array-DB class. makes it possible to execute sql queries on a array. BS_ARRAYDB_VERSION in file Bs_ArrayDb.class.php, constant BS_ARRAYDB_VERSION Bs_Db in file Bs_Db.class.php, class Bs_Db abstract class Bs_Db.class.php Bs_Db in file Bs_Db.class.php, method Bs_Db::Bs_Db() constructor. Bs_DbWrapper in file Bs_DbWrapper.class.php, method Bs_DbWrapper::Bs_DbWrapper() constructor Bs_DbWrapper in file Bs_DbWrapper.class.php, class Bs_DbWrapper DB Wrapper BS_DBWRAPPER_VERSION in file Bs_DbWrapper.class.php, constant BS_DBWRAPPER_VERSION BS_DB_ERROR in file Bs_Db.class.php, constant BS_DB_ERROR BS_DB_ERROR_ALREADY_EXISTS in file Bs_Db.class.php, constant BS_DB_ERROR_ALREADY_EXISTS BS_DB_ERROR_CANNOT_CREATE in file Bs_Db.class.php, constant BS_DB_ERROR_CANNOT_CREATE BS_DB_ERROR_CANNOT_DELETE in file Bs_Db.class.php, constant BS_DB_ERROR_CANNOT_DELETE BS_DB_ERROR_CANNOT_DROP in file Bs_Db.class.php, constant BS_DB_ERROR_CANNOT_DROP BS_DB_ERROR_CANNOT_SELECT_DB in file Bs_Db.class.php, constant BS_DB_ERROR_CANNOT_SELECT_DB BS_DB_ERROR_CONNECT_FAILED in file Bs_Db.class.php, constant BS_DB_ERROR_CONNECT_FAILED BS_DB_ERROR_CONSTRAINT in file Bs_Db.class.php, constant BS_DB_ERROR_CONSTRAINT BS_DB_ERROR_DIVZERO in file Bs_Db.class.php, constant BS_DB_ERROR_DIVZERO BS_DB_ERROR_INVALID in file Bs_Db.class.php, constant BS_DB_ERROR_INVALID BS_DB_ERROR_INVALID_DATE in file Bs_Db.class.php, constant BS_DB_ERROR_INVALID_DATE BS_DB_ERROR_INVALID_DSN in file Bs_Db.class.php, constant BS_DB_ERROR_INVALID_DSN BS_DB_ERROR_INVALID_NUMBER in file Bs_Db.class.php, constant BS_DB_ERROR_INVALID_NUMBER BS_DB_ERROR_INVALID_RS in file Bs_Db.class.php, constant BS_DB_ERROR_INVALID_RS BS_DB_ERROR_MISMATCH in file Bs_Db.class.php, constant BS_DB_ERROR_MISMATCH BS_DB_ERROR_NEED_MORE_DATA in file Bs_Db.class.php, constant BS_DB_ERROR_NEED_MORE_DATA BS_DB_ERROR_NODBSELECTED in file Bs_Db.class.php, constant BS_DB_ERROR_NODBSELECTED BS_DB_ERROR_NOSUCHFIELD in file Bs_Db.class.php, constant BS_DB_ERROR_NOSUCHFIELD BS_DB_ERROR_NOSUCHTABLE in file Bs_Db.class.php, constant BS_DB_ERROR_NOSUCHTABLE BS_DB_ERROR_NOT_CAPABLE in file Bs_Db.class.php, constant BS_DB_ERROR_NOT_CAPABLE BS_DB_ERROR_NOT_CONNECTED in file Bs_Db.class.php, constant BS_DB_ERROR_NOT_CONNECTED BS_DB_ERROR_NOT_FOUND in file Bs_Db.class.php, constant BS_DB_ERROR_NOT_FOUND BS_DB_ERROR_NOT_LOCKED in file Bs_Db.class.php, constant BS_DB_ERROR_NOT_LOCKED BS_DB_ERROR_SYNTAX in file Bs_Db.class.php, constant BS_DB_ERROR_SYNTAX BS_DB_ERROR_TRUNCATED in file Bs_Db.class.php, constant BS_DB_ERROR_TRUNCATED BS_DB_ERROR_UNSUPPORTED in file Bs_Db.class.php, constant BS_DB_ERROR_UNSUPPORTED BS_DB_ERROR_VALUE_COUNT_ON_ROW in file Bs_Db.class.php, constant BS_DB_ERROR_VALUE_COUNT_ON_ROW BS_DB_FETCHMODE_ASSOC in file Bs_Db.class.php, constant BS_DB_FETCHMODE_ASSOC Column data indexed by column names BS_DB_FETCHMODE_ORDERED in file Bs_Db.class.php, constant BS_DB_FETCHMODE_ORDERED Column data indexed by numbers, ordered from 0 and up BS_DB_VERSION in file Bs_Db.class.php, constant BS_DB_VERSION bs_isReservedDbWord in file Bs_DbGeneral.lib.php, function bs_isReservedDbWord() The following words are explicitly reserved in MySQL and most of them are forbidden by ANSI SQL92 Bs_MsSql in file Bs_MsSql.class.php, class Bs_MsSql This is the API for MSSQL it's an extention of the abstract class Bs_Db.class.php Bs_MsSql in file Bs_MsSql.class.php, method Bs_MsSql::Bs_MsSql() Constructor. BS_MSSQL_VERSION in file Bs_MsSql.class.php, constant BS_MSSQL_VERSION Bs_MySql in file Bs_MySql.class.php, method Bs_MySql::Bs_MySql() Constructor. Bs_MySql in file Bs_MySql.class.php, class Bs_MySql This is the API for mySQL it's an extention of the abstract class Bs_Db.class.php BS_MYSQL_VERSION in file Bs_MySql.class.php, constant BS_MYSQL_VERSION Bs_Oci in file Bs_Oci.class.php, class Bs_Oci *********************************************************************** This is the API for Oracle. it's an extention of the abstract class Bs_Db.class.php Bs_Oci in file Bs_Oci.class.php, method Bs_Oci::Bs_Oci() Constructor. BS_OCI_VERSION in file Bs_Oci.class.php, constant BS_OCI_VERSION Bs_Odbc in file Bs_Odbc.class.php, method Bs_Odbc::Bs_Odbc() Constructor. Bs_Odbc in file Bs_Odbc.class.php, class Bs_Odbc *********************************************************************** dependencies: Bs_Db BS_ODBC_VERSION in file Bs_Odbc.class.php, constant BS_ODBC_VERSION Bs_ResultSet in file Bs_ResultSet.class.php, class Bs_ResultSet This class implements a wrapper for a DB result set. Bs_ResultSet in file Bs_ResultSet.class.php, method Bs_ResultSet::Bs_ResultSet() constructor. BS_RESULTSET_VERSION in file Bs_ResultSet.class.php, constant BS_RESULTSET_VERSION Bs_ArrayDb.class.php procedural page Bs_ArrayDb.class.php Bs_DbGeneral.lib.php procedural page Bs_DbGeneral.lib.php Bs_DbWrapper.class.php procedural page Bs_DbWrapper.class.php Bs_Db.class.php procedural page Bs_Db.class.php Bs_MsSql.class.php procedural page Bs_MsSql.class.php Bs_MySql.class.php procedural page Bs_MySql.class.php Bs_Oci.class.php procedural page Bs_Oci.class.php Bs_Odbc.class.php procedural page Bs_Odbc.class.php Bs_ResultSet.class.php procedural page Bs_ResultSet.class.php Bs_Db_PhpUnit.class.php procedural page Bs_Db_PhpUnit.class.php Bs_MySql_PhpUnit.class.php procedural page Bs_MySql_PhpUnit.class.php Bs_Db_PhpUnit in file Bs_Db_PhpUnit.class.php, class Bs_Db_PhpUnit (subpackage: phpunit) Bs_Db_PhpUnit in file Bs_Db_PhpUnit.class.php, method Bs_Db_PhpUnit::Bs_Db_PhpUnit() (subpackage: phpunit) Bs_MySql_PhpUnit in file Bs_MySql_PhpUnit.class.php, method Bs_Mysql_PhpUnit::Bs_MySql_PhpUnit() (subpackage: phpunit) Bs_Mysql_PhpUnit in file Bs_MySql_PhpUnit.class.php, class Bs_Mysql_PhpUnit (subpackage: phpunit) top ## c commit in file Bs_Db.class.php, method Bs_Db::commit() Commit last query commit in file Bs_MySql.class.php, method Bs_MySql::commit() Commit the current or given transaction. commit in file Bs_MsSql.class.php, method Bs_MsSql::commit() Commit the current or given transaction. connect in file Bs_Oci.class.php, method Bs_Oci::connect() Connect to a database server and log in as the specified user. connect in file Bs_Odbc.class.php, method Bs_Odbc::connect() Connect to a database server and log in as the specified user. connect in file Bs_MySql.class.php, method Bs_MySql::connect() Connect to a database server and log in as the specified user. connect in file Bs_MsSql.class.php, method Bs_MsSql::connect() Connect to a database server and log in as the specified user. countRead in file Bs_Db.class.php, method Bs_Db::countRead() Issue a select query and return the number of 'affected' rows. countWrite in file Bs_Db.class.php, method Bs_Db::countWrite() Issue a write query (update, delete, replace) and return the number of affected rows. top ## d databaseExists in file Bs_MsSql.class.php, method Bs_MsSql::databaseExists() Tells whether the database (or databases) exist or not. databaseExists in file Bs_MySql.class.php, method Bs_MySql::databaseExists() Tells whether the database (or databases) exist or not. databaseName in file Bs_MySql.class.php, method Bs_MySql::databaseName() Get the name of the specified db in a result you got from mysql_list_dbs(). databaseName in file Bs_MsSql.class.php, method Bs_MsSql::databaseName() Get the name of the specified db in a result you got from mysql_list_dbs(). dbCount in file Bs_DbWrapper.class.php, method Bs_DbWrapper::dbCount() If dbCount finds any foreign tables in the where clause then it will put them into a comma separated list. dbDelete in file Bs_DbWrapper.class.php, method Bs_DbWrapper::dbDelete() Delete the record from the DB. dbInsert in file Bs_DbWrapper.class.php, method Bs_DbWrapper::dbInsert() Insert a new set of data (record) into the DB. dbPing in file Bs_Db.class.php, method Bs_Db::dbPing() Tells whether we're connected. dbUpdate in file Bs_DbWrapper.class.php, method Bs_DbWrapper::dbUpdate() Replace an existing record or, if not existent, insert a new one. disconnect in file Bs_Odbc.class.php, method Bs_Odbc::disconnect() Log out and disconnect from the database. disconnect in file Bs_Oci.class.php, method Bs_Oci::disconnect() Log out and disconnect from the database. disconnect in file Bs_MySql.class.php, method Bs_MySql::disconnect() Log out and disconnect from the database. disconnect in file Bs_MsSql.class.php, method Bs_MsSql::disconnect() Log out and disconnect from the database. top ## e escapeString in file Bs_Odbc.class.php, method Bs_Odbc::escapeString() Escape string for mysql query. escapeString in file Bs_Oci.class.php, method Bs_Oci::escapeString() Escape string for oracle query. escapeString in file Bs_MySql.class.php, method Bs_MySql::escapeString() Escape string for mysql query. escapeString in file Bs_MsSql.class.php, method Bs_MsSql::escapeString() Escape string for mssql query. escapeString in file Bs_Db.class.php, method Bs_Db::escapeString() Escape string for the query. top ## f $format in file Bs_MySql.class.php, variable Bs_MySql::$format some database specific formats. overwrites parent. $format in file Bs_Odbc.class.php, variable Bs_Odbc::$format some database specific formats. overwrites parent. $format in file Bs_Db.class.php, variable Bs_Db::$format some database specific formats. please overwrite. $format in file Bs_Oci.class.php, variable Bs_Oci::$format some database specific formats. overwrites parent. fetchDatabaseNames in file Bs_MySql.class.php, method Bs_MySql::fetchDatabaseNames() Return the available db names. fetchDatabaseNames in file Bs_MsSql.class.php, method Bs_MsSql::fetchDatabaseNames() Returns the available db names. fetchField in file Bs_MySql.class.php, method Bs_MySql::fetchField() Returns an object containing field information (of the table structure). fetchField in file Bs_MsSql.class.php, method Bs_MsSql::fetchField() Returns an object containing field information (of the table structure). fetchFieldNames in file Bs_MySql.class.php, method Bs_MySql::fetchFieldNames() Return the field names of the given database table. fetchFieldNames in file Bs_MsSql.class.php, method Bs_MsSql::fetchFieldNames() Return the field names of the given database table. fetchRow in file Bs_ResultSet.class.php, method Bs_ResultSet::fetchRow() Fetch and return a row of data. fetchRow in file Bs_Odbc.class.php, method Bs_Odbc::fetchRow() Fetch a row and return it as vector or hash depending on the fetchMode. fetchRow in file Bs_Oci.class.php, method Bs_Oci::fetchRow() Fetch a row and return it as vector or hash depending on the fetchMode. fetchRow in file Bs_MySql.class.php, method Bs_MySql::fetchRow() Fetch a row and return it as vector or hash depending on the fetchMode. fetchRow in file Bs_MsSql.class.php, method Bs_MsSql::fetchRow() Fetch a row and return it as vector or hash depending on the fetchMode. fetchRow in file Bs_Db.class.php, method Bs_Db::fetchRow() Fetch a row and return it as vector or hash depending on the fetchMode. fetchTableNames in file Bs_MySql.class.php, method Bs_MySql::fetchTableNames() Return the table names of the given database. fetchTableNames in file Bs_MsSql.class.php, method Bs_MsSql::fetchTableNames() Return the table names of the given database. fieldExists in file Bs_MySql.class.php, method Bs_MySql::fieldExists() Tells whether the db field (or fields) exist or not. fieldExists in file Bs_MsSql.class.php, method Bs_MsSql::fieldExists() Tells whether the db field (or fields) exist or not. fieldFlags in file Bs_MySql.class.php, method Bs_MySql::fieldFlags() Get the flags of a field at the specified offset from a result id. fieldFlags in file Bs_MsSql.class.php, method Bs_MsSql::fieldFlags() Get the flags of a field at the specified offset from a result id. fieldLen in file Bs_MySql.class.php, method Bs_MySql::fieldLen() Returns the length of a field at the specified offset from a result id. fieldLen in file Bs_Odbc.class.php, method Bs_Odbc::fieldLen() Returns the length of a field at the specified offset from a result id. fieldLen in file Bs_MsSql.class.php, method Bs_MsSql::fieldLen() Returns the length of a field at the specified offset from a result id. fieldName in file Bs_Odbc.class.php, method Bs_Odbc::fieldName() Get the field name at the specified offset from a result id. fieldName in file Bs_MsSql.class.php, method Bs_MsSql::fieldName() Get the field name at the specified offset from a result id. fieldName in file Bs_MySql.class.php, method Bs_MySql::fieldName() Get the field name at the specified offset from a result id. fieldType in file Bs_MsSql.class.php, method Bs_MsSql::fieldType() Get the type of a field at the specified offset from a result id. fieldType in file Bs_Odbc.class.php, method Bs_Odbc::fieldType() Get the type of a field at the specified offset from a result id. fieldType in file Bs_MySql.class.php, method Bs_MySql::fieldType() Get the type of a field at the specified offset from a result id. formatDateForDb in file Bs_Db.class.php, method Bs_Db::formatDateForDb() format and return date string in database date format. formatDateForDb in file Bs_Oci.class.php, method Bs_Oci::formatDateForDb() format and return date string in database date format. formatDatetimeForDb in file Bs_Db.class.php, method Bs_Db::formatDatetimeForDb() format and return datetime string in database datetime format. formatDatetimeForDb in file Bs_Oci.class.php, method Bs_Oci::formatDatetimeForDb() format and return datetime string in database datetime format. formatTimestampForDb in file Bs_Oci.class.php, method Bs_Oci::formatTimestampForDb() format and return timestamp string in database timestamp format. formatTimestampForDb in file Bs_Db.class.php, method Bs_Db::formatTimestampForDb() format and return timestamp string in database timestamp format. free in file Bs_ResultSet.class.php, method Bs_ResultSet::free() Frees the resources allocated for this result set. freeResult in file Bs_Odbc.class.php, method Bs_Odbc::freeResult() Free the internal resources associated with $result. Only needs to be called if you are concerned about how much memory is being used for queries that return large result sets. freeResult in file Bs_MySql.class.php, method Bs_MySql::freeResult() Free the internal resources associated with $result. Only needs to be called if you are concerned about how much memory is being used for queries that return large result sets. freeResult in file Bs_MsSql.class.php, method Bs_MsSql::freeResult() Free the internal resources associated with $result. Only needs to be called if you are concerned about how much memory is being used for queries that return large result sets. freeResult in file Bs_Db.class.php, method Bs_Db::freeResult() Free the internal resources associated with $result. freeResult in file Bs_Oci.class.php, method Bs_Oci::freeResult() Free the internal resources associated with $result. Only needs to be called if you are concerned about how much memory is being used for queries that return large result sets. top ## g getAll in file Bs_Db.class.php, method Bs_Db::getAll() Fetch the entire data given by the param $source into a hash. getAssoc in file Bs_Db.class.php, method Bs_Db::getAssoc() Fetch the entire data given by the param $source into a hash using the first column as the key. getAssoc2 in file Bs_Db.class.php, method Bs_Db::getAssoc2() hash array COLUMN BY COLUMN not record by record. getAssoc3 in file Bs_Db.class.php, method Bs_Db::getAssoc3() group the values of one field by another one. see the example. getClientInfo in file Bs_MySql.class.php, method Bs_MySql::getClientInfo() Returns a string that represents the client library version. getClientInfo in file Bs_MsSql.class.php, method Bs_MsSql::getClientInfo() Returns a string that represents the client library version. getCol in file Bs_Db.class.php, method Bs_Db::getCol() Fetch a full OR fraction col of data as vector given by the param $source. getData in file Bs_DbWrapper.class.php, method Bs_DbWrapper::getData() returns the desirec data. getDbObject in file Bs_Db.class.php, function getDbObject() function to get a db object for a given dsn (DB Servic Name). getDbStructure in file Bs_MySql.class.php, method Bs_MySql::getDbStructure() Return a 2-D array of tables and fieldnames found in the given db. getDbStructure in file Bs_MsSql.class.php, method Bs_MsSql::getDbStructure() Return a 2-D array of tables and fieldnames found in the given db. getDsn in file Bs_Db.class.php, method Bs_Db::getDsn() Return the _dsnInfo-hash. getErrorMessage in file Bs_Db.class.php, method Bs_Db::getErrorMessage() Return a textual error message for a bs DB error code getFieldValue in file Bs_Db.class.php, method Bs_Db::getFieldValue() Returns 1-n db-field values. getHostInfo in file Bs_MsSql.class.php, method Bs_MsSql::getHostInfo() Returns a string describing the type of connection in use, including the server host name. getHostInfo in file Bs_MySql.class.php, method Bs_MySql::getHostInfo() Returns a string describing the type of connection in use, including the server host name. getIniVar in file Bs_MsSql.class.php, method Bs_MsSql::getIniVar() Return the value of the currently used ini setting var. getIniVar in file Bs_MySql.class.php, method Bs_MySql::getIniVar() Return the value of the currently used ini setting var. getNumRecords in file Bs_Db.class.php, method Bs_Db::getNumRecords() Returns the number of records that get selected for a given query. getOne in file Bs_Db.class.php, method Bs_Db::getOne() Fetch a single value from a data amount given by the param $source. getOpenTables in file Bs_MySql.class.php, method Bs_MySql::getOpenTables() Returns the currently open tables in $db. getOpenTables in file Bs_MsSql.class.php, method Bs_MsSql::getOpenTables() Returns the currently open tables in $db. getProtocolInfo in file Bs_MySql.class.php, method Bs_MySql::getProtocolInfo() Returns the protocol version used by current connection. getProtocolInfo in file Bs_MsSql.class.php, method Bs_MsSql::getProtocolInfo() Returns the protocol version used by current connection. getRecordList in file Bs_DbWrapper.class.php, method Bs_DbWrapper::getRecordList() //If getRecordList finds any foreign tables in the where clause OR in the fieldArray, it will put it in the the //FROM <tab1>,<tab2> part of the sql query string. getRow in file Bs_Db.class.php, method Bs_Db::getRow() Fetch a full row of data as vector or hash given by the param $source. getServerInfo in file Bs_MsSql.class.php, method Bs_MsSql::getServerInfo() Returns a string that represents the server version number. getServerInfo in file Bs_MySql.class.php, method Bs_MySql::getServerInfo() Returns a string that represents the server version number. getStatusVar in file Bs_MySql.class.php, method Bs_MySql::getStatusVar() Return the value of the specified status var. getStatusVar in file Bs_MsSql.class.php, method Bs_MsSql::getStatusVar() Return the value of the specified status var. getTableInfo in file Bs_MySql.class.php, method Bs_MySql::getTableInfo() Returns a hash holding information about the given db table. getTableInfo in file Bs_MsSql.class.php, method Bs_MsSql::getTableInfo() Returns an hash holding information about the given db table. getTableInfo in file Bs_Oci.class.php, method Bs_Oci::getTableInfo() Returns a hash holding information about the given db table. getTableLastmod in file Bs_MySql.class.php, method Bs_MySql::getTableLastmod() returns the datetime of the last change to the data of the given db table. getTableProperties in file Bs_MySql.class.php, method Bs_MySql::getTableProperties() !!!!!!!!!!!!!!!!deprecated!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!deprecated!!!!!!!!!!!!!!!!!!!!!! use getTableStructure() it's a better name and returns better/more info. getTablesLastmod in file Bs_MySql.class.php, method Bs_MySql::getTablesLastmod() this is similar to getTableLastmod(), note the extra s. getTableStructure in file Bs_MySql.class.php, method Bs_MySql::getTableStructure() Returns an array with information about the fields of the given db table. getTableType in file Bs_MsSql.class.php, method Bs_MsSql::getTableType() Returns the table type of the specified db table. getTableType in file Bs_MySql.class.php, method Bs_MySql::getTableType() Returns the table type of the specified db table. top ## h hasFieldFlag in file Bs_MySql.class.php, method Bs_MySql::hasFieldFlag() Tells whether the field has the given flag. The field is specified by offset in a result id. hasFieldFlag in file Bs_MsSql.class.php, method Bs_MsSql::hasFieldFlag() Tells whether the field has the given flag. The field is specified by offset in a result id. top ## i idWrite in file Bs_Oci.class.php, method Bs_Oci::idWrite() overwrites parent method. idWrite in file Bs_Db.class.php, method Bs_Db::idWrite() Issue an insert query on a table with an auto_increment field and return the newly inserted id. init in file Bs_ArrayDb.class.php, method Bs_ArrayDb::init() inits the object with the given data. initByData in file Bs_DbWrapper.class.php, method Bs_DbWrapper::initByData() init using the result set (as array). initByID in file Bs_DbWrapper.class.php, method Bs_DbWrapper::initByID() Init by fetching the data from the DB and then call $this->initByData(). insertId in file Bs_Oci.class.php, method Bs_Oci::insertId() insertId in file Bs_MySql.class.php, method Bs_MySql::insertId() Returns the ID generated for an AUTO_INCREMENT column by the previous INSERT query on this thread. insertId in file Bs_Db.class.php, method Bs_Db::insertId() Get the id generated from the previous INSERT operation. insertId in file Bs_MsSql.class.php, method Bs_MsSql::insertId() Returns the ID generated for an AUTO_INCREMENT column by the previous INSERT query on this thread. isManipulation in file Bs_Db.class.php, method Bs_Db::isManipulation() Tells whether a query is a data manipulation query (insert, update, delete replace, alter, drop, create). isReservedWord in file Bs_Oci.class.php, method Bs_Oci::isReservedWord() Tells if a word is a reserved word for the rdbms. isReservedWord in file Bs_MsSql.class.php, method Bs_MsSql::isReservedWord() Tells if a word is a reserved word for mysql. isReservedWord in file Bs_MySql.class.php, method Bs_MySql::isReservedWord() Tells if a word is a reserved word for mysql. isValidName in file Bs_Oci.class.php, method Bs_Oci::isValidName() Tells if a name for a db, table or field is accepted by the rdbms or not. isValidName in file Bs_MsSql.class.php, method Bs_MsSql::isValidName() Tells if a name for a db, table or field is accepted by mysql or not. isValidName in file Bs_MySql.class.php, method Bs_MySql::isValidName() Tells if a name for a db, table or field is accepted by mysql or not. top ## l listDatabases in file Bs_MsSql.class.php, method Bs_MsSql::listDatabases() returns a result identifier for the available databases. listDatabases in file Bs_MySql.class.php, method Bs_MySql::listDatabases() returns a result identifier for the available databases. listFields in file Bs_MsSql.class.php, method Bs_MsSql::listFields() Retrieves information about the given tablename. listFields in file Bs_MySql.class.php, method Bs_MySql::listFields() Retrieves information about the given tablename. listTables in file Bs_Odbc.class.php, method Bs_Odbc::listTables() see odbc_tables() listTables in file Bs_MySql.class.php, method Bs_MySql::listTables() Retrieves information about the given table. (does it? is that text correct? --andrej) This is a wrapper for mysql_list_tables(). listTables in file Bs_MsSql.class.php, method Bs_MsSql::listTables() returns a result identifier for the available tables in the given database. top ## m mysql.php procedural page mysql.php (subpackage: examples) top ## n nativeError in file Bs_MsSql.class.php, method Bs_MsSql::nativeError() Returns the native error from the previous MySQL operation or '' (empty string) if no error occured. nativeError in file Bs_MySql.class.php, method Bs_MySql::nativeError() Returns the native error from the previous MySQL operation or '' (empty string) if no error occured. nativeError in file Bs_Odbc.class.php, method Bs_Odbc::nativeError() Returns the native error from the previous db operation or '' (empty string) if no error occured. nativeError in file Bs_Oci.class.php, method Bs_Oci::nativeError() Returns the native error from the previous sql operation or '' (empty string) if no error occured. nativeErrorCode in file Bs_MySql.class.php, method Bs_MySql::nativeErrorCode() Returns the numerical native error code from the previous MySQL operation or 0 (zero) if no error occured. nativeErrorCode in file Bs_Oci.class.php, method Bs_Oci::nativeErrorCode() Returns the numerical native error code from the previous sql operation or 0 (zero) if no error occured. nativeErrorCode in file Bs_Db.class.php, method Bs_Db::nativeErrorCode() Returns the numerical native error code from the previous DB operation or 0 (zero) if no error occured. nativeErrorCode in file Bs_Odbc.class.php, method Bs_Odbc::nativeErrorCode() Returns the numerical native error code from the previous db operation or 0 (zero) if no error occured. nativeErrorMsg in file Bs_Oci.class.php, method Bs_Oci::nativeErrorMsg() Returns the native error text from the previous sql operation or '' (empty string) if no error occured. nativeErrorMsg in file Bs_Db.class.php, method Bs_Db::nativeErrorMsg() Returns the native error text from the previous DB operation or '' (empty string) if no error occured. nativeErrorMsg in file Bs_MsSql.class.php, method Bs_MsSql::nativeErrorMsg() Returns the native error text from the previous MsSQL operation or '' (empty string) if no error occured or the error was below the min_message_severity. nativeErrorMsg in file Bs_Odbc.class.php, method Bs_Odbc::nativeErrorMsg() Returns the native error text from the previous db operation or '' (empty string) if no error occured. nativeErrorMsg in file Bs_MySql.class.php, method Bs_MySql::nativeErrorMsg() Returns the native error text from the previous MySQL operation or '' (empty string) if no error occured. numCols in file Bs_ResultSet.class.php, method Bs_ResultSet::numCols() Get the the number of columns in a result set. numCols in file Bs_Odbc.class.php, method Bs_Odbc::numCols() Get the number of columns (fields) from a result set. numCols in file Bs_Oci.class.php, method Bs_Oci::numCols() Get the number of columns (fields) from a result set. numCols in file Bs_MySql.class.php, method Bs_MySql::numCols() Get the number of columns (fields) from a result set. numCols in file Bs_Db.class.php, method Bs_Db::numCols() Get the number of columns (fields) in a result identifier. numCols in file Bs_MsSql.class.php, method Bs_MsSql::numCols() Get the number of columns (fields) from a result set. numRows in file Bs_ResultSet.class.php, method Bs_ResultSet::numRows() Get the number of rows in a result set. numRows in file Bs_MySql.class.php, method Bs_MySql::numRows() Get the number of rows from a result set. numRows in file Bs_Db.class.php, method Bs_Db::numRows() Get the number of rows from a result identifier. numRows in file Bs_Oci.class.php, method Bs_Oci::numRows() Get the number of rows from a result set. numRows in file Bs_MsSql.class.php, method Bs_MsSql::numRows() Get the number of rows from a result set. top ## p parseDsn in file Bs_Db.class.php, method Bs_Db::parseDsn() provides in file Bs_Db.class.php, method Bs_Db::provides() Tell whether a DB implementation or its backend extension supports a given feature. top ## q query in file Bs_ArrayDb.class.php, method Bs_ArrayDb::query() executes the given sql query on your data. quoteArgs in file Bs_Db.class.php, method Bs_Db::quoteArgs() Takes a hash and returns a string for an sql query. top ## r read in file Bs_Db.class.php, method Bs_Db::read() Issue a select query and return a resource (or statement for oci). rlArrayToHashArray in file Bs_DbWrapper.class.php, method Bs_DbWrapper::rlArrayToHashArray() rollback in file Bs_Db.class.php, method Bs_Db::rollback() Rollback last query rollback in file Bs_MsSql.class.php, method Bs_MsSql::rollback() Rollback last query rollback in file Bs_MySql.class.php, method Bs_MySql::rollback() Rollback last query rsRead in file Bs_Db.class.php, method Bs_Db::rsRead() Issue a select query and return an instance of Bs_ResultSet. runTest in file Bs_MySql_PhpUnit.class.php, method Bs_Mysql_PhpUnit::runTest() (subpackage: phpunit) runTest in file Bs_Db_PhpUnit.class.php, method Bs_Db_PhpUnit::runTest() (subpackage: phpunit) top ## s selectDb in file Bs_MySql.class.php, method Bs_MySql::selectDb() Select a MySQL database. selectDb in file Bs_Oci.class.php, method Bs_Oci::selectDb() Select a database. selectDb in file Bs_MsSql.class.php, method Bs_MsSql::selectDb() Select a MsSQL database. serverSupportsTableType in file Bs_MySql.class.php, method Bs_MySql::serverSupportsTableType() Tells whether the given table type is supported by the server or not. serverSupportsTableType in file Bs_MsSql.class.php, method Bs_MsSql::serverSupportsTableType() Tells whether the given table type is supported by the server or not. setDbName in file Bs_DbWrapper.class.php, method Bs_DbWrapper::setDbName() sets the db name that should be used. setDbObj in file Bs_DbWrapper.class.php, method Bs_DbWrapper::setDbObj() sets (overwrites) the db object to use. setDbTableName in file Bs_DbWrapper.class.php, method Bs_DbWrapper::setDbTableName() sets the table name that should be used. setPointer in file Bs_MySql.class.php, method Bs_MySql::setPointer() Sets the internal row pointer of the result id to point to the specified row number. setPointer in file Bs_MsSql.class.php, method Bs_MsSql::setPointer() Sets the internal row pointer of the result id to point to the specified row number. setPointer in file Bs_Db.class.php, method Bs_Db::setPointer() Set the internal row pointer of the result id to point to the specified row number. sqlArrayToOrderBy in file Bs_DbWrapper.class.php, method Bs_DbWrapper::sqlArrayToOrderBy() Usefull INTELLIGENT helper to built a the ORDER BY postfix sql string. sqlPrepareByArray in file Bs_DbWrapper.class.php, method Bs_DbWrapper::sqlPrepareByArray() Usefull INTELLIGENT helper to built a SELECT, INSERT, REPLACE and UPDATE (maybe more) sql string. startTransaction in file Bs_Db.class.php, method Bs_Db::startTransaction() Starts a transaction startTransaction in file Bs_MsSql.class.php, method Bs_MsSql::startTransaction() Starts a transaction As optional parameter you can pass a transaction ID. startTransaction in file Bs_MySql.class.php, method Bs_MySql::startTransaction() Starts a transaction As optional parameter you can pass a transaction ID. subSelect in file Bs_MySql.class.php, method Bs_MySql::subSelect() Handles a single nested SELECT statement to overcome that limitation in MySql as it isn't suported (yet). setUp in file Bs_MySql_PhpUnit.class.php, method Bs_Mysql_PhpUnit::setUp() (subpackage: phpunit) setUp in file Bs_Db_PhpUnit.class.php, method Bs_Db_PhpUnit::setUp() (subpackage: phpunit) top ## t tableExists in file Bs_MySql.class.php, method Bs_MySql::tableExists() Tells whether the db table (or tables) exist or not. tableExists in file Bs_MsSql.class.php, method Bs_MsSql::tableExists() Tells whether the db table (or tables) exist or not. tableHasTransactions in file Bs_Oci.class.php, method Bs_Oci::tableHasTransactions() tableHasTransactions in file Bs_MsSql.class.php, method Bs_MsSql::tableHasTransactions() tableHasTransactions in file Bs_MySql.class.php, method Bs_MySql::tableHasTransactions() tableName in file Bs_MySql.class.php, method Bs_MySql::tableName() Returns the name of the table that the field (specifed by an offset) is in. tableName in file Bs_MsSql.class.php, method Bs_MsSql::tableName() Returns the name of the table that the field (specifed by an offset) is in. tableName2 in file Bs_MySql.class.php, method Bs_MySql::tableName2() Get the name of the specified table in a result you got from mysql_list_tables(). tableName2 in file Bs_MsSql.class.php, method Bs_MsSql::tableName2() Get the name of the specified table in a result you got from mysql_list_tables(). toString in file Bs_Db.class.php, method Bs_Db::toString() Returns a string with information about the current state of this db object. top ## u updateTableStructure in file Bs_MySql.class.php, method Bs_MySql::updateTableStructure() updates an existing db table to the desired structure. top ## w write in file Bs_Db.class.php, method Bs_Db::write() Issue a write query (insert, update, delete, replace, drop, alter, create). top Documentation generated on Mon, 29 Dec 2003 21:07:24 +0100 by phpDocumentor 1.2.3