Re: <SELECT> tag and PHP

[Jochem Maas <jochem@xxxxxxxxxxxxx>]

weetat wrote:
> Hi all ,
> 
>   I have a <SELECT> for country in the php file . I would like to load
> the country and city belong to the country dynamically  from the database.
> 
> Anyone have ideas how to do it ?

below is a function that generates a select tag based on the
criteria you give it, the first argument, $items, you give it is the most
important - it should contain the data used to populate the list where by each
key in the array is the value of an <OPTION> and the corresponding value in
the array is the display text of corresponding <OPTION>.

to create the $items array you would perform a query on your database and
loop the results, e.g. (untested query code)

$res = mysql_query('SELECT id, name FROM foo ORDER BY name');
if ($res && mysql_numrows($res)) {
	while ($row = mysql_fetch_assoc($res)) {
		$items[ $row['id'] ] = $row['name']
	}
}

here is the function (linewrapping in the email may have screwed the code layout
a bit) - this function is quite old and by no means perfect (Richard Lynch gave good
argument as to the possible 'cons' of such a fucntion, but nonetheless here it is):

/** selectTag()
 *  generate an html select list using the given $items as options.
 *
 * @param   array   $items      - list of items to display as options
 * @param   array   $selected   - value of selected item in $items
 * @param   string  $selectname - value of select tag's name attribute
 * @param   numeric $addnone    - add a 'blank' option to the top of the list (different types depending on value passed)
 * @param   string  $onchange   - value of select tag's onchange attribute
 * @param   string  $selectid   - value of select tag's id attribute
 * @param   boolean $readonly   - whether the select tag is readsonly or not
 * @param   boolean $option_class_arr   - optional CSS class names for individual option tags
 * @param   string  $selectHTMLattribs  - passthru HTML (attributes for the select tag)
 *
 * @return  string
 */
function selectTag($items, $selected = '', $selectname = '', $addnone = 0, $onchange = '', $selectid = '', $readonly =
0, $option_class_arr = array(), $selectHTMLattribs = '')
{
    // must have an array of items
    if (!is_array($items)) {
        return '';
    }

    // determine the value of the selected item
    $selected = strtolower(trim($selected));

    // list of options we will generate
    $opts     = array();

    // add item with value 0 ?
    $add_none_value = 0;
    switch ( $addnone )  {
        case '1':   // item display = 'none'
            $zero_id_item = getStr('None');
            break;
        case '3':   // item display = '0'
            $zero_id_item = getStr('zero_digit');
            break;
        case '2':   // item display = 'all'
        case '4':   // item display = 'all <digit>' e.g. 'all 3'
            $zero_id_item = getStr('All');
            break;
        default:
            if(!empty($addnone) && $addnone != '0') {
                if(is_array($addnone)) {
                    list($add_none_value, $zero_id_item) = @each($addnone);
                } else {
                    // here we can drop in a custom 'blank' item:
                    $zero_id_item = $addnone;
                }
            }
            break;
    }
    if (isset($zero_id_item)) {
        $thisselected = ($selected > '')  ? '' : ' selected="selected"';
        // FIX THE NEXT LINE - BUT NOT IMPORTANT
        $class_var  = (false && isset($option_class_arr[IAJ_OPTION_ZERO_ITEM_CLASS_VALUE] )) ? ' class="' .
$option_class_arr[IAJ_OPTION_ZERO_ITEM_CLASS_VALUE] . '"' : '';
        $opts[]     = '<option value="'.htmlentities($add_none_value, ENT_QUOTES).'"
'.$thisselected.$class_var.'>'.$zero_id_item.'</option>';
    }

    $thisselected = '';
    foreach ($items as  $value => $displayname) {
        $thisselected = ($selected > '' && $selected == strtolower($value)) ? ' selected="selected"' : '';
        $class_var    = (isset($option_class_arr[$value])) ? ' class="' . $option_class_arr[$value] . '" ' : '';
        $opts[]       = '<option value="'.htmlentities($value,
ENT_QUOTES).'"'.$thisselected.$class_var.'>'.$displayname.'</option>';
    }

    // various select tag attribute values
    $onchange = (($onchange = trim($onchange)) > '')
              ? " onchange=\"$onchange\""
              : ''
              ;
    $id       = ($selectid = strval($selectid))
              ? " id=\"{$selectid}\""
              : ''
              ;
    $readonly = ($readonly == 1)
              ? ' readonly="readonly"'
              : ''
              ;

    return "<select name=\"{$selectname}\" {$selectHTMLattribs}{$id}{$onchange}{$readonly}>\n".
           join("\n\t", $opts).
           "\n</select>";
}

> 
> Thanks
> - weetat
> 

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php