HTML 'list/menu' And PHP/mysql
tell me the correct syntax to use for assigning the selected option from a pick-list before inserting to a mysql database? I am trying to give the visitor the option of some 20-30 categories from a pick-list and then I want to store the selected category in a field (called 'cat') in my mysql table.
View Complete Forum Thread with Replies
Related Forum Messages:
How I Can Make A List That Acts Like A Html Jump Menu?
how I can make a list that acts like a html jump menu (for a regular list I have to use a "Go" button in order to achieve the desired behaviour and jump menus I cannot use because they work only with links to other pages). For example,I want such a list filled with questions from my db and when I select one I want to see its possible answers; the page stays the same, only its data differs based on the selection. Or you can have a look at such a jump menu on this website, the one with options for geting to various sections of the forum.
View Replies !
Chain Menu But The Menu Should Be Multiple Select Menu/list
I am looking for codes to be able to do the same thing with multiple select menu/list. PHP codes or javascripts codes are both fine. 1) javascript + php approach: Prefer to be javascripts codes to display the chain menu. I can use the php to get the all three levels menu data from the database, and assign these values to the javascript. 2) php codes only: Or use the pure php codes (the problem is if just using php codes then I have to submit the form to the server every time, when top level menu select changes to create new menu.).
View Replies !
Mysql List Menu
how can I modify this code to list queries in alphabetical order and eliminate duplicate names. <?php mysql_connect("localhost", "xxx_xx", "xxxx") or die(mysql_error()); mysql_select_db("xxxx_xx") or die(mysql_error()); $query="SELECT Bloom_Name FROM ihs"; $result = mysql_query($query); echo '<select name="ihs">' while($nt=mysql_fetch_array($result)){ //Array or records stored in $nt echo '<option value="' . $nt['id'] . '">' . $nt['Bloom_Name'] . '</option>' /* Option values are added by looping through the array */ } echo '</select>' // Closing of list box ?>
View Replies !
Select List/Menu Using PHP And MYSQL
Here is my code: <select name="country" class="sidelinks"> <?php do { ?> <option value="<?php echo $row_AllCountries['country_ID']." ";?>"<?php if ($row_AllCountries['country_ID'] = $acountry) { echo "selected"; }?> > <?php echo $row_AllCountries['countryname'];?></option> <?php } while ($row_AllCountries = mysql_fetch_assoc($AllCountries)); ?> </select> A few words to describe: -$row_AllCountries['country_ID'](get from MySQL) is a unique country ID number -$row_AllCountries['countryname'](get from MySQL) is the name of the country -$acountry is the country ID number that i want to be selected when the form loads I have all the values and country names named OK...the only problem is that when the form loads it selects the last country.
View Replies !
Populating A List/menu From MySQL
is there a way to populate a list, or a menu form using php, and MySQL? Basically i have a list, and i am planing to import 2 variables, id, and name, bouth id and name are variables loaded from MySQL (yes there are multiple id's, and name's) Name would be the label displayed, and the value would be id. Thats what i need. After that i will make a submit button, witch will post the selected id to a different file. How can i achive this? Does anyone hae any samples maybe?
View Replies !
Can You Read A Value Into A List Menu?
a system i am developing has both a user and an admin side. The user can add a record and then the status of this is initially set to a fixed value. What I am wondering is, if i stick with a list of say 4 possible status', how can i get whatever status the admin changes the record to to be "sticky" on the menu the next time he looks at the call, as opposed to the menu showing the default value set in dreamweaver?
View Replies !
Drop Down List Menu.
How do I make one item required on my "drop down" list menu? E.g., let's say that I want one state to be selected, how do I make this possible with PHP? My PHP skill is amature, but I do understand most.
View Replies !
Cannot Get List To Stay In Menu
I am using 2 drop down menus which pull their options from a database. Once the user selects a language and then a product a list of available pdf's are displayed. However the form resets it self. How can I set this up so the products for the language selected stays. I was thinking about using a session but im not sure how to go about that when dealing with pulling data from MySQL Code:
View Replies !
A Form Menu List
I have a date of birth script on my website and at the moment im faced with typing in about 100 dates ranging from 1900 to 2006 is their any way i could use php to create the range of dates in a form menu list?
View Replies !
Adding Items To A List Or Menu
Not sure if it is a php question but since i am working in php here it is. Ho can i add items to (the item label=visual text and the value=index number) a list object on a website. I am having a list with 4 items and i would like to add the text from a textfield (textfield1.value) to the list object so it will hold 5 items.
View Replies !
PHP / Javascript Menu List Population
I would like a web page to have 2 menu lists The contents of the second menu list depending on the selection made in the first. The contents of the second would be populated from a database. I am fairly new to programming using PHP, Javascript and MySQL but I am sure what I am asking has been done before. Could someone please give me some pointers or direct me to a tutorial.
View Replies !
Trying To Create Dropdown Menu From List
I am trying to create a dynamic dropdown select menu from a directory containing other directories and files. This is to select a certain page from the list so I can edit it. I only want the files in the menu. Here's what I have so far but it doesn't populate the dropdown. Code:
View Replies !
Calendar Type List/menu
how do i do 3 list type menu one with the 12 months next with the days in that month and the year. so want i want is when people select a month the next list show the days as soon the pick the month.
View Replies !
Ordering A Drop-down Menu List
I am building a form that has a list/menu populating from the database. I'm using Dreamweaver to help code (which I know adds a mess), but I can usually edit it to do what I want. this is what it has: <option value="<?php echo $row_rsPhysician['specialtyID']?>"<?php if (!(strcmp($row_rsPhysician['specialtyID'], $row_rsPhysician['specialtyID']))) {echo "SELECTED";} ?>><?php echo $row_rsPhysician['specialtyName']?></option> <?php } while ($row_rsPhysician = mysql_fetch_assoc($rsPhysician)); $rows = mysql_num_rows($rsPhysician); if($rows > 0) { mysql_data_seek($rsPhysician, 0); $row_rsPhysician = mysql_fetch_assoc($rsPhysician); } ?> although if you have any generic code, I can play with it to get it to alphabetize my list. (the list is specialtyName and specialtyID is going into the database.
View Replies !
Array List Menu Problems
I am trying to store values from a List Menu into an sql database table as an ARRAY. However, when I select the multiple values from the form, it only stores the selected values as 'Array' in the SQL table. Here is the Select Statement: <select name="NOTES[]" size="9" multiple="multiple" id="NOTES"> <?php do { ?> <option value="<?php echo $row_literarydevices['LDEVICE']?>"<?php if (!(strcmp($row_literarydevices['LDEVICE'], $row_Recordset1['NOTES']))) {echo "selected="selected"";} ?>><?php echo $row_literarydevices['LDEVICE']?></option> <?php } while ($row_literarydevices = mysql_fetch_assoc($literarydevices)); $rows = mysql_num_rows($literarydevices); if($rows > 0) { mysql_data_seek($literarydevices, 0); $row_literarydevices = mysql_fetch_assoc($literarydevices); } ?> </select> Can anyone offer a reason to why the values are not being stored?
View Replies !
Default Menu/List Option
I'm trying to create a form with three menus, each with the same values, and I have no problems there. Each menu has it's initial value set at "None" and then the rest of the values are pulled from my MySQL db. Everything works great if the user selects three values that came from the database or selects something from the first menu but not the other two and then submits. The problem is when the user doesn't select anything from the first menu. The next page reads the form value as "" instead of "None" but only for the first menu. The other three menus work fine. I know this isn't really php related, but this is usually such a helpful forum that I thought I'd post here before I start to search for some helpful html forum. Answers would be greatly appreciated, but so would corrections for my terminology (which I think I am confused about) or a good link to a place where I should be asking this question.
View Replies !
Dynamically Populated List Menu
I have a DB with a field called county in a table called info. I want to populate the list menu below with the counties in the field county. Would there be a way to get around the fact that there will be many entries with the same county and we want only 1 instance in the list menu? Code:
View Replies !
Long Strings In List/menu Boxes
Is there a way to get a list/menu box to resize as the page is resized and for any long string that is an item in the list to be spread over two or more lines in the same way as text in a table does.
View Replies !
Flat File List Style Menu
I'm trying to build a Menu Building out of flatfiling with a section to add new areas to it. The idea behind it is to have a header for each section (as the top order list item) then each one below is a link of that category. I already figured I'm buillding it with limits (20 items Max per heading) and that to do it I will simply have each Heading/links in it be a new row in the document. example row Tips tips.php Tips on Php, file tips File Tips tips/files.php, etc etc With the first item of each row being the Heading and each other being the ones under it My question is What delimiters should I use to seperate in the row (I need to separate each item by 1 delimiter and then in each row separate the href, alt, name) Secondly for rewrtiign it should I simply write it so each time it rewrites the whole file or should I try and do string replacing and do modify sorta deal.
View Replies !
Form Validation :: List / Menu In Dreamweaver
Does anyone know anyway to put in additional php coding to validate list/menu in forms? I am currently using Dreamweaver, so I am using their Validation check in their Tags/Behaviour sections. I read in alot of places that this default function does not allow a validation check for list/menu. But I am wondering if anyone know of anyway to put in some additional coding so that it will allow it to validate the list/menu as well?
View Replies !
Pull Down Menu Generating A List Off Another File
Is there a way I can make a pull down menu generating a list off another file of all the destination case coming from the file locations.php? locations.php switch ($destination){ case "Las Vegas": echo "Bring an extra $500"; break; case "Amsterdam": echo "Bring an open mind"; break; case "Egypt": echo "Bring 15 bottles of SPF 50 Sunscreen"; break; case "Tokyo": echo "Bring lots of money";...........
View Replies !
Stuck On Dropdown Menu List, Could Use Some Guidence
I have a form with some drop down list/menus. I do a check for ommissions and if found display a message to re-try. What I need is a way to show which options where chosen when the user submitted the form the first time. If someone could show me how to do the first one, I'm sure it's the same process for the second one. Here's the code:
View Replies !
Script That Is A Bit Like A Jump Menu But Without The Pull Down List.
I am looking for a script that is a bit like a jump menu but without the pull down list. I want users to be able to enter a post code (4 digits) and then be redirected to a web page based on that post code as each web page is different per code. the jump menu provided in dreamweaver is almost there but as there are thousands of codes it is impractical to have them drop down.
View Replies !
Print Array In List/menu Form Object
how i print a full column array into a list/menu form object, so that the text links to their respective page.....it is basically for a list of interviews so you click on the band name and then goto the interview page.
View Replies !
Editing HTML Menu
I have a html menu as below. <ul> <li><a href="#">home</a></li> <li><a href="#">about</a></li> <li><a href="#">news</a></li> </ul> Should I use xml? I would imaging setting up a form with the menu displayed. The user could then select to add/delete/update the menu and PHP would process this.
View Replies !
How To Create Html List From Such Array ?
I've got an example array like this: $myArr = array( array("jj", "0", "jjj"), array("ee", "0", "eee"), array("bb", "ee", "bbb"), array("ll", "ee", "lll"), array("ff", "0", "fff"), ) Where each row is an array with columns: id of list element, id of parent list element ("0" means main node) and content of the element. So, from my array I'd like to create a list like this: <ul> <li>jjj</li> <li>eee <ul> <li>bbb</li> <li>eee</li> </ul> </li> <li>fff</li> <ul>
View Replies !
Html Pre-selected List Box Scrolled
Is it possible to have a list box with a pre-selected value automatically scrolled to that value when the form is loaded? i.e. if the size of the list box is 3, and the 4th value is pre-selected, I want the list box to appear starting at the 4th value in the form.
View Replies !
Generate A Random List Within My HTML
I'm trying to generate a random list within my HTML. I've done random lists before, but this is giving me problems. In the code below, $file should be printing the array I have stored in $file. $file contains raw HTML, comprised of about 10 items right now, but will be higher as I add to it. (That is why I did the $arraycount). I did a var_dump($file) and I can see that $file does indeed contain what I want it to, but I just cannot get the contents into my page. Code:
View Replies !
How To List/find Html Tags In Text
What I try to do is to search a text for html tags. Why. Because I want to use nl2br on the text, but since this command add br instead of all /n it is not a nice thing to add t.x. a html list inside the text. Of course it is possible to add the list and remove all space between li tags, but this is not so readable to the writer. What I try to do is also to add nl only in the plain text and inside li and td tags. So in the li case I have to find <ul> and </ul> and <table>..
View Replies !
List Of Sybmols Like To Display > On Html Page > And Which Are Others
i am making an application. the user can give description and that description is stored in database and then the description is shown on html page. suppose the user has written "<b>hello</b>" in description then in the database the following will be stored "<b>hello</b>" but when i display it on database the hello in bold letter will be displayed. i know the soultion that i have to replace the occurrences of < with < and occurrences of > with > but i don't know that which are other symbols which needs some repair like above so please give me a list of html symbols and their equivalent symbol.
View Replies !
Send An Html Page To People On A Mailing List.
I am wanting to be able to send an html page to people on a mailing list. I have set it up so it sends $mailing_template which sends an html page. Only, when it reaches the inbox it shows as straight html (un parsed) and not as the page. How can I set it to send it as HTML and not straight HTML code please?
View Replies !
Mysql Php Dynamic Menu
I am trying to write a script that will create dynamically a menu from MySQL database. The database table is a product categories table and it has the folowing filed: category_id, parent_category_id, category_name (some other fileds are there as well but these are enough to figure out the logic) I know that I have to store all the product_categories records in a temp array and then some how go through them and store the level of each record in the menu.... If you have done something like that I suppose you know what I mean and I would much appreciate to give me a hint here ... I had a look in the phpLayersMenu from sourceforge but it is really advanced OO code and I cannot understand the logic.... My target is to create a Tree menu with no pre - defined number of records...
View Replies !
Mysql / Dropdown Menu
what i am trying to do is to make a system with a few input pages and edit and read pages.. so right now i got the input/edit/read pages working. (yay) But now I want to have on 1 input page a dropdown menu that reads its information from the database. and that if i go to the page i can select a value out of the db and submit that inside my form and that it reminds the value if i view or edit the page. So what i got now is a little system that is able to add/remove/edit a value inside a field called "drop01" Well now i got a other input page called "input01.php" inside this script i want to have the dropdown menu that reads its values from the "drop01" field. PHP Code:
View Replies !
Dynamic Menu From MySQL
i have a php script that displays three list menu's. each list menu gets its values from a database. from the first list menu is selected, the selected value is then used to query the DB to get another set of list values to the second list menu and so forth to the third. my problem is that how do i achieve this by using list menu(not jump menu) if ajax is a solution, how to achieve that?
View Replies !
MySql Menu Populating
My goal is to use a Drop Down Menu that is populated by the database. The user is then able to select a name from the Menu that pulls all of the information for a particular person from the database. Finally, a table is populated with the information of the selected person.
View Replies !
MySQL Database In A Pulldown Menu
I have a script that I am trying run with PHP, that gets the contents of a database, and then arrange them in a pulldown menu. I then have that selected Name, for instance, and then I can choose between 2 Buttons. Edit and Delete. PHP Code:
View Replies !
Dynamic MySQL Nav Menu Sorting
I have this dynamic menu and I want to change the order of the menu items... I added a column in the database wich has an integer value for ordering the menuitems. But the only way is by hardcoding them into the database. I would like a way to sort them with drag-and-drop or with up/down arrows. Do you think that except PHP & MYsql I will need Javascript as well ? Any ideas how to do that ?
View Replies !
Mysql Fetch With Drop Down Menu
Im trying to do somekind of dropdown menu taking information from the database but im not quite sure how this could be done with my knowledge. alright so lets say i have a table named: projects SELECT name FROM project. and it will put all the data found in a html drop down menu?
View Replies !
Form / Drop Down Menu / MySql
I need to have a drop down list inside of a form which retrieves the data for the drop down list from a MySql Database. The data is in a table that will constantly be growing so obviously the items in the drop down list will grow as well. So the table is called "Songs" and the field is s_title. When the drop down list retreives the data I need it to place the songs in alphabetical order as well.
View Replies !
MySQL Results Into Drop Down Menu
I have a site populates a drop down menu with options, say... Option 1 Option 2 Option 3 Option 4 If i customer is currently set to Option 3, i'd like this to be at the top of the Drop down menu and therefore the default option. This seems like a pretty simple thing but their doesn't seem to be a quick fix.
View Replies !
|
TRACKER
