Dynamic PHP / MySQL Upload Form

Question

I'm trying to build a dynamic PHP / MySQL upload form wherein data fields can be dynamically added or removed, and all of this data can be uploaded to a database from one button.

Here's what this looks like with dynamic <textarea> elements that can be added and removed:

    <form method="post" action="dynamicForm.php" enctype="multipart/form-data">

        <!--Dynamically Added Paragraphs Go Here-->

        <input type="submit" name="upload" value="Upload" id="upload">

    </form>

    <button onclick="addParagraph()">Add Paragraph</button>

<script>

    //add textarea div and associate "Remove" button
    function addParagraph(){
        $("form").append('<div><textarea name="paragraph"></textarea><button class="remove">Remove</button></div>');

   //remove added paragraph
   $(document).on('click', ".remove", function(e) {
   $(this).parent().remove();
   });

</script>

Here's some example PHP that I could use for this:

if (isset($_POST['upload'])) {

    $db = mysqli_connect('','','','');

    $paragraph = $_POST['paragraph'];

    $sql = "INSERT INTO table (paragraph) VALUES ('$paragraph')";

    mysqli_query($db, $sql);

}

Each of the added paragraphs have the name paragraph. If there are 5 elements with the name paragraph, and the PHP code is looking for an element with name paragraph, what happens in this situation? Does all the data get uploaded, or just the first element with name paragraph? Will an error be thrown? If this won't upload all the added paragraphs, how can I get the PHP to upload all of them?

EDIT: Possible Solution

<script>

//changed name value to array "paragraph[]"
function addParagraph(){
    $("form").append('<div><textarea name="paragraph[]"></textarea><button class="remove">Remove</button></div>');


</script>



if (isset($_POST['upload'])) {

    $db = mysqli_connect('','','','');

    $sql = "INSERT INTO table (paragraph) VALUES ('$paragraph')";

    $paragraph_array = $_POST['paragraph'];

    for ($i = 0; $i < count($paragraph_array); $i++){

        $paragraph = mysqli_real_escape_string($paragraph_array[$i]);

        mysqli_query($db, $sql);
    }

}

It'd overwrite. Use the name paragraph[] then iterate over that in the PHP. You also are open to SQL injections, parameterize the query. — chris85
– chris85, Commented Jun 26, 2017 at 2:49
well for one thing <form method="post"> action="dynamicForm.php"> you need to remove the > after "post". — Funk Forty Niner
– Funk Forty Niner, Commented Jun 26, 2017 at 2:52
you'll also need to use a foreach or count against the multi-array. Your edit won't work. The [] belongs in <textarea name="paragraph[]"> only. Edit: this comment as per stackoverflow.com/revisions/44752505/2 — Funk Forty Niner
– Funk Forty Niner, Commented Jun 26, 2017 at 2:56
No, you need that client side, e.g. $("form").append('<div><textarea name="paragraph[]"></textarea><button class="remove">Remove</button></div>');. Then iterate over $_POST['paragraph'] because it then is an array. — chris85
– chris85, Commented Jun 26, 2017 at 2:58
Oh, okay, in that case it is needed (with provided code though it wouldnt have been). — chris85
– chris85, Commented Jun 26, 2017 at 3:37

abdulrahman.horaniia · Accepted Answer · 2017-06-26 03:22:27Z

0

Once user click upload button, all entered data will be uploaded even though there are multi input elements with the same name.

In the other hand in server side you can only access to the last entered valued in the input element that has the repeated name.

If you want to access to all values you should give input elements different names or just add "[]" at the end of repeated name and in the server side you will get all entered values encapsulated in array.

<?php var_dump($_POST);?>

array(2) { ["paragraph"]=> array(4) { [0]=> string(2) "t1" [1]=> string(2) "t2" [2]=> string(2) "t3" [3]=> string(2) "t4" } ["upload"]=> string(6) "Upload" }

edited Jun 26, 2017 at 3:22

answered Jun 26, 2017 at 3:10

abdulrahman.horaniia

11 bronze badge

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

Collectives™ on Stack Overflow

Dynamic PHP / MySQL Upload Form

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related