[ Index ]
 

Code source de PHP PEAR 1.4.5

Accédez au Source d'autres logiciels libresSoutenez Angelica Josefina !

title

Body

[fermer]

/DB/ -> sybase.php (sommaire)

The PEAR DB driver for PHP's sybase extension for interacting with Sybase databases PHP versions 4 and 5

Author: Sterling Hughes <sterling@php.net>
Author: Antônio Carlos Venâncio Júnior <floripa@php.net>
Author: Daniel Convissor <danielc@php.net>
Copyright: 1997-2005 The PHP Group
License: http://www.php.net/license/3_0.txt PHP License 3.0
Version: CVS: $Id: sybase.php,v 1.85 2007/02/06 07:35:07 aharvey Exp $
Poids: 942 lignes (29 kb)
Inclus ou requis:0 fois
Référencé: 3 fois
Nécessite: 1 fichier
 DB/common.php

Définit 1 class

DB_sybase:: (24 méthodes):
  DB_sybase()
  connect()
  disconnect()
  simpleQuery()
  nextResult()
  fetchInto()
  freeResult()
  numCols()
  numRows()
  affectedRows()
  nextId()
  createSequence()
  dropSequence()
  quoteFloat()
  autoCommit()
  commit()
  rollback()
  sybaseRaiseError()
  errorNative()
  errorCode()
  tableInfo()
  _sybase_field_flags()
  _add_flag()
  getSpecialQuery()


Classe: DB_sybase  - X-Ref

The methods PEAR DB uses to interact with PHP's sybase extension
for interacting with Sybase databases

These methods overload the ones declared in DB_common.

WARNING:  This driver may fail with multiple connections under the
same user/pass/host and different databases.

DB_sybase()   X-Ref
This constructor calls <kbd>$this->DB_common()</kbd>

return: void

connect($dsn, $persistent = false)   X-Ref
Connect to the database server, log in and open the database

Don't call this method directly.  Use DB::connect() instead.

PEAR DB's sybase driver supports the following extra DSN options:
+ appname       The application name to use on this connection.
Available since PEAR DB 1.7.0.
+ charset       The character set to use on this connection.
Available since PEAR DB 1.7.0.

param: array $dsn         the data source name
param: bool  $persistent  should the connection be persistent?
return: int  DB_OK on success. A DB_Error object on failure.

disconnect()   X-Ref
Disconnects from the database server

return: bool  TRUE on success, FALSE on failure

simpleQuery($query)   X-Ref
Sends a query to the database server

param: string  the SQL query string
return: mixed  + a PHP result resrouce for successful SELECT queries

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
Places a row from the result set into the given array

Formating of the array and the data therein are configurable.
See DB_result::fetchInto() for more information.

This method is not meant to be called directly.  Use
DB_result::fetchInto() instead.  It can't be declared "protected"
because DB_result is a separate object.

param: resource $result    the query result resource
param: array    $arr       the referenced array to put the data in
param: int      $fetchmode how the resulting array should be indexed
param: int      $rownum    the row number to fetch (0 = first row)
return: mixed  DB_OK on success, NULL when the end of a result set is

freeResult($result)   X-Ref
Deletes the result set and frees the memory occupied by the result set

This method is not meant to be called directly.  Use
DB_result::free() instead.  It can't be declared "protected"
because DB_result is a separate object.

param: resource $result  PHP's query result resource
return: bool  TRUE on success, FALSE if $result is invalid

numCols($result)   X-Ref
Gets the number of columns in a result set

This method is not meant to be called directly.  Use
DB_result::numCols() instead.  It can't be declared "protected"
because DB_result is a separate object.

param: resource $result  PHP's query result resource
return: int  the number of columns.  A DB_Error object on failure.

numRows($result)   X-Ref
Gets the number of rows in a result set

This method is not meant to be called directly.  Use
DB_result::numRows() instead.  It can't be declared "protected"
because DB_result is a separate object.

param: resource $result  PHP's query result resource
return: int  the number of rows.  A DB_Error object on failure.

affectedRows()   X-Ref
Determines the number of rows affected by a data maniuplation query

0 is returned for queries that don't manipulate data.

return: int  the number of rows.  A DB_Error object on failure.

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.

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 on failure.

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.  A DB_Error object on failure.

quoteFloat($float)   X-Ref
Formats a float value for use within a query in a locale-independent
manner.

param: float the float value to be quoted.
return: string the quoted string.

autoCommit($onoff = false)   X-Ref
Enables or disables automatic commits

param: bool $onoff  true turns it on, false turns it off
return: int  DB_OK on success.  A DB_Error object if the driver

commit()   X-Ref
Commits the current transaction

return: int  DB_OK on success.  A DB_Error object on failure.

rollback()   X-Ref
Reverts the current transaction

return: int  DB_OK on success.  A DB_Error object on failure.

sybaseRaiseError($errno = null)   X-Ref
Produces a DB_Error object regarding the current problem

param: int $errno  if the error is being manually raised pass a
return: object  the DB_Error object

errorNative()   X-Ref
Gets the DBMS' native error message produced by the last query

return: string  the DBMS' error message

errorCode($errormsg)   X-Ref
Determines 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

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   the table name
param: string  $column  the 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
return: void

getSpecialQuery($type)   X-Ref
Obtains the query string needed for listing a given type of objects

param: string $type  the kind of objects you want to retrieve
return: string  the SQL query string or null if the driver doesn't



Généré le : Sun Feb 25 14:08:00 2007 par Balluche grâce à PHPXref 0.7