php - Insert multiple checkbox into mysql -


so insert multiple checkbox mysql cant figured ou how.

selecting database , inserting:

$editformaction = $_server['php_self']; if (isset($_server['query_string'])) { $editformaction .= "?" . htmlentities($_server['query_string']); }  if ((isset($_post["mm_insert"])) && ($_post["mm_insert"] == "form1")) { $insertsql = sprintf("insert tournamenteams (id, id_tournament, id_team) values (%s, %s, %s)",    getsqlvaluestring($_post['id'], "int"),    getsqlvaluestring($_post['id_tournament'], "int"),    getsqlvaluestring($_post['id_team'], "int"));   mysql_select_db($database_searchon, $searchon); $result1 = mysql_query($insertsql, $searchon) or die(mysql_error()); } 

and created form , inside form theres checkbox. select database records , show on multiple checkbox , want selecting checkboxs want , insert when submit form, submit first checkbox mark.

form:

<form action="<?php echo $editformaction; ?>" method="post" name="form1" id="form1"> <select name="id_tournament"> <?php  {   ?> <option value="<?php echo $row_tournaments['id_tournament']?>" ><?php echo $row_tournaments['id_tournament']?></option> <?php } while ($row_tournaments = mysql_fetch_assoc($tournaments)); ?> </select> <?php { ?> <?php echo $row_teams['id_team']?>:<input type="checkbox" name="id_team" value="<?php echo $row_teams['id_team']?>" /> <?php } while ($row_teams = mysql_fetch_assoc($teams)); ?> <input type="submit" value="insert record" /> <input type="hidden" name="id" value="" /> <input type="hidden" name="mm_insert" value="form1" /> </form> 

checkbox:

<?php { ?> <?php echo $row_teams['id_team']?>:<input type="checkbox" name="id_team" value="<?php echo $row_teams['id_team']?>" /> <?php } while ($row_teams = mysql_fetch_assoc($teams)); ?> 

entire code better view:

<?php require_once('connections/searchon.php'); ?> <?php if (!function_exists("getsqlvaluestring")) { function getsqlvaluestring($thevalue, $thetype, $thedefinedvalue = "", $thenotdefinedvalue = "")  { if (php_version < 6) { $thevalue = get_magic_quotes_gpc() ? stripslashes($thevalue) : $thevalue; }  $thevalue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($thevalue) : mysql_escape_string($thevalue);  switch ($thetype) { case "text": $thevalue = ($thevalue != "") ? "'" . $thevalue . "'" : "null"; break;     case "long": case "int": $thevalue = ($thevalue != "") ? intval($thevalue) : "null"; break; case "double": $thevalue = ($thevalue != "") ? doubleval($thevalue) : "null"; break; case "date": $thevalue = ($thevalue != "") ? "'" . $thevalue . "'" : "null"; break; case "defined": $thevalue = ($thevalue != "") ? $thedefinedvalue : $thenotdefinedvalue; break; } return $thevalue; } }  $editformaction = $_server['php_self']; if (isset($_server['query_string'])) { $editformaction .= "?" . htmlentities($_server['query_string']); }    if ((isset($_post["mm_insert"])) && ($_post["mm_insert"] == "form1")) { $insertsql = sprintf("insert tournamenteams (id, id_tournament, id_team) values (%s, %s, %s)",    getsqlvaluestring($_post['id'], "int"),    getsqlvaluestring($_post['id_tournament'], "int"),    getsqlvaluestring($_post['id_team'], "int"));   mysql_select_db($database_searchon, $searchon); $result1 = mysql_query($insertsql, $searchon) or die(mysql_error()); }  mysql_select_db($database_searchon, $searchon); $query_tournamenteams = "select * tournamenteams"; $tournamenteams = mysql_query($query_tournamenteams, $searchon) or die(mysql_error()); $row_tournamenteams = mysql_fetch_assoc($tournamenteams); $totalrows_tournamenteams = mysql_num_rows($tournamenteams);  mysql_select_db($database_searchon, $searchon); $query_tournaments = "select * tournaments"; $tournaments = mysql_query($query_tournaments, $searchon) or die(mysql_error()); $row_tournaments = mysql_fetch_assoc($tournaments); $totalrows_tournaments = mysql_num_rows($tournaments);  mysql_select_db($database_searchon, $searchon); $query_teams = "select * teams"; $teams = mysql_query($query_teams, $searchon) or die(mysql_error()); $row_teams = mysql_fetch_assoc($teams); $totalrows_teams = mysql_num_rows($teams); ?>   <!doctype html public "-//w3c//dtd xhtml 1.0 transitional//en" "http://www.w3.org/tr/xhtml1/dtd/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="content-type" content="text/html; charset=utf-8" /> <title>untitled document</title> </head>  <body>  <form action="<?php echo $editformaction; ?>" method="post" name="form1" id="form1">   <select name="id_tournament"> <?php  {   ?> <option value="<?php echo $row_tournaments['id_tournament']?>" ><?php echo $row_tournaments['id_tournament']?></option> <?php } while ($row_tournaments = mysql_fetch_assoc($tournaments)); ?> </select>   <?php { ?> <?php echo $row_teams['id_team']?>:<input type="checkbox" name="id_team" value="<?php echo $row_teams['id_team']?>" /> <?php } while ($row_teams = mysql_fetch_assoc($teams)); ?>   <input type="submit" value="insert record" />  <input type="hidden" name="id" value="" /> <input type="hidden" name="mm_insert" value="form1" /> </form> <p>&nbsp;</p> <p>&nbsp;</p> </body> </html> <?php mysql_free_result($tournamenteams);  mysql_free_result($tournaments);  mysql_free_result($teams); ?> 

ps: im using dreamweaver since im still starting coding :)

any appreciated,

cumps.

in order have php receive every checkbox value (in array, naturally) put [] @ end of group's name. so, part create checkboxes should changed to:

<?php { ?> <?php echo $row_teams['id_team']?>:<input type="checkbox" name="id_team[]" value="<?php echo $row_teams['id_team']?>" /> <?php } while ($row_teams = mysql_fetch_assoc($teams)); ?> 

notice change in name="id_team[]".


Comments

Popular posts from this blog

twig - Using Twigbridge in a Laravel 5.1 Package -

jdbc - Not able to establish database connection in eclipse -

firemonkey - How do I make a beep sound in Android using Delphi and the API? -