•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the PHP section within the Web Development category of DaniWeb, a massive community of 374,185 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,446 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our PHP advertiser: Lunarpages PHP Web Hosting
Views: 273 | Replies: 4
 |
•
•
Join Date: Dec 2007
Posts: 5
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
for example :
I have 4 check box with their own variables a,b,c,d
How can I create query with condition using what users choose,
where users can choose more than one check box
thanks for your support
I have 4 check box with their own variables a,b,c,d
How can I create query with condition using what users choose,
where users can choose more than one check box
thanks for your support
•
•
Join Date: Nov 2007
Location: Arkansas
Posts: 250
Reputation:
Rep Power: 1
Solved Threads: 45
Posting Whiz in Training
What type of query (SELECT, UPDATE, INSERT...). Also, can you provide the html for the checkboxes?
•
•
Join Date: May 2008
Posts: 2
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
maybe something like:
"select.....blah blah....where a = $_POST['checkboxarrayname']['a'] and b = $_POST['checkboxarrayname']['b']"
and the html is:
<input type='checkbox' name='checkboxarrayname[a]' value='1'>
basically using posting array variables
HTH
"select.....blah blah....where a = $_POST['checkboxarrayname']['a'] and b = $_POST['checkboxarrayname']['b']"
and the html is:
<input type='checkbox' name='checkboxarrayname[a]' value='1'>
basically using posting array variables
HTH
•
•
Join Date: Dec 2007
Posts: 5
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
the problem is we don't know which checkbox is checked and count how many checkbox is checked, example we know 2 checkbox is checked so the query is two condition. if three checkbox is checked so the query is three condition.
can I make a query with a dinamic condition according how many checkbox is checked?
can I make a query with a dinamic condition according how many checkbox is checked?
•
•
Join Date: Nov 2007
Location: Bangalore, India
Posts: 3,042
Reputation:
Rep Power: 8
Solved Threads: 227
When you submit the page, only those checkboxes which were checked will be submitted. So, you will have the count of checkboxes which are checked, you will have all the checkboxes which were checked. Build your query depending upon those values.
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.
*PM asking for help will be ignored*
*PM asking for help will be ignored*
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb PHP Marketplace
Linear Mode
Similar Threads
- Creating a dynamic query using MSSQL and PHP (PHP)
- Dynamic query string (Search Engine Optimization)
- Dynamic Query (JSP)
- Dynamic Initialization implies Dynamic Help (C++)
- Help with dynamic menu (HTML and CSS)
- dynamic content from database, How? (Database Design)
Other Threads in the PHP Forum
- Previous Thread: How to php export to excel
- Next Thread: php / sql insert script error
