Index of download.marxmeier.com/sqlr/unsupported/php/
Using PHP with SQL/R
--------------------
Revision: 2000-06-28
Prerequisites
-------------
1. You need to install an Apache web server which includes the
PHP module and supports ODBC.
A pre-compiled binary for the Linux and HP-UX platform is
available for download at
ftp://ftp.marxmeier.com/sqlr/unsupported/apache/
2. You may need to install the iODBC driver manager.
A pre-compiled binary for the Linux and HP-UX platform is
available for download at
ftp://ftp.marxmeier.com/sqlr/unsupported/iodbc/
3. You need to install SQL/R A.02.21 or above.
If this system is only acting as an ODBC client (server is
running on a different system) you don't need a license key.
4. In order to use the example, you need to install the
HP Eloquence sample database which is available for download
at ftp://ftp.marxmeier.com/eloq/eloqcgi/
Installation
------------
1. Please unpack the php_sample.tar.gz archive in your htdocs
directory. When unpacked this will create a php_sample directory.
cd /var/opt/apache/htdocs/
tar xzf /tmp/php_sample.tar.gz
2. You need to define your data source (virtual data base) in
the SQL/R configuration file /etc/opt/sqlr2/odbc.dsn as usual.
For the SAMPLE database which could be downloaded at
ftp://ftp.msede.com/eloq/eloqcgi/ the following entry
is sufficient (if the eloqdb6 server is running locally).
--- odbc.dsn ---
[SAMPLE]
Database = sample
--- odbc.dsn ---
3. Next you need to configure your ODBC client. Please edit the
file /etc/opt/iodbc/odbc.ini (on HP-UX) and /etc/odbc.ini
(on Linux) as specified in the installation instructions.
If the SQL/R server is on the local machine, the following
content should be sufficient:
--- odbc.ini / Linux ---
[Default]
Driver = /opt/sqlr2/lib/libc6/libsqlrodbc.so
--- odbc.ini ---
--- odbc.ini / HP-UX ---
[Default]
Driver = /opt/sqlr2/lib/libsqlrodbc.sl
--- odbc.ini ---
4. You may need to change your Apache configuration. Please check
the configuration file /etc/opt/apache/httpd.conf.
If you have a modular Apache web server, the following
directive needs to be enabled:
LoadModule php3_module libexec/libphp3.so
The following directive needs to be enabled to associate the
.php3 files with the PHP module:
AddType application/x-httpd-php3 .php3
Running the example
-------------------
Please open the /php_sample file in your browser.
- Please entry a customer number, such as 32001 in the first field.
The Customer record should become visible after pressing submit.
- Please entry a matchcode, such as KE% in the second field.
A list of matching customers should become visible after pressing
submit.
Please note: The PHP code is kept to some minimum. It is meant as
a simple/stupid example and thats it.
I certainly agree that it is long winded and ugly.
Enjoy!
The SQL/R Team
