Re: mysql and php

One of the beautiful things about PHP is that it automatically puts all form variables for a POST form in HTTP_POST_VARS which is an associative array. Of course, this relies on 'enable track vars' being enabled in PHP config, which by default I believe it is. so, lets say you have two form variables in your script, one is the name of the fruit producer, like this: <input type=text name=producer size=20> and then lets say you have a select menu with three fruits in it, like this: <SELECT name=fruits> <OPTION VALUE="apple">Apple</OPTION> <OPTION VALUE="orange">Orange</OPTION> <OPTION VALUE="peach">Peach</OPTION> so if the user types in a name of the producer and selects a fruit and submits this form, then assuming you used POST as your form method (PHP also supports GET and hence uses HTTP_GET_VARS) then the two variables will be set: HTTP_POST_VARS[producer] would be set to what the user typed in HTTP_POST_VARS[fruits] would be either apple,orange or fruit. So you can just check for that. I have provided a function, you pass it the name of select variable, in this fruits, and you have two arrays, one with the values and one with the text to show in the menu. So I could have an array like this: $fruits = array("apple", "peach", "orange"); and then in the above HTML you would call the function like this: propts("fruits", 0, $fruits, $fruits, ""); function propts ($name,$size,$vals,$opts,$sel) { if(size == 0) echo "<SELECT NAME=\"$name\">\n"; else echo "<SELECT NAME=\"$name\" SIZE=\"$size\">\n"; for ($i=0;$vals[$i];$i++) { echo "<OPTION VALUE=\"$vals[$i]\""; if($sel == $vals[$i]) echo " SELECTED"; echo ">$opts[$i]</OPTION>\n"; } echo "</SELECT>\n"; } If you wanted to use numbers as your fruits in the database, then create another array that corresponds to the first and put that array name in place of $vals array in the function. (in my example, since I wanted the fruit name to be both the value and the text in html, I just gave it to the function twice). Notice that if you want a particular option to be selected by default you pass that name to the function as the last argument. Good luck /Cody Caughlan Wesley Choate wrote: > Could you show us the code you are using..the html form code and the > actually php program that the forms action refers to?? > > > -----Original Message----- > > From: Joanna [SMTP:joanna@blackhole.evilgeeks.com] > > Sent: Monday, July 17, 2000 12:02 PM > > To: php-db@lists.php.net > > Subject: [PHP-DB] mysql and php > > > > > > I have a db with a simple table. One of the fields in the tables are > > fruit. I created a HTML SELECT FORM to select what kind of > > fruit,apples,peaches,ect... I would like to input the kind of fruit into > > the table. I have even tried using php ifelse statements to assign > > integers instead of the actual fruit name and I still can't figure it > > out. Can someone please help. > > The thing I can't figure out is how to know which of the choices have been > > selected from the form. > > > > thanks > > > > > > > > -- > > PHP Database Mailing List (http://www.php.net/) > > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > > For additional commands, e-mail: php-db-help@lists.php.net > > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net > For additional commands, e-mail: php-db-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net