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
