CV. Ovrimos SQL Functions

簡介

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

注: 本增加已被搬移到 PECL 庫中且自以下版本起不再被綁定到 PHP 中:5.1.0.

注: 本增加模組在 Windows 平台下不可用。

需求

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

安裝

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.

運行時配置

本增加模組在 php.ini 中未定義任何配置選項。

範例

例子 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.

目錄
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