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);
}
?>
Table of Contents
- 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