 |  |  |  |  |  |  |  |
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
| 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.
Latest PHP Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
.htaccess ajax alerts apache api array autocomplete beginner binary broken cakephp checkbox class cms code convert cron curl database date display dynamic echo email emptydisplayvalue error explodefunction file files folder form forms function functions google hack href htaccess html htmlspecialchars image include insert integration ip java javascript joomla keywords limit link login loop mail menu methods mlm multiple mysql network object oop paypal pdf php problem query radio random recursion recursive redirect regex remote script search securephp server sessions shot sms soap source space sql subscription syntax system table tutorial update upload url validation validator variable video web xml youtube
