PHP-script Hosting
HO-S-30 PHP ODBC Hosting Demo
Use of ODBC from within a PHP script hosted in Virtuoso
PHP script calling ODBC
This demo shows simple ODBC functions being used in a PHP script: odbc_connect(), odbc_exec(), odbc_result_all() and odbc_tables().
The WebCalendar application is an Open-Source implementation of a multi-user web-calendar in PHP, released under the terms of the GPL; the project homepage is hosted on SourceForge.net. We include it here as an example of how to take an existing PHP application designed to run with Apache against mysql, postgresql or ODBC database backends, and host it within Virtuoso.
The default username and password are admin/admin.
The "Set the initial state" SQL files must be executed prior to running the demo. The file create_local_dsn.sql will create a local DSN named "Local Virtuoso Tutorial HO-S-30", which will be used for connecting the database.
For troubleshooting please read the "Environment Setup" section in "Runtime hosting" chapter from documentation.
In order to run this example you need PHP Runtime Hosting Enabled.
| View the source | Action |
|---|---|
| 1. create_local_dsn.sql | Set the initial state |
| 2. ho_s_30.sql | |
| 3. odbc-sample.php | Run |
| 4. webcalendar.php | Run |
OpenLink Home
Technical Support