PHP forums, MySQL forums, Web Development resources

Home PageHome    PHP ResourcesTopic List    FAQFAQ    SearchSearch    MemberlistMemberlist    UsergroupsUsergroups 
 RegisterRegister
    ProfileProfile    Log in to check your private messagesLog in to check your private messages    Download the RSS Reader RSS Feed Download the RSS Reader RSS for this forum Log inLog in 

PHP Forum :: MySQL Forum :: Java Script Forum



How do I get from check box to sql query string?

 
Post new topic   Reply to topic    WeberForums.com Forum Index -> PHP General
View previous topic :: View next topic  
Author Message
larryhagmansbigdayout



Joined: 28 Mar 2008
Posts: 2

PostPosted: Fri Mar 28, 2008 1:29 pm    Post subject: How do I get from check box to sql query string? Reply with quote

Hi Folks,

Lets say I put a dozen checkboxes on a form(or combo boxes) to enable the user to make a selection.
How will I get the selection the user clicks on to add to my sql query string.
Lets ay the user clikcs on all the boxes then I would want each selection somehow transferred to the qsl to manipulate the DB ans put it back out on a form
Any suggestions.most welcome

Larry
Back to top
View user's profile Send private message
larryhagmansbigdayout



Joined: 28 Mar 2008
Posts: 2

PostPosted: Fri Mar 28, 2008 9:48 pm    Post subject: Reply with quote

hmmm Rolling Eyes ...nope just had a go at putting the field names in a variable but that didn't work Crying or Very sad


Larry Wink
Back to top
View user's profile Send private message
lostboy



Joined: 02 May 2004
Posts: 4958
Location: toronto, canada

PostPosted: Sat Mar 29, 2008 5:01 am    Post subject: Reply with quote

If they all have the same name,they come in as an array. So you can
implode()
foreach()

and so on

You can test this with

Code:

echo "<pre>";
print_r($_POST);
echo "</pre>";

_________________
Lostboy

Cat, the other other white meat

Please read Posting Etiquette before posting

You can always try Google
Back to top
View user's profile Send private message Send e-mail AIM Address MSN Messenger
Display posts from previous:   
WeberTrivia Questions WeberTrivia Questions
 Think you are smart? Prove it!. Try your skills with these questions :
 WeberTrivia QuestionsRecursive arrays and multi-dimensional arrays are one and the same. (PHP and MySQL)
 WeberTrivia QuestionsThe \"cache_dir\" tag of the squid configuration has a default of /var/spool/squid. (Linux)

WeberTrivia Questions



PHP Code Examples
 Stream diffrent sizes of images from a single image to save disk space.
 JavaScript dropdown list menu to switch any page.
 Dump the contents of a PHP variable in html format with a recursive list of subfolders and files from a given root directory.
 PHP Dump in html format the contents of one array variable with a recursive list of the nested array variables inside.
 Link Extractor - This function is used to extract links from a given URL. This will convert relative path into absolute path and also remove PHPSESSID stuff.
 Building a Dynamic Form using Javascript and innerHTML. Add form elements in realtime without refreshing the page.
 A PHP Calendar function with CSS : add a cool calendar to any php page by just adding a calendar class based function.
Post new topic   Reply to topic    WeberForums.com Forum Index -> PHP General All times are GMT + 2 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum






Powered by phpBB © 2001, 2005 phpBB Group
PHP Forum :: MySQL Forum :: Java Script Forum