function selectTable($nomtable, $where = NULL, $order = NULL)
{
$sql = "SELECT * FROM $nomtable";
if ( $where !== NULL ) $sql .= " WHERE $where";
if ($order !== NULL)$sql.=" ORDER BY $order ";
{
$ret[] = $donnee;
}
return $ret;
}
function sqlSelect($sqlDonnee, $nomCol, $valCol)
{
for($i = 0 ; $i<count($sqlDonnee) ; $i++)
{
$selectDonee["name"][$i] = $sqlDonnee[$i][$nomCol];
$selectDonee["value"][$i] = $sqlDonnee[$i][$valCol];
}
return $selectDonee;
}
function htmlSelect($nom, $options, $selected = NULL, $css = NULL)
{
if ( $css !== NULL )
$select .= " $css>";
else
$select .= ">";
for($i = 0 ; $i<count($options["name"]) ; $i++)
{
if ( $selected !== NULL && $selected == $options["value"][$i] )
$select .= "<option value=\"".$options["value"][$i]."\" selected=\"selected\">".$options["name"][$i]."</option>\n";
else
$select .= "<option value=\"".$options["value"][$i]."\">".$options["name"][$i]."</option>\n";
}
$select .= "</select>\n";
return $select;
}
/*** Exemple utilisation ***/
/* <option selected> par defaut pour le pays ayant l'id 72 */
$paysSelect =
isset($_POST["pays"]) ?
($_POST["pays"]) :
("72");
$selectPays=selectTable("pays");
$pays=sqlSelect($selectPays,"nom","id");
echo htmlSelect
("id",
$pays,
$paysSelect);
// on construit notre <select>
