PHP-SQL Dynamic pull-down menu

**devpat** · 05-03-2009

Hello with all,

I would like to make a pull-down menu which indicates the contents of a table
It must indicate the contents of a table (namely a list of customer) or then give the possibility of returning a new customer if there does not exist yet.
how to make?

Thank you in advance.

**MindSpace** · 05-03-2009

try this hope that can work

<select>
<?php
$opt_str = '';
$dirname = 'path_to_your_directory'; //
if ($D = opendir($dirname)) {
while (false !== ($file = readdir($D))) {
if ($file != '.' && $file != '..') {
$opt_str .= "<option value=\"$file\">$file</option>\n";
}
}
closedir($D);
echo $opt_str;
}
?>
</select>

**Modifier** · 05-03-2009

All that should (if I did not plant myself) create you your pull-down menu with the contents of your table.

1. <html>
2. <body>
3. <form action= " page_de_validation.php " method= " POST " >
4. <SELECT name= " contained table " >
5. <? php
6. mysql_connect (“@serveur_sql”, “login”, “password”);
7. mysql_select_db (“la_base_qui_contient_ta_table”);
8.
9. $sql = “SELECT mon_champ FROM ma_table”;
10.
11. $reponse = mysql_query ($sql);
12.
13. while ($donnees = mysql_fetch_array ($reponse)) {
14. ? >
15. <option value= " <? php $donnees [“mon_champ”]? > " ><? php echo $donnees [“mon_champ”]? ></option>
16. <? php}? >
17.
18. <option value= " ajouter_si_manquant " >Ajouter a client</option>
19.
20. </form>
21. </body>
22. </html>