XXVIII_ FrontBase Functions

Introducción

These functions allow you to access FrontBase database servers_ More information about FrontBase can be found at http://www_frontbase_com/_

Documentation for FrontBase can be found at http://www_frontbase_com/cgi_bin/WebObjects/FrontBase_woa/wa/productsPage?currentPage=Documentation_

Frontbase support has been added to PHP 4_0_6_

Requerimientos

You must install the FrontBase database server or at least the fbsql client libraries to use this functions_ You can get FrontBase from http://www_frontbase_com/_

Instalación

In order to have these functions available, you must compile PHP with fbsql support by using the __with_fbsql[=DIR] option_ If you use this option without specifying the path to fbsql, PHP will search for the fbsql client libraries in the default installation location for the platform_ Users who installed FrontBase in a non standard directory should always specify the path to fbsql: __with_fbsql=/path/to/fbsql_ This will force PHP to use the client libraries installed by FrontBase, avoiding any conflicts_

Configuración en tiempo de ejecución

El comportamiento de estas funciones está afectado por los valores definidos en php_ini_

Tabla 1_ FrontBase configuration options

Name	Default	Changeable
fbsql_allow_persistent	"1"	PHP_INI_SYSTEM
fbsql_generate_warnings	"0"	PHP_INI_SYSTEM
fbsql_autocommit	"1"	PHP_INI_SYSTEM
fbsql_max_persistent	"_1"	PHP_INI_SYSTEM
fbsql_max_links	"128"	PHP_INI_SYSTEM
fbsql_max_connections	"128"	PHP_INI_SYSTEM
fbsql_max_results	"128"	PHP_INI_SYSTEM
fbsql_batchSize	"1000"	PHP_INI_SYSTEM
fbsql_default_host	NULL	PHP_INI_SYSTEM
fbsql_default_user	"_SYSTEM"	PHP_INI_SYSTEM
fbsql_default_password	""	PHP_INI_SYSTEM
fbsql_default_database	""	PHP_INI_SYSTEM
fbsql_default_database_password	""	PHP_INI_SYSTEM

For further details and definition of the PHP_INI_* constants see ini_set()_

Tipos de recursos

Constantes predefinidas

Estas constantes están definidas por esta extensión y estarán disponibles solamente cuando la extensión ha sido o bien compilada dentro de PHP o grabada dinámicamente en tiempo de ejecución_

FBSQL_ASSOC (integer)
FBSQL_NUM (integer)
FBSQL_BOTH (integer)
FBSQL_LOCK_DEFERRED (integer)
FBSQL_LOCK_OPTIMISTIC (integer)
FBSQL_LOCK_PESSIMISTIC (integer)
FBSQL_ISO_READ_UNCOMMITTED (integer)
FBSQL_ISO_READ_COMMITTED (integer)
FBSQL_ISO_REPEATABLE_READ (integer)
FBSQL_ISO_SERIALIZABLE (integer)
FBSQL_ISO_VERSIONED (integer)
FBSQL_UNKNOWN (integer)
FBSQL_STOPPED (integer)
FBSQL_STARTING (integer)
FBSQL_RUNNING (integer)
FBSQL_STOPPING (integer)
FBSQL_NOEXEC (integer)
FBSQL_LOB_DIRECT (integer)
FBSQL_LOB_HANDLE (integer)

Tabla de contenidos
fbsql_affected_rows __ Get number of affected rows in previous FrontBase operation
fbsql_autocommit __ Enable or disable autocommit
fbsql_change_user __ Change logged in user of the active connection
fbsql_close __ Close FrontBase connection
fbsql_commit __ Commits a transaction to the database
fbsql_connect __ Open a connection to a FrontBase Server
fbsql_create_blob __ Create a BLOB
fbsql_create_clob __ Create a CLOB
fbsql_create_db __ Create a FrontBase database
fbsql_data_seek __ Move internal result pointer
fbsql_database_password __ Sets or retrieves the password for a FrontBase database
fbsql_database __ Get or set the database name used with a connection
fbsql_db_query __ Send a FrontBase query
fbsql_db_status __ Get the status for a given database
fbsql_drop_db __ Drop (delete) a FrontBase database
fbsql_errno __ Returns the numerical value of the error message from previous FrontBase operation
fbsql_error __ Returns the text of the error message from previous FrontBase operation
fbsql_fetch_array __ Fetch a result row as an associative array, a numeric array, or both
fbsql_fetch_assoc __ Fetch a result row as an associative array
fbsql_fetch_field __ Get column information from a result and return as an object
fbsql_fetch_lengths __ Get the length of each output in a result
fbsql_fetch_object __ Fetch a result row as an object
fbsql_fetch_row __ Get a result row as an enumerated array
fbsql_field_flags __ Get the flags associated with the specified field in a result
fbsql_field_len __ Returns the length of the specified field
fbsql_field_name __ Get the name of the specified field in a result
fbsql_field_seek __ Set result pointer to a specified field offset
fbsql_field_table __ Get name of the table the specified field is in
fbsql_field_type __ Get the type of the specified field in a result
fbsql_free_result __ Free result memory
fbsql_get_autostart_info __ No description given yet
fbsql_hostname __ Get or set the host name used with a connection
fbsql_insert_id __ Get the id generated from the previous INSERT operation
fbsql_list_dbs __ List databases available on a FrontBase server
fbsql_list_fields __ List FrontBase result fields
fbsql_list_tables __ List tables in a FrontBase database
fbsql_next_result __ Move the internal result pointer to the next result
fbsql_num_fields __ Get number of fields in result
fbsql_num_rows __ Get number of rows in result
fbsql_password __ Get or set the user password used with a connection
fbsql_pconnect __ Open a persistent connection to a FrontBase Server
fbsql_query __ Send a FrontBase query
fbsql_read_blob __ Read a BLOB from the database
fbsql_read_clob __ Read a CLOB from the database
fbsql_result __ Get result data
fbsql_rollback __ Rollback a transaction to the database
fbsql_select_db __ Select a FrontBase database
fbsql_set_lob_mode __ Set the LOB retrieve mode for a FrontBase result set
fbsql_set_transaction __ Set the transaction locking and isolation
fbsql_start_db __ Start a database on local or remote server
fbsql_stop_db __ Stop a database on local or remote server
fbsql_tablename __ Get table name of field
fbsql_username __ Get or set the host user used with a connection
fbsql_warnings __ Enable or disable FrontBase warnings