Ovrimos SQL Functions
Introduktion
Ovrimos SQL Server, is a client/server, transactional RDBMS combined with Web capabilities and fast transactions.
Note: This extension has been moved to the » PECL repository and is no longer bundled with PHP as of PHP 4.4.5 and PHP 5.1.0.
Note: Denne udvidelse er ikke tilgΓ¦ngelige pΓ₯ Windows platformen.
Systemkrav
You'll need to install the sqlcli library available in the Ovrimos SQL Server distribution.
Installation
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.
Runtime Konfiguration
Denne udvidelse har intet konfigurations-direktiv defineret i php.ini.
Ressourcetyper
Eksempler
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
