current community

your communities

more stack exchange communities

Stack Exchange
tour help
careers 2.0
Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 0 down vote favorite

Here is my existing code i have my db looks like this

req table
test_id(auto increment)    test_work varchar(50)

<?php
include_once '../connect.php'; //database connection
if($_COOKIE["Utype"]!="Logistic")
{
                header("Location: login.php");
}

if(!isset($_POST['mat']))
{
     $checkboxValue = false;
} else {
     $checkboxValue = $_POST['mat'];
}

$values = implode(",", $_POST["mat"]);

$sql="Insert into req(test_work)
values ('$values')";
$result=mysql_query($sql);

?>


<script>
function toggle(source) {
  checkboxes = document.getElementsByName('mat[]');
  for(var i=0, n=checkboxes.length;i<n;i++) {
    checkboxes[i].checked = source.checked;
  }
}

$('input[type="checkbox"]').on('change', function(e){
        if($(this).prop('checked'))
        {
            $(this).next().val(1);
        } else {
            $(this).next().val(0);
        }
});

</script>
<form name="form" action="test.php" method="post">
<table border="1" width="200px" style="position:relative;top:0px;font-family:tahoma;font-size:12px;border-collapse:collapse">

<tr style="background-color:#f3f3f3">
<th width="2%"></th>
<th height="20px" width="15%">Work Order ID</th>
</tr>
<?php 
$resource=mysql_query("Select * from test",$con);

while($result2=mysql_fetch_array($resource))
    { 
    ?>
<tr style="background-color:#ffffff">
<td align="center"><input type="checkbox" name="mat[]" id="mat" value="<?php  echo $result2["id"]; ?>"/><?php  echo $result2["id"]; ?></td>
<td><?php  echo $result2["name"]; ?></td>
</tr>
<?php };?>
</table>
<input style="color:#FFFFFF;position:relative;width:70px"type="submit" name="submit" id="submit" value="Save" class="imgClass" height="50px">
</form>

This can insert only one checked checkbox. but if i check multiple checkboxes it only inserts one value.

How can I do single and also multiple(with comma separated) inserts? Like

as if i selected four checkbox from the array

 req table
    test_id(auto increment)    test_work varchar(50)
    23                         1, 2, 3, 4

and it omits the comma when i only select one checkbox

 req table
        test_id(auto increment)    test_work varchar(50)
        23                         1
share|improve this question
    
code looks good did u try echo $sql; and see how it looks like ? –  Abhik Chakraborty Jan 23 at 17:28

2 Answers 2

up vote 0 down vote

So instead of inserting one record into req, with a value for test_work of 'val1,val2,val3', you want it to insert three records with values of 'val1', 'val2', 'val3', right?

In that case, try this:

if(!isset($_POST['mat']))
{
    $checkboxValue = false;
} else {
    $checkboxValue = $_POST['mat'];
    foreach($_POST['mat'] as $val)
    {
        $query = "INSERT INTO req (test_work) VALUES ('$val')";
        mysql_query($query);
    }
}
share|improve this answer
    
I have updated my question sir.. –  user3117337 Jan 23 at 17:34
    
Your update still doesn't make it clear. In the code you are inserting data into a column called test_work, but your update calls the column mat_id. –  Rob Jan 23 at 17:37
    
No, i needed it with comma separated. –  user3117337 Jan 23 at 17:38
    
You need what column comma separated? mat_id, or test_work? Also, what is the data type of the column and it's size? –  Rob Jan 23 at 17:40
    
I updated it again.. im sorry. haha –  user3117337 Jan 23 at 17:42
up vote 0 down vote

This works. Your code will take multiple checkboxes and produce a string like: 1,2,5.

This will insert one row into your database where the "test_work" column has the value 1,2,5.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.