title: Adding bulk rows to same table
body: <p>I am making a program for book store. Where one can add book quantity and price and store it in database. I've stored book names in one table like this:</p>
  
  <pre><code>+-----+-----------+
  | ID  | book_name |
  +-----+-----------+
  | 1   | English   |
  | 2   | Physics   |
  | 3   | Chemstry  |
  +-----+-----------+
  </code></pre>
  
  <p>And Books stock in other like this:</p>
  
  <pre><code>+-----+---------+---------------+------------+
  | ID  | book_id | book_quantity | book_price |
  +-----+---------+---------------+------------+
  | 1   | 1       | 200           | 400        |
  | 2   | 2       | 200           | 400        |
  | 3   | 3       | 200           | 400        |
  +-----+---------+---------------+------------+
  </code></pre>
  
  <p>Now the problem is I have make a program for single data insert but I dont know how to insert bulk data with this structure. HTML code is like this:</p>
  
  <pre><code>&lt;form&gt;
      English &lt;input type="hidden" name="book_id" value="1"&gt; &lt;input type="text" name="book_quantity"&gt; &lt;input type="text" name="book_price" /&gt; &lt;br /&gt;
      Physics &lt;input type="hidden" name="book_id" value="2"&gt; &lt;input type="text" name="book_quantity"&gt; &lt;input type="text" name="book_price" /&gt; &lt;br /&gt;
      Chemistry &lt;input type="hidden" name="book_id" value="3"&gt; &lt;input type="text" name="book_quantity"&gt; &lt;input type="text" name="book_price" /&gt; 
      &lt;input type="hidden" name="action" value="add_bulk"&gt;
  &lt;/form&gt;
  </code></pre>
  
  <p>The values of <code>&lt;input name</code> is same, and how can I make a prefect structure, I am failing to find a proper solution for it.</p>