LXXX. Ovrimos SQL Functions

�vod

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

Pozn�mka: Toto roz��en� nen� k dispozici na platform�ch Windows.

Po�adavky

You'll need to install the sqlcli library available in the Ovrimos SQL Server distribution.

Instalace

To enable Ovrimos support in PHP just compile PHP with the --with-ovrimos[=DIR] parameter to your configure line. DIR is the Ovrimos' libsqlcli install directory.

Konfigurace b�hu

Toto roz��en� nem� definov�no ��dn� konfigura�n� direktivy.

Typy prost�edk�

P��klady

P��klad 1. Connect to Ovrimos SQL Server and select from a system table

<?php $conn = ovrimos_connect("server.domain.com", "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 an Ovrimos SQL server.

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


	downloads \| documentation \| faq \| getting help \| mailing lists \| \| php.net sites \| links \| my php.net

search for in the