<?php
/*
* @description PHP script that read summary news from your website database
* and return it as a vxml application
*
* A sample usage of php/mysql in vxml application
*
* sample Mysql Table
create table news (
id int(4) NOT NULL auto_increment,
summary tinytext NOT NULL,
PRIMARY KEY (news_id)
) TYPE=MyISAM;
* @Author Ben Yacoub Hatem [email protected]
* @version 1.0.0
* @date 04-12-2002
)
*/
// Config
$host = ""; // MySQL host
$user = ""; // User login
$pass = ""; // User passwd
$db = ""; // News database
$query = "SELECT summary FROM news order by id DESC LIMIT 0,3"; // MySQL Query
// End config
include ("vxml.class.php");
$vxml_object=new voicexml;
$vxml_object->_encoding = "windows-1256";
$vxml_object->start_vxml_header($lang="en");
$vxml_object->vxml_start_property("caching","safe");
$vxml_object->vxml_start_property("maintainer","[email protected]" );
// Creation du menu
$vxml_object->vxml_start_menu("choix");
$vxml_object->vxml_start_prompt();
$vxml_object->vxml_audio("Welcome to dynamix news, please say : one, two or three to read news.");
$vxml_object->vxml_choice("#1","one" );
$vxml_object->vxml_choice("#2","two" );
$vxml_object->vxml_choice("#3","three" );
// I'm not sure if <default> is vxml 2.0 standard so i'm using addtext()
$vxml_object->addtext("<default><reprompt/></default>");
$vxml_object->end_vxml_prompt();
$vxml_object->end_vxml_menu();
// Read news from MySQL Database
/* Connecting, selecting database */
$link = @mysql_connect($host, $user, $pass)
or die("Could not connect");
@mysql_select_db($db) or die("Could not select database");
/* Performing SQL query */
$result = @mysql_query($query) or die("Query failed");
$i = 1;
while ($line = @mysql_fetch_array($result, MYSQL_ASSOC)) {
foreach ($line as $summary) {
$text = strip_tags($summary);
// VXML code
$vxml_object->vxml_start_form($i);
$vxml_object->vxml_start_block();
$vxml_object->vxml_audio($summary);
$vxml_object->vxml_start_goto("_home");
$vxml_object->end_vxml_block();
$vxml_object->end_vxml_form();
// End VXML code
$i++;
}
}
/* Free resultset */
mysql_free_result($result);
/* Closing connection */
mysql_close($link);
// End MySQL
$vxml_object->end_vxml();
$vxml_object->generate();
?>
|
Download
