post from multiple checkboxes php mysql

Question

my form data im listed my table sample 10 records.

<td class='table-checkbox'><input type="checkbox" name="product[]" value="1" class='selectable-checkbox'></td>
    <td><div class="input-mini">
    <input type="text" id="spinnn"  name="quantity[]" value="5" class='spinner'/>
    </div>
    </td>
    </tr>

..... .....

my php code

$carino = $_POST['carino']; 
$quantity = $_POST['quantity']; 
$product = $_POST['product'];
foreach($product as $product){ 
foreach($quantity as $quantity ){ 
$sql = "INSERT INTO mytable (product,quantity,cno) VALUES ('$product','$quantity','$carino')";
mysql_query($sql);
}}

i want to be insert this data my table. but my foreach is wrong how can i do ?

product is unique

my table

product - quantity - cno
1            5        2   
2            10       2

http://pastie.org/private/nwrrinnxlrumt6p3kuyq#11,13-14,19

Skewled · Accepted Answer · 2014-04-17 19:24:39Z

1

This:

<?php 

if(isset($_POST['submit'])) {

    $carino = "2"; 

    $adet = $_POST['adet'];
    $urunno = $_POST['urunno'];
    $total = count($_POST['adet']);

    echo '<hr>'; 

    foreach ($urunno as $checked)
            {
            $value = $checked - 1;
                echo "Value of Urunno: $checked:  Adet: $adet[$value] <br>";
                echo "INSERT INTO member_interests
                    (`urun`,`adet`,'carino')
                VALUES
                    ('$checked','$adet[$value]','$carino')<br>";
            }
    }
?>

<tr>
<form method="post" action="<?php $_SERVER['PHP_SELF']; ?>">
<td class='table-checkbox'><input type="checkbox" name="urunno[]" value="1">Product One</td>
<input type="text" id="spinnn"  name="adet[]" class='spinner'/>
<td class='table-checkbox'><input type="checkbox" name="urunno[]" value="2">Product Two</td>
<input type="text" id="spinnn"  name="adet[]" class='spinner'/>
<td class='table-checkbox'><input type="checkbox" name="urunno[]" value="3">Product Three</td>
<input type="text" id="spinnn"  name="adet[]" class='spinner'/>
<td><div class="input-mini">
<input type="submit" name="submit" value="run" />
</form>
</div>
</td>
</tr>
</tbody>
</table>
</div>

Output:

Value of Urunno: 2: Adet: 2 
INSERT INTO member_interests (`urun`,`adet`,'carino') VALUES ('2','2','2')
Value of Urunno: 3: Adet: 3 
INSERT INTO member_interests (`urun`,`adet`,'carino') VALUES ('3','3','2')

edited Apr 17, 2014 at 19:24

answered Apr 16, 2014 at 16:32

Skewled

7834 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

10 Comments

sinan Over a year ago

is wrong because, urunno must be unique i updated my question.

Skewled Over a year ago

The is an example of working with the data, you had nested foreach loops and I wanted you to visually see what was happening. I changed it to a for loop for you, to show you what the result would be.

sinan Over a year ago

hello, i find a bug. e.g im listed two products. i selected two products no problem. but im select firstly product not problem. but im select only secondly product my adet valuse is 0 but urun id correct how can resolve thiş bug ?

sinan Over a year ago

if i m select all checkbox not making error. else i check two or one checkbox code not running, where is the problem ?

Skewled Over a year ago

because you have to pass a value even if it is 0

|

Hidde · Accepted Answer · 2014-04-16 16:21:14Z

1

The logic can be as follows (think of the code yourself, or search on the internet):

Make sure that all POST arrays are the same length (they should be)
Loop over the count from 0 to the length of the arrays
Insert the value at that point in each of the arrays into the database.

A quick tip: you are very susceptible to SQL injection. If this is production code, either use prepared queries, or use a PHP database wrapper like PDO to do it for you. The mysql_... functions are deprecated.

answered Apr 16, 2014 at 16:21

Hidde

12k8 gold badges46 silver badges71 bronze badges

Comments

Anand Somasekhar · Accepted Answer · 2014-04-18 05:54:31Z

1

    Try this one  
      <?php
        //add the database connection
        ?>
        <form name="myform" action="">
        <table>
        <?php 
        $length=//how many time below check box repeat in this page
        for($i=0;$i<$length;$i++){?>
        <tr>
        <td class='table-checkbox'>
        <input type="checkbox" name="urunno[]" value="<?php echo $i;?>" class='selectable-checkbox'>
        </td>
        <td>c1k</td>
        <td>2147483647</td>
        <td>520</td>
        <td>435345345 A.Ş.</td>
        <td>
        <div class="input-mini">
        <input type="text" id="spinnn"  name="adet<?php echo $i;?>" class='spinner'/>
        </div>
        </td>
        </tr>
        <?php
        }?>
        </table>
        <input type="submit" name="submit" value="Submit">
        </form>
        <?php
        if(isset($_post['submit']))
        {
        $carino = $_POST['carino'];  //here this element not present in question, i am also follow this
        $adet = $_POST['adet']; 
        $urunno = $_POST['urunno'];
        $length=sizeof($urunno);
        for($i=0;$i<$length;$i++)
        {
          $urun1=$urunno[$i];
          $adet1=$adet[$urun1];
          $sql = "INSERT INTO table (urunno,adet,cno) VALUES ('$urun1','$adet1','$carino')";
          mysql_query($sql);

          //the above code insert sql work in every time //otherwise use batch insert
           //refrer this link http://stackoverflow.com/questions/12960569/mysql-bulk-insert-via-php

        }
}?>

edited Apr 18, 2014 at 5:54

answered Apr 16, 2014 at 16:42

Anand Somasekhar

5701 gold badge11 silver badges20 bronze badges

2 Comments

sinan Over a year ago

if i m select all checkbox not making error. else i check two or one checkbox code not running, where is the problem ?

Anand Somasekhar Over a year ago

please check it this now ?

Collectives™ on Stack Overflow

post from multiple checkboxes php mysql

3 Answers 3

10 Comments

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

10 Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related