Russian Ukraine English
Catalog RSS

XLIX. Ovrimos SQL functions

Ovrimos SQL Server, is a client/server, transactional RDBMS combined with Web capabilities and fast transactions.

Ovrimos SQL Server is available at To enable ovrimos support in PHP just compile php with the '--with-ovrimos' parameter to configure script. You'll need to install the sqlcli library available in the Ovrimos SQL Server distribution.

Example 1. Connect to Ovrimos SQL Server and select from a system table

<?php $conn = ovrimos_connect ("", "8001", "admin", "password"); if ($conn != 0) {     echo ("Connection ok!");     $res = ovrimos_exec ($conn, "select table_id, table_name from sys.tables");     if ($res != 0) {         echo "Statement ok!";         ovrimos_result_all ($res);         ovrimos_free_result ($res);     }     ovrimos_close($conn); } ?>      
This will just connect to SQL Server.

Table of Contents
ovrimos_connect — Connect to the specified database
ovrimos_close — Closes the connection to ovrimos
ovrimos_close_all — Closes all the connections to ovrimos
ovrimos_longreadlen — Specifies how many bytes are to be retrieved from long datatypes
ovrimos_prepare — Prepares an SQL statement
ovrimos_execute — Executes a prepared SQL statement
ovrimos_cursor — Returns the name of the cursor
ovrimos_exec — Executes an SQL statement
ovrimos_fetch_into — Fetches a row from the result set
ovrimos_fetch_row — Fetches a row from the result set
ovrimos_result — Retrieves the output column
ovrimos_result_all — Prints the whole result set as an HTML table
ovrimos_num_rows — Returns the number of rows affected by update operations
ovrimos_num_fields — Returns the number of columns
ovrimos_field_name — Returns the output column name
ovrimos_field_type — Returns the (numeric) type of the output column
ovrimos_field_len — Returns the length of the output column
ovrimos_field_num — Returns the (1-based) index of the output column
ovrimos_free_result — Frees the specified result_id
ovrimos_commit — Commits the transaction
ovrimos_rollback — Rolls back the transaction