MAXDB_OPTIONS(3) 1 MAXDB_OPTIONS(3)maxdb_options - Set options
Procedural style
SYNOPSIS
bool maxdb_options (resource $link, int $option, mixed $value)
DESCRIPTION
Object oriented style
bool maxdb::options (int $option, mixed $value)
maxdb_options(3) can be used to set extra connect options and affect behavior for a connection.
This function may be called multiple times to set several options.
maxdb_options(3) should be called after maxdb_init(3) and before maxdb_real_connect(3).
The parameter $option is the option that you want to set, the $value is the value for the option. For detailed description of the options
see http://maxdb.sap.com/documentation/ The parameter $option can be one of the following values:
Valid options
+-------------------------+---------------------------------------------------+
| Name | |
| | |
| | Description |
| | |
+-------------------------+---------------------------------------------------+
| | |
| MAXDB_COMPNAME | |
| | |
| | The component name used to initialise the SQLDBC |
| | runtime environment. |
| | |
| | |
| MAXDB_APPLICATION | |
| | |
| | The application to be connected to the database. |
| | |
| | |
| MAXDB_APPVERSION | |
| | |
| | The version of the application. |
| | |
| | |
| MAXDB_SQLMODE | |
| | |
| | The SQL mode. |
| | |
| | |
| MAXDB_UNICODE | |
| | |
| | TRUE, if the connection is an unicode (UCS2) |
| | client or FALSE, if not. |
| | |
| | |
| MAXDB_TIMEOUT | |
| | |
| | The maximum allowed time of inactivity after |
| | which the connection to the database is closed by |
| | the system. |
| | |
| | |
| MAXDB_ISOLATIONLEVEL | |
| | |
| | Specifies whether and how shared locks and |
| | exclusive locks are implicitly requested or |
| | released. |
| | |
| | |
| MAXDB_PACKETCOUNT | |
| | |
| | The number of different request packets used for |
| | the connection. |
| | |
| | |
|MAXDB_STATEMENTCACHESIZE | |
| | |
| | The number of prepared statements to be cached |
| | for the connection for re-use. |
| | |
| | |
| MAXDB_CURSORPREFIX | |
| | |
| | The prefix to use for result tables that are |
| | automatically named. |
| | |
+-------------------------+---------------------------------------------------+
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
See maxdb_real_connect(3).
SEE ALSO maxdb_init(3), maxdb_real_connect(3).
PHP Documentation Group MAXDB_OPTIONS(3)
Check Out this Related Man Page
MAXDB_REAL_CONNECT(3) 1 MAXDB_REAL_CONNECT(3)maxdb_real_connect - Opens a connection to a MaxDB server
Procedural style
SYNOPSIS
bool maxdb_real_connect (resource $link, [string $hostname], [string $username], [string $passwd], [string $dbname], [int $port],
[string $socket])
DESCRIPTION
Object oriented style
bool maxdb::real_connect ([string $hostname], [string $username], [string $passwd], [string $dbname], [int $port], [string $socket])
maxdb_real_connect(3) attempts to establish a connection to a MaxDB database engine running on $hostname.
This function differs from maxdb_connect(3):
omaxdb_real_connect(3) needs a valid resource which has to be created by function maxdb_init(3)
o With function maxdb_options(3) you can set various options for connection.
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
Example #1
Object oriented style
<?php
/* create a connection object which is not connected */
$maxdb = maxdb_init();
/* set connection options */
$maxdb->options(MAXDB_UNICODE, "FALSE");
$maxdb->options(MAXDB_TIMEOUT, 5);
/* connect to server */
$maxdb->real_connect('localhost', 'MONA', 'RED', 'DEMODB');
/* check connection */
if (maxdb_connect_errno()) {
printf("Connect failed: %s
", maxdb_connect_error());
exit();
}
printf ("Connection: %s
.", $maxdb->host_info);
$maxdb->close();
?>
Example #2
Procedural style
<?php
/* create a connection object which is not connected */
$link = maxdb_init();
/* set connection options */
maxdb_options($link, MAXDB_UNICODE, "FALSE");
maxdb_options($link, MAXDB_TIMEOUT, 5);
/* connect to server */
maxdb_real_connect($link, 'localhost', 'MONA', 'RED', 'DEMODB');
/* check connection */
if (maxdb_connect_errno()) {
printf("Connect failed: %s
", maxdb_connect_error());
exit();
}
printf ("Connection: %s
.", maxdb_get_host_info($link));
maxdb_close($link);
?>
The above example will output something similar to:
Connection: localhost <...>
SEE ALSO maxdb_connect(3), maxdb_init(3), maxdb_options(3), maxdb_ssl_set(3), maxdb_close(3).
PHP Documentation Group MAXDB_REAL_CONNECT(3)