//**************************************
// Name: Automated dropdown list
// Description:Function that returns an xhtml dropdown element with a database based options that will be ready to use in a form.
More info, examples and updates can be found here http://code.tiko-world.com/forum/viewtopic.php?p=195#195
// By: [RTS]BN+VS*
//
//This code is copyrighted and has// limited warranties.Please see http://www.Planet-Source-Code.com/vb/scripts/ShowCode.asp?txtCodeId=2566&lngWId=8//for details.//**************************************
function dropDown($name, $elements, $defaultValue = 0, $values = null, $args = '', $retainValue = true)
{ // By De Dauw Jeroen - December 2008 - jeroen_dedauw@yahoo.com
// http://code.tiko-world.com/forum/viewtopic.php?t=81
$nr = 0;
if ($retainValue && isset($_REQUEST[$name])) $defaultValue = $_REQUEST[$name];
foreach($elements as $option)
{
$html.="<option value ='".($values != null ? $values[$nr] : $nr)."' ".($defaultValue == ($values != null ? $values[$nr] : $nr) ? 'selected' : '').">$option</option>";
$nr++;
}
return "<select name='$name' $args>$html</select>";
}
function getDropDown($name, $table, $descriptions_field, $values_field = null, $value = 0, $sqlSort = null, $args = null, $retainValue = true)
{ // By De Dauw Jeroen - December 2008 - jeroen_dedauw@yahoo.com
if (empty($values_field)) $values_field = $name;
if (empty($sqlSort)) $sqlSort = "ORDER BY `$descriptions_field` ASC";
if (empty($args)) $args = "id='$name'";
return dropDown($name, getOptions($descriptions_field, $table, "", $sqlSort), $value, getOptions($values_field, $table, "", $sqlSort), $args);
}
function getOptions($select, $from, $where = "", $other = "")
{ // By De Dauw Jeroen - November 2008 - jeroen_dedauw@yahoo.com
global $db;
$options = array();
$db->Query("SELECT $select FROM $from ".(strlen($where) > 0 ? "WHERE $where" : "").(strlen($other) > 0 ? " $other" : ""));
while($record = $db->GetObject())
{
$options[] = $record->$select;
}
return $options;
}
|
