i want get all values from checkbox and insert it on one column like 1,2,3
that my code , i don't know what's wrong
<form method="post" style="display:inline">
<label><input type="checkbox" name="data[]" value="1">1</label>
<label><input type="checkbox" name="data[]" value="2">2</label>
<label><input type="checkbox" name="data[]" value="3">3</label>
</form>
<?php
if ($_POST['do'] =="insertawards")
{
$media_array = $_POST['data'];
$values = array();
foreach($media_array as $value)
{
$values[] = $value;
}
$values = implode(',', $values);
$db->query_write("INSERT INTO " . TABLE_PREFIX . " awards (awards_forumid,awards_userid,awards_name,awards_link)
VALUES('".$values."','0','".$_POST['awards_name']."','".$_POST['awards_link']."') ");
}
?>
when i used implode , i get error and inserting 0 on datbase
$media_array = $_POST['data'];
foreach ($media_array as $one_media)
{
$source .= $one_media;
}
$source = implode(',', $source);