 |
Submit Your Code | |
 |
SEO Monitor | |
 |
UpTime Monitor | |
 |
PHP Code Contest | |
 |
My Favorite Examples | |
|
My Favorite Articles | |
 |
Update Your Profile | |
|
|
| More Weber Sites | ||
| PHP Code Search | ||
| Web Development Forums | ||
| Learn MySQL Playing Trivia | ||
| PHPBB2 Templates | ||
| Web Development Index | ||
| Web Development Resources | ||
| Web Development Content | ||
| Recommended Links | ||
| PHPClasses | ||
| PHP Editor | ||
| PHP Jobs | ||
| Vision.To Design | ||
| Ajax Tutorials | ||
| PHP Programming Help | ||
| PHP/MySQL Programming | ||
| Webmaster Resources | ||
| Webmaster Forum | ||
| XML meta language | ||
| website builder | ||
| Recommended | ||
| Mobile Dev World | ||
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Code | |||||
<? /* Created by: Chris Brown Date: 2000-AUG-04 This function will return an HTML select list from two columns in any table. You have the option of specifying an "other" value wich is useful for null values on data entry and an "All" option for queries. Also you can specify a default selected item and a where clause to limit the records in the list. Feel free to add to this and repost it or comment if you like, it needs some error handling. */ function html_drop_down ($in_name ,$in_tablename ,$in_value_column_name ,$in_display_column_name ,$in_other_value = "" ,$in_other_display = "" ,$in_selected_value = "" ,$in_where_clause = "") { // build the SQL string $sql = "SELECT " . $in_value_column_name . " col_val," . $in_display_column_name . " col_disp" . " FROM " . $in_tablename; if ($in_where_clause) { $sql .= " " . $in_where_clause; } $sql .= " order by col_disp"; // connect to mysql, put your specifics here. mysql_pconnect() or die ("problems connecting to Database."); // queries the database, be sure to name your database. $result = mysql_db_query("ecomm",$sql); // build the select list. if ($result) { $return_value = "<SELECT NAME=\"$in_name\">"; if ($in_other_display) { $return_value .= "<OPTION VALUE=\"$in_other_value\"> $in_other_display </OPTION>"; } while ($rec = mysql_fetch_array($result)) { $return_value .= "<OPTION "; if ($in_selected_value) { if ($rec["col_val"] == $in_selected_value) { $return_value .= " SELECTED "; } } $return_value .= " VALUE=\"" . $rec["col_val"] . "\"> " . $rec["col_disp"] . " </OPTION>"; } $return_value .= "</select>"; } else { $return_value .= "No data."; } mysql_free_result($result); return $return_value; } ?> <? /* Here's three examples of how you can use this function */ /* Simple example */ echo html_drop_down ("formvar1_prod_type" ,"prod_types" ,"prod_type_id" ,"name"); /* An example with an extra value in the list, good for N/A, All values for queries etc.. */ echo html_drop_down ("formvar2_prod_type" ,"prod_types" ,"prod_type_id" ,"name" ,"-1" ,"All Types"); /* An example with a where clause */ echo html_drop_down ("formvar3_prod_type" ,"prod_types" ,"prod_type_id" ,"name" ,"-1" ,"All Types" ,"3" ,"WHERE prod_type_id <> 4"); /* Here's the data used in my example, it should work with any table though: mysql> select prod_type_id, name from prod_types; +--------------+-------------------+ | prod_type_id | name | +--------------+-------------------+ | 1 | Mother Boards | | 2 | Graphics Cards | | 3 | Memory | | 4 | Pointing Devices | | 5 | Keyboards | | 6 | Operating Systems | +--------------+-------------------+ 6 rows in set (0.00 sec) mysql> */ ?> | |||||
| Related Code Examples | |||||
