dewey_witt Posted July 19, 2007 Share Posted July 19, 2007 OK say i have this form below. I need to put just the VALUES into a mysql database table. How? I need just the values. Please Help! <form action="somephp.php" method="post" enctype="multipart/form-data" multiple="multiple"> <input name="thing[]" type="checkbox" value="Thing One" /> <input name="thing[]" type="checkbox" value="Thing Two" /> <input name="thing[]" type="checkbox" value="Thing Three" /> <input name="thing[]" type="checkbox" value="Thing Four" /> </form> Quote Link to comment Share on other sites More sharing options...
kael.shipman Posted July 19, 2007 Share Posted July 19, 2007 Isn't that usually what you do with form inputs - use the VALUES? Sorry to be short, but you may consider actually learning the language a bit before posting; this is all in the manual: <?php //Access the variable with the $_POST array $things = $_POST['thing']; //$things is now a numerically indexed array with only the checked values. foreach($things as $thing) { mysql_real_escape_string($thing); mysql_query("insert into things set thing = '$thing'"); } ?> In the above, if I checked Thing One, Thing Three and Thing Four, your $things array would be this: <?php $things = array(0=>'Thing One', 1=>'Thing Three', 2=>'Thing Four'); ?> Quote Link to comment Share on other sites More sharing options...
dewey_witt Posted July 19, 2007 Author Share Posted July 19, 2007 Well thanx. And I tried the manual. Im a "show me" type. I know too many languages I think. But again thank you. Quote Link to comment Share on other sites More sharing options...
kael.shipman Posted July 20, 2007 Share Posted July 20, 2007 My mistake; I thought you were just taking the easy way out . Sorry! Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.