| | |
insert checkbox values to database
Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
![]() |
•
•
Join Date: Aug 2008
Posts: 22
Reputation:
Solved Threads: 0
Bit of a php and sql issue, so thought I'd try here...
for a registration form, I have created an sql file such as...
...etc...for all the fields, which I then import to the database.
But then the form also has 15 checkboxes where the user may or may not check them. The checkboxes are hard coded and they all have the same name in an array, eg...
...etc...
The issue I am having is understanding how these values are stored in the database, since I have not created any rows in the sql file for the checkboxes. When I create the table and import it to the database, do I need to create one/some for the checkbox values???
Much help needed and appreciated, thanks!
for a registration form, I have created an sql file such as...
firstname varchar(30) not null ...etc...for all the fields, which I then import to the database.
But then the form also has 15 checkboxes where the user may or may not check them. The checkboxes are hard coded and they all have the same name in an array, eg...
MySQL Syntax (Toggle Plain Text)
<input type="checkbox" name="nature[]" value="0" /> <input type="checkbox" name="nature[]" value="1" /> <input type="checkbox" name="nature[]" value="2" />
...etc...
The issue I am having is understanding how these values are stored in the database, since I have not created any rows in the sql file for the checkboxes. When I create the table and import it to the database, do I need to create one/some for the checkbox values???
Much help needed and appreciated, thanks!
![]() |
Similar Threads
- inserting multiple selection from checkbox in to one column (JSP)
- insert checkbox list (VB.NET)
- inserting checkbox values in mysql +PHP (PHP)
- submiting info into a database for retrieval! (PHP)
Other Threads in the MySQL Forum
- Previous Thread: is my query wrong
- Next Thread: combine three tables
| Thread Tools | Search this Thread |
Tag cloud for MySQL
"use" 1 amazon api aws bizspark breathalyzer changingprices cmg communityjournalism contentmanagement contractors copyright count court crm data database design developer development distinct drupal dui ec2 eliminate email eudora facebook form foss gartner gnu government gpl groklaw groupware hiring hyperic images innerjoins insert ip joebrockmeier journalism keyword keywords kickfire laptop law legal license licensing linux managing mariadb matchingcolumns metron micromanage microsoft microsoftexchange mindtouch montywidenius mozilla multiple mysql mysqlcolumnupdating mysqlindex mysqlinternalqueries mysqlsearch news opendatabasealliance opengovernment opensource operand oracle pdf penelope php priceupdating query referencedesign remove reorderingcolumns results resultset search select simpledb sourcecode spotify sql statement sugarcrm syntax techsupport thunderbird transparency update virtualization





