Ovrimos SQL Functions

简介

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

Note: 本扩展已被移动到 » PECL 库中且自以下版本起不再被绑定到 PHP 中：4.4.5 and PHP 5.1.0.

Note: 本扩展模块在 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 中未定义任何配置选项。

资源类型

范例

Example#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 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

Ovrimos SQL Functions

简介

需求

安装

运行时配置

资源类型

范例

Table of Contents