» google_pagerank()
  » preg_replace()
  » imagecreatefrompng()
  » site_pageranks()
  » imagepng()
  » imagedestroy()
  » imagestring()
  » imagecolorallocate()
  » htmlentities()
  » fopen()
  » preg_match()
  » header()
  » getimagesize()
  » htmlspecialchars()
  » ob_start()
  » session_start()
  » strstr()
  » ob_flush()
  » preg_match_all()
  » strpos()
  » setcookie()
  » flush()
  » str_replace()
  » array2vars()
  » nl2br()
  » preg_split()
  » ereg()
  » urlencode()
  » ereg_replace()
  » readgzfile()

Become a sponsor for $15/month. Link is sitewide - PR5 homepage, 20+ PR4 pages, 90+ PR3 pages. Email dave[AT]icemelon[D0T]c0m.

(4.1.0 - 4.2.3 only, PECL)

dbplus_xunlockrel -- Free exclusive lock on relation

Description

int dbplus_xunlockrel ( resource relation )

Warning

This function is EXPERIMENTAL . The behaviour of this function, the name of this function, and anything else documented about this function may change without notice in a future release of PHP. Use this function at your own risk.

dbplus_xunlockrel() will release an exclusive lock on relation previously obtained by dbplus_xlockrel() .

XXV. dbx Functions

Introduction

The dbx module is a database abstraction layer (db 'X', where 'X' is a supported database). The dbx functions allow you to access all supported databases using a single calling convention. The dbx-functions themselves do not interface directly to the databases, but interface to the modules that are used to support these databases.

Requirements

To be able to use a database with the dbx-module, the module must be either linked or loaded into PHP, and the database module must be supported by the dbx-module. Currently, the following databases are supported, but others will follow:

FrontBase (available from PHP 4.1.0).

Microsoft SQL Server

MySQL

ODBC

PostgreSQL

Sybase-CT (available from PHP 4.2.0).

Oracle (oci8) (available from PHP 4.3.0).

SQLite (PHP 5).

Documentation for adding additional database support to dbx can be found at http://www.guidance.nl/php/dbx/doc/ .

Installation

In order to have these functions available, you must compile PHP with dbx support by using the --enable-dbx option and all options for the databases that will be used, e.g. for MySQL you must also specify --with-mysql=[DIR] . To get other supported databases to work with the dbx-module refer to their specific documentation.

Runtime Configuration

The behaviour of these functions is affected by settings in php.ini .

Table 1. DBX Configuration Options

Name Default Changeable Changelog dbx.colnames_case "unchanged" PHP_INI_SYSTEM Available since PHP 4.3.0. For further details and definitions of the PHP_INI_* constants, see the Appendix H .

Here's a short explanation of the configuration directives.

dbx.colnames_case string

Columns names can be returned "unchanged" or converted to "uppercase" or "lowercase". This directive can be overridden with a flag to dbx_query() .

Resource Types

There are two resource types used in the dbx module. The first one is the link- object for a database connection, the second a result- object which holds the result of a query.

Predefined Constants

The constants below are defined by this extension, and will only be available when the extension has either been compiled into PHP or dynamically loaded at runtime.

DBX_MYSQL ( integer )

DBX_ODBC ( integer )

DBX_PGSQL ( integer )

DBX_MSSQL ( integer )

DBX_FBSQL ( integer )

DBX_OCI8 ( integer ) (available from PHP 4.3.0)

DBX_SYBASECT ( integer )

DBX_SQLITE ( integer ) (PHP 5)

DBX_PERSISTENT ( integer )

DBX_RESULT_INFO ( integer )

DBX_RESULT_INDEX ( integer )

DBX_RESULT_ASSOC ( integer )

DBX_RESULT_UNBUFFERED ( integer ) (PHP 5)

DBX_COLNAMES_UNCHANGED ( integer ) (available from PHP 4.3.0)

DBX_COLNAMES_UPPERCASE ( integer ) (available from PHP 4.3.0)

DBX_COLNAMES_LOWERCASE ( integer ) (available from PHP 4.3.0)

DBX_CMP_NATIVE ( integer )

DBX_CMP_TEXT ( integer )

DBX_CMP_NUMBER ( integer )

DBX_CMP_ASC ( integer )

DBX_CMP_DESC ( integer )

Table of Contents dbx_close  -- Close an open connection/database dbx_compare  -- Compare two rows for sorting purposes dbx_connect  -- Open a connection/database dbx_error  --  Report the error message of the latest function call in the module (not just in the connection) dbx_escape_string  --  Escape a string so it can safely be used in an sql-statement dbx_fetch_row  -- Fetches rows from a query-result that had the DBX_RESULT_UNBUFFERED flag set dbx_query  -- Send a query and fetch all results (if any) dbx_sort  --  Sort a result from a dbx_query by a custom sort function

Related Function(s)

dbplus_xlockrel()

dbx_query()

dbx_close()

dbx_compare()

dbx_connect()

dbx_error()

dbx_escape_string()

dbx_fetch_row()

dbx_sort()