Введение

The MaxDB PHP extension allows you to access the functionality provided by MaxDB 7.5.0 and above. More information about the MaxDB Database server can be found at http://www.mysql.com/products/maxdb/.

The MaxDB PHP extension is compatible to the MySQL mysqli extension. There are only minor differences in the behaviour of some functions due to the differences of the underlying database servers, MaxDB and MySQL.

The main differences to mysqli are in the following functions:

Documentation for MaxDB can be found at http://dev.mysql.com/doc/maxdb/.

Требования

In order to have these functions available, you must compile PHP with MaxDB support. Additionally, you must have the MaxDB SQLDBC runtime library available to access the MaxDB server.

Documentation for MaxDB SQLDBC can be found at http://dev.mysql.com/doc/maxdb/.

Download the MaxDB SQLDBC package from http://dev.mysql.com/downloads/maxdb/clients.html.

Установка

By using the --with-maxdb[=DIR] configuration option you enable PHP to access MaxDB databases. [DIR] points to the directory that contains the installed MaxDB SQLDBC package.

Windows users will need to enable php_maxdb.dll inside of php.ini.

Настройка во время выполнения

Поведение этих функций зависит от установок в php.ini.

Краткое разъяснение конфигурационных директив.

Предопределенные классы

Предопределенные константы

Перечисленные ниже константы определены данным расширением и могут быть доступны только в том случае, если PHP был собран с поддержкой этого расширения или же в том случае, если данное расширение подгружается во время выполнения.

The following constants to use with maxdb_options() are defined. For further description of these constants see http://dev.mysql.com/doc/maxdb/.

The function maxdb_fetch_array() uses a constant for the different types of result arrays. The following constants are defined:

Примеры

All examples in the MaxDB PHP documentation use the HOTELDB demo database from MaxDB. More about this database can be found at http://dev.mysql.com/doc/maxdb/en/98/11b83fa6b33c17e10000000a114084/frameset.htm.

To use the examples in the MaxDB PHP documentation, you have to load the tutorial data into your database. Then you have to set maxdb.default_db in php.ini to the database that contains the tutorial data.

This simple example shows how to connect, execute a query, print resulting rows and disconnect from a MaxDB database.

Пример 1. MaxDB extension overview example <?php $link = maxdb_connect("localhost", "MONA", "RED", "DEMODB");     /* check connection */ if (maxdb_connect_errno()) {    printf("Connect failed: %s\n", maxdb_connect_error());    exit(); } /* Performing SQL query */ $query = "SELECT * FROM hotel.city"; $result = maxdb_query($link, $query) or die("Query failed : " . maxdb_error()); /* Printing results in HTML */ echo "<table>\n"; while ($line = maxdb_fetch_array($result, MAXDB_ASSOC)) {     echo "  <tr>\n";     foreach ($line as $col_value) {         echo "    <td>$col_value</td>\n";     }     echo "  </tr>\n"; } echo "</table>\n"; /* Free resultset */ maxdb_free_result($result); /* Closing connection */ maxdb_close($link); ?>

The following example shows how to bind variables to a SELECT INTO statement.

Пример 2. Example for use of SELECT INTO statements <?php $link = maxdb_connect("localhost", "MONA", "RED", "DEMODB"); /* check connection */ if (!$link) {    printf("Connect failed: %s\n", maxdb_connect_error());    exit(); }     /* Performing SQL query */ $stmt = maxdb_prepare ($link, "SELECT percentage INTO ? FROM hotel.countrylanguage where language = ?"); if (!$stmt) {   printf ("Prepare failed: %s\n", maxdb_error($link)); } $name = "Mbundu"; maxdb_stmt_bind_param($stmt, 'ds', $percentage, $name); maxdb_stmt_execute($stmt); printf ("%f\n", $percentage); maxdb_stmt_close ($stmt); ?>

The following example shows how to use MaxDB database procedures.

Пример 3. Example fore using database procedures <?php $link = maxdb_connect("localhost", "MONA", "RED", "DEMODB"); /* check connection */ if (!$link) {    printf("Connect failed: %s\n", maxdb_connect_error());    exit(); } maxdb_report (MAXDB_REPORT_OFF); maxdb_query($link,"DROP DBPROC test_proc"); maxdb_report (MAXDB_REPORT_ERROR); $query = "create dbproc test_proc (INOUT e_text char(72)) AS select * from SYSDBA.DUAL; fetch into :e_text;"; maxdb_query($link, $query); /* Performing SQL query */ $stmt = maxdb_prepare ($link, "CALL test_proc (?)"); if (!$stmt) {   printf ("Prepare failed: %s\n", maxdb_error($link)); } maxdb_stmt_bind_param($stmt, 's', $result); maxdb_stmt_execute($stmt); printf ("%s\n", $result); maxdb_stmt_close ($stmt); ?>