Adding multiple textbox entry to a mysql database

Question

I have created a form, with 5 textbox fields and I want to add those five entries in the database. I want to use the textbox "array", that way I can use a for-each when saving to the database. As anyone, any code on how to do this or can direct me in the right path?

input type="text" value="whateva" name= ?php text[0] ?> 
input type="text" value="whateva" name= ?php text[1] ?> 
input type="text" value="whateva" name= ?php text[2] ?> 

if (isset($_POST['Submit']) {
  //add to db
  (for-each $text as $val) {
    //add to db
  }
}

Is this possible?

Corey Ballou · Accepted Answer · 2009-12-09 18:49:59Z

1

HTML

<input type="text" value="whateva" name="text[]" />
<input type="text" value="whateva" name="text[]" />
<input type="text" value="whateva" name="text[]" />

PHP

if (!empty($_POST['text'])) {
    foreach ($_POST['text'] AS $value) {
        // add to the database
        $sql = 'INSERT INTO tableName SET fieldName = "' . mysql_real_escape_string($value) . '"';
    }
}

answered Dec 9, 2009 at 18:49

Corey Ballou

43.7k8 gold badges66 silver badges77 bronze badges

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

Comments

Deniss Kozlovs · Accepted Answer · 2009-12-09 18:45:22Z

0

Yes, HTML supports arrays. just name your textareas like this:

<textarea name="field[]"></textarea> /* Notice square brackets */

For this example, in PHP, your $_GET or $_POST will have array key with name 'field' and values from these textareas.

answered Dec 9, 2009 at 18:45

Deniss Kozlovs

4,8392 gold badges30 silver badges36 bronze badges

Comments

claws · Accepted Answer · 2009-12-09 18:45:39Z

0

If 'Submit' is the name of the submit button. yeah that will work.

but few suggestions:

correct it as:

< input type="text" value="whateva" name= "" />
Use validation for the text submitted by user
IMPORTANT: "GET A BOOK ON PHP" and learn it. Seriously, if you learn this way, you wont become a good programmer. You are learning it the hardway. Book is must for you.

answered Dec 9, 2009 at 18:45

claws

54.7k61 gold badges153 silver badges201 bronze badges

1 Comment

ferronrsmith Over a year ago

the site wasn't recognizing my tags. blanking the data sorry

Collectives™ on Stack Overflow

Adding multiple textbox entry to a mysql database

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related