[SOLVED] Insert into database question (multiple rows)

[forumnz]

I have a form with with 2 text fields.

The user is able to add more fields using javascript.

 

Basically, I am wondering how I would insert multiple rows into a database. Normally I would know how to do this, but the amount of rows is uncertain (could be 1 or 100).

 

I suppose I would use an array? How would I do that?

 

More info: the form would submit text fields named:

name1 email1

name2 email2

name3 email3

etc...

 

Thanks, Sam

[Ken2k7]

<?php

$name_count = $email_count = 1;

while (isset($_POST['name' + $name_count])) {
    // do something
    $name_count++;
}

// same for email

 

Get the hint?

[forumnz]

Oh one more thing!

 

The user is able to delete sets of test fields (name and email), but each time a new one is created, a new number is generated. So basically the form might submit something like:

 

name1 email1

name3 email3

name18 email18

 

Meaning all the numbers inbetween contain no data so they shouldn't be inserted - how would I get around this?

 

Thanks!

[forumnz]

Thanks Ken2k7. Yes I understand that

[Ken2k7]

Oh great! I would like to say it's a JavaScript problem though!

 

<?php

foreach ($_POST as $key => $value) {
     if (strpos($key, 'name') === 0) {
          // do something
     }
     if (strpos($key, 'email') === 0) {
          // do something
     }
}

[forumnz]

Is there a way to cycle through the numbers and create an array with the existing numbers?

Am I making this too complicated?

 

[forumnz]

I'm just going to solve this topic and write a new (better explained) one

 

Thanks

[Ken2k7]

Is there a way to cycle through the numbers and create an array with the existing numbers?

Am I making this too complicated?

 

Not complicated. Do you know PHP at all? It's not hard. We're not here to write code for you.

[forumnz]

I do know a bit of PHP and I'm really good with a lot of things, I've just never really worked with arrays :/

 

I don't expect you to write code for me, I would be happy with the theory behind it

[Ken2k7]

Create 2 arrays (one for names and one for email) before the loop. Then inside the loop, inside each if statement, add them to the array. You know if the entry in the if statement means it's either name or email. Add them to the correct array.