Make multiple inputs in mysql table at once with one submit button

Question

I have for example in mysql table: fruit_store id fruit price

and I have form like:

<a href="#" id="add_input">Add</a> 
<a href="#" id="remove_input">Remove</a>  
    <form action="<?php $_SERVER['PHP_SELF'] ?>" method="POST">
        <table id="workTbl">
            <tr>
                <td>Fruit</td>
                <td>Price</td>
            </tr>
        </table>
        <p><input name="submit" type="submit" id="submit_tbl" /></p>
       </form>

and have jquery code:

$(function(){
    $("#add_input").click(function(){
        $("#workTbl").append("<tr><td><input name='fruit_input' type='text' /></td><td><input name='price_input' type='text' /></td></tr>");
    });
    $("#remove_input").click(function(){ 
         $('#workTbl input:last').remove();
         $('#workTbl input:last').remove();           
    })
});

I want to ask how to insert multiple inputs into mysql table fruit_store with one submit button or multiple forms i don't know help me please!

How do you insert value now? What do you have done?

RRStoyanov
– RRStoyanov

2011-05-26 15:59:47 +00:00
Commented May 26, 2011 at 15:59 — RRStoyanov
– RRStoyanov, Commented May 26, 2011 at 15:59

Dreaded semicolon · Accepted Answer · 2011-05-26 16:03:51Z

1

use [] in the input name as in here

   <input name='fruit_input[]' .... />

then in php upon receiving post data, loop through

  if (is_array($_POST['fruit_input'])){
   foreach ($_POST['fruit_input'] as $key=>$value){
        $price=$_POST['fruit_price'][$key];
        ...

answered May 26, 2011 at 16:03

Dreaded semicolon

2,3141 gold badge29 silver badges44 bronze badges

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

Comments

Khurram Ijaz · Accepted Answer · 2011-05-26 16:26:16Z

0

you need to put some php code to see what fields have are present in the post array use

<?php 

 if( ! empty( $_POST ) )
{

   $sql = "insert into table  ......values ...";

   mysql_query($sql);

}
?>

to check how many values are present in the post array use

print_r($_POST)

i hope you will understand from here onward.

edited May 26, 2011 at 16:26

answered May 26, 2011 at 16:09

Khurram Ijaz

1,8645 gold badges24 silver badges43 bronze badges

Collectives™ on Stack Overflow

Make multiple inputs in mysql table at once with one submit button

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related