how to insert array (checkbox) into BD?

wounded_soul

Greeting 😉

i hve qestion i dont know how to solve it . i didt many search but ,,

anyway,i want to insert the values of array into database .

this my code:

<?php



$result=mysql_query("SELECT * FROM tool where Type ='decoration' ");

echo"<input type='hidden' name='dec' value='".$result['Type']."'><b>Decoration</b><br>";
echo "<img src='images/111.jpg' width='120' height='120' />&nbsp;&nbsp;&nbsp;&nbsp;<br>&nbsp;&nbsp;&nbsp;&nbsp;";

$dec=$_session['dec'];
echo "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Quantity&nbsp;&nbsp;&nbsp;Price (Per 10 Pieces)<br>";

WHILE($row=mysql_fetch_array($result))
{
echo "<input type='checkbox' name='de[]' value='".$row['Id']."' />".$row['Title']."&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input type='text' id='' size=2 maxlength='2' title='Year' onKeyPress='return YearDigitsOnly(window.event)' >&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(".$row['Price']." BD)<br>"; 
}

echo "<hr></hr></td></tr>";

?>

insert code :


extract($_POST);

$de_array=$_POST['de']; 	
if(isset($dec))
{	
	foreach ($de_array as $one_de)
{
$source .= $one_de.", "; 
}
$de= substr($source, 0, -2); 

$query = "INSERT INTO tool_request  VALUES('$resvID','$de')"; 
$result = mysql_query($query);

}

i hope get help

NogDog

If the goal is to insert the values as a comma-separated string, you could just implode the array:

$deValues = implode(',', $_POST['de']);

Then just use $deValues as the value to be inserted for that field.

Whether that is really the best solution, though, depends on why you want to do that, and whether it really makes more sense to insert each value into a separate, relational table; or perhaps just serialize() the array and store that value in the DB, instead (and just unserialize() it when you read it from the DB later).