如何将动态生成的表单存储不同的字段值返回数据库php mysql？

问题描述：

I am beginner in php mysql and I have a problem below picture type of form how to save values of all rows or only selected row fields values:- name of fields are as :-

  foreach($data as $row){
 <tr>
  <td><input type="checkbox" value="$row['ProductID']" name="productID[]" /></td>
  <td>     <input type="text" value="$row['Quantity']" name="quantity[]" /></td>
 <td><input type="text" value="$row['Price']" name="price[]" /></td>
 </tr>
}

1. Question is How to get only selected row fields value in php or jquery I have no Idea how to get only selected row fields value in php

我是php mysql的初学者，我有一个问题，如下图片类型的表格如何保存所有行的值或仅选择的行字段值： - 字段的名称为： - p>

  foreach（$ data as $ row）{
＆lt; tr＆gt; 
＆lt; td＆gt;  ＆lt; input type =“checkbox”value =“$ row ['ProductID']”name =“productID []”/＆gt;＆lt; / td＆gt; 
＆lt; td＆gt;  ＆lt; input type =“text”value =“$ row ['Quantity']”name =“quantity []”/＆gt;＆lt; / td＆gt; 
＆lt; td＆gt;＆lt; input type =“text”value =  “$ row ['Price']”name =“price []”/＆gt;＆lt; / td＆gt; 
＆lt; / tr＆gt; 
} 
  code>  pre> 
 
     p> 
 
 
  1。 问题是如何在php或jquery中只获取选定的行字段值 strong> 
我不知道如何只获取php中选定的行字段值 p> 
  div>

答

If you are trying to get a listing of all your items with a note whether selected or not, just change your form names a bit (If I understand what you are looking for...):

<?php 
    $data[] =   array('ProductID'=>123,"Quantity"=>1,"Price"=>"2.00");
    $data[] =   array('ProductID'=>234,"Quantity"=>2,"Price"=>"1.50");
    $data[] =   array('ProductID'=>345,"Quantity"=>1,"Price"=>"4.59");
    $data[] =   array('ProductID'=>456,"Quantity"=>4,"Price"=>"1.99");

    foreach($data as $row){ ?>
    <tr>
        <td><input type="checkbox" name="product[<?php echo $row['ProductID'];?>][select]" /></td>
        <td><input type="text" value="<?php echo $row['Quantity']; ?>" name="product[<?php echo $row['ProductID'];?>][qty]" /></td>
        <td><input type="text" value="<?php echo $row['Price']; ?>" name="product[<?php echo $row['ProductID'];?>][price]" /></td>
    </tr>
<?php }

Gives you:

// Just loop through the [product] array looking for the 'select' = 'on' 
Array
(
    [product] => Array
        (
            [123] => Array
                (
                    [qty] => 1
                    [price] => 2.00
                )

            [234] => Array
                (
                    [select] => on
                    [qty] => 2
                    [price] => 1.50
                )

            [345] => Array
                (
                    [qty] => 1
                    [price] => 4.59
                )

            [456] => Array
                (
                    [qty] => 4
                    [price] => 1.99
                )
        )
)

To get the selected items:

if(!empty($_POST['product'])) {
    foreach($_POST['product'] as $row) {
            if(!empty($row['select'])) {
                    print_r($row);
                }
        }
}

如何将动态生成的表单存储不同的字段值返回数据库php mysql？

相关推荐