|
||
| [ class tree: core_db ] [ index: core_db ] [ all elements ] | ||
|
Packages: packageless applications_chartwizard applications_cms applications_contactform applications_debedoo applications_faq applications_filebrowser applications_filemanager applications_imagearchive applications_indexedlistmanager applications_mailinglist applications_simplequiz applications_smartshop applications_websearchengine core core_auth core_crypt core_date core_db core_file core_gfx core_html core_lang core_net core_storage core_text core_util core_xml Cpdf plugins_geo plugins_indexserver plugins_instanthelp plugins_jsrs plugins_onomastics toolbox_phppackager _ Files:
Bs_ArrayDb.class.php
Bs_Db.class.php Bs_DbGeneral.lib.php Bs_DbWrapper.class.php Bs_Db_PhpUnit.class.php Bs_MsSql.class.php Bs_MySql.class.php Bs_MySql_PhpUnit.class.php Bs_Oci.class.php Bs_Odbc.class.php Bs_ResultSet.class.php subpackage examples Classes: |
[ Top ] $_currentlyOpenTransactionID = ''[line 109] Holds the 'transaction ID'. (If an trans. ID was set).Tags:
[ Top ] Class Methodsconstructor Bs_Oci [line 156]method affectedRows [line 420]
Gets the number of rows affected by the data manipulation query. For other queries, this function returns FALSE. see numRows(). Tags:
Overrides Bs_Db::affectedRows() (Gets the number of rows affected by the last data manipulation query.) [ Top ]
method connect [line 177]
Connect to a database server and log in as the specified user. use (select) the given db, if any. NOTE I: If we are already connected to somewhere (no matter where), the existing db connection gets closed first. NOTE II: It's possible to get back an exception but the connection was successfull. Probably the given default database could not be selected => BS_DB_ERROR_CANNOT_SELECT_DB Tags:
Parameters:
[ Top ]
method disconnect [line 239]
Log out and disconnect from the database. Tags:
[ Top ]
method escapeString [line 2096]
Escape string for oracle query. Tags:
Overrides Bs_Db::escapeString() (Escape string for the query.) Parameters:
[ Top ]
method fetchRow [line 319]
Fetch a row and return it as vector or hash depending on the fetchMode. Subsequent calls will return the next row in the result set, or NULL if there are no more rows. If fetchMode is BS_DB_FETCHMODE_ASSOC (default), it returns a hash array that corresponds to the fetched row else if it's BS_DB_FETCHMODE_ORDERED returns a vector starting at offset 0. A clean example usage of this method to fetch rows into an array: while ($row = $this->fetchRow($res, $fetchMode)) { if (isEx($row)) { $row->stackTrace('was here: currentFunction()', __FILE__, __LINE__); return $row; } $ret[] = $row; } Tags:
Overrides Bs_Db::fetchRow() (Fetch a row and return it as vector or hash depending on the fetchMode.) Parameters:
[ Top ]
method formatDateForDb [line 2111]
format and return date string in database date format. overwrites parent method. Tags:
Overrides Bs_Db::formatDateForDb() (format and return date string in database date format.) Parameters:
[ Top ]
method formatDatetimeForDb [line 2132]
format and return datetime string in database datetime format. overwrites parent method. Tags:
Overrides Bs_Db::formatDatetimeForDb() (format and return datetime string in database datetime format.) Parameters:
[ Top ]
method formatTimestampForDb [line 2145]
format and return timestamp string in database timestamp format. overwrites parent method. Tags:
Overrides Bs_Db::formatTimestampForDb() (format and return timestamp string in database timestamp format.) Parameters:
[ Top ]
method freeResult [line 448]
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. All associated result memory is automatically freed at the end of the script's execution. Tags:
Overrides Bs_Db::freeResult() (Free the internal resources associated with $result.) Parameters:
[ Top ]
method getTableInfo [line 1609]
Returns a hash holding information about the given db table. The returned hash (for mySQL 3.23.36) returns these 15 keys (values are examples): mysql> show table status like 'test'; +------+--------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+----------------+---------+ | Name | Type | Row_format | Rows | Avg_row_length | Data_length | Max_data_length | Index_length | Data_free | Auto_increment | Create_time | Update_time | Check_time | Create_options | Comment | +------+--------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+----------------+---------+ | test | MyISAM | Dynamic | 4 | 22 | 88 | 4294967295 | 2048 | 0 | 5 | 2001-04-02 09:06:58 | 2001-04-02 09:07:00 | NULL | | | +------+--------+------------+------+----------------+-------------+-----------------+--------------+-----------+----------------+---------------------+---------------------+------------+----------------+---------+ Tags:
Parameters:
[ Top ]
method idWrite [line 2190]
overwrites parent method. needed cause oracle is different than mysql. i don't like it. we need a sequence for this to work. Tags:
Overrides Bs_Db::idWrite() (Issue an insert query on a table with an auto_increment field and return the newly inserted id.) Parameters:
[ Top ]
method insertId [line 434]
Tags:
Overrides Bs_Db::insertId() (Get the id generated from the previous INSERT operation.) [ Top ]
method isReservedWord [line 2279]
Tells if a word is a reserved word for the rdbms. This is a 'shortcut' for => "sql reference" pdf chapter "C Oracle Reserved Words" and is great for something like an autmated system checkup. HINT: Make a type conversion (bool) and check for true or false on the returned value. Tags:
Parameters:
[ Top ]
method isValidName [line 2259]
Tells if a name for a db, table or field is accepted by the rdbms or not. Tags:
Parameters:
[ Top ]
method nativeError [line 2336]
Returns the native error from the previous sql operation or '' (empty string) if no error occured. Tags:
[ Top ]
method nativeErrorCode [line 2309]
Returns the numerical native error code from the previous sql operation or 0 (zero) if no error occured. Tags:
Overrides Bs_Db::nativeErrorCode() (Returns the numerical native error code from the previous DB operation or 0 (zero) if no error occured.) [ Top ]
method nativeErrorMsg [line 2323]
Returns the native error text from the previous sql operation or '' (empty string) if no error occured. HINT: Better use nativeErrorCode() before calling this method, or call nativeError() directly. Tags:
Overrides Bs_Db::nativeErrorMsg() (Returns the native error text from the previous DB operation or '' (empty string) if no error occured.) [ Top ]
method numCols [line 366]
Get the number of columns (fields) from a result set. Tags:
Overrides Bs_Db::numCols() (Get the number of columns (fields) in a result identifier.) Parameters:
[ Top ]
method numRows [line 385]
Get the number of rows from a result set. Tags:
Overrides Bs_Db::numRows() (Get the number of rows from a result identifier.) Parameters:
[ Top ]
method selectDb [line 250]
Select a database. Tags:
Parameters:
[ Top ]
method tableHasTransactions [line 1752]
Tags:
Parameters:
[ Top ]
method _dbErrorToBsError [line 2392]
Maps error codes of the current dbms to bs-dbErrorCodes. Tags:
Parameters:
[ Top ]
Documentation generated on Mon, 29 Dec 2003 21:12:14 +0100 by phpDocumentor 1.2.3 |

