Adaptive Server Enterprise extension module for PHP in ESD #4

Starting with ESD #4, the Adaptive Server Enterprise extension module for PHP has the full set of APIs for application development:

API type

API

Description

Connections:

sybase_close()

Closes the specified connection to ASE.

sybase_connect()

Opens a connection to ASE.

sybase_pconnect()

(New) Opens a persistent connection to ASE.

Queries:

sybase_affected_rows()

(New) Returns the number of rows affected by the last insert, delete, or update query on the specified connection.

sybase_query()

Sends a query to the specified connection.

The complete result set is automatically fetched and buffered.

sybase_unbuffered_query()

(New) Sends a query to the specified connection.

The complete result set is not automatically fetched and buffered as with sybase_query().

Remote Procedure Calls:

sybase_rpc_bind_param_ex

(New) Binds a PHP variable to a remote procedure parameter.

sybase_rpc_execute

(New) Executes the remote procedure call that was initialized with sybase_rpc_init().

sybase_rpc_init

(New) Returns a statement identifier pointing to the statement initialized for the remote procedure on the connection.

Result sets:

sybase_data_seek()

(New) Moves the internal row pointer on the result set associated with the result identifier to point to the specified row number.

sybase_fetch_array()

(New) Fetch a result row as an associative array, a numeric array, or both.

sybase_fetch_assoc()

Fetches one row of data from the result set associated with the specified result identifier in an associative array.

sybase_fetch_field()

(New) Returns an object containing field information.

sybase_fetch_object()

(New) Fetches one row of data from the result set associated with the specified result identifier as an object.

sybase_fetch_row()

(New) Fetches one row of data from the result set associated with the specified result identifier in a numeric array.

sybase_field_seek()

(New) Sets the internal pointer to the field offset requested.

sybase_free_result()

Frees all memory associated with the result set.

sybase_next_result()

(New) Returns a result set identifier pointing to the next result set on the connection.

sybase_num_fields()

(New) Returns the number of fields in the result set.

sybase_num_rows()

(New) Returns the number of rows in the result set of a select statement.

sybase_use_result

(New) Stores the result set of the last unbuffered query on the connection and returns a result set identifier pointing to this stored result set.

Miscellaneous:

sybase_get_last_message()

(New) Returns the last message returned by the server.

sybase_get_last_status

(New) Returns the last status result that was sent on the connection.

sybase_select_db()

(New) Sets the current active database on the server referred to by the connection resource.

sybase_set_message_handler()

(New) Sets a user-defined callback function that is to be called when a client or server message is received.

See the Adaptive Server Enterprise Extension Module for PHP Programmers Guide.