PHP ʖ²ἯTH
º/A
LXXIV. Ovrimos SQL functions
½鉜
Ovrimos SQL Server, is a client/server, transactional RDBMS combined with Web capabilities and fast transactions.
ע: ¸À©չģ¿鲻ʊӃӚ Windows ƽ̨£¡
Шdz
Ovrimos SQL Server is available at http://www.ovrimos.com/. 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.
ԋАʱŤփ
¸À©չģ¿鎴¶¨ҥȎºΉ薃ָn¡£
Դ Ѝ
·¶=
=ד 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);}?
Ŀ¼ 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
º/A
ưµ㼯A
Ora_Rollback
ɏһ¼¶
ovrimos_close