I have a form that on submit I would like to have an email sent and a query of the database done which would display this record as well as all the other records in the database.
When I include the onsubmit code nothing gets saved to the database.
Help please
Here is the form:
Here is the onsubmit info:
When I include the onsubmit code nothing gets saved to the database.
Help please
Here is the form:
<table>
<tr>
<td colspan="6"><h2 align="center">Thank you all for coming to the 2008 Denver Bound Annual Event.</h2>
<h2 align="center">We hope you had a great time.</h2>
<h2 align="center">If you could take a few moments and complete this form it will help us make next years event even better.</h2>
<p> <hr> </p></td>
</tr>
<tr>
<td width="125"> </td>
<td width="95" align="center">Wonderful</td>
<td width="90" align="center">Really Good</td>
<td width="90" align="center">Good</td>
<td width="90" align="center">Not To Bad</td>
<td width="105" align="center">What were you thinking</td>
</tr>
<tr>
<td width="125">What did you think of the Venue?<br></td>
<td width="95" align="center">
<input type="radio" name="Venue" value="Wonderful"></td>
<td width="90" align="center">
<input type="radio" name="Venue" value="ReallyGood"></td>
<td width="90" align="center">
<input type="radio" name="Venue" value="Good"></td>
<td width="90" align="center">
<input type="radio" name="Venue" value="NotTooBad"></td>
<td width="105" align="center">
<input type="radio" name="Venue" value="WhatWereYouThinking"></td>
</tr>
<tr>
<td width="125">What did you think of the Schedule?<br></td>
<td width="95" align="center">
<input type="radio" name="Schedule" value="Wonderful"></td>
<td width="90" align="center">
<input type="radio" name="Schedule" value="ReallyGood"></td>
<td width="90" align="center">
<input type="radio" name="Schedule" value="Good"></td>
<td width="90" align="center">
<input type="radio" name="Schedule" value="NotTooBad"></td>
<td width="105" align="center">
<input type="radio" name="Schedule" value="WhatWereYouThinking"></td>
</tr>
<tr>
<td width="125">What did you think of our Lineup of Presenters?<br></td>
<td width="95" align="center">
<input type="radio" name="Presenters" value="Wonderful"></td>
<td width="90" align="center">
<input type="radio" name="Presenters" value="ReallyGood"></td>
<td width="90" align="center">
<input type="radio" name="Presenters" value="Good"></td>
<td width="90" align="center">
<input type="radio" name="Presenters" value="NotTooBad"></td>
<td width="105" align="center">
<input type="radio" name="Presenters" value="WhatWereYouThinking"></td>
</tr>
<tr>
<td width="125">What did you think of the Equipment?<br></td>
<td width="95" align="center">
<input type="radio" name="Equipment" value="Wonderful"></td>
<td width="90" align="center">
<input type="radio" name="Equipment" value="ReallyGood"></td>
<td width="90" align="center">
<input type="radio" name="Equipment" value="Good"></td>
<td width="90" align="center">
<input type="radio" name="Equipment" value="NotTooBad"></td>
<td width="105" align="center">
<input type="radio" name="Equipment" value="WhatWereYouThinking"></td>
</tr>
<tr><td colspan="6"><hr></td></tr>
<tr>
<td width="100%" colspan="6">Thoughts on the Individual Presenters<br></td>
</tr>
<tr>
<td width="125"><b>Lee Harrington</b></td>
<td width="" colspan="5"><textarea rows="10" name="Lee" cols="40"></textarea><br></td>
</tr>
<tr>
<td width="125"><b>Lqqkout</b></td>
<td width="" colspan="5"><textarea rows="10" name="Lqqkout" cols="40"></textarea><br></td>
</tr>
<tr>
<td width="125"><b>Max</b></td>
<td width="" colspan="5"><textarea rows="10" name="Max" cols="40"></textarea><br></td>
</tr>
<tr>
<td width="125"><b>Scott Smith</b></td>
<td width="" colspan="5"><textarea rows="10" name="Scott" cols="40"></textarea><br></td>
</tr>
<tr>
<td width="100%" colspan="6">Any Additional Comments?</td>
</tr>
<tr>
<td width="100%" colspan="6"><textarea rows="20" name="Comments" cols="60"></textarea></td>
</tr>
</table>
<p> </p>
<p> </p>
<p><input type="submit" value="Submit" name="B1"><input type="reset" value="Reset" name="B2"></p>
Here is the onsubmit info:
<p align="center"><h1>Thank you for your feedback.</h1>
<p>Master Robert, ms lilly, and the Denver Bound Staff appreciate your making the effort to help us make next years event even better.
<p>Here are some of the comments we have received:
<?php
global $database;
$sql = "SELECT * FROM #__chronoforms_17;";
$database->setQuery($sql);
$rows = $database->loadObjectList();
echo "<table border=\"1\" cellspacing=\"1\" width=\"500\">
<tr>
<td><b>Venue</b></td>
<td><b>Schedule</b></td>
<td><b>Presenters</b></td>
<td><b>Equipment</b></td>
</tr>";
foreach ( $rows as $record ) {
echo "record: ";print_r($record);echo"<br />";
echo "<tr> <td>".$record->Venue."</td>
<td>".$record->Schedule."</td>
<td>".$record->Presenters."</td>
<td>".$record->Equipment."</td> </tr>";
}
echo "</table>";
?>
<p>And your comments about our presenters:
<?php
global $database;
$sql = "SELECT * FROM #__chronoforms_17;";
$database->setQuery($sql);
$rows = $database->loadObjectList();
echo "<table border=\"1\" cellspacing=\"1\" width=\"500\">
<tr>
<td><b>Lee</b></td>
<td><b>Lqqkout</b></td>
<td><b>Max</b></td>
<td><b>Scott</b></td>
</tr>";
foreach ( $rows as $record ) {
echo "record: ";print_r($record);echo"<br />";
echo "<tr> <td>".$record->Lee."</td>
<td>".$record->Lqqkout."</td>
<td>".$record->Max."</td>
<td>".$record->Scott."</td> </tr>";
}
echo "</table>";
?>
<p>And your comments about the event:
<?php
global $database;
$sql = "SELECT * FROM #__chronoforms_17;";
$database->setQuery($sql);
$rows = $database->loadObjectList();
echo "<table border=\"1\" cellspacing=\"1\" width=\"500\">
<tr>
<td><b>Comments</b></td>
</tr><tr><td><hr></td></tr>";
foreach ( $rows as $record ) {
echo "record: ";print_r($record);echo"<br />";
echo "<tr> <td>".$record->Comments."</td>
</tr>";
}
echo "</table>";
?>