PHP - Insert data from HTML table into MySQL database [closed]

Question

Closed. This question needs to be more focused. It is not currently accepting answers.

Want to improve this question? Guide the asker to update the question so it focuses on a single, specific problem. Narrowing the question will help others answer the question concisely. You may edit the question if you feel you can improve it yourself. If edited, the question will be reviewed and might be reopened.

Closed 10 years ago.

Improve this question

I have an HTML form and a table inside it. Submit buttons and other lines of code are removed in this preview. Code below.

<form method="post" action="">
    <table>
        <thead>
            <tr>
                <th>Days</th>
                <th>Price</th>
            </tr>
        </thead>
        <tbody>
            <tr>
                <td><input name="days[]" type="text"/></td>
                <td><input name="price[]" type="text"></td>
            </tr>
            <tr>
                <td><input name="days[]" type="text"/></td>
                <td><input name="price[]" type="text"></td>
            </tr>
        </tbody>
    </table>
</form>

Link to the image, how the form with the table looks:

Table image

So, whenever I click the submit button, I want to put the data of each column from table to MySQL database.

Then I need to display that data from database in the HTML table that should look like in the image:

Database data

I understand how to retrieve data from database and output it in the table, but I can't find out how to insert every table's column data into MySQL database when I click a submit button.

Welcome to Stack Overflow! This question is a little short on information. Can you share what you have tried, and what problems have you run into? — Jay Blanchard
– Jay Blanchard, Commented Mar 6, 2015 at 22:32

Rex · Accepted Answer · 2015-03-06 22:26:39Z

1

Take a look at $_POST['NAME OF INPUT']; and MySQL's INSERT INTO.

answered Mar 6, 2015 at 22:26

Rex

1431 gold badge4 silver badges11 bronze badges

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

Comments

Maze Runner · Accepted Answer · 2015-03-06 22:32:10Z

0

Give each input field a unique name identifier 'name="days_a"' which you can get onSubmit using $_POST['days_a'],$_POST['days_b'] etc

answered Mar 6, 2015 at 22:32

Maze Runner

2442 silver badges10 bronze badges

Comments

halfer · Accepted Answer · 2015-03-06 23:01:56Z

0

At the very start of your script, before your doctype, try this:

<?php
if ($_POST)
{
    echo "<pre>" . print_r($_POST, true) . "</pre>";
}
?>

That should get you started! Your form elements correctly use the array approach, and investigating the format of the data you get back will reveal how to read the data you need. You will probably use a foreach() loop to iterate over each array from this superglobal.

answered Mar 6, 2015 at 23:01

community wiki

halfer

Collectives™ on Stack Overflow

PHP - Insert data from HTML table into MySQL database [closed]

3 Answers 3

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Linked

Related