VoiceXML Forum Community Message Board


Post New Topic  Post A Reply
my profile | register | search | faq | forum home
  next oldest topic   next newest topic
» VoiceXML Forum Community Message Board   » Newbies   » print content of variable in vxml to a mysql table

 - UBBFriend: Email this page to someone!    
Author Topic: print content of variable in vxml to a mysql table
DD86
Junior Member
Member # 3868

Rate Member
Icon 1 posted October 12, 2006 03:14 PM      Profile for DD86     Send New Private Message       Edit/Delete Post   Reply With Quote 
hi I have the following vxml code, and i want to save the variabl
es job and tid in a table en mysql how do I That?

vxml code:
code:
<?xml version = "1.0" encoding="iso-8859-1"?>

<vxml version="2.0" xml:lang="da">

<var name="job" />
<var name="tid" />


<forrm id="raportvelkomst">
<block>
<prompt>Du har nu mugligheder for at raport terer de timer du har brugt p� en opgave.</prompt>
</block>

<block>
<goto next="#raportjobkode"/>
</block>
</form>


<form id="raportjobkode">
<field name="jobkode">
<prompt>Hvilken jobkode vil du indraport terer?</prompt>
<grammar src="jobkode.grxml" />
<filled>
<assign name="job" expr="jobkode" />
</filled>
<nomatch>
Undskyld, jeg h�rte ikke navnet. Pr�v igen:
<reprompt />
</nomatch>


<noinput> Jeg kan ikke h�re noget, pr�v igen.<reprompt /> </noinput>
</field>


<field name="bekr�ftkontakt">
<prompt timeout="1.5s">
Du valgte f�lgende jobkode: <value expr="jobkode$.utterance" />
</prompt>
<noinput>
<assign name="bekr�ftkontakt" expr="'true'" />
</noinput>
<nomatch>
Jeg beklager.
<clear />
</nomatch>
</field>

<block>
<if cond="job == '20'">
<goto next="#virker" />
</if>

<goto next="#virkerikke"/>
</block>
</form>


<form id="raporttid">
<field name="timer">
<prompt>Si antallet af timer du har brugt p� din opgave</prompt>
<grammar src="tid.grxml" />
<filled>
<assign name="tid" expr="timer" />
</filled>
<nomatch>
Undskyld, jeg h�rte ikke tallet. Pr�v igen:
<reprompt />
</nomatch>


<noinput> Jeg kan ikke h�re noget, pr�v igen.<reprompt /> </noinput>
</field>


<field name="bekr�ftkontakt">
<prompt timeout="1.5s">
Du har nu valgt at raport erer at du brugte <value expr="timer$.utterance" /> timer p� opgaven.
</prompt>
<noinput>
<assign name="bekr�ftkontakt" expr="'true'" />
</noinput>
<nomatch>
Jeg beklager.
<clear />
</nomatch>
</field>

<block>
<prompt>Tak!.</prompt>
<disconnect/>
</block>
</form>

<form id="virker">
<block>
<prompt>Det virker.</prompt>
<disconnect/>
</block>
</form>


<form id="virkerikke">
<block>
<prompt>Det virker ikke en skid.</prompt>
<disconnect/>
</block>
</form>

</vxml>

can i do it whit this script?

<script language="php">

//opretter forbindelse
mysql_connect("localhost", "....", ".....") or die(mysql_error());
mysql_select_db("gruppe3") or die(mysql_error());

//echo "//inds�tter en r�kke af informationer i tabellen rappotere";
mysql_query ("INSERT INTO rapportere
(Jobkode, Timer) VALUES('job', 'tid')")
or die(mysql_error());

</script>


Posts: 1 | From: Denmark | Registered: Oct 2006  |  IP: Logged
mheadd
Member
Member # 3181

Member Rated:
4
Icon 1 posted October 16, 2006 12:02 PM      Profile for mheadd   Author's Homepage   Email mheadd   Send New Private Message       Edit/Delete Post   Reply With Quote 
Take a look at the following threads:

http://www.voicexml.org/cgi-bin/ubb/ultimatebb.cgi?ubb=get_topic;f=3;t=000069

http://www.voicexml.org/cgi-bin/ubb/ultimatebb.cgi?ubb=get_topic;f=3;t=000060

Hope this information is helpful.

--------------------
Mark
VoiceinGov.org
http://www.voiceingov.org

Posts: 55 | Registered: Jun 2005  |  IP: Logged


All times are Eastern  
Post New Topic  Post A Reply Close Topic    Move Topic    Delete Topic next oldest topic   next newest topic
 - Printer-friendly view of this topic
Hop To:

Contact Us | VoiceXML Forum



Powered by Infopop Corporation
UBB.classicTM 6.3.1.2