 |  |  |  |  |  |  |  |
Field List Input Problem
Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
Thread Solved
 |
I am working of a musicians volunteer DB. I have a ADD Volunteer page:
Then I target a page that does the ADD:
I, also, have a EDIT Volunteer page:
Then I target a page that does the UPDATE:
Three issues I need help to resolve:
1) When I select more then one choice from my Instrument field, then select the ADD button, the multiple selections do not carry over to my mySQL table record. Only one value does. The field is a varchar type with plenty of characters allowed.
2) Once I get the data into my DB properly, I need to then be able to have it display properly when I retrieve it on my Update Volunteer Entry page.
3) Eventually, I will establish a Performance Date table in which I will assign Volunteers to performances. When I add a Volunteer:
IF they have multiple instruments they play, I would to provide the user a menu of choices for the field, based of the field Volunteer::Instrument
ELSE
Display it this way: Instrument - Piano
END IF
On a personal note, this is a online DB I am working on for the local Rescue Mission (Homeless Shelter Program). This is my first PHP/mySQL project, so I got much to learn. But once I see how things are done, I catch on pretty quickly.
If there is anyone who would like to volunteer their services to assist me in finishing this project for them, I could make sure you get a Letter of Donated Services from the the Non-Profit organization(tax right off). Just give me a PRIVATE message, if you are willing to help.
Thanks and I appreciate any help that can be offered.
PHP Syntax (Toggle Plain Text)
Then I target a page that does the ADD:
PHP Syntax (Toggle Plain Text)
I, also, have a EDIT Volunteer page:
PHP Syntax (Toggle Plain Text)
Then I target a page that does the UPDATE:
PHP Syntax (Toggle Plain Text)
Three issues I need help to resolve:
1) When I select more then one choice from my Instrument field, then select the ADD button, the multiple selections do not carry over to my mySQL table record. Only one value does. The field is a varchar type with plenty of characters allowed.
2) Once I get the data into my DB properly, I need to then be able to have it display properly when I retrieve it on my Update Volunteer Entry page.
3) Eventually, I will establish a Performance Date table in which I will assign Volunteers to performances. When I add a Volunteer:
IF they have multiple instruments they play, I would to provide the user a menu of choices for the field, based of the field Volunteer::Instrument
ELSE
Display it this way: Instrument - Piano
END IF
On a personal note, this is a online DB I am working on for the local Rescue Mission (Homeless Shelter Program). This is my first PHP/mySQL project, so I got much to learn. But once I see how things are done, I catch on pretty quickly.
If there is anyone who would like to volunteer their services to assist me in finishing this project for them, I could make sure you get a Letter of Donated Services from the the Non-Profit organization(tax right off). Just give me a PRIVATE message, if you are willing to help.
Thanks and I appreciate any help that can be offered.
•
•
Join Date: Jun 2007
Posts: 1,225
Reputation: 
Solved Threads: 166
You need to change the name of the instrument select element to "Instrument[]". Then when adding to the database run
On the update page you will need to put the instruments into an array and loop through them checking if they are selected (You should also do this for the add page as it will help keep the data uniform and prevent errors).
ex.
and then echo
Make sure you sanitize your input by adding field validation and using
implode(',',$Instrument); because it will return an array of selected elements. Implode will put them into a comma separated string so it can be put into the database.On the update page you will need to put the instruments into an array and loop through them checking if they are selected (You should also do this for the add page as it will help keep the data uniform and prevent errors).
ex.
PHP Syntax (Toggle Plain Text)
and then echo
$options where the options for the select should be in the update form.Make sure you sanitize your input by adding field validation and using
mysql_real_escape_string to prevent sql injection. Last edited by kkeith29; Jul 3rd, 2009 at 3:06 pm.
•
•
•
•
Originally Posted by kkeith29 
You need to change the name of the instrument select element to "Instrument[]". Then when adding to the database runimplode(',',$Instrument);because it will return an array of selected elements. Implode will put them into a comma separated string so it can be put into the database.
On the update page you will need to put the instruments into an array and loop through them checking if they are selected (You should also do this for the add page as it will help keep the data uniform and prevent errors).
ex.
PHP Syntax (Toggle Plain Text)
and then echo$optionswhere the options for the select should be in the update form.
Make sure you sanitize your input by adding field validation and usingmysql_real_escape_stringto prevent sql injection.
I really appreciate it.
•
•
Join Date: Jun 2007
Posts: 1,225
Reputation:
Solved Threads: 166
This is the add page. It submits to itself now since there is no reason to have another page process it.
Put this code on one page:
You can change where the errors and result go. You need to add validation to the forms.
I am working on the edit page.
Put this code on one page:
PHP Syntax (Toggle Plain Text)
You can change where the errors and result go. You need to add validation to the forms.
I am working on the edit page.
•
•
•
•
Originally Posted by kkeith29
You need to change the name of the instrument select element to "Instrument[]". Then when adding to the database runimplode(',',$Instrument);because it will return an array of selected elements. Implode will put them into a comma separated string so it can be put into the database.
On the update page you will need to put the instruments into an array and loop through them checking if they are selected (You should also do this for the add page as it will help keep the data uniform and prevent errors).
ex.
PHP Syntax (Toggle Plain Text)
and then echo$optionswhere the options for the select should be in the update form.
Make sure you sanitize your input by adding field validation and usingmysql_real_escape_stringto prevent sql injection.
PHP Syntax (Toggle Plain Text)
And my HTML is formatted like this:
PHP Syntax (Toggle Plain Text)
Hopefully it something simple in the HTML or PHP.
It's weird though... It shows a List (displayed very narrow) with the correct rows highlighted but NO VALUES ???
Thanks!!!
•
•
Join Date: Jun 2007
Posts: 1,225
Reputation:
Solved Threads: 166
It is my fault. I get to typing and miss simple stuff.
Change:
to
Change:
PHP Syntax (Toggle Plain Text)
PHP Syntax (Toggle Plain Text)
Google is your friend.
Use [code] tags.
If you have found a solution to your problem, please mark the thread as SOLVED.
Use [code] tags.
If you have found a solution to your problem, please mark the thread as SOLVED.
•
•
•
•
Originally Posted by kkeith29
It is my fault. I get to typing and miss simple stuff.
Change:
toPHP Syntax (Toggle Plain Text)
PHP Syntax (Toggle Plain Text)
Last edited by dwdata; Jul 3rd, 2009 at 10:04 pm.
|
Similar Threads
- Multi-Field List Box (VB.NET)
- AJAX created input field does not work in FireFox (JavaScript / DHTML / AJAX)
- Problem with input (ASP)
- Number input problem. (C++)
- php connection to mysql headache (PHP)
- Input for a solution to matrix problem (C)
- List <char *> Problem (C)
Other Threads in the PHP Forum
- Previous Thread: Regex help
- Next Thread: emailto option in php
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest PHP Posts
- Today's Posts
- Unanswered Threads
apache api array basic beginner binary body broken cakephp class cms code computing confirm cron curl customizableitems database date date/time delete display dynamic echo email error file files filter folder form forms forum function functions gc_maxlifetime global google headmethod href htaccess html iframe image include ip javascript joomla limit link list login malfunction memmory memory menu mlm msqli_multi_query multiple mycodeisbad mysql navigation oop parameter parsing paypal pdf php phpmysql query question random recourse recursion regex script search select seo server sessions snippet source space sql static system table thesishelp trouble tutorial update upload url variable video web webdesign xml youtube