 |  |  |  |  |  |  |  |
Checkbox Arrays ARGH!!
Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
Thread Solved |
•
•
Join Date: Aug 2007
Posts: 52
Reputation: 
Solved Threads: 5
Junior Poster in Training
Hello all,
I have a form that contains checkboxes to update a database with either "Yes" or "No" based on the user selection.
The check boxes are in an array with the values set to a "LinkID"
example:
I have the following insert statement that works as long as the values are "Yes":
However, I need this to also update the datebase if the user unchecks the checkbox (BTW there are 4 checkboxes "Add", "Update" "Delete", and "View") or the checkbox has not been selected.
Can anyone point me in the right direction ?
Many thanks in advance!
I have a form that contains checkboxes to update a database with either "Yes" or "No" based on the user selection.
The check boxes are in an array with the values set to a "LinkID"
example:
php Syntax (Toggle Plain Text)
I have the following insert statement that works as long as the values are "Yes":
php Syntax (Toggle Plain Text)
However, I need this to also update the datebase if the user unchecks the checkbox (BTW there are 4 checkboxes "Add", "Update" "Delete", and "View") or the checkbox has not been selected.
Can anyone point me in the right direction ?
Many thanks in advance!
I keep hitting "escape", but I'm still here!!!!
:}
:}
When checkboxes are sent in requests as "on" if they are checked, if they are not checked they aren't sent at all. You're also missing an if on line 20
GCS d- s+ a-->? C++(++++) UL+++ P+>+++ L+++ E--- W+++
N+ o K w++(---) O? !M- V PS+>++ PE+ Y+ PGP !t- 5? X- R tv+
b+>++ DI+ D G++>+++ e+ h+>++ r y+
PMs asking for help will not be answered, post on the forums. That's what they're there for.
N+ o K w++(---) O? !M- V PS+>++ PE+ Y+ PGP !t- 5? X- R tv+
b+>++ DI+ D G++>+++ e+ h+>++ r y+
PMs asking for help will not be answered, post on the forums. That's what they're there for.
•
•
Join Date: Aug 2007
Posts: 52
Reputation:
Solved Threads: 5
Junior Poster in Training
Thanks for the input. I do see that the "if" is missing as I was doing the "cut and paste thing".
I understand what you are saying there, but unsure right now on how to exactly write what I need it to do..
basically the concept here is
I display the users assigned menus along with 4 checkboxes (Add, Update, Delete, View)...These checkboxes are an aray populated with the values contained within the db. Additionally, this checkbox array is given a value that is a constant within the repeating region.
ex:
what I want to do is:
if the user changes any values in the checkbox array, I need the db updated with all changes. I used the constant value within the array to maintain the correct record to be updated on change.
I have it working to updating and added yes values, but keep getting "stumped" on the next part...;}
any example you can thing of would me most appreciated
I understand what you are saying there, but unsure right now on how to exactly write what I need it to do..
basically the concept here is
I display the users assigned menus along with 4 checkboxes (Add, Update, Delete, View)...These checkboxes are an aray populated with the values contained within the db. Additionally, this checkbox array is given a value that is a constant within the repeating region.
ex:
php Syntax (Toggle Plain Text)
what I want to do is:
if the user changes any values in the checkbox array, I need the db updated with all changes. I used the constant value within the array to maintain the correct record to be updated on change.
I have it working to updating and added yes values, but keep getting "stumped" on the next part...;}
any example you can thing of would me most appreciated
Last edited by JeniF; Feb 27th, 2008 at 9:50 pm. Reason: typo
I keep hitting "escape", but I'm still here!!!!
:}
:}
•
•
Join Date: Jun 2007
Posts: 1,227
Reputation:
Solved Threads: 167
i know i can create you some working code if i understand what you are trying to do more. do you have an online example to look at?
•
•
•
•
if the user changes any values in the checkbox array, I need the db updated with all changes.
Ignorance is definitely not bliss!
*PM asking for help will be ignored*
*PM asking for help will be ignored*
•
•
Join Date: Aug 2007
Posts: 52
Reputation:
Solved Threads: 5
Junior Poster in Training
Hey there,
Yes after my "Brain-Cloud" left me for the day, I realized that I needed to delete the original values stored and reset them with the new values.
I managed to get this done.
Thanks for the "heads-up" on that one...
If anyone is interested in the code, let me know and I will post it
Yes after my "Brain-Cloud" left me for the day, I realized that I needed to delete the original values stored and reset them with the new values.
I managed to get this done.
Thanks for the "heads-up" on that one...
If anyone is interested in the code, let me know and I will post it
I keep hitting "escape", but I'm still here!!!!
:}
:}
Yep. Please post your code. If anyone come across the same problem, this thread might be useful. Ignorance is definitely not bliss!
*PM asking for help will be ignored*
*PM asking for help will be ignored*
•
•
Join Date: Aug 2007
Posts: 52
Reputation:
Solved Threads: 5
Junior Poster in Training
Here is the code that I used and tested:
php Syntax (Toggle Plain Text)
I keep hitting "escape", but I'm still here!!!!
:}
:}
 |
Other Threads in the PHP Forum
- Previous Thread: PHP tags into HTML tags
- Next Thread: Not getting information from the database
Views: 1467 | Replies: 7
| Thread Tools | Search this Thread |
Latest PHP Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for PHP
.htaccess access ajax apache api array beginner binary broken cakephp checkbox class cms code cron curl database date datepart directory display download dynamic echo email error file files folder form forms function functions google href htaccess html image include insert integration ip java javascript joomla jquery limit link list login loop mail menu methods mlm mod_rewrite multiple mysql oop parse password paypal pdf php problem query radio random recursion regex remote script search select seo server sessions sms soap source space speed sql structure syntax system table tutorial update updates upload url validation validator variable video web webdesign xml youtube
