Code: Select all
<select name="season" size="4" multiple>
<option value="1">Spring</option>
<option value="2">Summer</option>
<option value="3">Fall</option>
<option value="4">Winter</option>
</select>Thanks!
lwr
Moderator: General Moderators
Code: Select all
<select name="season" size="4" multiple>
<option value="1">Spring</option>
<option value="2">Summer</option>
<option value="3">Fall</option>
<option value="4">Winter</option>
</select>Code: Select all
<select name="season[]" size="4" multiple>
<option value="1">Spring</option>
<option value="2">Summer</option>
<option value="3">Fall</option>
<option value="4">Winter</option>
</select>Code: Select all
array(2)
{
[0]=> string(1) "1"
[1]=> string(1) "4"
}Code: Select all
<?php
// Was the form posted?
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
if (! empty($_POST['season'])) {
// Season had a value passed to it, lets get it.
$season = $_POST['season'];
foreach ($season as $key => $value) {
// Now we can loop this array and use either the array keys
// (which in your case are more than likely going to be useless)
// or use the array values (which are more useful in this case)
echo "A season of $value was submitted\n";
}
}
} else {
echo 'The form was not submitted!';
}
?>Code: Select all
$season = $_POST['season'];
foreach ($season as $key => $value) {
$sql3 = "INSERT INTO season (activity_id, season) VALUES (" .
$activity_id . ", " . $season . ")";
}Code: Select all
<form action="test.php" method="post">
<select name="season[]" size="4" multiple>
<option value="1">Spring</option>
<option value="2">Summer</option>
<option value="3">Fall</option>
<option value="4">Winter</option>
</select>
<input type="submit" name="action" value="Cancel" />
<input type="submit" name="action" value="Create New Activity" />
</form>
</body>
</html>
<?php
if (!empty($_POST['season'])) {
$season = $_POST['season'];
foreach ($season as $key => $value) {
echo "A season of $value was submitted\n";
}
}
?>Code: Select all
<form action="transact_activity.php" method="post">
<table border="0">
<tr>
<td width="130" valign="top"><strong>Name:</strong></td>
<td width="397"><input type="text" name="name" maxlength="255" /></td>
</tr>
<tr>
<td colspan="2" valign="top" background="../images/table_line.jpg"> </td>
</tr>
<tr>
<td width="130" valign="top"><strong>Short Description:</strong></td>
<td><input name="short_desc" type="text" size="50" maxlength="255" /></td>
</tr>
<tr>
<td width="130" valign="top"><strong>Full Descriptoin:</strong></td>
<td><textarea name="full_desc" cols="50" rows="5"></textarea></td>
</tr>
<tr>
<td colspan="2" valign="top" background="../images/table_line.jpg"> </td>
</tr>
<tr>
<td width="130" valign="top"><strong>Header Picture:</strong></td>
<td><input type="file" name="header" /></td>
</tr>
<tr>
<td width="130" valign="top"><strong>Icon Picture</strong></td>
<td><input type="file" name="icon" /></td>
</tr>
<tr>
<td colspan="2" valign="top" background="../images/table_line.jpg"> </td>
</tr>
<tr>
<td width="130" valign="top"><strong>Price:</strong></td>
<td>$
<input name="price" type="text" maxlength="255" /></td>
</tr>
<tr>
<td colspan="2" valign="top" background="../images/table_line.jpg"> </td>
</tr>
<tr>
<td width="130" valign="top"><strong>Season:</strong><br />
(hold ctrl to select multiple values)</td>
<td>
<select name="season[]" size="4" multiple>
<option value="1">Spring</option>
<option value="2">Summer</option>
<option value="3">Fall</option>
<option value="4">Winter</option>
</select>
</td>
</tr>
<tr>
<td colspan="2" valign="top" background="../images/table_line.jpg"> </td>
</tr>
<tr>
<td width="130" valign="top"><strong>Location:</strong></td>
<td>
<select name="location"s>
<option value="north">North</option>
<option value="east">East</option>
<option value="south">South</option>
<option value="west">West</option>
<option value="downtown">Downtown</option>
</select>
</td>
</tr>
<tr>
<td width="130" valign="top"><strong>Address:</strong></td>
<td><textarea name="address" cols="30" rows="3"></textarea></td>
</tr>
<tr>
<td width="130" valign="top"><strong>Website:</strong></td>
<td><input name="website" type="text" value="" size="30" maxlength="255" /></td>
</tr>
<tr>
<td width="130" valign="top"><strong>Contact:</strong></td>
<td><input type="text" name="contact" maxlength="255" /></td>
</tr>
<tr>
<td colspan="2" valign="top" background="../images/table_line.jpg"> </td>
</tr>
<tr>
<td width="130" valign="top"> </td>
<td>
<input type="submit" name="action" value="Cancel" />
<input type="submit" name="action" value="Create New Activity" />
</td>
</tr>
</table>
</form>Code: Select all
if (isset($_POST['name']) and ($_POST['name']) != ''
and isset($_POST['full_desc']) and ($_POST['short_desc']) != ''
and isset($_POST['short_desc']) and ($_POST['full_desc']) != ''
and isset($_POST['price']) and ($_POST['price']) != ''
and isset($_POST['address']) and ($_POST['address']) != ''
and isset($_POST['location']) and ($_POST['location']) != ''
and isset($_POST['website']) and ($_POST['website']) != ''
and (!empty($_POST['season']))
and isset($_POST['contact']) and ($_POST['contact']) != '') {
$price = strval($_POST['price']);
//Insert values into activity table
$sql = "INSERT INTO activity " .
"(name, full_desc, short_desc, price, address, location, website, contact) " .
"VALUES ('"
. htmlspecialchars($_POST['name']) . "','"
. htmlspecialchars($_POST['full_desc']) . "','"
. htmlspecialchars($_POST['short_desc']) . "',"
. $price . ",'"
. htmlspecialchars($_POST['address']) . "','"
. htmlspecialchars($_POST['location']) . "','"
. htmlspecialchars($_POST['website']) . "','"
. htmlspecialchars($_POST['contact']) . "')";
mysql_query($sql, $conn) or die('Could not insert into ACTIVITY; ' . mysql_error());
//retrieve id value from activity just entered
$sql2 = "SELECT activity_id FROM activity WHERE name='" . htmlspecialchars($_POST['name']) .
"' AND full_desc='" . htmlspecialchars($_POST['full_desc']) .
"' AND short_desc='" . htmlspecialchars($_POST['short_desc']) .
"' AND address='" . htmlspecialchars($_POST['address']) .
"' AND location='" . htmlspecialchars($_POST['location']) . "'";
$result = mysql_query($sql2, $conn) or die('Could not retrieve ACTIVITY_ID; ' . mysql_error());
$row = mysql_fetch_array($result);
$activity_id = $row['activity_id'];
//Inserts into season table for each selected season
$season = $_POST['season'];
foreach ($season as $key => $value) {
echo "A season of $value was submitted\n";
}
redirect('panel.php?s=created&pn=' . $_POST['season']);
} else if (($_POST['page_name']) == ''
or ($_POST['page_desc']) == '')
{
redirect('panel.php?compose=yes&alert=fillallfields');
} else {
redirect('panel.php?s=no&pn=' . $_POST['name']);
}