Add array with unknown size into database

Question

I need to build a page where the user can enter the name of the categories of products of an webstore. I created a page with dynamic input fields so the user will be able to add all the categories (which i don't know the ammount). I have to get the name of those categories and put into a database. I got a script online and made a few changes but i dont know how to proceed further on. I need help with the php script, how to get the array and insert into the database.

This is my form script:

<form method="post" action="setup3.php">
    <div class="input_fields_wrap">
        <button class="add_field_button">Add More Fields</button>
        <div>
            <input type="text" name="mytext[]">
        </div>
    </div>
    <div>
        <input type="submit" value="Next" />
    </div>
</form>

what do you get when you put some values in the form above and do var_dump($_POST) on setup3.php page ? — Maximus2012
– Maximus2012, Commented Apr 14, 2015 at 20:54
I get this: array(1) { ["mytext"]=> array(3) { [0]=> string(5) "test1" [1]=> string(5) "test2" [2]=> string(5) "test3" } } — Rodrigo Sasse
– Rodrigo Sasse, Commented Apr 14, 2015 at 21:00
i think that all I need is a loop where a get the current element of the array and add it to the database, but i dont know how to do it, not even start. This is the first time i programm for web. — Rodrigo Sasse
– Rodrigo Sasse, Commented Apr 14, 2015 at 21:01
Google: "php iterate through arrays". You need to put in work from your side and then post the problem here if you run into any issues. You might want to start with some basic PHP tutorials first. — Maximus2012
– Maximus2012, Commented Apr 14, 2015 at 21:03

Harold · Accepted Answer · 2015-04-14 22:04:25Z

1

I think this would point you in the right direction:

<?php
if (! empty($_POST['mytext'])) {
    foreach ($_POST['mytext'] as $entry) {
        // perform your insert here.
    }
}

I would strongly recommend using an ORM like Doctrine (http://www.doctrine-project.org/) since it already tackles a lot of security issues for you.

If you wish to stay pretty close to low-level database interactions, writing plain SQL queries, I'd recommend using PDO (http://php.net/manual/en/book.pdo.php)

answered Apr 14, 2015 at 22:04

Harold

1,4131 gold badge15 silver badges27 bronze badges

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

Collectives™ on Stack Overflow

Add array with unknown size into database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related