PhpRiot
Become Zend Certified

Prepare for the ZCE exam using our quizzes (web or iPad/iPhone). More info...


When you're ready get 7.5% off your exam voucher using voucher CJQNOV23 at the Zend Store

IBM DB2 Functions

Table of Contents

  • db2_autocommit - Returns or sets the AUTOCOMMIT state for a database connection
  • db2_bind_param - Binds a PHP variable to an SQL statement parameter
  • db2_client_info - Returns an object with properties that describe the DB2 database client
  • db2_close - Closes a database connection
  • db2_column_privileges - Returns a result set listing the columns and associated privileges for a table
  • db2_columns - Returns a result set listing the columns and associated metadata for a table
  • db2_commit - Commits a transaction
  • db2_conn_error - Returns a string containing the SQLSTATE returned by the last connection attempt
  • db2_conn_errormsg - Returns the last connection error message and SQLCODE value
  • db2_connect - Returns a connection to a database
  • db2_cursor_type - Returns the cursor type used by a statement resource
  • db2_escape_string - Used to escape certain characters
  • db2_exec - Executes an SQL statement directly
  • db2_execute - Executes a prepared SQL statement
  • db2_fetch_array - Returns an array, indexed by column position, representing a row in a result set
  • db2_fetch_assoc - Returns an array, indexed by column name, representing a row in a result set
  • db2_fetch_both - Returns an array, indexed by both column name and position, representing a row in a result set
  • db2_fetch_object - Returns an object with properties representing columns in the fetched row
  • db2_fetch_row - Sets the result set pointer to the next row or requested row
  • db2_field_display_size - Returns the maximum number of bytes required to display a column
  • db2_field_name - Returns the name of the column in the result set
  • db2_field_num - Returns the position of the named column in a result set
  • db2_field_precision - Returns the precision of the indicated column in a result set
  • db2_field_scale - Returns the scale of the indicated column in a result set
  • db2_field_type - Returns the data type of the indicated column in a result set
  • db2_field_width - Returns the width of the current value of the indicated column in a result set
  • db2_foreign_keys - Returns a result set listing the foreign keys for a table
  • db2_free_result - Frees resources associated with a result set
  • db2_free_stmt - Frees resources associated with the indicated statement resource
  • db2_get_option - Retrieves an option value for a statement resource or a connection resource
  • db2_last_insert_id - Returns the auto generated ID of the last insert query that successfully executed on this connection
  • db2_lob_read - Gets a user defined size of LOB files with each invocation
  • db2_next_result - Requests the next result set from a stored procedure
  • db2_num_fields - Returns the number of fields contained in a result set
  • db2_num_rows - Returns the number of rows affected by an SQL statement
  • db2_pclose - Closes a persistent database connection
  • db2_pconnect - Returns a persistent connection to a database
  • db2_prepare - Prepares an SQL statement to be executed
  • db2_primary_keys - Returns a result set listing primary keys for a table
  • db2_procedure_columns - Returns a result set listing stored procedure parameters
  • db2_procedures - Returns a result set listing the stored procedures registered in a database
  • db2_result - Returns a single column from a row in the result set
  • db2_rollback - Rolls back a transaction
  • db2_server_info - Returns an object with properties that describe the DB2 database server
  • db2_set_option - Set options for connection or statement resources
  • db2_special_columns - Returns a result set listing the unique row identifier columns for a table
  • db2_statistics - Returns a result set listing the index and statistics for a table
  • db2_stmt_error - Returns a string containing the SQLSTATE returned by an SQL statement
  • db2_stmt_errormsg - Returns a string containing the last SQL statement error message
  • db2_table_privileges - Returns a result set listing the tables and associated privileges in a database
  • db2_tables - Returns a result set listing the tables and associated metadata in a database

PHP Manual