Combo box in PHP4

Anon

Hi,

I need to create a combo mox and message boxes under PHP4. could some one let me know how to do this.

Thanks

Ernie

Anon

<?
/* 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=\"PRODUCT_TYPE\">";

   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>

Anon

The issue I ran into with this function is that it hard codes the name of the combo box to PRODUCT_TYPE, which makes it unsuitable to be used more than once on a given page. I added an additional parameter to it, "in_picklist_name" , and substituted that variable where PRODUCT_TYPE is now. So my parameter list looks like this:

function DB_PICKLIST ($in_name
,$in_tablename
,$in_value_column_name
,$in_display_column_name
,$in_picklist_name
,$in_other_value = ""
,$in_other_display = ""
,$in_selected_value = ""
,$in_where_clause = ""
) {

I invoke it like this:

echo DB_PICKLIST "this_artist" , "artists" , "ID" , "artist", "artists_ID" , "" , "" , "$ThisArtistID");