Insert html form data into database

Question

How to store a html table data into MySQL database.

Sample Html code is given below. In original, there is about thousand form on the same page.

<thead>
<tr>
    <th> Id</th>
    <th>From area</th>
    <th>To area</th>
    <th>Basic price</th>
</tr>
</thead>   
<form action="basicprice.php" method="get" name="basicprice">
<tr>
    <td>4</td>
    <td class="static">Address 1</td>
    <td class="static">Airport 1</td>
    <td class="center"><input type="text" name="basicprice" value="54"></td>
    <td><input name="submit" type="submit" value="Save"></td>
</tr>                                     
</form>
<form action="basicprice.php" method="get" name="basicprice">
<tr>
    <td>4</td>
    <td class="static">Address 1</td>
    <td class="static">Airport 1</td>
    <td class="center"><input type="text" name="basicprice" value="54"></td>
    <td><input name="" type="submit" value="Save"></td>
</tr>

I want create a database from these details. Need Help.

Thanks in advance

you can use array please try reading array documnetaion if you are a starter. — Mr world wide
– Mr world wide, Commented Jan 6, 2017 at 9:10
no no. this is the html I have. I want store the value which is in td tags and textbox. I can't do it manually because there are thousands of same snippets are there @PraveenKumar — Kavi
– Kavi, Commented Jan 6, 2017 at 9:13
Is value is same for all it will keep on changing for every form..? — Mr world wide
– Mr world wide, Commented Jan 6, 2017 at 9:15

Mr world wide · Accepted Answer · 2017-01-06 09:13:28Z

1

Use only one form and add input feild name as array[]

<form action="basicprice.php" method="get" name="basicprice">
<tr>
    <td>4</td>
    <td class="static">Address 1</td>
    <td class="static">Airport 1</td>
    <td class="center"><input type="text" name="basicprice[]" ></td>
    <td><input name="submit" type="submit" value="Save"></td>
</tr>                                     
</form>

In this array you will get all values no need to write forms again and again.

answered Jan 6, 2017 at 9:13

Mr world wide

4,86410 gold badges47 silver badges105 bronze badges

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

Comments

Community · Accepted Answer · 2017-05-23 11:46:00Z

1

Have a look on bellow link "PHP - Insert data from HTML table into MySQL database" might give you some idea on how to make insert query using array elements

edited May 23, 2017 at 11:46

CommunityBot

11 silver badge

answered Jan 6, 2017 at 9:21

Pradeep Veera

113 bronze badges

Collectives™ on Stack Overflow

Insert html form data into database

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