| [ Index ] |
|
Code source de SPIP Agora 1.4 |
[Code source] [Imprimer] [Statistiques]
(pas de description)
| Poids: | 835 lignes (26 kb) |
| Inclus ou requis: | 0 fois |
| Référencé: | 0 fois |
| Nécessite: | 0 fichiers |
DB_sybase:: (24 méthodes):
DB_sybase()
connect()
disconnect()
errorNative()
errorCode()
sybaseRaiseError()
simpleQuery()
nextResult()
fetchInto()
freeResult()
numCols()
numRows()
affectedRows()
nextId()
createSequence()
dropSequence()
getSpecialQuery()
autoCommit()
commit()
rollback()
tableInfo()
_sybase_field_flags()
_add_flag()
quoteIdentifier()
| DB_sybase() X-Ref |
| DB_sybase constructor. |
| connect($dsninfo, $persistent = false) X-Ref |
| Connect to a database and log in as the specified user. param: $dsn the data source name (see DB::parseDSN for syntax) param: $persistent (optional) whether the connection should return: int DB_OK on success, a DB error on failure |
| disconnect() X-Ref |
| Log out and disconnect from the database. return: bool true on success, false if not connected. |
| errorNative() X-Ref |
| Get the last server error messge (if any) return: string sybase last error message |
| errorCode($errormsg) X-Ref |
| Determine PEAR::DB error code from the database's text error message. param: string $errormsg error message returned from the database return: integer an error number from a DB error constant |
| sybaseRaiseError($errno = null) X-Ref |
| Gather information about an error, then use that info to create a DB error object and finally return that object. param: integer $errno PEAR error number (usually a DB constant) if return: object DB error object |
| simpleQuery($query) X-Ref |
| Send a query to Sybase and return the results as a Sybase resource identifier. param: the SQL query return: mixed returns a valid Sybase result for successful SELECT |
| nextResult($result) X-Ref |
| Move the internal sybase result pointer to the next available result param: a valid sybase result resource return: true if a result is available otherwise return false |
| fetchInto($result, &$arr, $fetchmode, $rownum=null) X-Ref |
| Fetch a row and insert the data into an existing array. Formating of the array and the data therein are configurable. See DB_result::fetchInto() for more information. param: resource $result query result identifier param: array $arr (reference) array where data from the row param: int $fetchmode how the resulting array should be indexed param: int $rownum the row number to fetch return: mixed DB_OK on success, null when end of result set is |
| freeResult($result) X-Ref |
| Free the internal resources associated with $result. param: $result Sybase result identifier return: bool true on success, false if $result is invalid |
| numCols($result) X-Ref |
| Get the number of columns in a result set. param: $result Sybase result identifier return: int the number of columns per row in $result |
| numRows($result) X-Ref |
| Get the number of rows in a result set. param: $result Sybase result identifier return: int the number of rows in $result |
| affectedRows() X-Ref |
| Gets the number of rows affected by the data manipulation query. For other queries, this function returns 0. return: number of rows affected by the last query |
| nextId($seq_name, $ondemand = true) X-Ref |
| Returns the next free id in a sequence param: string $seq_name name of the sequence param: boolean $ondemand when true, the seqence is automatically return: int the next id number in the sequence. DB_Error if problem. |
| createSequence($seq_name) X-Ref |
| Creates a new sequence param: string $seq_name name of the new sequence return: int DB_OK on success. A DB_Error object is returned if |
| dropSequence($seq_name) X-Ref |
| Deletes a sequence param: string $seq_name name of the sequence to be deleted return: int DB_OK on success. DB_Error if problems. |
| getSpecialQuery($type) X-Ref |
| Returns the query needed to get some backend info param: string $type What kind of info you want to retrieve return: string The SQL query string |
| autoCommit($onoff = false) X-Ref |
| Enable/disable automatic commits |
| commit() X-Ref |
| Commit the current transaction. |
| rollback() X-Ref |
| Roll back (undo) the current transaction. |
| tableInfo($result, $mode = null) X-Ref |
| Returns information about a table or a result set. NOTE: only supports 'table' and 'flags' if <var>$result</var> is a table name. param: object|string $result DB_result object from a query or a param: int $mode a valid tableInfo mode return: array an associative array with the information requested |
| _sybase_field_flags($table, $column) X-Ref |
| Get the flags for a field. Currently supports: + <samp>unique_key</samp> (unique index, unique check or primary_key) + <samp>multiple_key</samp> (multi-key index) param: string $table table name param: string $column field name return: string space delimited string of flags. Empty string if none. |
| _add_flag(&$array, $value) X-Ref |
| Adds a string to the flags array if the flag is not yet in there - if there is no flag present the array is created. param: array $array reference of flags array to add a value to param: mixed $value value to add to the flag array |
| quoteIdentifier($str) X-Ref |
| Quote a string so it can be safely used as a table / column name Quoting style depends on which database driver is being used. param: string $str identifier name to be quoted return: string quoted identifier string |
| Généré le : Sat Feb 24 14:40:03 2007 | par Balluche grâce à PHPXref 0.7 |