Submit $_POST with dynamically generated fields

bambinou1980 · August 5, 2015

Hi All,

I am still on the learning curbe with PHP, I have created a form that generated fields based on the number of products in the database.

My problem now is to work out how to submit the $_POST data of each dynimically generated fields, I just cannot work out how I will manage to find the fields "name" in advance as the form data can grow from one product up to let's say 10.

Could you please give me some hints on the type of logic I should use as I really do not know(due to my beginner level) where to start on dynimically generated fields.

Thank you!

Ben

                       <form role="form" method="post" action="index.php">
                    
                        <div class="form-group">
                            <label for="name_id">
                                Customer Name *
                            </label>
                            <input type="text" name="customer_name" placeholder="Customer Name" class="form-control" id="name_id"/>
                        </div>
                        
                        <div class="form-group">
                            <label for="due_date_id">
                                Due Date *
                            </label>
                            <input type="text" name="due_date" placeholder="" class="form-control" id="duedate_id"/>
                        </div>
                        

                        
                        
                        <!--Product 1-->
                        <?php
                        $query_field1 = "SELECT * FROM products ORDER BY name desc";
                        $result_field1 = mysqli_query($connection, $query_field1) or die (mysqli_error());
                        $number = 0;
                        while($row_field1 = mysqli_fetch_array($result_field1)){
                        $name = $row_field1['name'];
                        $price1 = $row_field1['price1'];
                        $price2 = $row_field1['price2'];
                        $price3 = $row_field1['price3'];
                        ?>
                         <div class="form-inline well">
                         <label for="product1_id">Choose Product <?php echo ++$number; ?></label>
                        <div class="form-group">
                        <select name="product1" id="product1"  class="form-control">
                        
                         <option value="<?php echo $name; ?>" /><?php echo $name; ?></option>";
                         </select>
                                

                          
                         <label class="btn btn-default">
                        <input type="radio" id="price1_id" name="action" value="<?php echo $price1;?>" /> €<?php echo $price1;?>
                        </label>
                        
                        <?php if(($price2) != null) {
                        echo "<label class='btn btn-default'>
                        <input type='radio' id='price2_id' name='action' value='{$price2}'/> € {$price2}
                        </label>";
                        } ?>
                        
                        
                        
                        <?php if(($price3) != null) {
                        echo "<label class='btn btn-default'>
                        <input type='radio' id='price3_id' name='action' value='{$price3}'/> € {$price3}
                        </label>";
                        } ?>
                        

                        <label for="product1_id">Qty</label>
                        <input name="quantity1" id="quantity1" type="text" class="form-control" maxlength="4" size="4"><!--disabled="disabled"-->

                          </div>
                          </div>
                                                    <?php } ?>
                          
                        

                                                 
                        

                    
           

                        
                        
                        <div class="form-group">
                            <label for="address_id">
                                Address *
                            </label>
                            <textarea type="text" name="address" placeholder="Company's Address" rows="4" cols="50" class="form-control" id="address_id" value=""></textarea>
                        </div>
                        
                        <div class="form-group">
                            <label for="phone_id">
                                Phone
                            </label>
                            <input type="text" name="phone" placeholder="Customer Phone" class="form-control" id="phone_id" value=""  />
                        </div>
                        
                        <div class="form-group">
                            <label for="email_id">
                                Email
                            </label>
                            <input type="email" name="email" placeholder="Customer Email" class="form-control" id="email_id" value=""  />
                        </div>
                        
                        <div class="form-group">
                            <label for="vat_id">
                                V.A.T Number(ie:MT20343324)
                            </label>
                            <input type="text" name="vat" placeholder="V.A.T Number"  class="form-control" id="vat_id" value=""  />
                        </div>
                        <button type="submit" name="submit" class="btn btn-default">
                            Create Order
                        </button>
                        </div>

                    </form>

Barand · August 5, 2015

You are listing all the products. Each one has dropdown menu with only a single option. What is the point of that?

cyberRobot · August 5, 2015

You could use the array format when naming the form fields. Here is a quick example:

<?php
if($_SERVER['REQUEST_METHOD'] == 'POST') {
    foreach($_POST['product'] as $currKey=>$currValue) {
        echo '<div>' . $_POST['product'][$currKey] . ' = ' . $_POST['price'][$currKey] . '</div>';
    }
}
?>
<form method="post">
    <?php
    for($i=1; $i<=5; $i++) {
        ?>
        <div>
            <label>Product <?php echo $i; ?> <input type="text" name="product[]" /></label>
            <label>Price <?php echo $i; ?> <input type="text" name="price[]" /></label>
        </div>
        <?php
    }
    ?>
    <input type="submit" />
</form>

Barand · August 5, 2015

I would go a step further than ch0cu3r and use the product's row id as the array indexes

name="product[$id]"

name="price[$id]"

then you know which product the data relates to when processing the form

Edited August 5, 2015 by Barand

mac_gyver · August 5, 2015

You are listing all the products. Each one has dropdown menu with only a single option. What is the point of that?

this is the second time someone has questioned this. i don't think the OP has planned how his page is actually going to be used.

cyberRobot · August 5, 2015

this is the second time someone has questioned this. i don't think the OP has planned how his page is actually going to be used.

I would imagine that the OP was just trying to connect the product name to the corresponding price fields. Using Barand's suggestion to tie the product ID to the field names should eliminate the need for the drop-down fields.

bambinou1980 · August 8, 2015

Yes sorry about the drodown menu, this should be a simple input field greyed out so the user cannot change it's value. The reason this was there is because I just copied and pasted the first line of code, I was going to change this later on.

mac_gyver · August 8, 2015

this should be a simple input field greyed out so the user cannot change it's value

it shouldn't even be that. just echo the product name next to the radio buttons it belongs to.

bambinou1980 · August 12, 2015

Mac_Gyver, I cannot do that. Each product has 3 price(3 types of clients).

So product1 = Price1[radio], Price2[radio], Price3[radio]

product2 = Price1[radio], Price2[radio], Price3[radio]

product3 = Price1[radio], Price2[radio], Price3[radio]

And so on...

I have now managed to generate all my "names" and ids dynamically but I was Looking at the first solution of CyberRobt, I am not sure this will work with 3 prices per product, or will it?

I have this now:

 <?php  $random_number = rand(999 ,99999999999 );  ?>   <form role="form" method="post" action="index.php">       <div class="form-group"><label for="order_id">Order ID</label><input type="text" name="cust_order_id" class="form-control" value="<?php echo "FP" .$random_number; ?>" readonly="readonly" /></div>     <div class="form-group"><label for="name_id">Company *</label> <select name="cust_company" class="form-control" id="cust_company_id">                        <?php                         $query_field1 = "SELECT * FROM customers ORDER BY cust_company desc";                        $result_field1 = mysqli_query($connection, $query_field1) or die (mysqli_error());                        $number1 = 0;                        $number2 = 0;                        $number3 = 0;                        while($row_field1 = mysqli_fetch_array($result_field1)){                        $cust_name = htmlspecialchars($row_field1['cust_name']);                        $cust_surname =  htmlspecialchars($row_field1['cust_surname']);                        $cust_company =  htmlspecialchars($row_field1['cust_company']);                        $cust_address = htmlspecialchars($row_field1['cust_address']);                        $cust_phone =  htmlspecialchars($row_field1['cust_phone']);                        $cust_email =  htmlspecialchars($row_field1['cust_email']);                        $cust_vat =  htmlspecialchars($row_field1['cust_vat']);?>                          <option value="<?php echo $cust_company; ?>" data-name="<?php echo $cust_name; ?>" data-surname="<?php echo $cust_surname; ?>" data-address="<?php                                 echo $cust_address; ?>" data-phone="<?php echo $cust_phone; ?>" data-email="<?php echo $cust_email; ?>" data-vat="<?php echo $cust_vat; ?>"><?php echo                                   $cust_company; ?></option>                        <?php } ?>                        </select>                        </div> <div class="form-group"><label for="address_id">Address *</label><textarea name="cust_address" placeholder="Company's Address" rows="4" cols="50" class="form-control" readonly="readonly" ></textarea></div> <div class="form-group"><label for="name_id">Name *</label><input type="text" name="cust_name" placeholder="Customer Name" class="form-control" value="" readonly="readonly" /></div>                                                <div class="form-group"><label for="surname_id">Surname *</label><input type="text" name="cust_surname" placeholder="Customer Surname" class="form-control" value=""  readonly="readonly" /></div> <div class="form-group"><label for="phone_id">Phone</label><input type="text" name="cust_phone" placeholder="Customer Phone" class="form-control" value=""  readonly="readonly" /></div> <div class="form-group"><label for="email_id">Email</label><input type="email" name="cust_email" placeholder="Customer Email" class="form-control" value=""  readonly="readonly" /></div> <div class="form-group"><label for="vat_id">V.A.T Number(ie:MT20343324)</label><input type="text" name="cust_vat" placeholder="V.A.T Number"  class="form-control" value="" readonly="readonly" /></div>                                                 <div class="form-group"><label for="due_date_id">Due Date *</label><div class="form-inline well">                            <div class="input-append date" id="dp3" data-date="12-02-2012" data-date-format="dd-mm-yyyy">                              <input name="due_date" class="form-control" size="25" type="text" id="dp1" value="12-02-2012">                                <span class="add-on"><i class="icon-th"></i></span></div>                            </div>                        </div>  <script>$('#dp1').datepicker({          format: 'dd-mm-yyyy'           });</script>  <?php                        //Query all the prices                         $query_field2 = "SELECT * FROM products ORDER BY name desc";                        $result_field2 = mysqli_query($connection, $query_field2) or die (mysqli_error());                        $number1 = 0;                        $number2 = 0;                        $number3 = 0;                        $id_1 = 0;                        $id_2 = 0;                        $id_3 = 0;                        $quantity = 0;                         while($row_field2 = mysqli_fetch_array($result_field2)){$name = htmlspecialchars($row_field2['name']);$price1 = htmlspecialchars($row_field2['price1']);$price2 = htmlspecialchars($row_field2['price2']);$price3 = htmlspecialchars($row_field2['price3']); ?><div class="form-inline well"><label for="product1_id">Choose Product <?php echo ++$number1; ?></label><div class="form-group">                        <input name="<?php echo "product".++$number2; ?>" type="text" class="form-control" value="<?php echo $name; ?>" disabled>                          <!--Price 1-->                        <label class="btn btn-default">                        <input type="radio" name="<?php echo "action".++$number3; ?>" value="<?php echo $price1;?>" id="<?php echo ++$id_1; ?>" />€ <?php echo $price1; ?>                        </label>                         <!--Price 1-->                         <!--Price 2--> <?php   //Do not show second price if not setif(($price2) != null) {echo "<label class=\"btn btn-default\">                        <input type=\"radio\" name=\"action".($number3)."\" value=\"{$price2}\" id=\"".(++$id_2)."\" /> € {$price2}                        </label>";} ?>                        <!--Price 2-->                     <!--Price 3--> <?php                        //Do not show third price if not setif(($price3) != null) {echo "<label class=\"btn btn-default\">                        <input type=\"radio\" name=\"action{$number3}\" value=\"{$price3}\"  id=\"".(++$id_3)."\" /> € {$price3}                        </label>";} ?>                        <!--Price 3-->  <label for="product1_id">Qty</label><input name="<?php echo "quantity".++$quantity; ?>" type="text" class="form-control" maxlength="4" size="4"> </div> </div>    <?php } ?>                        <div class="form-inline well text-center"><button type="submit" name="submit" class="btn btn-success btn-lg">Create Order</button></div></div> </form>                    </div> </div></div></div></div>    <script>       $('#cust_company_id').change(function() {    selectedOption = $('option:selected', this);    $('textarea[name=cust_address]').val( selectedOption.data('address') );    $('input[name=cust_name]').val( selectedOption.data('name') );    $('input[name=cust_surname]').val( selectedOption.data('surname') );    $('input[name=cust_phone]').val( selectedOption.data('phone') );    $('input[name=cust_email]').val( selectedOption.data('email') );    $('input[name=cust_vat]').val( selectedOption.data('vat') );}); </script>

Edited August 12, 2015 by bambinou1980

mac_gyver · August 13, 2015

I cannot do that

yes you can. between all the threads you have started for this, you have been given the parts you need, though some of the advice has been off topic because you have shown things like using a select/option menu where nothing is being selected.

start off with the basics and define what you are trying to do or produce before writing any code for it. until you can create a form that submits the data you want, there's no point in all of the other markup you have in your code.

see this basic example -

<form method="post" action="index.php">
<?php

// Query for all the products
$query_field2 = "SELECT * FROM products ORDER BY name";
$result_field2 = mysqli_query($connection, $query_field2) or die (mysqli_error($connection)); // you were missing the connection link in the mysqli_error() statement

while($row_field2 = mysqli_fetch_array($result_field2)){
    $id = $row_field2['id']; // i guessed this was id, even though you stated your columns were product_id (and product_name) in one of the threads
    $name = htmlspecialchars($row_field2['name']);
    $price1 = htmlspecialchars($row_field2['price1']); // these should be decimal numbers only and be under your control, so no need to apply htmlspecialchars
    $price2 = htmlspecialchars($row_field2['price2']);
    $price3 = htmlspecialchars($row_field2['price3']);

    echo $name;
    echo "<input type='radio' name='price[$id]' value='$price1' checked>€ $price1"; // pre-check/select the first price
    if($price2 != null){
        echo "<input type='radio' name='price[$id]' value='$price2'>€ $price2";
    }
    if($price3 != null){
        echo "<input type='radio' name='price[$id]' value='$price3'>€ $price3";
    }
    
    echo "<label> Qty ";
    echo "<input name='quantity[$id]' type='text' size='4'></label><br>\n";
} ?>
<button type="submit" name="submit" >Create Order</button>
</form>

Edited August 13, 2015 by mac_gyver

bambinou1980 · August 13, 2015

Hi Mac_gyver,

Yes now I am getting all the ids and all the php working right, where I am struggling is with the jquery.

Here is my new code, remember I will then add this later on:

http://jsfiddle.net/jaredwilli/tzpg4/4/

 <form role="form" method="post" action="index.php">
  
  
   <div class="form-group">
<label for="order_id">
Order ID
</label>
<input type="text" name="cust_order_id" class="form-control" value="<?php echo "FP" .$random_number; ?>" readonly="readonly" />
</div>
  
  

<div class="form-group">
<label for="name_id">
Company *
</label> 
<select name="cust_company" class="form-control" id="cust_company_id">
                        <?php 
                        $query_field1 = "SELECT * FROM customers ORDER BY cust_company desc";
                        $result_field1 = mysqli_query($connection, $query_field1) or die (mysqli_error());
                        while($row_field1 = mysqli_fetch_array($result_field1)){
                        $cust_name = htmlspecialchars($row_field1['cust_name']);
                        $cust_surname =  htmlspecialchars($row_field1['cust_surname']);
                        $cust_company =  htmlspecialchars($row_field1['cust_company']);
                        $cust_address = htmlspecialchars($row_field1['cust_address']);
                        $cust_phone =  htmlspecialchars($row_field1['cust_phone']);
                        $cust_email =  htmlspecialchars($row_field1['cust_email']);
                        $cust_vat =  htmlspecialchars($row_field1['cust_vat']);
?>
   <option value="<?php echo $cust_company; ?>" data-name="<?php echo $cust_name; ?>" data-surname="<?php echo $cust_surname; ?>" data-address="<?php echo $cust_address; ?>" data-phone="<?php echo $cust_phone; ?>" data-email="<?php echo $cust_email; ?>" data-vat="<?php echo $cust_vat; ?>"><?php echo $cust_company; ?></option>
                        <?php } ?>
   </select>
                     </div>

<div class="form-group">
<label for="address_id">
Address *
</label>
<textarea name="cust_address" placeholder="Company's Address" rows="4" cols="50" class="form-control" readonly="readonly" ></textarea>
</div>

<div class="form-group">
<label for="name_id">
Name *
</label>
<input type="text" name="cust_name" placeholder="Customer Name" class="form-control" value="" readonly="readonly" />
</div>
                        
                        <div class="form-group">
<label for="surname_id">
Surname *
</label>
<input type="text" name="cust_surname" placeholder="Customer Surname" class="form-control" value=""  readonly="readonly" />
</div>

<div class="form-group">
<label for="phone_id">
Phone
</label>
<input type="text" name="cust_phone" placeholder="Customer Phone" class="form-control" value=""  readonly="readonly" />
</div>

<div class="form-group">
<label for="email_id">
Email
</label>
<input type="email" name="cust_email" placeholder="Customer Email" class="form-control" value=""  readonly="readonly" />
</div>

<div class="form-group">
<label for="vat_id">
V.A.T Number(ie:MT20343324)
</label>
<input type="text" name="cust_vat" placeholder="V.A.T Number"  class="form-control" value="" readonly="readonly" />
</div>
                        

                        <div class="form-group">
<label for="due_date_id">
Due Date *
</label>
<div class="form-inline well">
                            <div class="input-append date" id="dp3" data-date="12-02-2012" data-date-format="dd-mm-yyyy">
                              <input name="due_date" class="form-control" size="25" type="text" id="dp1" value="12-02-2012">
                                <span class="add-on"><i class="icon-th"></i></span>
</div>
                            </div>
                        </div>


<script>
$('#dp1').datepicker({
          format: 'dd-mm-yyyy'
           });
</script>


<?php 
                        //Query all the prices 
                        $query_field2 = "SELECT * FROM products ORDER BY name desc";
                        $result_field2 = mysqli_query($connection, $query_field2) or die (mysqli_error());
                        $choose_product_id = 0;
                        $action_id = 0;
                        $products_id = 0;
                        $label_id = 0;
                        $quantity = 0;

                        while($row_field2 = mysqli_fetch_array($result_field2)){
                        $name = htmlspecialchars($row_field2['name']);
                        $price1 = $row_field2['price1'];
                        $price2 = $row_field2['price2'];
                        $price3 = $row_field2['price3'];

?>
<div class="form-inline well">
<label for="<?php echo "label".++$label_id; ?>">Choose Product <?php echo ++$choose_product_id; ?></label>
<div class="form-group">

<!--Product name Select-->
<select name="<?php echo "action".++$action_id; ?>" class="form-control products" id="<?php echo "products".++$products_id; ?>">
<?php 
                        $query_field3 = "SELECT * FROM products ORDER BY name desc";
                        $result_field3 = mysqli_query($connection, $query_field3) or die (mysqli_error());
                        while($row_field3 = mysqli_fetch_array($result_field3)){
                        $product_name = htmlspecialchars($row_field3['name']);
                        $product_price1 =  htmlspecialchars($row_field3['price1']);
                        $product_price2 =  htmlspecialchars($row_field3['price2']);
                        $product_price3 = htmlspecialchars($row_field3['price3']);
?>
<option value="<?php echo $product_name; ?>" data-product_price1="<?php echo $product_price1; ?>" data-product_price2="<?php echo $product_price2; ?>" data-product_price3="<?php echo $product_price3; ?>"><?php echo $product_name; ?></option>
                        <?php } ?>
   </select>

<!--Price Select-->
                        <select name="<?php echo "action".++$number2; ?>" class="form-control">

<option id="price1"></option>
<option id="price2"></option>
<option id="price3"></option>


</select>

<label for="product1_id">Qty</label>
<input name="<?php echo "quantity".++$quantity; ?>" type="text" class="form-control" maxlength="4" size="4" id="<?php echo "quantity".$quantity; ?>">
 </div>
 </div>
    <?php } ?>
                        <div class="form-inline well text-center">
<button type="submit" name="submit" class="btn btn-success btn-lg">
Create Order
</button>
</div>
</div> 
</form>
                    
</div>

</div>
</div>
</div>
</div>
<!--
<script>  
$("#products").change(function() {
  $("#product_prices").load("getter.php?choice=" + $("#products").val());
});
</script>  
-->
<script>   
    $('#cust_company_id').change(function() {
    selectedOption = $('option:selected', this);
    $('textarea[name=cust_address]').val( selectedOption.data('address') );
    $('input[name=cust_name]').val( selectedOption.data('name') );
    $('input[name=cust_surname]').val( selectedOption.data('surname') );
    $('input[name=cust_phone]').val( selectedOption.data('phone') );
    $('input[name=cust_email]').val( selectedOption.data('email') );
    $('input[name=cust_vat]').val( selectedOption.data('vat') );
}); 
</script>   
<script>    
$(".products").change(function() {  
selectedOption = $(this).find(":selected"); 
$(this).next().children().each(function(idx){ 
var num=idx+1; 
$(this).text( selectedOption.data('product_price'+num)); 
}); 
</script>

I have the dropdowns populated correctly but the jquery code that read the first drop down menu is not pulling the second dropdown menu. I have also modified my code to make it simpler for me to understand.

I have also added more dynamic ids in my code as it was full of mistakes. This is the last part of my problem, after that, all good......

I have removed the radios and added 2 dropdown menu instead.

Edited August 13, 2015 by bambinou1980

bambinou1980 · August 13, 2015



 oups posted twice

Edited August 13, 2015 by bambinou1980

bambinou1980 · August 13, 2015

  <form role="form" method="post" action="index.php">       <div class="form-group"><label for="order_id">Order ID</label><input type="text" name="cust_order_id" class="form-control" value="<?php echo "FP" .$random_number; ?>" readonly="readonly" /></div>     <div class="form-group"><label for="name_id">Company *</label> <select name="cust_company" class="form-control" id="cust_company_id">                        <?php $query_field1 = "SELECT * FROM customers ORDER BY cust_company desc";                        $result_field1 = mysqli_query($connection, $query_field1) or die (mysqli_error());                        while($row_field1 = mysqli_fetch_array($result_field1)){$cust_name = htmlspecialchars($row_field1['cust_name']);$cust_surname =  htmlspecialchars($row_field1['cust_surname']);$cust_company =  htmlspecialchars($row_field1['cust_company']);                        $cust_address = htmlspecialchars($row_field1['cust_address']);                        $cust_phone =  htmlspecialchars($row_field1['cust_phone']);                        $cust_email =  htmlspecialchars($row_field1['cust_email']);                        $cust_vat =  htmlspecialchars($row_field1['cust_vat']);?>   <option value="<?php echo $cust_company; ?>" data-name="<?php echo $cust_name; ?>" data-surname="<?php echo $cust_surname; ?>" data-address="<?php echo $cust_address; ?>" data-phone="<?php echo $cust_phone; ?>" data-email="<?php echo $cust_email; ?>" data-vat="<?php echo $cust_vat; ?>"><?php echo $cust_company; ?></option>                        <?php } ?>   </select>                     </div> <div class="form-group"><label for="address_id">Address *</label><textarea name="cust_address" placeholder="Company's Address" rows="4" cols="50" class="form-control" readonly="readonly" ></textarea></div> <div class="form-group"><label for="name_id">Name *</label><input type="text" name="cust_name" placeholder="Customer Name" class="form-control" value="" readonly="readonly" /></div>                                                <div class="form-group"><label for="surname_id">Surname *</label><input type="text" name="cust_surname" placeholder="Customer Surname" class="form-control" value=""  readonly="readonly" /></div> <div class="form-group"><label for="phone_id">Phone</label><input type="text" name="cust_phone" placeholder="Customer Phone" class="form-control" value=""  readonly="readonly" /></div> <div class="form-group"><label for="email_id">Email</label><input type="email" name="cust_email" placeholder="Customer Email" class="form-control" value=""  readonly="readonly" /></div> <div class="form-group"><label for="vat_id">V.A.T Number(ie:MT20343324)</label><input type="text" name="cust_vat" placeholder="V.A.T Number"  class="form-control" value="" readonly="readonly" /></div>                                                 <div class="form-group"><label for="due_date_id">Due Date *</label><div class="form-inline well">                            <div class="input-append date" id="dp3" data-date="12-02-2012" data-date-format="dd-mm-yyyy">                              <input name="due_date" class="form-control" size="25" type="text" id="dp1" value="12-02-2012">                                <span class="add-on"><i class="icon-th"></i></span></div>                            </div>                        </div>  <script>$('#dp1').datepicker({          format: 'dd-mm-yyyy'           });</script>  <?php //Query all the prices $query_field2 = "SELECT * FROM products ORDER BY name desc";                        $result_field2 = mysqli_query($connection, $query_field2) or die (mysqli_error());$choose_product_id = 0;                        $action_id = 0;$products_id = 0;$label_id = 0;$quantity = 0;                         while($row_field2 = mysqli_fetch_array($result_field2)){$name = htmlspecialchars($row_field2['name']);$price1 = htmlspecialchars($row_field2['price1']);$price2 = htmlspecialchars($row_field2['price2']);$price3 = htmlspecialchars($row_field2['price3']); ?><div class="form-inline well"><label for="<?php echo "label".++$label_id; ?>">Choose Product <?php echo ++$choose_product_id; ?></label><div class="form-group"> <!--Product name Select--><select name="<?php echo "action".++$action_id; ?>" class="form-control products" id="<?php echo "products".++$products_id; ?>"><?php $query_field3 = "SELECT * FROM products ORDER BY name desc";                        $result_field3 = mysqli_query($connection, $query_field3) or die (mysqli_error());                        while($row_field3 = mysqli_fetch_array($result_field3)){$product_name = htmlspecialchars($row_field3['name']);$product_price1 =  htmlspecialchars($row_field3['price1']);$product_price2 =  htmlspecialchars($row_field3['price2']);                        $product_price3 = htmlspecialchars($row_field3['price3']);?><option value="<?php echo $product_name; ?>" data-product_price1="<?php echo $product_price1; ?>" data-product_price2="<?php echo $product_price2; ?>" data-product_price3="<?php echo $product_price3; ?>"><?php echo $product_name; ?></option>                        <?php } ?>   </select> <!--Price Select-->                        <select name="<?php echo "action".++$number2; ?>" class="form-control"> <option id="price1"></option><option id="price2"></option><option id="price3"></option>  </select> <label for="product1_id">Qty</label><input name="<?php echo "quantity".++$quantity; ?>" type="text" class="form-control" maxlength="4" size="4" id="<?php echo "quantity".$quantity; ?>"> </div> </div>    <?php } ?>                        <div class="form-inline well text-center"><button type="submit" name="submit" class="btn btn-success btn-lg">Create Order</button></div></div> </form>                    </div> </div></div></div></div><!--<script>  $("#products").change(function() {  $("#product_prices").load("getter.php?choice=" + $("#products").val());});</script>  --><script>      $('#cust_company_id').change(function() {    selectedOption = $('option:selected', this);    $('textarea[name=cust_address]').val( selectedOption.data('address') );$('input[name=cust_name]').val( selectedOption.data('name') );$('input[name=cust_surname]').val( selectedOption.data('surname') );    $('input[name=cust_phone]').val( selectedOption.data('phone') );    $('input[name=cust_email]').val( selectedOption.data('email') );    $('input[name=cust_vat]').val( selectedOption.data('vat') );}); </script>   <script>    $(".products").change(function() {  selectedOption = $(this).find(":selected"); $(this).next().children().each(function(idx){ var num=idx+1; $(this).text( selectedOption.data('product_price'+num)); }); </script>

mac_gyver · August 14, 2015

your current code should be using an array for the form field name="...." attributes. this will allow you to process the submitted form data using php array functions. this is even more important if you plan on having an 'add' javascrpt/jquery button that dynamically adds more rows of data. using sequentially numbered field names will mean that you have to find and keep track of the number of fields in the javascript/jquery so that you can number the dynamic ones properly. by using an array for the field name, you don't need to do anything extra in the javascript/jquery for the dynamically added rows of data and all the form fields, the static ones and the dynamically added ones, will all be part of the same submitted data and will all be processed by the php code the same.

you are also querying for all the product rows, then querying for all the rows again inside of the loop that's looping over the result from the first query. that is killing your database server with queries. even if your current method will result in a workable solution, once you query for all the rows in your database table, one time, just reuse that result set. the easiest and quickest way of reusing a result set multiple times would be to store all the rows in a php array or use a fetch_all statement if the database library you are using supports it.

beyond those, i'm not sure why your code doesn't work, and since you have changed your concept multiple times, i'm not sure any of the previous helpers want to take the time to figure out what you are doing in this iteration of your design.

Sign In

Submit $_POST with dynamically generated fields

Recommended Posts

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Join the conversation

Important Information