I'm having some trouble getting my php code to work properly. I'm submitting three different variables from a vxml form to my php. I then need the php to deposit the variables into files and update a mysql database accordingly, but it's not quite doing what I want it to.
The code is run from a webserver via an AIX server.
Here's my php code that I got so far:
Expand|Select|Wrap|Line Numbers
- <?php
- header('Content-type: application:voicexml+xml; charset=iso-8859-1');
- header('Content-Encoding: iso-8859-1');
- echo "<?xml version=\"1.0\" encoding=\"iso-8859-1\"?>\n";
- echo "<vxml version=\"2.1\" xmlns=\"http://www.w3.org/2001/vxml\" xml:lang=\"en-GB\">";
- echo "<property name=\"inputmodes\" value=\"dtmf\"/>";
- echo "<form>";
- echo "<block>";
- $msg = "";
- $msg2 = "";
- $code = 1;
- $wavName = "";
- $wavAudition = "";
- $number = "";
- $tmpFile=$HTTP_POST_FILES['rec_name']['tmp_name'];
- if (is_uploaded_file($tmpFile)) {
- $wavName="/name/".date("YmdHis").".wav";
- copy($tmpFile, sprintf("%s", $wavName));
- $msg = "audio saved";
- echo "saved name";
- } else {
- $code = 0;
- $msg = "unable to save audio";
- echo "not saved";
- }
- $tmpFile=$HTTP_POST_FILES['rec_audition']['tmp_name'];
- if (is_uploaded_file($tmpFile)) {
- $wavAudition = "audition/".date("YmdHis").".wav";
- copy($tmpFile, sprintf("%s", $wavAudition));
- $msg2 = "audio saved";
- echo "saved audition";
- } else {
- $code = 0;
- $msg2 = "unable to save audio";
- echo "not saved";
- }
- $tmpFile = $HTTP_POST_FILES['contact_number']['tmp_name'];
- if (is_uploaded_file($tmpFile)) {
- copy($tmpFile, sprintf("%s", $number);
- }
- $con = mysql_connect("localhost","username","password");
- if (!$con) {
- die('Could not connect: ' . mysql_error());
- }
- mysql_select_db("Database Name", $con);
- $callDate = date("Ymd");
- $callTime = date("His");
- $sql="INSERT INTO table (calContactDir, calContactNum, calAuditionDir, calDate, calTime)
- VALUES
- ('$wavName','$number','$wavAudition', '$callDate', '$callTime')";
- if (!mysql_query($sql,$con)) {
- die('Error: ' . mysql_error());
- }
- $sql="SELECT calUniqueID FROM Caller WHERE calContactDir = '$wavName'";
- $uniqueID = mysql_query($sql,$con);
- mysql_close($con);
- echo "<audio src=\"file:///170.wav\" maxage=\"0\"/>";
- echo "<prompt>$callDate</prompt>";
- echo "<audio src=\"file:///171.wav\" maxage=\"0\"/>";
- echo "<prompt>$uniqueID</prompt>";
- echo "<goto next=\"file:///Audition_test.vxml#closing\"/>";
- echo "</block>";
- echo "</form>";
- echo "</vxml>";
- ?>
Expand|Select|Wrap|Line Numbers
- <submit next="submit.php" namelist="rec_name contact_number rec_audition" method="POST" enctype="multipart/form-data"/>
The parts of the code that are in italics are sections that I have removed as I'm under a Non Disclosure Agreement concerning the application and I don't want to place our database details, etc. out in the open (hope no one minds).
If anyone could help me out that would be greatly appreciated.