SDBC Interface

Interfaces for the 602SQL Server

PHP Module (General Information)

The PHP module for 602SQL is a shared library (php_602sqlXX.dll for Windows, php_602sqlXX.so for Linux) that allows provides access to a 602SQL Server from the PHP language. If you load the library into PHP (see below) you will be able to use the new functions with the wb_ prefix in PHP. See the function list below.

Module Installation

It is assumed that you have 602SQL Server and PHP working on your computer for the required operating system (Linux or Windows)

In order to load the PHP module, do the following:

• Save the compiled module into the directory which PHP loads these files (parameter extension_dir in php.ini). The module must be able to locate the 602SQL Server libraries (add the directory to the PATH)
• Load the module into PHP. This can be done when starting PHP from the php.ini file (extension=php_602sql11), or in the PHP script using dl().

The directory with PHP modules and the directory that contains the php.ini file can be found from the phpinfo() command.

Configuration Parameters in PHP.INI

The following parameters can be set in the PHP.INI file:

• wb_binmode - Mode of reading values from variable-length columns (WB_CONVERT by default, see Converting values from 602SQL into PHP)
• wb_longreadlen - Preset data size that will be read from the variable-length attributes (4096 by default, see Converting values from 602SQL into PHP)
• wb_datestring - Sets the mode of converting PHP variables with DATE, TIME or TIMESTAMP types into SQL statements (0 by default, see the wb_exec function)
• wb_max_links - Maximum number of database connections that can be opened at one time (-1 by default, see the wb_connect function)
• wb_allow_persistent, wb_max_persistent - Parameters that affect persistent database connections (wb_allow_persistent=1 and wb_max_persistent=-1 by default, see the wb_pconnect function)

Example

A part of the PHP.INI file with the php_602sql module configuration parameters:

[602SQL]
wb_longreadlen = 4096
wb_binmode = WB_CONVERT
wb_datestring = 0
wb_max_links = -1
wb_max_persistent = -1
wb_allow_persistent = 1   

Information about the PHP Module Version

Information about the PHP module version is available in the form of 4 integer (INT) constants (PHP_602SQL_VERSION_MAJOR, PHP_602SQL_VERSION_MINOR, PHP_602SQL_VERSION_PATCH and PHP_602SQL_VERSION_PATCH2)

See

• Connect to the database
• Connect to the database using persistent connection
• Disconnect the database, closing a cursor
• Execute SQL statement or query
• Prepare a SQL statement for execution
• Execute the prepared SQL statement
• Get the last SQL server error description
• Quick display of cursor contents
• Reading database record values into an array
• Set the current record
• Reset the internal pointer to the current record
• Read cursor data
• Get cursor information
• Import (upload) data to the database
• Functions for data transfers (in tables, external files or ODBC data sources) to/from the database
• Description of database type transfers to PHP types
• Manipulation of variable-length types

Example

A simple PHP script that works with a database. We assume that the wbserver is accessible and the Anonymous user has sufficient privileges. This script returns the list of 602SQL Server users.

$conn=wb_connect("wbserver", "_sysext", "Anonymous", "");
$res=wb_exec($conn, "select logname from Usertab where Ord(category)=CATEG_USER");
wb_result_all($res);
wb_close($res);
wb_close($conn);

List of topics:

• Passing Values from 602SQL to PHP
• wb_connect
• wb_pconnect
• wb_close
• wb_select_db
• wb_exec
• wb_data_seek
• wb_fetch_into
• wb_fetch_row
• wb_result
• wb_result_all
• wb_import_file
• wb_data_transport
• Information about Cursors
• Manipulating Variable-length Types in PHP
• 'Prepared' SQL Functions
• Auxiliary Functions
• XML Transfer in PHP interface

SDBC Interface

Interfaces for the 602SQL Server