PHP Ovrimos SQL Functions

EditRocket provides the following information on Ovrimos SQL functions in the PHP source code builder.

void ovrimos_close ( int $connection ) - Closes the specified connection to Ovrimos. This has the effect of rolling back uncommitted transactions.

bool ovrimos_commit ( int $connection_id ) - Commits the transaction.

int ovrimos_connect ( string $host , string $dborport , string $user , string $password ) - Connects to the specified database.

string ovrimos_cursor ( int $result_id ) - Gets the name of the cursor. Useful when wishing to perform positioned updates or deletes.

int ovrimos_exec ( int $connection_id , string $query ) - Executes an SQL statement (query or update) and returns a result identifier.

bool ovrimos_execute ( int $result_id [, array $parameters_array ] ) - Executes a prepared statement.

bool ovrimos_fetch_into ( int $result_id , array &$result_array [, string $how [, int $rownumber ]] ) - Fetches a row from the given result set, into result_array.

bool ovrimos_fetch_row ( int $result_id [, int $how [, int $row_number ]] ) - Fetches a row from the result set. Column values should be retrieved with other calls.

int ovrimos_field_len ( int $result_id , int $field_number ) - Gets the length of the specified output column.

string ovrimos_field_name ( int $result_id , int $field_number ) - Returns the output column name at the index specified.

int ovrimos_field_num ( int $result_id , string $field_name ) - Returns the 1-based index of the specified output column.

int ovrimos_field_type ( int $result_id , int $field_number ) - Returns the type of the output column

bool ovrimos_free_result ( int $result_id ) - Frees the specified result identifier.

bool ovrimos_longreadlen ( int $result_id , int $length ) - Specifies how many bytes are to be retrieved from long datatypes (long varchar and long varbinary).

int ovrimos_num_fields ( int $result_id ) - Returns the number of columns in the specified result identifier.

int ovrimos_num_rows ( int $result_id ) - Gets the number of rows affected by update operations.

int ovrimos_prepare ( int $connection_id , string $query ) - Prepares an SQL statement.

string ovrimos_result ( int $result_id , mixed $field ) - Retrieves the output column specified by field.

int ovrimos_result_all ( int $result_id [, string $format ] ) - Prints the whole result set as an HTML table.

bool ovrimos_rollback ( int $connection_id ) - Rolls back the transaction.