Ovrimos SQL Functions
Bevezetés
Ovrimos SQL Server, is a client/server, transactional RDBMS combined with Web capabilities and fast transactions.
Note: Ez a kiterjesztés átkerült a » PECL tárba és már nem terjesztik a PHP-vel együtt ettÅ‘l a verziótól kezdve: PHP 4.4.5 and PHP 5.1.0.
Note: Ez a kiterjesztés nem működik Windows operációs rendszereken!
Követelmények
You'll need to install the sqlcli library available in the Ovrimos SQL Server distribution.
TelepÃtés
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.
Futásidejű beállÃtások
Ez a kiterjesztés semmilyen konfigurációs beállÃtásokat nem definiál a php.ini állományban.
ErÅ‘forrás tÃpusok
Példák
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