Code: Select all
<?php
function state_dropdown()
{
$options = "";
$state = $_SESSION['state'];
$query = "SELECT abbrev, IF(abbrev = '$state', ' SELECTED', '') AS selected FROM states";
db_connect();
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result))
{
$options .= "<option{$row['selected']}>{$row['abbrev']}</option>";
}
db_close();
echo $options;
}
?>Code: Select all
<?php
/* THIS FUNCTION WILL ECHO OUT THE HTML NEEDED FOR A HTML LIST BOX
IF $A_OPTIONVALUES IS NULL USE DISPLAY VALUES ARRAY KEY
IF $ECHOHTML IS TRUE ECHO HTML ELSE RETURN HTML
IF $use_dsp_val_as_key USE $a_displayValues AS VALUE AND DISPLAY
$selected_option_value CAN BE AN ARRAY FOR MULTIPLE SELECTION BOXES
*/
function printSelectBoxOptions($a_displayValues, $a_optionValues, $selected_option_value,$echoHTML,$use_dsp_val_as_key){
//echo '<PRE>'; print_r(func_get_args()); echo '</PRE>';
$html = '';
$arrayCount = 0;
//IF OPTION VALUES IS NULL USE DISPLAY VALUE OR ARRAY KEY FOR OPTION VALUE
if(is_null($a_optionValues)){
if($use_dsp_val_as_key)//USE DISPLAY AS OPTION VALUE
$a_optionValues = &$a_displayValues;
else //USE DISPLAY ARRAY KEY AS OPTION VALUE
$a_optionValues = array_keys($a_displayValues);
}
if(is_array($a_displayValues)){
foreach ($a_displayValues as $x => $v) {
//IF SELECTED OPTION VALUE IS AN ARRAY
//SEARCH ARRAY FOR VALUE
//THIS IS USED FOR MULTIPLE SELECT BOXES
$is_sel = FALSE;
if(is_array($selected_option_value)){
$is_sel = search_array_forValue($a_optionValues[$arrayCount], $selected_option_value);
}
if($is_sel or $a_optionValues[$arrayCount]==$selected_option_value)
$sel = ' selected';
else
$sel = '';
$html.= '<option value="'.$a_optionValues[$arrayCount].'"'.$sel.'>'.$a_displayValues[$x].'</option>'."\r";
$arrayCount++;
}
}else{
return FALSE;
}
if($echoHTML){
echo $html;
return TRUE;
}else{
return $html;
}
}
?>Code: Select all
<?php
//CREATE SELECT BOX WITH 1 - 100
//MAKE 22 THE SELECTED VALUE
echo '<select>';
printSelectBoxOptions(range(0, 100), NULL, 22,TRUE,TRUE);
echo '</select>';
?>Code: Select all
<?php
$a_states= array();
$state = &$_SESSION['state'];
$query = "SELECT abbrev FROM states";
db_connect();
$result = mysql_query($query);
while ($row = mysql_fetch_assoc($result))
{
$a_states[] = $row['abbrev'];
}
db_close();
echo '<select>';
printSelectBoxOptions($a_states, $a_states, $state,TRUE,FALSE);
echo '</select>';
?>