##### jdbc2http

- Overview
- Connection
- Limitations
- Download

##### Supported Databases

- Overview
- MySQL

##### Server Side Drivers

- Scripts
  - Login - dologin.php
  - Logout - dologout.php
  - Metadata - dodbmeta.php
  - Set Parameters - doparam.php
  - SQL - dosql.php
  - Prepared Statements

##### Project Documentation

- Project Information
- Project Reports

## dologin.php

This script performs a login to the database and stores the connection parameters in the server session. A new server session is created if necessary.

dologin.php processes the following HTTP parameters:

dburl
  the database URL used to connect to the database server from PHP
user
  the database user name.
password
  the password of the database user.

If the login succeeds, the response from dologin.php is an XML document as follows:

    <result>
            <sessionid>session id</sessionid>
            <param name='transaction-isolation'>transaction isolation</param>
            <param name='catalog-term'>catalog term</param>
            <param name='schema-term'>schema term</param>
            ...
            <warning>
                    <reason>error message</reason>
                    <sqlstate>SQL state</sqlstate>
                    <vendor-code>vendor code</vendor-code>
            </warning>
    </result>

In case of an error, the resulting response is:

    <result>
            <error>
                    <reason>error message</reason>
                    <sqlstate>SQL state</sqlstate>
                    <vendor-code>vendor code</vendor-code>
            </error>
    </result>

The following parameters are now deprecated:

host
  the host name of IP address of the database server.
port
  the port the database server is listening to.
database
  the name of the MySQL database.