PHP VoiceXML Magazine: Dynamic VoiceXML and PHP in entreprise

Published on 2005-08-15 10:28:03

Part 2 Coding : Service's content
In this example we separated content in a table named "content", So the second part of our entreprise VoiceXML application will connect to the database, retrieve the content of the service and read them to the enduser, then go back to the main menu to choose another service ... etc

/**

* PHP Voice entreprise : Services listing

* @author Ben Yacoub Hatem <hatem>

* @version $Id: 1.0 Thu Nov 18 05:51:08 CET 2004 05:51:08 by hatem EXP

require_once("config.php");

require_once("../phpvoice/vxml.class.php");

// Check for valid category

$cat = mysql_escape_string($_GET['cat']);

if (trim($cat)!="") {

$link = @mysql_connect($host, $user, $pass) or die("Could not connect");

@mysql_select_db($db) or die("Could not select database");

$query_cat = "SELECT name FROM $category_tbl where id='$cat'"

$result = @mysql_query($query_cat) or die("Query failed");

$num = @mysql_num_rows($result);

if ($num == 1) {

$line = @mysql_fetch_array($result, MYSQL_ASSOC);

$cat_name = $line['name'];

} else exit;

} else {

exit;

}

// read news from db

$query = "SELECT content FROM $news_tbl where service='$cat' order by adddate DESC LIMIT 0,$number_of_news"; // MySQL Query

$result = @mysql_query($query) or die("Query failed");

$num = @mysql_num_rows($result);

if ($numstart_vxml("", "", "en", "", "", "2.0");

$app->start_catch("connection.disconnect"); $app->start_exit_c(); $app-

>end_catch();

$app->load("message",array("","Welcome to $cat_name,

$CompanyName","#choix"));

// Creation du menu

$app->start_menu("choix");

$app->start_prompt();

$app->write("Please press numbers from 1 to

$number_of_news to read informations. Use * to go to main menu.");

$app->end_prompt();

for ($i=1;$istart_choice_c($i,$i,"","#$i" );

}

$app->start_choice_c("*","*","","#*" );

$app->load("nomatch",array("Sorry, your entry isn't valid.","en-

US"));

$app->load("noinput",array("Sorry, I didn't receive any

entry.","en-US"));

$app->end_menu();

// Read content from MySQL Database

$i = 1;

while ($line = @mysql_fetch_array($result, MYSQL_ASSOC)) {

foreach ($line as $content) {

$app->load("message",

array($i,utf8_encode(strip_tags($content)),"#choix","news$i.wav"));

$i++;

}

mysql_free_result($result);

mysql_close($link);

// End MySQL

// back to the main application if * is called.

$app->load("message", array("*","$CompanyName Thank you. We're going back to the main menu.","index.php"));

$app->end_vxml();

$app->generate();

The service part is the more easy one as you can notice. We have a category of content, that we'll browse. We just verify that this category exist and have content, Then a multi choice menu via voice to allow choose which content to read.

We have just taken an example of menu that accept dtmf entry from user to naviguate. I have just use it to show more VoiceXML possibilities.

In the end of the application we notice the asterisk * that will allow us to switch to the main application.

Conclusion :
The main code of the application is over here, in the next articles I'll try to discuss optimization of the applications, administration and possible extended usage of this small code. Something to make the IVR application more easy to use for the endusers.

Related Entries