VoiceXML Database Access
Introduction
One of the primary reasons that developers use server-side programming is to extract information from a database and format it in HTML for viewing in a browser. This article develops an example of this type of program and then modifies it for voice applications. In these examples, we'll demonstrate using both PHP and Java servlets with the Java Database Connectivity (JDBC) API.
Before you can progress with the examples, you need to install a database. For these examples, we'll use MySQL. Additionally, for the Java/JDBC example, you need suitable JDBC drivers. Finally, for the Java servlet environment, you need to configure the tools so that they can work together.
PHP includes support for MySQL, so no configuration changes are needed. After you have completed the Java setup, created some data to test it with, and completed the testing, you'll use the same data to test your PHP/MySQL configuration.