PHP FrontBase Functions
EditRocket provides the following information on FrontBase functions in the PHP source code builder.
int fbsql_affected_rows ([ resource $link_identifier ] ) - fbsql_affected_rows() returns the number of rows affected by the last INSERT, UPDATE or DELETE query associated with link_identifier.
bool fbsql_autocommit ( resource $link_identifier [, bool $OnOff ] ) - Returns the current autocommit status.
int fbsql_blob_size ( string $blob_handle [, resource $link_identifier ] ) - Returns the size of the given BLOB.
bool fbsql_change_user ( string $user , string $password [, string $database [, resource $link_identifier ]] ) - fbsql_change_user() changes the logged in user of the specified connection. If the new user and password authorization fails, the current connected user stays active.
int fbsql_clob_size ( string $clob_handle [, resource $link_identifier ] ) - Returns the size of the given CLOB.
bool fbsql_close ([ resource $link_identifier ] ) - Closes the connection to the FrontBase server that's associated with the specified link identifier.
bool fbsql_commit ([ resource $link_identifier ] ) - Ends the current transaction by writing all inserts, updates and deletes to the disk and unlocking all row and table locks held by the transaction. This command is only needed if autocommit is set to false.
resource fbsql_connect ([ string $hostname [, string $username [, string $password ]]] ) - fbsql_connect() establishes a connection to a FrontBase server.
string fbsql_create_blob ( string $blob_data [, resource $link_identifier ] ) - Creates a BLOB from the given data.
string fbsql_create_clob ( string $clob_data [, resource $link_identifier ] ) - Creates a CLOB from the given data.
bool fbsql_create_db ( string $database_name [, resource $link_identifier [, string $database_options ]] ) - Attempts to create a new database on the specied server.
bool fbsql_data_seek ( resource $result , int $row_number ) - Moves the internal row pointer of the FrontBase result associated with the specified result identifier to point to the specified row number.
string fbsql_database ( resource $link_identifier [, string $database ] ) - Get or set the database name used with the connection.
string fbsql_database_password ( resource $link_identifier [, string $database_password ] ) - Sets and retrieves the database password used by the connection.
resource fbsql_db_query ( string $database , string $query [, resource $link_identifier ] ) - Selects a database and executes a query on it.
int fbsql_db_status ( string $database_name [, resource $link_identifier ] ) - Gets the current status of the specified database.
bool fbsql_drop_db ( string $database_name [, resource $link_identifier ] ) - fbsql_drop_db() attempts to drop (remove) an entire database from the server associated with the specified link identifier.
int fbsql_errno ([ resource $link_identifier ] ) - Returns the numerical value of the error message from previous FrontBase operation.
string fbsql_error ([ resource $link_identifier ] ) - Returns the error message from previous FrontBase operation.
array fbsql_fetch_array ( resource $result [, int $result_type ] ) -
array fbsql_fetch_assoc ( resource $result ) -
object fbsql_fetch_field ( resource $result [, int $field_offset ] ) - Used in order to obtain information about fields in a certain query result.
array fbsql_fetch_lengths ( resource $result ) -
object fbsql_fetch_object ( resource $result ) -
array fbsql_fetch_row ( resource $result ) - fbsql_fetch_row() fetches one row of data from the result associated with the specified result identifier.
string fbsql_field_flags ( resource $result [, int $field_offset ] ) - Gets the flags associated with the specified field in a result.
int fbsql_field_len ( resource $result [, int $field_offset ] ) - Returns the length of the specified field.
string fbsql_field_name ( resource $result [, int $field_index ] ) - Returns the name of the specified field index.
bool fbsql_field_seek ( resource $result [, int $field_offset ] ) - Seeks to the specified field offset.
string fbsql_field_table ( resource $result [, int $field_offset ] ) - Returns the name of the table that the specified field is in.
string fbsql_field_type ( resource $result [, int $field_offset ] ) -
bool fbsql_free_result ( resource $result ) - Frees all memory associated with the given result identifier.
array fbsql_get_autostart_info ([ resource $link_identifier ] ) -
string fbsql_hostname ( resource $link_identifier [, string $host_name ] ) - Gets or sets the host name used with a connection.
int fbsql_insert_id ([ resource $link_identifier ] ) - Gets the id generated from the previous INSERT operation which created a DEFAULT UNIQUE value.
resource fbsql_list_dbs ([ resource $link_identifier ] ) - Return a result pointer containing the databases available from the current fbsql daemon.
resource fbsql_list_fields ( string $database_name , string $table_name [, resource $link_identifier ] ) - Retrieves information about the given table.
resource fbsql_list_tables ( string $database [, resource $link_identifier ] ) - Returns a result pointer describing the database.
bool fbsql_next_result ( resource $result ) - When sending more than one SQL statement to the server or executing a stored procedure with multiple results will cause the server to return multiple result sets. This function will test for additional results available form the server. If an additional result set exists it will free the existing result set and prepare to fetch the words from the new result set.
int fbsql_num_fields ( resource $result ) - Returns the number of fields in the given result set.
int fbsql_num_rows ( resource $result ) - Gets the number of rows in the given result set.
string fbsql_password ( resource $link_identifier [, string $password ] ) - Get or set the user password used with a connection.
resource fbsql_pconnect ([ string $hostname [, string $username [, string $password ]]] ) - Establishes a persistent connection to a FrontBase server.
resource fbsql_query ( string $query [, resource $link_identifier [, int $batch_size ]] ) - Sends a query to the currently active database on the server.
string fbsql_read_blob ( string $blob_handle [, resource $link_identifier ] ) - Reads BLOB data from the database.
string fbsql_read_clob ( string $clob_handle [, resource $link_identifier ] ) - Reads CLOB data from the database.
mixed fbsql_result ( resource $result [, int $row [, mixed $field ]] ) - Returns the contents of one cell from a FrontBase result set.
bool fbsql_rollback ([ resource $link_identifier ] ) - Ends the current transaction by rolling back all statements issued since last commit.
int fbsql_rows_fetched ( resource $result ) - Gets the number of rows affected by the last statement.
bool fbsql_select_db ([ string $database_name [, resource $link_identifier ]] ) - Sets the current active database on the given link identifier.
void fbsql_set_characterset ( resource $link_identifier , int $characterset [, int $in_out_both ] ) -
bool fbsql_set_lob_mode ( resource $result , int $lob_mode ) - Sets the mode for retrieving LOB data from the database.
bool fbsql_set_password ( resource $link_identifier , string $user , string $password , string $old_password ) - Changes the password for the given user.
void fbsql_set_transaction ( resource $link_identifier , int $locking , int $isolation ) - Sets the transaction locking and isolation.
bool fbsql_start_db ( string $database_name [, resource $link_identifier [, string $database_options ]] ) - Start a database on local or remote server.
bool fbsql_stop_db ( string $database_name [, resource $link_identifier ] ) - Stops a database on local or remote server.
string fbsql_table_name ( resource $result , int $index ) - fbsql_table_name() gets the name of the current table in the given result set.
-
string fbsql_username ( resource $link_identifier [, string $username ] ) - Get or set the username used for the connection.
bool fbsql_warnings ([ bool $OnOff ] ) - Enables or disables FrontBase warnings.
